Technology Analyst III, Business Intelligence

CapMetro

Austin, Northern (TX, KY)

Hybrid

USD 90,000 - 130,000

Full time

7 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

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

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