18 Capmetro Data Analyst Jobs Hiring Near You

Technology Analyst III, Business Intelligence

Austin, TX, United States

Trending

Job Description 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.

Responsibilities WHAT YOU’LL BE DOING

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

SYSTEMS & PLATFORMS SUPPORTED Primary BI Platforms

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

Data & Integration Platforms

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

Integrated Enterprise Systems (Primary or Backup)

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

Supporting Infrastructure & Tools

• Azure Data Factory
• Azure DevOps
• Azure Infrastructure
• Active Directory

Qualifications WHAT YOU BRING

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

KNOWLEDGE, SKILLS & ABILITIES

• 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 commitment to customer service, continuous improvement, and teamwork.

Mobility Status

As a Remote position, your primary workplace is your home or another location in the state of Texas. The incumbent is expected to work in the office as needed and must have the ability to respond to a CapMetro facility within 24 hours if business needs require. Must be in-office for socialization, strategic collaboration, supervision, oversight, and accountability as needed. Mobility status is subject to change at any time based on business needs or organizational decisions.

This position is based in Austin, Texas. Successful out-of-state candidates must relocate to the state of Texas prior to start date .

About Us

CapMetro is Austin's regional public transportation provider. We've been around since 1985 and work every day to give residents, commuters, and visitors the best possible transit options available to match their busy everyday lives.

We're always on the move, connecting people with jobs, schools, restaurants, shops, festivals, and other great places to hang out. In fact, we have more than 31 million boardings each year.

About the Team

At CapMetro, we work to empower, enhance, and serve the region and its communities through the responsible delivery of safe, reliable, high‑quality transportation. We are driven by a culture ofSafety, Equity, Transparency, Sustainability, and Innovation. These values guide us in our daily activities, and decision‑making and position us to be a great community partner and to better serve our riders who trust us to get them where they’re going!

WHAT’S IN IT FOR YOU

• Work with a diverse, collaborative, and energetic workforce whose focus is to bring innovation into the industry and how we serve our customers and team members.
• Utilize our free and reduced‑fare transit service to get to the office and then plan to hit the gym (for free) and work with our onsite trainers, before heading back home.
• If you have children between the ages of 6 months and 6 years old, enroll them in the onsite award‑winning Childcare and Learning Center.

…and much more!

COMMITMENT TO EQUAL EMPLOYMENT OPPORTUNITY

CapMetro is an equal employment opportunity employer and committed to creating a welcoming environment for all employees. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, pregnancy, age, or any other protected characteristic as outlined by federal, state, or local laws. CapMetro makes hiring decisions based solely on qualifications, merit, and organization needs at the time.

Job Info

• Job Identification 750
• Job Category Information Technology
• Job Schedule Full time
• Locations 2910 E 5th Street, Austin, TX, 78702, US