FBS Senior Data Engineer

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

Strong data analytics and technical skills are essential, 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
• Advanced expertise in SQL and Oracle PL/SQL development, including complex query writing, performance tuning, and optimization
• Strong data modeling experience, including dimensional modeling using Kimball methodologies, Third Normal Form (TNF), Data Vault concepts, and Medallion Architecture
• 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
• Excellent communication, documentation, stakeholder management, and cross-team collaboration skills

Intermediate Python development skills for data integration, automation, and analytics are required, while experience with Snowflake, DBT, and related orchestration/version-control tools is a plus.