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

Benefits

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

KPI definitiondata analysisdata modelingmetric calculationsdashboard designreport performance optimizationdata quality controlstrend analysisscenario comparisonsdata stitching

Soft Skills

stakeholder engagementcommunicationdata storytellinginfluencing decision-makingcollaborationorganizational skillsnarrative developmentproblem-solvingalignment facilitationinsight generation