Job Title: Business Intelligence Reporting AnalystDepartment: Information Technology FLSA Status: Exempt, Non-RepresentedAnnual Salary Range: $72,700 - $90,900JOB SUMMARY:The Business Intelligence Reporting Analyst help drive critical business decisions by analyzing metrics and designing reports. They communicate these results to managers and often provide suggestions based on their findings. The Business Intelligence Reporting Analyst will take on advanced reporting needs and assist departments with the development of desktop dashboards for reporting Key Performance Indicators (KPI's). The position assists department staff with developing new reports, learning basic and advanced features of the BI tool and conducts training classes periodically to improve all departments reporting skills. This position also makes tables available to departments for reporting, runs necessary jobs to keep data current and assists in creating data dictionaries for cloud based system APIs.
ORGANIZATIONAL STRUCTURE:The Business Intelligence Reporting Analyst reports to the Manager of Analytics.
ESSENTIAL FUNCTIONS:- Performs administrative functions of Power BI to assure available data is ready for reporting.
- Creates and publishes advanced reports and dashboards on a project basis; gathering specifications, designing reports / dashboards, and offering suggestions for enhancements.
- Coordinates with departments to test reports for accuracy and intent.
- Supports departments in the development, editing and enhancement of their own reports and dashboards.
- Provides necessary training to departments to allow users to create their own reports and dashboards.
- Ensures programming and reporting activities are well-defined and remain within scope. Takes initiative in working with internal staff to redirect when necessary.
- Reviews, monitors, and analyzes department reporting efforts.
- Utilizes technology to better measure, monitor and communicate KPI's to key MCTS staff and stakeholders and works in conjunction with IT staff to ensure adequate business processes are in place to capture key performance data.
- Coordinates internal involvement with industry bus benchmarking group (ABBG) to ensure accurate reporting, timely responses and dissemination of best practices and industry updates.
- Contributes expertise to the development and delivery of performance management documents, policies and procedures.
- Performs other related duties as assigned.
QUALIFICATIONS:- Bachelor's degree in business, engineering, planning, programming or relevant field. Extensive work experience may be accepted in lieu of degree requirements.
- Minimum of five (5) years' experience analyzing data.
- Minimum of three (3) years' experience using Business intelligence reporting tools.
- Minimum of two (2) years' experience using Power BI software.
- High degree of computer literacy and demonstrated ability to integrate technology in the workplace.
- Experience working within public transportation preferred.
KNOWLEDGE, SKILLS, AND ABILITIES:- Excellent verbal and written communication skills and a demonstrated competency to interact with people at all levels of the organization.
- Highly developed organizational, analytical and problem-solving skills with the ability to visualize data and connections between Key Performance Indicators and goals.
- Demonstrated initiative, flexibility and ability to work with minimal supervision and the ability to multi-task and prioritize work.
- Knowledge of desktop dashboards, report writing software or similar programs.
- Proficient in Microsoft programs such as Excel, Word and Power Point, and experience with reporting tools such as Tableau, Microsoft Power BI and/or Oracle Business Intelligence Enterprise Edition.
- Knowledge of data mining methods and "big data" reporting.
- Ability to maintain effective working relationships with staff and stakeholders, as well as to work effectively as a team member in a diverse environment.
- Ability to train users with limited experience in reporting tools.
PHYSICAL REQUIREMENTS AND ENVIRONMENTAL FACTORS:- Work is frequently conducted in an office or similar indoor environment relatively free from unpleasant environmental conditions or hazards. Incumbent is sometimes located in an outdoor vehicle, warehouse or shop environment.
- Physical requirements are those described as sedentary work exerting 10 pounds of force occasionally or a negligible amount of force frequently.
DISCLAIMER STATEMENT:The above are general requirements that must be met for consideration. They are not intended to be an exhaustive list of job qualifications or job duties.
