Senior Data Engineer R at Brillio

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 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. Brillios 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.Senior Data EngineerPrimary SkillsETL Fundamentals SQL SQL (Basic Advanced) Python Data Warehousing Modern Data Platform Fundamentals Data Modelling Fundamentals PLSQL T-SQL Stored Procedures SpecializationETL Specialization: Data Engineer BODS Informatica IICS SQL OracleJob requirementsJob Title: Lead Data Engineer (79 Years)Location: Location: 2-3 days Hybrid from Raleigh NC or Bay Area CANote- This role requires Fulltime employee only without SponsorshipJob PurposeAs 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$120000 - $130000 a yearKnow what its like to work and grow at Brillio: Click hereWe may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.Required Experience:Senior IC Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full-Time Experience: years Vacancy: 1