Analyst I, Business Intelligence

Capital Metropolitan Transportation Authority•Austin, TX

20h•Remote

About The Position

We are looking for an Analyst I or II who will work closely with the Service Analysis, Scheduling, and Service Planning team. This role leverages business intelligence tools, analytics, and machine learning techniques to analyze large datasets and support data-driven decision-making that improves service quality, sustainability, and operational performance. The Analyst I designs and maintains performance metric dashboards, automated and ad hoc reports, and user-friendly BI applications to support internal analysis and strategic planning, including reporting to the National Transit Database. The role includes developing analytical models to evaluate service and process improvements, identifying optimization opportunities, and contributing to data-driven strategies that enhance key performance indicators (KPIs). The Analyst II develops performance dashboards, user friendly BI applications, and automated or ad hoc reports—including those required for monthly and annual National Transit Database submissions. The position identifies opportunities to optimize services and processes, builds models to evaluate potential strategies, and contributes to data driven planning initiatives. The Analyst is a proactive, analytical problem solver who collaborates with staff across the organization and may mentor junior team members. Salary Range: Analyst I - $63,687 - $80,000 annually Analyst II - $74,689 - $95,000 annually

Requirements

Bachelor’s degree in Business, Economics, Statistics, Computer Science or a similar field. Related experience may substitute on a year-for-year basis.
Two (2) years of experience in data analysis, reporting, or business intelligence, including internships or academic projects preferred.
Basic to intermediate experience using Excel and SQL.
Basic programming or querying skills in SQL; familiarity with Python or R is a plus.
Understanding of data structures and common data quality issues.
Ability to analyze datasets, identify trends, and report findings clearly.
Skill in creating and maintaining standard dashboards and reports.
Strong attention to detail and accuracy.
Ability to work effectively in a team environment with guidance.
Willingness to learn enterprise data systems, tools, and processes.
Effective written and verbal communication skills.
Customer focused mindset and commitment to service quality.

Nice To Haves

Exposure to BI or data visualization tools such as Power BI or Tableau preferred.
Data analytics certification or coursework is a plus.
Analyst II Qualifications: Bachelor’s degree in Business, Economics, Statistics, Computer Science or a similar field. Related experience may substitute on a year-for-year basis.
Three (3) years of experience performing data analysis using SQL, Oracle, MS Access, Excel, and data visualization tools.
Experience using advanced Excel features.
One (1) year experience in Power BI and/or Tableau.
Hands on experience with data analytics projects using Python, SQL, or R.
Experience working with relational databases at an advanced level.
Experience with ETL (Extract–Transform–Load) processes and tools preferred.
Experience with data mining, statistical modeling, machine learning methods, or simulation techniques.
Data Analytics Certification preferred.
Analyst II Proficiency in SQL, Oracle, Python, R, SPSS, or similar analytical tools.
Knowledge of ETL processes, relational databases, and data management best practices.
Skill in data visualization tools such as Power BI, Tableau, and SharePoint.
Understanding of statistical techniques, modeling, and trend analysis.
Ability to analyze complex datasets, identify data discrepancies, and summarize findings effectively.
Strong research, calculation, and analytical abilities.
Ability to identify problems, propose solutions, and manage multiple projects under tight deadlines.
Commitment to continuous improvement of analytic methods and processes.
Excellent written, oral, and interpersonal communication skills, including the ability to gather information through stakeholder interviews.
Ability to work effectively in a team environment within a matrix organization.
Skill in building and maintaining productive working relationships.
Strong attention to detail and ability to understand and apply complex transit concepts.
Dedication to customer service and team oriented work practices.
Ability to work independently with minimal supervision.

Responsibilities

Prepare recurring performance reports (e.g., monthly metrics) including tables, charts, and narrative summaries for internal decision making, developing standard and ad hoc reports, dashboards, and performance metrics using approved BI and reporting tools.
Maintain documentation for BI reports, including data sources, definitions, assumptions, and known limitations.
Participate in testing and validating reporting tools, dashboards, and software updates to ensure functionality and data accuracy.
Partner with organizational stakeholders to identify opportunities to leverage operational and service data for improved decision-making.
Collaborate with cross functional leaders to design, enhance, and implement business intelligence solutions, recommending improvements to reporting methods, documentation standards, and analytical practices and present analytical findings to non technical audiences in clear, accessible language.
Develop user documentation, guides, and FAQs to support effective use of dashboards and BI tools.
Participate in project management activities and cross departmental initiatives as assigned.
Support data quality initiatives by identifying discrepancies, conducting validation checks, and collaborating with data owners to resolve issues, assisting in the collection, preparation, validation, and documentation of data to ensure accuracy, completeness, and reliability.
Help maintain departmental databases and datasets, perform updates, data refreshes, and basic data transformations.
Design and implement data collection methodologies, systems, and processes that optimize data quality, efficiency, and usefulness, working with data contributors and owners to identify issues, resolve discrepancies, and ensure accuracy prior to publication.
Perform data audits, investigate anomalies, and diagnose discrepancies to strengthen data integrity, and assist in developing diagnostic reports to determine when data recollection or correction is required.
Support the collection, validation, and reporting of National Transit Database (NTD) statistics to ensure accurate, timely submission.
Use established data models, queries, and analytic methods to analyze service, operational, and performance data, identifying trends, anomalies, and basic insights to support organizational decision making.
Perform ad hoc analysis and research for projects, presentations, regulatory reporting, and operational inquiries.
Conduct analysis of operational datasets using programming tools, BI platforms, and automation technologies, developing reports, dashboards, scorecards, and data visualizations to meet departmental and organizational analytics needs.
Prepare recurring metric reports featuring charts, graphs, and narrative summaries, perform statistical analyses to identify trends, evaluate service performance, and recommend operational improvements, producing ad hoc analyses and reports for both internal and external stakeholders.
Build, validate, and maintain data models and algorithms, and departmental relational databases to support analytics and reporting, clean, prepare, and integrate datasets—including external data sources—for accurate and comprehensive analysis.
Support development of advanced analytical tools and contribute to machine learning experimentation, testing, and model training, assist with software testing, upgrades, and implementation to ensure reliable functionality for end users.
Contribute to external reporting requirements (e.g., National Transit Database reporting) by compiling and validating data under guidance from senior staff.
Assist in project management tasks as needed, working with team members, departments, vendors, and external partners to gather requirements, address data questions, and support analytic needs.
Continue developing skills in data analytics, BI tools, and transit industry knowledge through training and on the job experience, taking initiative in learning new concepts related to the transit industry.
Support a culture of safety by considering the needs and abilities of all passengers and contributing to the safe and effective delivery of transportation services.
Proactively learn emerging analytics tools, concepts, and transit industry practices.
Support Capital Metropolitan Transportation Authority’s Safety Management Systems (SMS) process by following safety and security policies, considering safety in every action and reporting safety and security concerns.
Performs other duties as required.