Job Title : Data Solution Architect
Location : Plainsboro, NJ – Hybrid (only locals)
Employment Type : Long Term Contract
Job Summary
We are seeking an experienced Data Engineering Solution Architect to design and implement a Commercial Data Lake (CDL) platform for European commercial data. The ideal candidate will have strong experience in AWS-based data lake architecture, ETL pipeline development using AWS Glue, Snowflake integration, and Master Data Management (MDM) using Reltio.
This role will focus on building scalable Lakehouse architectures using the Medallion (Bronze, Silver, Gold) data model to support commercial analytics, reporting, and business intelligence for life sciences datasets.
Job description :
Required Skills
- Strong experience with AWS Glue and ETL pipeline development
- Experience building Data Lakes on AWS
- Knowledge of Lakehouse architecture and Medallion data modeling
- Strong expertise in Snowflake data warehousing
- Experience with data modeling and enterprise data transformations
- Hands-on experience with Reltio Master Data Management (MDM)
- Experience integrating multiple enterprise data sources
- Knowledge of data quality, data governance, and data standardization frameworks
- Strong collaboration and architecture design skills
Key Responsibilities
· Data Lake & ETL Architecture
· Data Warehousing & Analytics
· Data Modeling
· Master Data Management Integration
· Data Governance & Quality
