Senior Lead Data Engineer (BODS) - R01568221

Job description

**Senior Data Engineer** **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 strong 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** - 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. - 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. - 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. - Leadership & Team Management - Lead and mentor a team of data engineers. - Conduct code reviews and enforce development standards. - Drive technical best practices and architecture governance. - Collaborate with cross-functional teams including BI, Analytics, and Application teams. - Participate in sprint planning, estimation, and technical roadmap discussions. - Stakeholder Collaboration - Work closely with business stakeholders to gather and translate requirements into technical solutions. - Provide technical guidance and solution recommendations. - Ensure alignment between enterprise data strategy and business goals. - Support production issue resolution and root cause analysis. **Required Skills** **Technical Expertise** - Strong experience with SAP BODS - Hands-on experience with IBM DataStage - Experience with Redwood scheduling - Advanced SQL development - Strong expertise in Oracle database - Deep understanding of Enterprise Data Warehouse architecture **Data Engineering Concepts** - Data modeling (Star/Snowflake schema, SCD Types) - ETL/ELT best practices - Data quality frameworks - Performance tuning and optimization - Data security and governance standards **Preferred / Good To Have** - Experience with modern cloud data platforms (Azure, AWS, GCP) - Knowledge of Snowflake, Databricks, or Synapse - CI/CD implementation for data pipelines - Exposure to data cataloging and metadata management tools - Experience in Agile/Scrum methodologies **Qualifications** - Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field. - 5+ years of experience in Data Engineering. - 2+ years of experience in leading technical teams. **Key Competencies** - Strong architectural and analytical skills - Leadership and mentoring capability - Excellent communication and stakeholder management - Problem-solving mindset - Ability to drive enterprise-scale data initiatives Please Note - This is L3 support project - Flexibility to work in rotational shift is mandatory