Lead ETL Data Engineer
argyle infotechPlainsboro (NJ)
Lead ETL Data Engineer
Posted 7 days ago
argyle infotechPlainsboro (NJ)
SENIORITY
Lead
About the role
Lead ETL Data Engineer– Pharma Data Engineering
Location:
Plainsboro, NJ (Hybrid – 3 days onsite/week) local to New Jersey or tri-State candidate
About the Role:
We are seeking a highly skilled and consultative Lead Data Engineer with deep experience in Data Warehousing and Informatica to lead data integration initiatives for a Life Science practice within Brillio. This role is ideal for someone who not only excels technically but thrives as a thought partner to business stakeholders, helping to uncover opportunities for value creation through data.
Key Responsibilities:
- Lead the design, development, and optimization of ETL workflows using Informatica PowerCenter and IICSArchitect high-performance, scalable solutions on Snowflake Data Warehouse
- Design robust data models with strong understanding of facts and dimensions
- Act as a strategic advisor to business stakeholders, using data to drive insights and business outcomes
- Partner with line-of business leaders to identify and prioritize opportunities where data engineering can deliver measurable value
- Lead a team of data engineers through complex integration efforts with a problem solving attitude
- Translate unstructured problems into structured, scalable data solutions
- Deliver high quality business presentations and solution documentation tailored to technical and executive audiences
- Ensure alignment between technical delivery and business value realization
Optimize performance through effective data modelling, partitioning, and indexing.
Lead data migration and integration projects to move legacy data systems to Snowflake.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.