SQL Server Developer

Must Haves :

Must have 10+ years of SQL

Must have strong Power BI

Must have Healthcare

Azure Data Factory

Expert level experience with T-SQL(10+ years).

SSIS – 10+ years

Title : SQL Server Developer

Open: 1

Company: Healthcare Client

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

OR Fully remote

Hours | shift | On Call | Timezone: 8-5 EST hours

Team: Database and Business Analytics

Exclusive: yes

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

Start: ASAP

Interview Process: 1 round interview that will be both technical and cultural with and his team

Prescheduled Interview Times: no

What the environment / Sell:

Dress Code: business casual

Notes: N/A

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)