Senior BI Analyst: Dashboards & Data Warehousing

CapMetro; Austin, Northern (TX, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

CapMetro in Austin, TX is seeking a Technology Analyst III – Business Intelligence to support and advance enterprise reporting, analytics, and data warehouse capabilities. You will design, develop, and support BI solutions, including dashboards, reports, and data pipelines, ensuring data accuracy, availability, and trust across operations and finance.

The role partners with stakeholders, IT leadership, and vendors to deliver complex BI queries, dashboards, and data extracts, including spatial

Qualifications

• 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.

Responsibilities

• 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 BI 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 ETL processes.
• Identify new data sources and reporting needs; extend the data warehouse through new integrations following architecture and best practices.
• Troubleshoot data inconsistencies, refresh failures, and integration issues; communicate data limitations or delays to stakeholders.
• Maintain technical, metadata, and user documentation; develop user guides and training materials to support adoption of BI solutions.
• Participate in after-hours and on-call IT support rotation.
• Provide technical leadership and ownership of BI systems, working with IT teams and vendors to ensure security and availability.

Skills

SQL programming

Analytical skills

Communication

Data validation

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

Snowflake

Azure Data Factory

Job description

CapMetro in Austin, TX is seeking a Technology Analyst III – Business Intelligence to support and advance enterprise reporting, analytics, and data warehouse capabilities. You will design, develop, and support BI solutions, including dashboards, reports, and data pipelines, ensuring data accuracy, availability, and trust across operations and finance.

The role partners with stakeholders, IT leadership, and vendors to deliver complex BI queries, dashboards, and data extracts, including spatial