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.