Sr. ETL Developer

The Senior ETL / Data Integration Developer will be part of a Data Migration Team on a larger Case Management System Modernization Program being implemented on Azure using MS Dynamics 365 (PowerApps). The role will design and build data integration routines for moving data from multiple source systems to a new target system with a different data model. Responsibilities include:

• Design and develop Cloud ETL processes and workflows using Azure Data Factory and SQL Server Integration Services (SSIS).
• Develop Extract, transform, and load (ETL) processes to transmit data from legacy on-premises source system to Azure SQL Databases and Dataverse data repository on Azure.
• Create necessary data structures or data models to support data at all stages.
• Use Azure Data Factory/SSIS platform to extract, transform, and load data from legacy source system data extracts to multiple staging area AzureSQL Databases.
• Use KingswaySoft to move data from AzureSQL Database to Common Data Service (CDS) data reporting.
• Communicate analysis, results and ideas to key decision makers including business and technical stakeholders.

Projected compensation range for this position is $135K - $155K. The final salary offered will generally fall within this range and is determined by various factors, including but not limited to the individual's particular combination of education, knowledge, skills, competencies, and experience, as well as internal pay equity, location, contract-specific affordability and other organizational requirements.

Required Skills

• At least 8 years of IT systems development experience, primarily in data integration roles
• More than 4 years of development experience with Microsoft SQL Server
• More than 5 years of experience in SQL scripting (extremely strong SQL skills required, including writing T-SQL stored procedures)
• More than 5 years of experience in ETL development with SQL Server Integration Services (SSIS)
• More than 2 years of experience with Azure Data Factory.
• More than 5 years of experience performing data reconciliation, data validation, ETL testing, deploying ETL packages and automating ETL jobs, developing reconciliation reports.
• Strong analytical skills applied to business software solutions maintenance and/or development
• Must be able to work with a team to write code, review code, and work on system operations.
• Past project experience with Data Conversion and Data Migration
• Experience with Data Quality, Data Quality Rules/ Metrics/Dashboards .
• DevOps experience using GIT, developing, deploying code to production
• Eligible for a Government issued Public Trust Clearance

Desirable Skills

• Experience with MS Power Platform, especially Power BI
• Microsoft certifications
• Active federal government public trust clearance