SQL Server DeveloperCan be remote, client strongly prefers someone that will relocate just outside of Cleveland, OHDay To DayCreating SSRS packagesCreating SQL stored proceduresCreating dashboards with pythonExtracting and Loading Data using API'sBuilding ETL processesMust Haves10-15 years of SQL development experienceAzure Data FactoryAPI'sPython experienceSSRS, ETLAble to interface with senior leadershipExperience creating dashboardsRoles & ResponsibilitiesDesign 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 martsTroubleshooting 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 systemsClosely work with offshore and onshore development teams and deliver projects on timeCreate support documentation and cross-train other development team members on implemented processes so that they can support these solutions.Must HaveExpert 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 dataExcellent organizational, interpersonal, presentation, and analytical skills. Ability to perform comfortably in a fast-paced, dynamic and deadline-oriented work environmentAbility to successfully execute multiple complex tasks simultaneouslyGood To HaveExperience with SnowflakeExperience using PowerShell scripts (2+ years)