Data Architect

3 Months ago • 8 Years + • Data Analysis • $130,000 PA - $140,000 PA

Job Summary

Job Description

Brillio is seeking a highly skilled and consultative Lead Data Engineer with deep experience in Data Warehousing and Informatica to lead data integration initiatives for its Life Science practice. The role involves architecting high-performance, scalable solutions on Snowflake Data Warehouse, designing robust data models, and acting as a strategic advisor to business stakeholders to drive value through data. Responsibilities include designing, developing, and optimizing ETL workflows using Informatica PowerCenter and IICS, leading data migration and integration projects, and ensuring alignment between technical delivery and business value realization. The role requires strong SQL, Informatica, and data warehousing skills, with experience in the pharma domain being preferred.
Must have:
  • 8+ years of experience in data engineering and ETL
  • 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
  • Exceptional communication and stakeholder engagement skills
  • Demonstrated consultative mindset
  • Strong project management and team leadership skills
Good to have:
  • Experience in pharma domain with IQVIA, Komodo, and VEEVA datasets
  • SnowPro certification

Job Details

About Brillio:

Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.

Consultant

Primary Skills
  • ETL Fundamentals, SQL, SQL (Basic + Advanced), Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, PLSQL, T-SQL, Stored Procedures

Job requirements

  • Job Title: Lead Data Engineer– Pharma Data Engineering 
  • Location: Plainsboro, NJ (Hybrid – 3 days onsite/week)
 
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 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.

Know more about:
Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/
 
Equal Employment Opportunity Declaration
Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
 
#LI-SR1

Similar Jobs

Silicon Labs - Engineering Manager - MCU Software Development

Silicon Labs

Hyderabad, Telangana, India (On-Site)
3 Weeks ago
Ubisoft - Community Developer

Ubisoft

Montpellier, Occitanie, France (On-Site)
3 Months ago
Thumbtack - Senior Data Scientist, Product

Thumbtack

United States (Remote)
3 Weeks ago
Antarctica Global - Data Analyst

Antarctica Global

Mumbai, Maharashtra, India (Hybrid)
1 Year ago
Adyen - Manager, Account Management

Adyen

Paris, Île-de-France, France (On-Site)
1 Month ago
Unity - Senior Business Systems Analyst

Unity

United States (Remote)
7 Months ago
Meta - Data Science Director

Meta

Menlo Park, California, United States (Remote)
8 Months ago
Hashlist - Principal Data Engineer

Hashlist

Chennai, Tamil Nadu, India (Hybrid)
9 Months ago
luxsoft - Data Architect

luxsoft

Milton Keynes, England, United Kingdom (On-Site)
2 Months ago
Growe - Data Analyst

Growe

(Remote)
1 Month ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Axon - Senior Mechanical Engineer - Thermal

Axon

Scottsdale, Arizona, United States (On-Site)
1 Month ago
Apple - AIML - Senior Engineering Program Manager, FM Evaluation

Apple

Cupertino, California, United States (On-Site)
1 Month ago
Instawork - Product Operations Manager

Instawork

Chicago, Illinois, United States (On-Site)
1 Month ago
Workato - Manager, Technical Delivery

Workato

Singapore (On-Site)
2 Weeks ago
bytro studios - Java Backend Engineer

bytro studios

St. Julian's, Malta (Hybrid)
5 Months ago
zeta - Associate Director - Program Management

zeta

Bengaluru, Karnataka, India (On-Site)
1 Month ago
Mixpanel - Senior Account Executive, Enterprise

Mixpanel

New York, New York, United States (Hybrid)
2 Weeks ago
Rockstar Games - Engineering Manager

Rockstar Games

Edinburgh, Scotland, United Kingdom (On-Site)
2 Months ago
Penumbrainc - Sr. Manager SAP Operations

Penumbrainc

Alameda, California, United States (Hybrid)
9 Months ago
Notion - Product Counsel

Notion

San Francisco, California, United States (On-Site)
2 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Plainsboro Township, New Jersey, United States

Illumination - Storyboard Artist Intern - Summer 2025

Illumination

Santa Monica, California, United States (Hybrid)
5 Months ago
Palo Alto Networks - Consulting Director, DFIR, Reactive Services (Unit 42)

Palo Alto Networks

Santa Clara, California, United States (Remote)
2 Months ago
Glean - Solutions Architect

Glean

Seattle, Washington, United States (On-Site)
2 Months ago
Thatgamecompany - Product Data Scientist

Thatgamecompany

United States (Remote)
4 Months ago
whoop - Senior Test Development Engineer (Software)

whoop

Boston, Massachusetts, United States (On-Site)
1 Month ago
rivos - SOC Design Verification

rivos

Santa Clara, California, United States (Hybrid)
3 Years ago
Marvell - Analog Design Engineer, Sr. Principal

Marvell

Irvine, California, United States (On-Site)
2 Months ago
Pattern - Senior Product Manager - Operations

Pattern

Lehi, Utah, United States (On-Site)
2 Months ago
Haleon - Manufacturing Technician - Days

Haleon

New York, United States (On-Site)
1 Year ago
Apple - Software Engineer - Strategic Data Solutions

Apple

Austin, Texas, United States (On-Site)
2 Weeks ago

Get notifed when new similar jobs are uploaded

Data Analysis Jobs

Apple - AI Solutions Architect, Data Solutions & Initiatives

Apple

Cupertino, California, United States (On-Site)
1 Month ago
Publicis Groupe - Publicis Media - Dual Study Program Business Informatics Data Science & AI (m/f/d) - 2026 - Duesseldorf / Ravensburg

Publicis Groupe

Düsseldorf, North Rhine-Westphalia, Germany (Hybrid)
2 Weeks ago
Axel springer - Cloud Engineer - Data Processing Platform

Axel springer

Berlin, Berlin, Germany (On-Site)
2 Months ago
Bluevine India - Senior Data Scientist

Bluevine India

Bengaluru, Karnataka, India (Hybrid)
3 Months ago
eBay - Data Science Analyst, Seller Experience

eBay

Toronto, Ontario, Canada (Hybrid)
3 Weeks ago
Comscore - Associate Data Dictionary Analyst - Chinese

Comscore

London, England, United Kingdom (On-Site)
3 Weeks ago
PayPal - Senior Data Scientist

PayPal

Dublin, County Dublin, Ireland (Hybrid)
2 Weeks ago
Scorewarrior - Data Scientist (Marketing)

Scorewarrior

Limassol, Limassol, Cyprus (On-Site)
1 Month ago
Tencent - Game Operations (Data Analysis) --PUBGM Eastern Europe

Tencent

Shenzhen, Guangdong Province, China (On-Site)
2 Months ago
Next Level Business Services - Sr. Big Data Engineer in San Francisco, CA  / McLean, VA

Next Level Business Services

San Francisco, California, United States (On-Site)
9 Months ago

Get notifed when new similar jobs are uploaded

About The Company

Phoenix, Arizona, United States (Hybrid)

Guadalajara, Jalisco, Mexico (Hybrid)

Guadalajara, Jalisco, Mexico (Hybrid)

St. Louis, Missouri, United States (Remote)

Guadalajara, Jalisco, Mexico (Hybrid)

Warren, New Jersey, United States (On-Site)

Guadalajara, Jalisco, Mexico (Hybrid)

Tampa, Florida, United States (Hybrid)

Phoenix, Arizona, United States (Remote)

Guadalajara, Jalisco, Mexico (Hybrid)

View All Jobs

Get notified when new jobs are added by Brillio