SQl Developer

Title : SQL Server Developer

Can be Remote, Client strongly prefers someone that will relocate just outside of Cleveland, OH

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)