Senior Architect - R01569361

New York, New York, US hybrid Until 10/7/2026 First posted August 8, 2026 Last posted August 8, 2026
Job description
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.

Job Title: ETL Lead

Location: Hybrid – Plainsboro NJ - 4Days

Primary Skills: IICS, IDMC, Snowflake, SQL

Key responsibilities :

  • Extensive Hands-on in data warehouse designing
  • Hands on in Informatica skills with excellent problem solving capability.
  • Ability to lead the team and guide them through difficult situations.
  • Excellent communication and articulation skills.
  • Presentable skills to Business and technical teams.
  • Through understanding for dimension and facts.
  • Need to have a Problem solver attitude.
  • Understanding of Pharma domain with respect to Life Science datasets from IQVIA, Komodo, VEEVA tool sets
  • Expertise with Snowflake DWH in terms of architecture and optimization
  • Experience with Informatica Power center and IICS
  • Strong business communication Good understanding and knowledge one Snowflake Cortex AI
  • Good to have Pharma domain experience.
  • Build and lead solution charter in areas of data engineering
  • Comfortable with technical details like building first cut architecture design
  • Razor sharp skills on execution of small to large programs
  • Ability to work in ambiguous situations with unstructured problems and anticipate potential issues/risks
  • Experience in handling complex information and presenting it in compelling narratives through business presentations for various audiences
  • Professional agility and strategic thinking
  • Ability to write and design technical business process documentation
  • Excellent project management, relationship building and organizational skills

 

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-CH1

 
Know what it’s like to work and grow at Brillio: Click here

Compensation (from employer):
140000–150000 USD per year

About this role

Summary

Lead data warehousing projects using Informatica, Snowflake, and SQL in pharma domain.

Job title

ETL Lead

Experience level

senior level

Industry

technology

Location requirements

hybrid work in New York, remote allowed

Salary

$140k–$150k

Management role

No

Skills & keywords

Required skills

IICSIDMCSnowflakeSQLInformatica Powercenter

Preferred skills

Pharma domain experiencebusiness communicationarchitecture designproject management

Specializations

data warehousinginformaticasnowflakesqlpharma domain
Locations

Structured locations inferred from the posting.

New York, NY, USA

Hybrid City