Analyst, Business Intelligence

Posted: 04/07/2024


This Business Intelligence (BI) Analyst position reports directly to the Manager of Service Analysis and will work with Service Analysis, Scheduling and Service Planning areas of the Planning department. The BI Analyst will assist CapMetro in making informed business decisions that enhance service quality and sustainability, use business intelligence analytical tools and machine learning techniques to leverage the warehouse of datasets, mine for information and statistics, create performance metric dashboards, and create user-friendly BI interface applications to query databases. This position will be responsible for creating data-driven strategies that improve CapMetro processes and KPIs as well as support of the collection and compilation of data used to support strategic planning functions.  The BI Analyst will develop automated and ad-hoc performance reports that may be submitted to National Transit Database monthly or annually. Must be adept at using large data sets to find opportunities for service and process optimization and using models to test the effectiveness of different courses of action. Must have a passion for data and a highly analytical mind.



Note: The duties and primary responsibilities below are intended to describe the general content of and requirements of this job and are not intended to be an exhaustive statement of duties.?

  • Work with stakeholders throughout the organization to identify opportunities for leveraging service and operational data using a variety of tools and analytic techniques.
  • Develop and implement data methodologies, data collection systems, and other strategies that optimize statistical efficiency and quality
  • Use BI analytic software tools to program and develop reports and data analytics.
  • Create reports, dashboards, scorecards to meet functional area needs.
  • Document BI data analytics including data sources, definitions, methodology, procedures, validity/data integrity considerations.
  • Confer with persons originating, handling, entering or receiving data to identify problems and resolve issues prior to advancing information.
  • Build models, test data set validations, and clean data sets to ensure the most accurate reporting
  • Develop custom data models and algorithms to apply to data sets. Obtain data from outside sources to enhance analytic functions.
  • 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.



  • Bachelor’s degree in Business, Economics, Statistics, Computer Science or a similar field.  Related experience may substitute on a year-for-year basis.
  • Five (3) years of experience analyzing data using programming tools and a variety of automated office software including Oracle, SQL, MS Access, Data Visualization Tools, and Excel. Data Analytics Certification preferred
  • Experience using advance Excel features with experience in BI tools.
  • Data analytics project experience using Python, SQL, or R.
  • Experience using a variety of data mining/data analysis/machine learning methods, using a variety of data tools, building and implementing models, using/creating algorithms and creating/running simulations.