SQL Server Developer

Title: SQL Server Developer

Company: Healthcare Client

Remote / Hybrid Schedule: 3 day onsite and 2 remote (they can choose which)

OR Fully remote

Duration: 6+ months, contract to hire (they will sponsor but must be able to convert after 6 months)

Day to Day:

• Creating SSRS packages

• Creating SQL stored procedures

• Creating dashboards with python

• Extracting and Loading Data using API's

• Building ETL processes

Must Haves:

• 10-15 years of SQL development experience

• Azure Data Factory

• API's

• Python experience

• SSRS, ETL

• Able to interface with senior leadership

• Experience creating dashboards

Job Description Summary

Roles & Responsibilities:

• Design SSIS/ETL packages to load and transform data to and from various source and destination systems in specified formats (e.g., SQL Server databases, web services, flat files).

• Design, develop and support new/existing data marts

• Troubleshooting of existing BI processes and timely resolution of the issues.

• Work with business users and business analysts to gather requirements for the design, creation, and implementation of changes to existing database systems or new systems.

• Support and maintenance of existing processes and systems

• Closely work with offshore and onshore development teams and deliver projects on time

• Create support documentation and cross-train other development team members on implemented processes so that they can support these solutions.

Must Have:

• Expert level experience with T-SQL(10+ years). Should have hands on experience with writing complex and optimized queries, analytical queries and performance tuning.

• Extensive hands-on with SSIS (10+ years)

• Must have hands-on with architecting end-to-end integration solutions and data syncs between OLTP and BI systems.

• Must have experience with extracting & loading data using APIs.

• Build custom modules using C#

• Experience with Power BI developing Analytical and Operational dashboards.

• Experience with Microsoft Azure (ADF) (5+ years)

• Experience with Python (3+ years)

• Prior experience working with healthcare data

• Excellent organizational, interpersonal, presentation, and analytical skills. Ability to perform comfortably in a fast-paced, dynamic and deadline-oriented work environment

• Ability to successfully execute multiple complex tasks simultaneously

Good to Have:

• Experience with Snowflake

• Experience using PowerShell scripts (2+ years)