Job Description :
Hi

Job Title : MS SQL Server Data Warehouse Developer
Location : San Mateo, CA
Duration : Long Term
Description :

Client will hire from phone – skype interviews
18 month long assignment
Really want someone with Healthcare experience
MUST have excellent communication, as will have to interface with Business/Health users

MS SQL Server Data Warehouse Developer - 18 month long contract - San Mateo, CA

Notes:

Candidates must be able to pass a stringent Criminal background check before starting work.
All work done on-site: San Mateo, CA 94403
Client will hire from in person or PHONE interviews
Local to the Bay Area highly preferred
Role:
Our Government client seeks two MS SQL SERVER Data Warehouse Developers. Our client, the Health Information Technology Division (HIT) is looking for two (2) Microsoft SQL Server data warehouse developers with experience working in Microsoft Azure to design and implement a healthcare Enterprise Data Warehouse (EDW

REQUIRED SKILLS:
- Should have 9-10 years work experience as relates to this req
- SQL
– Microsoft Azure
– Power BI
– Microsoft SQL Server
- Love of Data
- Fluent in TSQL
Use of Microsoft Azure Data Lake, Data Factory, and Data Warehouse
Strong SSIS development skills using SQL Server Data Tools and Visual Studio
Ability to write and maintain reports using SQL Server Reporting Services (SSRS) and Power BI
Proficiently use SQL Server Management Studio 2016+
Fluent in C# and/or Python

- Experience/ability designing, implementing, data cleaning and standardizing of the health enterprise- wide data warehouse.
- They will design/implement data processing pipelines, data cleansing, standardization, data profiling, and enrichment processes to populate the data warehouse.
- Should have previous experience with Microsoft Azure data warehousing practices, including SQL Server Analytics and Integration Services and have a firm understanding of data warehousing layout.
- Ability to provide creative and refined solutions to complex data and business requirements.
- Must be able to work effectively under minimal supervision and may be required to provide technical oversight for the work of other team members.

DESIRED SKILLS:

Healthcare experience very strongly preferred (MORE PREFERRED THAN HIE)
Health Information Exchange (HIE) knowledge strongly preferred
MUST BE ABLE TO PERFORM THE BELOW WORK REQUIREMENTS:
* Design, implement, and maintain complex ETL solutions on-premise and in Azure.
Design, implement, and maintain data solutions from data collection and curation through to content delivery via reports, dashboards, and other toolsets.
Model and develop databases and data structures to satisfy business processes and technical requirements.
Solve complex requirements using advanced-level SQL techniques such as window functions, CTEs, CROSS APPLY statements, etc.
Incorporate appropriate tools, technologies, techniques and design patterns to create maintainable, scalable, high-performance database solutions.
Design, implement, and maintain code in development, test, and production environments.
Design solutions to support systematic promotion between environments.
* Write, modify, tune, and debug database indexes, queries, stored procedures, views, user-defined functions, and other database entities.
Perform SQL Server administration activities including backup, restore, DBCC
commands, and indexing.
Automate complex processes with SQL Agent jobs.
Design, develop, and troubleshoot permissions schemas using advanced security concepts.
Identify complex data patterns and inconsistencies through data analysis and data mining.
Collaborate with project managers and business analysts to develop solutions that meet client business requirements.
Stay current with Microsoft SQL Server tools and technologies.
Assist with code reviews.
Define standard work for EDW maintenance