Engineered a unified FP&A application at Premier Early Childhood Education Partners that consolidates financial and operational data from disparate sources into a single source of truth. Automated recurring monthly reporting workflows and built interactive Power BI dashboards, eliminating over 15 hours of manual work per reporting cycle and improving decision-making speed for leadership.
- Role
- Data engineering intern
- Challenge
- Financial and operational reporting depended on disconnected sources and repeated manual reconciliation.
- Outcome
- Eliminated more than 15 hours of manual work from each monthly reporting cycle.
Decisions
- Normalize inputs into a shared reporting model
- Automate recurring transformations
- Design dashboards around leadership decisions
Architecture
- Source systems
- Python and SQL transforms
- Snowflake model
- Power BI semantic layer
- Leadership reporting
What changed my thinking
- A trusted definition is more valuable than a clever chart
- Data quality checks belong inside the pipeline
PythonSQLPower BISnowflakeREST API