August 17, 2021 at 1:46 pm
This is from a job posting that another department in my company put together.
Basic Qualifications
Bachelor’s degree in data science or related field and 2+ years of related experience
Proven experience writing relational and multi-dimensional SQL database queries.
Experience with Azure Data Lake
Experience with ETL and ELT that move data from disparate systems.
Experience with Git and Azure DevOps, JSON.
Scripting language experience: Python, PowerShell.
Understanding of OLTP databases, OLAP databases, data stores, and analytical structure principles
Knowledge of data mining and segmentation techniques
Experience with designing, building, monitoring, and troubleshooting BI solutions.
Demonstrated innovation, customer focus, attention to detail, acquisition of new technical skills, and ability to navigate ambiguous and fast-paced situations.
Preferred Qualifications
Master’s degree in data science or related field and 2+ years of related experience
· Microsoft certification DP-203: Data Engineering on Microsoft Azure.
· Experience with Azure Databricks.
· Experience with Microsoft Power BI including DAX commands.
· Experience with Microsoft SQL Server stored procedures and functions.
· Proficiency and application of R language.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 17, 2021 at 1:50 pm
Rubber ducky effect is strong for me this morning. Was baffled for the past couple of days as to why the "exact same code" would work in a query window but fail within a tSQLt test. Finally decided to post the question here, as I'm writing up the sample code I realize …… that the test that's failing is in a different schema than the code I'm using.
D'oh!
Thanks everyone for helping me without helping me! Super fast response time! haha
This is a good reminder for why we ask for the sample data and expected results. I have found that just putting that together will often lead to a solution or helps identify the actual issue. Instead of taking pages of back and forth in the forum just to get to the OP's expected result we often end up with multiple valid solutions.
Unfortunately - that does sometimes lead to a much larger discussion on which valid solution is the better solution.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 17, 2021 at 1:57 pm
[F]ortunately - that does sometimes lead to a much larger discussion on which valid solution is the better solution.
Fixed that for you. This is always the most important part, to Jeff's larger point above. Knowing what to do implies knowing why you are doing it, if you are doing it correctly.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 17, 2021 at 1:57 pm
This is from a job posting that another department in my company put together.
Basic Qualifications
Bachelor’s degree in data science or related field and 2+ years of related experience Proven experience writing relational and multi-dimensional SQL database queries. Experience with Azure Data Lake Experience with ETL and ELT that move data from disparate systems. Experience with Git and Azure DevOps, JSON. Scripting language experience: Python, PowerShell. Understanding of OLTP databases, OLAP databases, data stores, and analytical structure principles Knowledge of data mining and segmentation techniques Experience with designing, building, monitoring, and troubleshooting BI solutions. Demonstrated innovation, customer focus, attention to detail, acquisition of new technical skills, and ability to navigate ambiguous and fast-paced situations. Preferred Qualifications
Master’s degree in data science or related field and 2+ years of related experience · Microsoft certification DP-203: Data Engineering on Microsoft Azure.
· Experience with Azure Databricks.
· Experience with Microsoft Power BI including DAX commands.
· Experience with Microsoft SQL Server stored procedures and functions.
· Proficiency and application of R language.
Sooo, why not just specify the Masters to begin with since you can't have it without the BA degree? Also, aren't Masters degrees pretty much just money-sink scams that get you a pretty piece of paper without giving you the real-world knowledge you actually need to do your jobs?
Although, since my BA is in an unrelated field to IT, I'm already failing the job requirements despite having working with SQL for over 16 years. Guess I will take my server and find another company to play with. (@sob)
August 17, 2021 at 1:59 pm
If they put Masters in the Basic requirements, HR will never forward anyone who doesn't have it, regardless of experience. Having it in preferred also gives them the option to push for higher salary if they find someone with that.
Reindeer games, basically.
Looks like a good career goal list for me though. Other than the master's, I've enough student debt as it is.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 17, 2021 at 2:03 pm
If they put Masters in the Basic requirements, HR will never forward anyone who doesn't have it, regardless of experience. Having it in preferred also gives them the option to push for higher salary if they find someone with that.
Reindeer games, basically.
Looks like a good career goal list for me though. Other than the master's, I've enough student debt as it is.
Ahh. The post formatting made me miss the "Preferred Qualifications" comment right before the masters' degree. I thought it was required.
My bad.
I have a laundry list of things I want to learn related to new SQL functionality. And not enough time to learn them. Sigh. PowerShell first. Definitely need that. R and the others can wait.
August 17, 2021 at 3:45 pm
Not a bad description, though I dislike the "experience" with, as it doesn't weight anything higher than anything else. What do you care about more? Not that you might find a good candidate, but I assume you want someone more in the data science area, maybe more R than Python or the reverse.
Not that you can't teach someone a portion of skills, but I'd try to aim the description more at the type of person I want and have a bunch of nice to haves in there. Like git/Azure DevOps. Takes about 2-3 weeks to get someone in that habit and teach them a few things if they've never used it.
August 17, 2021 at 4:05 pm
Not a bad description, though I dislike the "experience" with, as it doesn't weight anything higher than anything else. What do you care about more? Not that you might find a good candidate, but I assume you want someone more in the data science area, maybe more R than Python or the reverse.
Not that you can't teach someone a portion of skills, but I'd try to aim the description more at the type of person I want and have a bunch of nice to haves in there. Like git/Azure DevOps. Takes about 2-3 weeks to get someone in that habit and teach them a few things if they've never used it.
I have no idea what they are looking for, actually. This group writes reports.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 17, 2021 at 4:07 pm
Rubber ducky effect is strong for me this morning. Was baffled for the past couple of days as to why the "exact same code" would work in a query window but fail within a tSQLt test. Finally decided to post the question here, as I'm writing up the sample code I realize …… that the test that's failing is in a different schema than the code I'm using.
D'oh!
Thanks everyone for helping me without helping me! Super fast response time! haha
You should still post the question and how you fixed it. Someone else may have the same or similar problem.
August 17, 2021 at 5:46 pm
I have found that just putting that together will often lead to a solution or helps identify the actual issue.
Heh... PREACH IT BROTHER! 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2021 at 1:54 am
Steve Jones - SSC Editor wrote:Not a bad description, though I dislike the "experience" with, as it doesn't weight anything higher than anything else. What do you care about more? Not that you might find a good candidate, but I assume you want someone more in the data science area, maybe more R than Python or the reverse.
Not that you can't teach someone a portion of skills, but I'd try to aim the description more at the type of person I want and have a bunch of nice to haves in there. Like git/Azure DevOps. Takes about 2-3 weeks to get someone in that habit and teach them a few things if they've never used it.
I have no idea what they are looking for, actually. This group writes reports.
That's what I do hehe. They're looking for someone that can take on incoming data files from disparate sources, combine them in some logical way within databases/data warehouses, write reports that compare those files to each other and the systems that the rest of the business uses to see what needs fixed, track and trend anything that's wrong or needs attention. Plus, gather requirements, build out the reports, get fancy with visualizations and forecasting using statistics in R. And stay organized by putting it all into DevOps and git. Oh, and "Demonstrated innovation, customer focus, attention to detail, acquisition of new technical skills, and ability to navigate ambiguous and fast-paced situations", so "willing to work all hours of the day and night for some dumb solution, especially when it breaks, and doesn't care when people yell at them for things that aren't their fault".
Surprised they didn't throw it in but "willing to train their replacement" is probably in there too.
That's like three or four teams' worth of work, but that's what they're looking for. If they can find someone with half of that, they'll be happy.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 18, 2021 at 1:57 am
jonathan.crawford wrote:Rubber ducky effect is strong for me this morning. Was baffled for the past couple of days as to why the "exact same code" would work in a query window but fail within a tSQLt test. Finally decided to post the question here, as I'm writing up the sample code I realize …… that the test that's failing is in a different schema than the code I'm using.
D'oh!
Thanks everyone for helping me without helping me! Super fast response time! haha
You should still post the question and how you fixed it. Someone else may have the same or similar problem.
I hear you and understand what you mean, but it's literally a case of "I took the code from the wrong test and thought it worked, when it wasn't what was failing". PEBKAC
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 18, 2021 at 12:42 pm
Heads up, folks. Norton Life Lock lit up big time on the following breach. It looks pretty serious...
https://www.wired.com/story/t-mobile-hack-data-phishing/
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2021 at 5:41 pm
wonder if that affects me. I use Google FI, but it uses T-Mo as an underlying network, among others.
August 18, 2021 at 6:11 pm
There's a reason the wife and I have froze our credit reports.
I KNOW my info has been leaked, and several times from various breaches. Aside from not using the same passwords around and freezing the reports, there's not a whole lot else I can do.
That, and keep an eye on the credit reports...
Viewing 15 posts - 65,641 through 65,655 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply