Bachelor's or Master's degree in Computer Science, Information Systems or related field
Qualification wording
8+ years of experience in Data Engineering.
2+ years of experience in leading technical teams.
Strong experience with SAP BODS
Advanced SQL development Strong expertise in Oracle database
Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
Education & alternatives
Qualifications
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
- 8+ years of experience in Data Engineering.
JobType: full-time
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.
- Develop complex data workflows and transformations.
- Perform performance tuning of ETL jobs and SQL queries.
- Optimize batch processing and scheduling using Redwood.
- Manage incremental loads and data reconciliation processes.
3. Database & SQL Development
- Write and optimize complex SQL queries, stored procedures, and functions.
3. Database & SQL Development
- Write and optimize complex SQL queries, stored procedures, and functions.
- Work extensively with Oracle databases and related technologies.
- Experience with Redwood scheduling
- Advanced SQL development
- Strong expertise in Oracle database
Must-have skills
SAP BODS, SQL, IICS
Good-to-have skills
Preferred / Good to Have
- Experience with modern cloud data platforms (Azure, AWS, GCP)
- Knowledge of Snowflake, Databricks, or Synapse
- Experience with modern cloud data platforms (Azure, AWS, GCP)
- Knowledge of Snowflake, Databricks, or Synapse
- CI/CD implementation for data pipelines
- 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).
- Strong experience with SAP BODS
- Hands-on experience with IBM DataStage
- Experience with Redwood scheduling
- 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.
- Advanced SQL development
- Strong expertise in Oracle database
- Deep understanding of Enterprise Data Warehouse architecture
Technical Expertise
- Strong experience with SAP BODS
- Hands-on experience with IBM DataStage
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.
Requirements
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 practices and architecture governance.
Collaborate with cross-functional teams including BI, Analytics, and Application teams.
Participate in sprint planning, estimation, and technical roadmap discussions.
5. 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.
8+ 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
Flexibility for Shift working is mandatory.
Must-have skills
SAP BODS, SQL, IICS
Good-to-have skills
redwood, Python, Banking Domain
Demand for Data Engineer roles
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
US government figures for database architects
Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.