FBS Senior Data Engineer

As a Senior Data Engineer on the BW SOON Data Team at Capgemini, you will analyze data from multiple source systems and design/models data marts based on business requirements.

The ideal candidate will have strong data analytics and technical skills, along with the ability to create data models, STTMs, and other technical documentation.

Key responsibilities include:

• Designing, developing, monitoring, and supporting ETL/ELT pipelines processing large volumes of enterprise data, with advanced experience using Oracle Data Integrator (ODI)
• Developing enterprise data warehouse and data mart solutions, including data models, STTMs, technical design documents, and data lineage documentation
• Analyzing and profiling data from multiple source systems, including DB2, Oracle, and distributed data platforms
• Demonstrating advanced expertise in SQL and Oracle PL/SQL development, including complex query writing, performance tuning, and optimization
• Leading in the design, development, and implementation of data products in partnership with business partners and data scientists
• Investigating and resolving production issues, data quality concerns, performance bottlenecks, and SLA risks
• Collaborating with business partners to translate requirements into scalable data solutions
• Implementing data quality controls, reconciliation processes, metadata management, and governance standards
• Supporting cloud modernization, data migration, and platform transformation initiatives
• Exhibiting excellent communication, documentation, stakeholder management, and cross-team collaboration skills

Requirements include:

• Oracle
• ODI (Oracle data integration)
• PL-SQL
• GitHub
• Experience in Production Support
• Intermediate Python development skills for data integration, automation, and analytics
• Intermediate Snowflake, DBT, and related orchestration/version-control tools (e.g., Fivetran, Airflow, GitHub) is a plus