Business Intellgence Developer & Operations Analyst

WHO WE'RE LOOKING FOR

The Business Intelligence (BI) Developer & Operations Analyst position assists Cap Metro in making informed business decisions that enhance service quality and sustainability of Demand Response and Innovative Mobility service. The BI Developer & Operations Analyst develops automated and ad‑hoc performance reports to submit National Transit Database data reports and create performance metric dashboards (including eligibility, customer service, service coordination, and contractor performance).

The BI Developer & Operations Analyst creates a user‑friendly BI interface application to query databases, uses SQL queries, BI analytical tools to leverage data warehouses to mine for information and analyze statistics and participates in data warehouse design. The BI Developer & Operations Analyst provides quality and consistent data, produces report metrics, and conducts analysis to make timely decisions, provide transparency, and develop strategies to balance service quality and sustainability, and drive innovation.

The BI Developer and Operations Analyst works to identify performance trends, use datasets to analyze operations costs, staffing, effectiveness/efficiency, and quality of service.

• 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 data warehouse design process and O&M support for Cap Metro.
• 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.
• Use 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 time frames 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.
• Perform other duties as required.

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