• Build and maintain recurring acquisition analytics and reporting (monthly, quarterly, annual) • Develop dashboards, scorecards, and leadership-ready briefing materials that show progress, trends, risks, and workload • Define, track, and improve acquisition KPIs and performance measures (quality, timeliness, throughput, cycle time, etc.) • Analyze spending and vendor data by category, organization, budget line, and vendor to support planning and decision-making • Maintain and improve acquisition and vendor data sources (including databases or trackers used for vendor capability and contract data) • Support market research and acquisition planning with data-driven analysis (e.g., vendor landscape, historical spend, trends) • Create clear documentation, templates, and reporting guides so products are repeatable and easy for teams to use • Produce high-quality deliverables in Microsoft 365 (Excel, PowerPoint, Word) and PDF

• Hands‑on Delivery (IC): Build and maintain production Power BI reports and semantic/tabular models; optimize DAX, star schemas, query folding, and refresh performance; own and continuously improve inherited portfolio items. • SQL & Data modeling: Author performant SQL for curated reporting tables in Snowflake; collaborate with Data Engineering on data modeling standards, release processes, and deployment pipelines (DEV/UAT/PROD) • People Leadership: Manage and develop 3-4 analysts through backlog grooming, 1:1s, growth plans, and code/design reviews; cultivate a culture of craftsmanship, curiosity, and accountability. • Delivery KPIs: Define and track clear KPIs for BI delivery (e.g., refresh reliability, stakeholder satisfaction, cycle time) and coach analysts to meet/exceed targets. • Governance & Enablement: Champion Power BI as the source of truth with robust access controls, versioning, certified datasets, and well‑defined semantic layers; enable self‑service through reusable templates, themes, and training. Lead BI literacy training across business units. • Stakeholder partnership: Act as the go‑to BI partner for operational leaders; translate needs into scalable datasets/dashboards tied to measurable outcomes and decision workflows. Establish meeting cadences with Product, Accounting, and BU leaders to prioritize work that drives measurable business outcomes.

• Support high‑impact analytics initiatives from problem framing through delivery; quantify value, design robust analyses, and communicate recommendations to business partners and executives • Partner with business leaders to identify analytics opportunities and deliver actionable insights. Present findings and recommendations to partners and leadership in clear, compelling formats • Develop analytics products and solutions using Databricks, modern Business and Artificial Intelligence tools and Agile principles • Implement advanced analytics where applicable, leveraging Python for advanced analytics, automation, and integration with Databricks workflows • Architect and publish trusted Power BI datasets and dashboards (DAX, Power Query, semantic models), following standards for usability and adoption • Build performant Databricks workflows (notebooks, jobs, SQL Warehouses) to wrangle large datasets, engineer features, and automate recurring analyses • Develop Python scripts for automation, data wrangling, and integration with Databricks and Azure services • Partner with Data Engineering for scalable data solutions • Own analysis quality: data validation, experiment/study design, sensitivity checks, and reproducibility (versioning, documentation) • Define and monitor KPIs; create and make improvement recommendations based on scorecards and operational reporting that tie directly to business objectives • Demonstrate advanced and compelling data storytelling, statistical thinking, and visualization craftsmanship • Collaborate with Data Governance and Compliance to ensure appropriate use of PHI and adherence to privacy/security controls • Facilitate data stewardship and literacy across the business • Drive adoption of data products to scale data value • Stay current with emerging analytics methodologies, technologies and capabilities and apply for continuous improvement

• Support research and analysis efforts related to mobility, data analytics, and innovative transportation technologies • Contribute to the development, testing, and refinement of data-driven tools, platforms, and internal applications • Apply programming, data analytics, and technical skills to support analytical workflows, automation, and innovation-focused initiatives • Support data visualization and storytelling efforts to translate technical findings into clear, accessible insights for a range of audiences • Collaborate with project teams across transportation disciplines to support ongoing tasks, special analyses, and ad-hoc project needs • Document methods, findings, and lessons learned in a manner that balances technical rigor with clarity for non-technical stakeholders