Data Engineering - Solution Architect Onshore, NJ - Hybrid RoleRole: 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.New Jersey, United StatesESR Healthcare