WHAT YOU'LL BE DOING

• Identify valuable data sources and automate data collection process using SQL stored procedures, data views.

• Work cross-functionally with various departments to identify data/performance metric needs, design routine and ad-hoc reports, and analyze data.

• Participate in Datawarehouse design process and O&M support for CapMetro.

• Document contents in a data warehouse and meta-data storage.

• Identify and access source datasets relevant to demand response and innovative mobility analysis.

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

• Perform quality assurance checks on new and enhanced reports.

• Uses GIS to create maps to visualize performance data.

• Assist department management including the contracted services team with administrative review of contracts, ensuring receipt of complete and valid reporting through audit and documentation procedures.

• Prepare monthly operating performance metric reports, including graphs, charts, and analysis.

• Conduct trend analyses and provide summary reports to management.

• Evaluate findings, using knowledge of contracts, operating practices, and industry business practices.

• Coordinate the department collection of required National Transit Database (NTD) statistics and ensure that reports are accurate and completed within the timeframes required.

• Develop and update technical documentation.

• Recommend establishment of new or modified reporting methods, procedures, and documentation to improve daily business practices.

• Research and compile data, statistical and other pertinent information for special projects, reports and presentations.

• Assist with testing for software installations and upgrades in a timely manner ensuring the highest level of functionality for the end-users.

• Support a safety culture by considering the needs and abilities of all passengers, ensuring the safe and effective provision of appropriate transportation services.

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

WHAT YOU BRING

• Bachelor’s degree in Business, Computer Science, or related field. Related experience may substitute for the education on a year for year basis up to four (4) years.

• Three (3) years of experience using programming software and a variety of automated office software including Oracle, SQL, MS Access, Data Visualization Tools, Visual Studio, and Excel. SAS Certification preferred.

• Experience in aggregation of enterprise level dashboards/ reporting using .NET technology.

• Relevant experience using current GIS technology of using editing tools, performing spatial analysis and creating geodatabases with ArcGIS platform is preferred.

• Two (2) years of experience in data analytic software, data collection and analysis.

• Knowledge of transit scheduling and dispatch software, and call-center systems preferred.

Knowledge, Skills and Abilities

• Strong skills writing SQL queries in Oracle, Microsoft SQL Server, or other industry leading RDBMS to implement complex business logics.

• General knowledge of scripting languages 

• Industry experience in data development, production, and automation

• High-level understanding of data warehouse concepts/methodologies to implement business intelligence solutions.

• Strong debugging/troubleshooting skills to understand the complexity connected with security issues and data access permissions of the data warehouse. 

• Excellent oral and written communication skills.

• Aptitude for organization and adaptive/deductive reasoning.

• Skilled in research, calculation, analysis and summarization of complex data

• Detail oriented with the ability to process, understand, utilize and report complex transit concepts.

• Able to establish and maintain effective working relationships through interpersonal skills.

   

WORK ENVIRONMENT AND PHYSICAL DEMANDS 

Work is generally performed in an office environment in which there is only minimal exposure to unpleasant and/or hazardous working conditions. This position works with multiple project timelines and is responsible for managing employees performing work of a complex nature. 

Incumbent must have the ability to stand and sit frequently throughout an eight-hour period, reach vertically for overhead use as well as horizontally. Must be able to use a telephone or headset equipment. Incumbents must be able to lift and move material weighing up to 20 lbs., perform work at a computer terminal for 6-8 hours a day, and function in an environment with constant interruptions.

Reasonable accommodation may be made to enable individuals with disability to perform the essential functions as previously described.

Mobility Status:

As a Mobile position, the incumbent is expected to work in the office as needed.  There will be access to touchdown/collaboration spaces when on site. Must be in-office for socialization, strategic collaboration, supervision, oversight, and accountability as needed. CapMetro reserves the right to modify work status based on business needs.

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 of Safety, 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.