
Technical Program Manager – Supply Chain, Kusto, SQL
BPCS, Comprehensive marketing solutions, ltd.
full-time
Posted on:
Location Type: Remote
Location: Washington • United States
Visit company websiteExplore more
Salary
💰 $41 - $44 per hour
About the role
- Own end-to-end operational and KPI reporting, including metric definition, instrumentation, refresh cadence, and executive narratives
- Develop and maintain metrics reflecting supply, demand, and operational performance across workstreams
- Produce recurring 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 reporting
- Design how data flows across planning, sourcing, and operational systems 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, reducing manual data reconciliation
- 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 data
- 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 planning, operations, sourcing, and strategy stakeholders
- Act as connective tissue across teams to align on operational taxonomy, hierarchies, and reporting rollups
- Influence decision-making through clear data storytelling and trusted, actionable insights
Requirements
- Demonstrated experience delivering operational and performance insights that drive 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 MS-SQL, Kusto, and Power BI
- Advanced Excel or Python for data analysis
- Project or process management, including tracking, reporting, and cross-functional coordination
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
data analysisKPI definitiondata modelingreporting layer designmetric calculationsdashboard designquery optimizationdata quality controlstrend analysisdata reconciliation
Soft Skills
stakeholder engagementcommunicationdata storytellinginfluencing decision-makingcross-functional coordinationorganizational alignmentproblem-solvingnarrative developmentcollaborationleadership