SQL DEVELOPER :: 10+ YEARS :: HYBRID IN OHIO

SQL Server Developer
Can be Remote, Client strongly prefers someone that will relocate just outside of Cleveland, OH
Citizen, GC, Green Card EAD

•    Must have 10+ years of SQL
•    Must have Healthcare
•    Azure Data Factory
•    Expert level experience with T-SQL(10+ years).
             SSIS – 10+ years
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)