Lead the migration and integration of enterprise data across systems using SQL, SSIS, and related data movement technologies.
Design and oversee data integration processes that support enterprise system interoperability.
Ensure data migrations are delivered with high levels of accuracy, completeness, and validation controls.
Coordinate the end-to-end lifecycle of data integrations including discovery, source-to-target mapping, build, testing, and deployment.
Partner with business and technical stakeholders to gather integration requirements and understand system dependencies.
Define data attributes, transformation rules, and mapping logic necessary for successful integration.
Identify data quality risks and remediation strategies prior to integration or migration activities.
Facilitate integration discovery workshops and architecture discussions with client teams.
Design scalable integration solutions leveraging SQL, SSIS, and enterprise integration patterns.
Oversee the development and execution of data pipelines, transformation logic, and integration workflows.
Ensure integrations align with enterprise architecture standards and system interoperability requirements.
Establish and maintain documentation including source-to-target mappings, integration specifications, and technical runbooks.
Identify and address data quality considerations during migration and integration processes.
Work with data governance teams to ensure integrations follow data standards and stewardship practices.
Implement validation and reconciliation processes to ensure data integrity across systems.
Continuously expand technical capabilities by learning and adopting modern integration technologies and iPaaS platforms.
Support the organization’s transition from traditional ETL approaches toward cloud-based integration architectures.
Contribute to the development of modern integration frameworks and reusable patterns.

Requirements

7+ years of experience in data integration, ETL development, or enterprise data migration.
Strong experience with SQL and SSIS for building and managing data pipelines.
Proven ability to lead complex data migration initiatives across enterprise systems.
Experience defining source-to-target mappings and data transformation rules.
Strong understanding of data quality practices, validation, and reconciliation techniques.
Ability to collaborate effectively with both business and technical stakeholders.
Strong documentation and communication skills for technical and functional audiences.

Benefits

Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
11 paid federal holidays and flexible unlimited time off (UTO)
Generous 401(k) matching with immediate vesting
Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
A healthy environment where we value unique experiences, and care about everything that makes you, you.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLSSISdata integrationETL developmentdata migrationdata pipelinesdata transformationdata qualityvalidation techniquesreconciliation processes

Soft Skills

collaborationcommunicationdocumentationleadershipproblem-solving