- Audit and map all existing data tables across Finance, Growth, Marketing, and Customer Support.
- Design and build a unified master table architecture that consolidates cross-functional data into a single source of truth.
- Create executive dashboards in Sigma or similar BI tools to surface real-time KPIs for leadership.
- Deliver ad-hoc analyses for the S&P Associate and CFO, synthesizing data from multiple sources into actionable recommendations.
- Automate reporting workflows using SQL, Python, AI-based tools, or BI-native scheduling to reduce manual work.
- Ensure data quality and governance by reconciling discrepancies across systems and enforcing consistency.
- Document all processes including data lineage, transformation logic, and dashboard guides in Confluence.
- Partner cross-functionally with Growth, Finance, Marketing, and Customer Support to understand KPI priorities and close data gaps.
PostgreSQLSQLBusiness Intelligence+5 more