Data Engineering - Solution Architect  Onshore , NJ - Hybrid role. 

$99,999 yearly
  • ESR Healthcare
  • NJ
  • Mar 04, 2026

Job Description

Data Engineering - Solution Architect  Onshore , NJ - Hybrid role. 

> Role: Solution Architect - Commercial Data Lake (Europe CDL) 

>      * Design and manage end-to-end ETL pipelines using AWS Glue
> following Lakehouse and Medallion (Bronze/Silver/Gold) architecture.
>      * Build and maintain a Data Lake on AWS, integrating data from
> various sources, with Snowflake as the analytical warehouse.
>      * Lead data modeling and transformations for commercial life
> sciences datasets, including Sales, CRM, HCP/HCO, Address, and
> Affiliation data.
>      * Define integration architecture and data mappings with Reltio MDM,
> including mastering rules, inbound/outbound data flows, and ID
> propagation (in collaboration with Reltio specialists).
>      * Drive data standardization, enrichment, and quality controls to
> support trusted analytics and downstream consumption.
>      * Design curated Gold-layer datasets and KPIs to power dashboards
> and business reporting.
>      * Partner with business and analytics teams to translate commercial
> data requirements into scalable technical solutions.
>      * Provide architectural guidance, best practices, and support for
> data governance, scalability, and performance.