Build Centralized Data Warehouse Platform

Our organization currently pulls MIS figures from SAP BW cubes, several MySQL / SQL Server databases, and a handful of REST-based services. The patchwork works—barely—but it slows us down every time we assemble a report. My goal is to streamline reporting by moving everything into a single, well-governed data warehouse that also supports real-time analytics. What I need • A dimensional warehouse schema that accommodates SAP BW, relational, and REST data. • Production-ready ETL pipelines (Python,SQL, or an established tool such as Azure Data Factory, Informatica, Talend—use what you know best) that extract, transform, and load data with minimal latency. • Incremental load logic and data-quality checks so the warehouse stays in sync without full reloads. • Documentation covering schema design, job orchestration, and how to add new sources. Acceptance criteria 1. All listed sources land in the warehouse on an automated schedule with ETL runtimes under 15 minutes. 2. KPI dashboard refresh proves sub-minute query response on at least three combined data sets. 3. Reconciliation reports confirm source-to-warehouse data accuracy >99.5 %. 4. Handover documents enable an internal analyst to extend or modify a pipeline unaided. If you have hands-on experience unifying SAP data with relational and API feeds and can demonstrate near-real-time reporting, I’d like to see how you would tackle this project and the toolset you propose.

Project ID: 40549722