Technical Program Manager – Business Insights, Reporting

Role Overview

• Own end-to-end KPI reporting, including metric definition, instrumentation, refresh cadence, and executive-level narratives
• Develop and maintain portfolio-level metrics that reflect progress, throughput, health, risk, and value realization across programs and workstreams
• Produce recurring executive reporting packages (weekly, bi-weekly, monthly) with clear storylines, insights, and decision points
• Perform data analysis to support leadership decisions, including trend analysis, drivers, risks, and scenario comparisons
• Establish and maintain standardized metric definitions to ensure consistency, trust, and alignment across leadership reporting
• Design how data flows across operational tools and systems (e.g., work tracking, intake, operational platforms) into a unified reporting layer
• Structure and manage the data backbone, including entities, hierarchies, mappings, and standards that enable cross-tool reporting
• Integrate multiple reporting sources into consolidated, scalable models, eliminating manual data stitching
• Define and enforce data quality controls, including completeness, consistency, lineage, and reconciliation
• Enable “dashboard as the aggregator” patterns, allowing leaders to move seamlessly from high-level insights to underlying work
• Normalize and reconcile inconsistent hierarchies, rollups, and parent/child relationships using translation and mapping logic
• Design and build scalable Power BI solutions, including datasets, semantic models, measures, and reusable reporting components
• Apply best practices for tabular data modeling, metric calculations, and dashboard design
• Optimize report performance and reliability through efficient model design, refresh strategies, and query optimization
• Partner with stakeholders to translate ambiguous business questions into durable, scalable metrics and dashboards
• Partner closely with program leaders, engineering, operations, finance, and strategy stakeholders
• Act as connective tissue across teams to align on portfolio taxonomy, hierarchies, and rollups
• Influence decision-making through clear data storytelling and trusted, actionable insights

Requirements

• Demonstrated experience delivering portfolio-level insights and executive reporting that drives leadership decisions
• Strong capability designing data models and reporting layers across multiple systems and tools
• Proven ability to define KPIs, analyze trends, and translate findings into leadership-ready narratives
• Strong stakeholder engagement, communication, and data storytelling skills
• Minimum 2–4 years of experience with:
• Azure DevOps, Microsoft Fabric, and Power BI
• SQL or Python
• Program and Portfolio Management, including rhythm-of-business execution and operational reporting

Tech Stack

• Azure
• Python
• SQL

Benefits

• Medical, dental, and vision coverage
• Flexible Spending Account
• 401k program
• Competitive PTO offerings
• Parental Leave
• Opportunities for professional growth and development