Title: SQL Server Developer

Location: 100% Remote

Duration: 6 Months CTH

Visa: No H1B

Must have healthcare Experience & 10+ Years of SQL & SSIS Experience 

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)