Data Engineer - Data Source Enablement

Curate Partners is seeking a Data Engineer to support the Clinical OMOP squad in onboarding new clinical data sources into the Clinical Analytics Enablement Layer. The role focuses on building source-to-OMOP mappings, developing SQL and Airflow data pipelines, validating clinical data integration and quality, and supporting deployment, monitoring, reconciliation, documentation, and downstream communication.

Responsibilities

• Design and build source-to-OMOP mappings, translating source clinical content into the appropriate OMOP domains and tables
• Develop and update pipeline transformations (SQL/Airflow DAGs) to ingest, transform, and load new source data into Clinical OMOP
• Validate patient identity resolution, ensuring new source records correctly integrate with existing OMOP person-matching processes
• Validate terminology mappings and standardized vocabulary/concept assignment for newly onboarded source data
• Perform end-to-end validation in test environments and support production deployment and post-release monitoring
• Represent newly onboarded sources in reconciliation and observability processes
• Update documentation and data dictionaries, and communicate new source availability to downstream Clinical OMOP consumers
• Work across multiple concurrent source-enablement workstreams to meet Q4 delivery targets

Company

• Consulting and talent solutions for digital transformation
• Woburn, Massachusetts, USA
• https://curatepartners.com/
• Founded in 2014
• 51-200 employees

Qualifications

• Strong SQL skills, with hands-on BigQuery experience
• Experience with pipeline orchestration tools (e.g., Airflow) for data ingestion and transformation development
• Familiarity with the OMOP Common Data Model (CDM), clinical terminology/vocabulary standards, and patient matching concepts
• Experience validating data quality (completeness, conformance, plausibility) for newly onboarded data sources
• Experience in a GCP data analytics environment
• Ability to work independently across multiple concurrent data source enablement efforts in an agile/sprint-based delivery model
• Curate Partners is a specialized recruitment agency that bridges the talent gap in digital transformation.
• Woburn, Massachusetts, USA
• https://curatepartners.com
• H1B Sponsorship
• Data Powered by
• Distribution of Different Job Fields Receiving Sponsorship
• Represents job field similar to this job
• Engineering and Development
• Trends of Total Sponsorships
• *2026
• (1)
• 2022
• 2021
• (3)
• 2020
• Growth Stage
• Leadership Team
• Ian Hambelton CISSP CISM
• Chief Information Security Officer
• Vijay Kukreja
• Chief Consulting Officer
• Company data provided by
• AI Tools
• Customize Your Resume
• Maximize your interview chances
• Build Cover Letter
• Make your application stand out
• Analyze How Well You Fit
• Understand your strength & weakness

Required skills

• SQL, Google BigQuery, Apache Airflow, OMOP Common Data Model, Clinical Terminology and Vocabulary Standards, Patient Matching, Data Quality Validation, Google Cloud Platform, Agile Delivery

Experience

• Mid level