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

About the role

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.