SQl Developer

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

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)