Data Warehouse & Integration Engineer

Data Quality, Reconciliation & Suspense Management: Design and maintain rigorous data quality and reconciliation checks to align our system with upstream SAP data. Independently manage suspense queues to catch, investigate, and remediate SAP data inconsistencies before they impact downstream users.

Business Continuity Support: Maintain the backend database architecture and pipelines that support our large non-finance user base, ensuring 100% data accuracy and uptime for critical sales revenue reporting.

Data Pipeline Management: Monitor, optimize, and troubleshoot existing ETL processes built in Pentaho, ensuring stable data delivery from Oracle to our Snowflake target environment.

ETL Migration Project: Actively participate in researching, testing, and executing a migration strategy to transition our data pipelines away from Pentaho to a low-to-no-cost open-source alternative (e.g., Apache Hop, Airbyte, or Python/SQL).

Database Development: Write, refine, and optimize advanced Oracle PL/SQL packages, stored procedures, and views required to process complex revenue data and handle data remediation.

Production Support & Scheduling: Monitor daily batch jobs and schedules using AppWorx in a Linux environment, taking swift ownership of resolving daily load failures.

BI Layer Integrity: Ensure the underlying data structures feeding SAP BusinessObjects are performing optimally and perfectly reconciled against business rules.

Technical Guidance & Quality Advocacy: Act as a technical mentor for junior or peer team members. Establish and champion best practices for code design, documentation, and data validation, leading informal design reviews to ensure consistency across all work.