ETL LeadBrillio • Plainsboro, NJ, United States

ETL Lead

Brillio • Plainsboro, NJ, United States

1 hour 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

SAP Application Observability and Automation Lead (Raritan)

Tata Consultancy Services • Raritan, NJ, US

Full-time +1

Role : SAP Application Observability and Automation Lead.Location : Raritan, NJ (Onsite).Must Have Technical / Functional Skills. We are seeking a highly skilled and proactive SAP Application Support Le...Show more

Last updated: less than 1 hour ago • Promoted • New!

Loader

Owens Corning • Branchburg, NJ, United States

Full-time

Branchburg, NJ, US, 08876 .DTM marginTopNone marginBottomNone marginRightNone marginLeftMedium" style="margin-top : px; "> . Owens Corning, global in scope - human in scale.We're an internatio...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: 1 hour 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

Cardiology Business Manager

Deborah Heart and Lung Center • Browns Mills, NJ, US

Full-time

Job Details Description Position Summary : The Cardiology Business Manager is responsible for the daily business, data, and financial operations of the cardiology product line.This manager-level lea...Show more

Last updated: 8 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: 1 hour ago • Promoted • New!

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: 2 hours ago • Promoted • New!

Deal Leader - Banking BPO

New Jersey Staffing • Princeton, NJ, US

Full-time

Senior Business Development Leader For Banking Bpo.The Senior Business Development Leader for Banking BPO is a high-impact commercial role responsible for driving strategic revenue growth within th...Show more

Last updated: 11 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

Travel - MRI Tech

Titan Medical (Nebraska) • Bordentown, NJ, United States

Full-time

WHEN YOU WORK FOR US, WE WORK FOR YOU.With Titan Medical, you gain access to thousands of travel nursing and allied health jobs across the country. You also get unmatched service.From the moment you...Show more

Last updated: 2 hours ago • Promoted • New!

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

Side Hustle Project Lead

Finance Buzz • Joint Base Mdl, 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

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: 4 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