ON Partners

Pure-play retained executive search designed for the way you work.

Integration & Data Leader

Full TimeRemoteTeam 51-200Since 2006H1B No SponsorCompany SiteLinkedIn

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.

Related Categories

Related Job Pages