Integration & Data Leader

Role Overview

• 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.

Tech Stack

• Cloud
• ETL
• SQL
• SSIS

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.