SpaceX Market Data Accuracy Repair

Our market-facing analytics are reporting conflicting numbers and I need a sharp data specialist to hunt down and eliminate the discrepancies. The problems sit squarely in the data analytics layer: customer records don’t balance with financial reports, operational KPIs drift between refreshes, and leadership is losing confidence in the dashboards. I have already confirmed that accuracy issues are present in all three source domains—customer, financial, and operational—so the task is to trace the pipelines end-to-end, pinpoint root causes, and deliver a rock-solid single source of truth. Here’s what I expect from you: • Audit current ETL jobs, warehouse schemas and any ad-hoc queries touching those datasets. • Fix or rebuild faulty transformations, making sure every business rule is documented in-line or in Git. • Implement automated validation tests that flag anomalies before they reach Power BI/Tableau dashboards. • Provide a concise hand-over report explaining what was wrong, how you patched it, and how to keep it stable. Acceptance criteria • Customer, financial and operational tables reconcile within 0.1 % of their respective authoritative systems. • All pipelines run reliably on schedule for one week without manual intervention. • Unit tests and data-quality alerts are live in CI/CD so future changes can’t reintroduce errors. I’m ready to grant access to the warehouse (Snowflake), our Python-based Airflow DAGs and the dashboard layer the moment we agree on an approach. Let’s get SpaceX leadership trusting the numbers again.

Project ID: 40383594