Phone (Office): 512-476-7502  |  Email:

Data Analyst

Capital Metropolitan Transportation Authority
Job Description
The Data Analyst reports directly to the Manager, Service Analysis and will also work directly with the scheduling and service planning areas of the Planning Department. This position is responsible for the technical database management and maintenance functions in support of the collection and compilation of data used to support strategic planning functions including synthesizing and analyzing data from multiple sources. Assist in performing analytical service planning, development tasks, and projects. Develop macros, modules and/or queries in support of the data analysis functions. This role also develops and maintains critical spreadsheets and data sets. The Data Analyst will be an inquisitive, self-starter who will engage staff across the agency to identify potential problems and propose solutions. 

Education and Experience: 
• Bachelor’s degree in Business, Economics, Statistics or a similar field. Related experience may substitute on a year-for-year basis. 
• Four (4) years of experience in business analysis or data analysis. 
• Experience using advanced Excel features and techniques including pivot tables, linked spreadsheets, lookup formulas, and graphing. 
• Experience working with data warehouse software and Business Intelligence (BI) is preferred. 
• Experience using word processing and presentation software. 
• Experience with statistical software package or database software, including experience developing relational databases and using SQL (Oracle and Access experience preferred). 

Salary Range: $23.60 to $29.50/HR 

Consider joining the team that keeps one of the best and fastest growing cities in the nation moving! 
Contact Information