ON Partners
Pure-play retained executive search designed for the way you work.
Integration & Data Leader
Location
United States
Posted
8 hours ago
Salary
$160K - $170K / year
Bachelor Degree7 yrs expEnglishCloudETLSQLSSIS
Job Description
• 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.
Job 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.