Senior Data Engineer
n

Primary Skills
CI/CD Pipeline, CSS/SCSS/LESS, PyTest, PostgreSQL / MongoDB / Redis, REST API / GraphQL

Specialization
Python Fullstack with Microservices: Software Development Lead

Job requirements
We are seeking an experienced Lead Data Engineer to take end-to-end ownership of Enterprise Data Warehouse (EDW) solutions. This role will be responsible for designing, architecting, and optimizing scalable, secure, and high-performance data pipelines using SAP BODS, IBM DataStage, Redwood, SQL, Oracle, and modern data platforms.
The ideal candidate will combine solid hands-on technical expertise with leadership capabilities to drive data engineering best practices and deliver enterprise-grade data solutions aligned with business objectives.
Key Responsibilities
1. EDW Architecture & Data Engineering
Design and implement scalable data integration and transformation frameworks for the Enterprise Data Warehouse.
Architect and optimize ETL/ELT pipelines using SAP BODS and IBM DataStage.
Develop and maintain robust data models (Star/Snowflake schemas,



SCD implementation).
Ensure high availability, reliability, and performance of data pipelines.
Implement data governance, security, and compliance standards.
2. ETL Development & Optimization
Develop complex data workflows and transformations.
Perform performance tuning of ETL jobs and SQL queries.
Optimize batch processing and scheduling using Redwood.
Implement error handling, logging, and monitoring mechanisms.
Manage incremental loads and data reconciliation processes.
3. Database & SQL Development
Write and optimize complex SQL queries, stored procedures, and functions.
Work extensively with Oracle databases and related technologies.
Design and manage indexing strategies and query optimization.
Support database performance analysis and tuning.
4. Leadership & Team Management
Lead and mentor a team of data engineers.
Conduct code reviews and enforce development standards.
Drive technical best prac

📌 Senior Lead Data Engineer (Bengaluru)
🏢 Brillio
📍 Bengaluru