ON Partners

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

Integration & Data Leader

Data ScientistData ScientistFull TimeRemoteTeam 51-200Since 2006H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

7 days 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

More Data Scientist Jobs

Staff Data Scientist

Milliman

Solutions for a world at risk™

Data Scientist7 days ago
Full TimeRemoteTeam 1,001-5,000Since 1947

What We Do Milliman IntelliScript is a group of a few hundred experts in fields ranging from actuarial science to information technology to clinical practice. Together, we develop and deploy category-defining, data-driven, software-as-a-service (SaaS) products for a broad spectru...

United States
Data Scientist7 days ago
InternshipRemoteTeam 1,001-5,000H1B No Sponsor

Data Science Intern contributing to reinsurance and commercial insurance projects

Python
Nevada
$33 - $36 / hour

Data Scientist - Machine Learning

Blue Rose Research

Blue Rose Research is a project with OpenLabs to develop a wide range of cutting-edge products used by the most important progressive organizations in the country. Our research undergirds short-term and long-term strategy for advancing progressive causes and has a trusted track record among key decision makers. Our team members have a storied history, and have worked with central players to develop strategy and direct hundreds of millions of dollars of resources over the past several electoral cycles. The work produced by the team is widely regarded as among the most technically sophisticated in the space. If you join us, you’ll be plugging into a diverse team of decorated engineers, PhD data scientists and political insiders who are closely connected to some of the most important decision makers in the progressive ecosystem. Our work ranges from high-dimensional Bayesian modeling to make accurate inferences from polling data to building utility-scale data and analytics infrastructure for the progressive left. Come join us!

Data Scientist7 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor

This role sits at the center of our forecasting team, which builds models that help progressive organizations understand the electoral landscape and make informed decisions. Own the full lifecycle from messy data to actionable insight, collaborating with an interdisciplinary team...

United States

Senior Data Scientist

West Bend Insurance Company

Providing valuable insurance coverages and services for over 130 years. Follow ➡️ #wbsilverlining for great content!

Data Scientist7 days ago
Full TimeRemoteTeam 1,001-5,000Since 1894H1B No Sponsor

The Senior Data Scientist applies advanced analytics, predictive modeling, and data science techniques to solve complex Property & Casualty (P&C) insurance business problems. This role partners closely with business and technical stakeholders to develop insights that improve pric...

United States