Technical Program Manager – Business Insights & Reporting

Blueprint is a technology solutions firm headquartered in Bellevue, Washington, focused on solving complex problems through innovative technology. The Technical Program Manager will operationalize an AI-focused organization by building reporting and data foundations, delivering executive dashboards, and collaborating with various stakeholders to translate data into actionable insights.

Responsibilities:

• 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
• Minimum 2–4 years of experience with: SQL or Python
• Minimum 2–4 years of experience with: Program and Portfolio Management, including rhythm‑of‑business execution and operational reporting
• Experience working in fast‑paced or startup‑like environments with high ambiguity
• Experience integrating work tracking tools (e.g., Jira, Azure DevOps) into unified reporting views
• Familiarity with semantic modeling, advanced calculations, and reporting optimization in Power BI
• Working knowledge of data warehousing concepts and multi‑source analytics architectures
• Examples of building dashboards, data ecosystems, or operational reporting frameworks end‑to‑end