Lead ETL/Data Warehouse architect designing and optimizing Snowflake DWHs, building ETL with Informatica (IICS/PowerCenter/IDMC), guiding teams, producing architecture and technical documentation, managing projects, and presenting complex information to business and technical stakeholders. Works with pharma life-science datasets (IQVIA, Komodo, Veeva).
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
Brillio Basking Ridge, New Jersey, USA Office
Basking Ridge, United States
Brillio Bridgewater, New Jersey, USA Office
Bridgewater, United States
Brillio Edison, New Jersey, USA Office
399 Thornall Street, Edison, NJ, United States, 08837
Brillio Jersey City, New Jersey, USA Office
Jersey City, United States
Similar Jobs
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead and develop a team of pre-sales solution architects to drive partner-aligned solution development and go-to-market strategies. Assign and align resources to opportunities, support demand generation, recruit and coach staff, evaluate performance, and manage day-to-day operations (scheduling, expenses, reporting). Advocate ServiceNow platform solutions, integrate AI into workflows, and collaborate with cross-functional and executive stakeholders to accelerate partner monetization and market penetration.
Top Skills:
AINow PlatformServicenow
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Own the multi-year vision and end-to-end software install experience for Samsara devices. Drive install correctness metric, design guided install and verification flows in the Samsara Fleet app, build intelligence to verify hardware installs, provide fleet readiness visibility, run customer install observations, and translate findings into roadmap across hardware, firmware, and software.
eCommerce • Fashion • Retail • Sales • Wearables • Design
Lead HR Business Partner for corporate functions (Finance, Legal, IT, Strategy). Advise leaders on organizational design, workforce planning, talent strategy, succession, change management, employee relations, and people analytics. Drive leadership development, performance calibration, and HR operational execution in partnership with centers of excellence. Based in NYC with hybrid on-site expectation.
Top Skills:
ExcelPowerPointTeamsVisioWordWorkday
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
