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.

Primary Skills

• ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures

Specialization

• ETL Specialization: Data Engineer , BODS, Informatica IICS, SQL, Oracle

Job requirements

Job Title: Lead Data Engineer (7–9 Years)
Location: Location: 2-3 days Hybrid from Raleigh, NC or Bay Area, CA
Note- This role requires Fulltime employee only without Sponsorship
 
Job Purpose
As a Lead Data Engineer, you will be responsible for end-to-end ownership of data engineering solutions for the Enterprise Data Warehouse (EDW). You will design, architect, and optimize scalable and secure data pipelines leveraging BODS, Informatica IICS, SQL, Oracle and modern data platforms. You will lead a team, drive technical best practices, and partner with business and technology stakeholders to deliver critical data solutions.
 
Key Responsibilities
·   Architect, design, and lead the development of complex data integration pipelines for EDW, ODS, and Data Marts.
·   Ensure compliance with data governance, privacy, and security standards.
·   Lead impact analysis, design reviews, and release management for data engineering projects.
·   Own performance optimization of ETL pipelines, SQL queries, and database objects.
·   Mentor and guide junior engineers, manage deliverables, and ensure high-quality outcomes.
·   Drive adoption of cloud-based solutions (Snowflake, AWS) and automation for data workflows.
·   Partner with Product Owners to align delivery with business goals and PI objectives.
·   Provide L3 technical support for production incidents.
 
Required Skills & Qualifications
·   Strong expertise in ETL tools (BODS, Informatica IICS) and SQL (Oracle, Netezza, Teradata).
·   Hands-on experience in data architecture, modeling (Dimensional & Relational), and optimization.
·   Advanced performance tuning for large-scale pipelines and DB objects.
·   Familiarity with cloud data platforms (Snowflake, AWS, BigQuery, Redshift).
·   Strong leadership skills to guide a small team of engineers.
·   Excellent communication, stakeholder engagement, and problem-solving abilities.
·   Prior experience in the Financial Services domain is highly desirable.
 
• #L1- AS

$120,000 - $130,000 a year

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