ETL LeadBrillio • Plainsboro, NJ, United States

ETL Lead

Brillio • Plainsboro, NJ, United States

2 hours ago

Job type

Full-time

Job description

Job Title : ETL Lead

Location : Plainsboro, NJ (Hybrid – 3 days onsite / week)

About the Role :

We are seeking a highly skilled and consultative ETL Lead 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 IICS

Architect 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 modeling, partitioning, and indexing.

Lead data migration and integration projects to move legacy data systems to Snowflake.

Collaborate with business analysts, data engineers, and stakeholders to define requirements and deliver data solutions.

Required Skills & Qualifications :

8+ years of experience in data engineering and ETL, with hands-on expertise in Informatica (PowerCenter and IICS)

Advanced SQL skills and experience with performance tuning

Proven experience designing and optimizing solutions in Snowflake

Strong foundation in data warehouse design, with a focus on dimensional modeling

Prior experience in pharma domain with exposure to IQVIA, Komodo, and VEEVA datasets – strongly preferred

Exceptional communication and stakeholder engagement skills

Demonstrated consultative mindset, capable of influencing and leading cross-functional discussions on data-driven value generation

Experience writing business process and technical documentation

Strong project management, organization, and team leadership skills

Ability to work in fast-paced environments with ambiguity and shifting priorities

Key Expectations :

Very strong SQL and Informatica (PowerCenter & IICS) capabilities

Deep understanding of Pharma datasets and commercial analytics

Proven consultative approach with ability to drive thought leadership and business impact

Excellent stakeholder management and presentation skills

Onsite at Plainsboro, NJ – 3 days onsite / week

Preferred Qualifications

SnowPro certification is highly desirable.

Create a job alert for this search

Lead • Plainsboro, NJ, United States

Related jobs

Manager, Non-Credit Allied Health & Workforce Enrollment - Raritan Valley Community College

Raritan Valley Community College • North Branch, NJ, United States

Full-time

Administrative and Professional.Raritan Valley Community College has an anticipated opening for a Manager of Non-Credit Allied Health & Workforce Operations. The Manager of Non-credit Allied Health ...Show more

Last updated: 30+ days ago • Promoted

Side Hustle Project Lead

Finance Buzz • Pemberton, New Jersey, US

Full-time +1

We’re offering a role for someone who wants to lead their own side-income project in their spare time.You’ll explore various proven side hustles, select the ones that fit your lifestyle, and run th...Show more

Last updated: 30+ days ago • Promoted

Sr. Technical Lead

Vertex Solutions Inc. • Princeton, NJ, United States

Full-time

Our insurance client is seeking a dynamic Technical Lead with 5-7 years of experience as a technical lead, with a strong background in working with modern tech stacks like MERN.Join a talented arch...Show more

Last updated: 2 hours ago • Promoted • New!

Absence Leave Solutions PFML Unit Leader

MetLife • Bridgewater, NJ, United States

Full-time

Location : Must live within a commutable distance of the Oriskany, NY, Tampa, FL, Bloomfield, CT Cary, NC, Aurora, IL, Bridgewater, NJ, Omaha, NE, Warwick, RI, Clark Summit, PA, San Juan, PR, West D...Show more

Last updated: 4 days ago • Promoted

Data Analytics Engineer

Dale WorkForce Solutions • Somerset County, NJ, United States

Permanent

Location : 5x per week Somerset, NJ.Our client is a publicly traded, globally recognized technology and manufacturing organization that relies on data-driven insights to support operational excellen...Show more

Last updated: 2 hours ago • Promoted • New!

SAP EWM

Diverse Lynx • Raritan, NJ, US

Full-time

SAP Extended Warehouse Management (EWM).SAP Extended Warehouse Management (EWM).Show more

Last updated: 30+ days ago • Promoted

Customer Support Quality Lead

VirtualVocations • Hamilton, New Jersey, United States

Full-time

A company is looking for a Customer Support Quality Lead to enhance customer support interactions.Key Responsibilities Establish and improve a QA program for evaluating agent performance across s...Show more

Last updated: 3 hours ago • Promoted • New!

Senior Transmission Line Engineer

Leidos Inc • Wrightstown, NJ, United States

Full-time

Senior Transmission Line Engineer.These employees will apply established NESC, ASCE, ACI, and other applicable standards in the engineering and design of electrical overhead and underground systems...Show more

Last updated: 2 days ago • Promoted

ARRT MRI Supervisor

MLee Healthcare Staffing and Recruiting, Inc • Cookstown, NJ, United States

Full-time

Monday - Friday | 5x8s - Day Shift | Full-Time.MRI Supervisor to lead our client's advanced imaging team and oversee daily operations at their hospital. In this full-time role, you'll manage schedul...Show more

Last updated: 30+ days ago • Promoted

Associate Team Leader

H&R Block • Bordentown, NJ, US

Full-time +1

Joining us as an Associate Team Leader, youll support a single retail office during tax season to consistently exceed client expectations and provide daily operations direction for the tax office.Y...Show more

Last updated: 30+ days ago • Promoted

Integration Analyst (Cadence scheduling and decision trees Required)

Barnabas Health Medical Group • Basking Ridge, NJ, US

Full-time

Job Title : Integration Analyst Location : RWJ - 379 Campus Dr, Somerset Department Name : Patient Access Services Req : 0000216949 Status : Salaried Shift : Day Pay Range : $68,724.Pay Transparency : The...Show more

Last updated: 3 days ago • Promoted

Lead Analyst, Contract Analytics, MTST

Johnson and Johnson • Raritan, NJ, United States

Full-time

At Johnson & Johnson, we believe health is everything.Our strength in healthcare innovation empowers us to build a world where complex diseases are prevented, treated, and cured, where treatments a...Show more

Last updated: 5 hours ago • Promoted • New!

Portfolio Delivery and Governance Lead -Whitehouse Station, NJ

Staffing • Whitehouse Station, NJ, US

Temporary

Portfolio Delivery And Governance Lead.Location : Whitehouse Station, NJ - Hybrid.Job Description : The AAE Portfolio Lead will be responsible for running architecture and portfolio governance of all...Show more

Last updated: 30+ days ago • Promoted

CMA I

Axia Women's Health • Warren, NJ, United States

Full-time

Great Place to Work for the 4th year in a row, our vision is to lead the way in improving women's health.At the core of achieving this is a caring, connected, and progressive community of women's h...Show more

Last updated: 9 days ago • Promoted

Procurement / Purchasing Lead

Bluenote • Somerville, NJ, United States

Full-time

A growing B2B company is seeking a Purchasing / Procurement Lead to be responsible for managing vendor relationships, negotiating pricing, and driving cost optimization across product lines.The role ...Show more

Last updated: 2 hours ago • Promoted • New!

PAM Consultant

Cynet Systems • Raritan, NJ, United States

Full-time

Contractor should have a good understanding of Supply Chain, R&D, and OT MLL environments.Understanding the applications interaction. Good understanding on qualification process.Good level of knowle...Show more

Last updated: 17 days ago • Promoted

AML Modeling Specialist

Santander Holdings USA Inc • Trenton, NJ, US

Full-time

Country : United States of America.Santander is a global leader and innovator in the financial services industry.We believe that our employees are our greatest asset. Our focus is on fostering an enr...Show more

Last updated: 29 days ago • Promoted

Data Architect

Pyramid Consulting, Inc • Basking Ridge, NJ, United States

Temporary

Please review the job description below and contact me ASAP if you are interested.Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and pai...Show more

Last updated: 2 hours ago • Promoted • New!