Business Intelligence Manager

• Stand up and run the “Stat” review program (agendas, pre-reads, follow-ups) that drives accountability and closes the loop on actions.

• Publish and maintain an enterprise KPI catalog with definitions, targets, owners, and data lineage.
• Own executive/Board dashboards and the GRTC Performance Report; ensure clarity, accuracy, accessibility, and strong data storytelling.
• Translate leadership questions into metrics, analyses, and visualizations; brief findings to executives and cross-functional teams.
• Lead ad-hoc research and benchmarking; quantify benefits, risks, and tradeoffs to support operational and strategic decisions.
• Align KPI methods to applicable guidance (e.g., FTA TAM), maintain benchmarking participation, and ensure accurate external submissions.

• Co-develop the enterprise data & analytics roadmap with IT; define the migration path toward Microsoft Fabric over the coming year(s), including evaluations and small pilots.
• Manage dimensional models and shared datasets; ensure consistent definitions and solid performance on the current stack (e.g., SQL Server/Azure SQL, Synapse/Databricks, or equivalent).
• Standardize ingestion/ELT patterns from core systems (ERP, HRIS, operations/ITS, maintenance, finance, customer experience); document lineage, refresh cadences, and owners.
• Establish pragmatic data quality checks (validation rules, issue tracking) and refresh monitoring; coordinate remediation with data/system owners.
• Implement lightweight governance, including naming conventions, change control for datasets/reports, and periodic access reviews aligned with the principle of least privilege, and coordinate security with IT.
• Promote Power BI and semantic model best practices; choose Import/DirectQuery patterns that are fit for purpose today, and plan for DirectQuery as Fabric adoption matures.
• Maintain a concise data catalog and documentation, and define clear stewardship roles and responsibilities.
• Partner with IT to introduce version control and simple deployment practices tailored to our scale; monitor key cost/performance KPIs and recommend improvements for right-sizing and scheduling.

EDUCATION / KNOWLEDGE / EXPERIENCE:

PREFERRED QUALIFICATIONS:

• Transit/public sector or asset-intensive operations experience.