Job Title - Business System Analyst with strong SQL
Location - Philadelphia, PA
Duration - 12 Plus Months
Rate - DOE
U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
No H1B, CPT, OPT and 3
rd party c2c for this client
Job Description - It might differ from project to project, but below might be the crux of what we are looking for apart from Analytical skills.
- They use Google BigQuery to execute the queries they write.
- I am on a daily basis querying the Google Cloud data warehouse to search for data elements requested by external vendor for file requests.
- This includes performing joins to multiple tables, filter conditions in the where or having clause, and writing moderate/advanced case when statements to mock up the data for a file layout request.
- To get further descriptions on the meaning of the data elements within our data warehouse that are unfamiliar, an internal database dictionary is used to get the meaning behind data elements.
- Lastly, in terms of data, tech, and SQL portion of the job of a BSA is to perform UAT testing for file feed requests or enhancements to already existing file feeds.
- SQL scripts are generated to try and find flaws within development of file feed process. (ex. If medicare PPO members are to solely be included in the file, writing a SQL script on the test file for the feed to see if any medicare HMO members accidentally made it into the file).
- In terms of technical ability, a candidate should be very well versed in SQL writing and reading queries while also being able to spot issues within development queries but not write code themselves.