Technology Analyst III, Business Intelligence

WHO WE’RE LOOKING FOR

Are you passionate about turning complex data into meaningful insights that drive organizational decision‑making? Capital Metro is seeking a Technology Analyst III – Business Intelligence to support and advance our enterprise reporting, analytics, and data warehouse capabilities.

This role partners closely with business stakeholders, IT leadership, and vendors to design, develop, and support enterprise Business Intelligence (BI) solutions, including dashboards, reports, data pipelines, and integrations across multiple operational systems. You will play a key role in ensuring data accuracy, availability, and trust for operational, financial, and service delivery reporting across the agency.

• Design, develop, maintain, and support enterprise BI reports and dashboards that enable data‑driven decision‑making across the organization.
• Partner with departmental business system analysts, data analysts, and BI users to analyze reporting needs and deliver complex BI queries, reports, dashboards, charts, scorecards, and data extracts, including spatial data.
• Maintain and support Business Intelligence tools and platforms, ensuring reliability, performance, and usability for internal and public‑facing reporting.
• Analyze and mine data from the enterprise data warehouse, developing complex SQL‑based queries and validating results to ensure accuracy and completeness.
• Design, develop, test, monitor, manage, and validate data warehouse and pipeline activity, including extraction, transformation, loading, cleansing, and refresh processes.
• Identify new data sources and reporting needs; extend the data warehouse through new integrations following established architecture and best practices.
• Troubleshoot data inconsistencies, refresh failures, and integration issues; communicate data limitations or delays to stakeholders in a timely manner.
• Maintain technical, metadata, and user documentation; develop user guides, FAQs, and training materials to support adoption of BI solutions.
• Participate in after‑hours and on‑call IT support rotation, supporting time‑sensitive operational and reporting needs.
• Provide technical leadership and ownership of assigned BI systems, working with internal IT teams and vendors to ensure systems are secure, available, and well‑maintained.

• Power BI
• Enterprise web‑based financial and performance dashboards

• Snowflake / Enterprise Data & Analytics Platform (EDAP)
• SQL-based data sources

• ArcGIS
• Swiftly
• Genfare
• Trapeze
• OrbCAD
• Sitefinity
• Enterprise Asset Management (EAM)
• UTA – APC Ridership systems
• Pickup App
• DUO Authentication

• Azure Data Factory
• Azure Dev Ops
• Azure Infrastructure
• Active Directory

• Bachelor’s degree in Computer Science or a related field; additional related experience may substitute for degree on a year‑for‑year basis (up to four years).
• Five (5) years of experience in Information Technology or a related field.
• Four (4) years of progressively responsible experience implementing and supporting enterprise data warehouse, BI reporting, dashboards, and data integrations using Microsoft tools.
• Strong relational database knowledge and SQL programming experience.
• Hands‑on experience with ETL (Extract, Transform, Load) processes and tools.
• Experience troubleshooting technical and data‑related issues and supporting end users in a customer‑service‑oriented environment.

• Experience with Power BI and Snowflake in an enterprise reporting environment.
• Experience with Python and/or JavaScript for data or reporting solutions.
• Familiarity with transit, operational, or large‑scale enterprise data systems and integrations.
• Experience supporting audit, compliance, or externally published reporting.

• Strong analytical, data validation, and problem solving skills.
• Ability to clearly communicate technical concepts to non technical audiences.
• Self‑motivated, collaborative, and able to manage multiple priorities in a matrixed environment.
• Demonstrated…