"Alerted.org

Reporting, and Data Analyst, Manager

Print (https://www.governmentjobs.com/careers/metrocouncil/jobs/newprint/4957780)

Apply



Reporting, and Data Analyst, Manager

Salary

$93,704.00 - $152,068.80 Annually

Location

390 Robert St. N St. Paul, MN

Job Type

Full-Time

Job Number

2025-00158

Division

Metropolitan Transportation Services

Department

Metro MO Service Center

Opening Date

06/04/2025

Closing Date

6/25/2025 11:59 PM Central

+ Description

+ Benefits

+ Questions

WHO WE ARE

We are the Metropolitan Council, the regional government for the seven-county Twin Cities metropolitan area. We plan 30 years ahead for the future of the metropolitan area and provide regional transportation, wastewater, and housing services.More information about us on our website. (https://metrocouncil.org/About-Us/The-Council-Who-We-Are.aspx)

We are committed to supporting a diverse workforce that reflects the communities we serve.

About the division:

Metropolitan Transportation Services (MTS), conducts planning for the regional transportation system that includes highways, transit, aviation, freight, and bicycle and pedestrian connections. The Metropolitan Council is the regions federally designated Metropolitan Planning Organization. MTS also provides direct transit service through contracts or partnerships with counties to deliver six major programs: Metro Mobility/ADA, Transit Link Dial-a-Ride, contracted regular-route bus service, micro-transit, Metro Move, and Metro Vanpool.

How your work would contribute to our organization and the Twin Cities region:

The Reporting and Data Analyst Manager typically oversees the collection, management, and interpretation of data to support business operations. Responsibilities include:

+ Developing and maintaining reports and dashboards for tracking KPIs.

+ Analyzing contractor performance and customer service metrics.

+ Ensuring data accuracy and integrity for strategic decision-making.

+ Training staff in business-critical systems and reporting tools.

What you would do in this job

1. Identify official data sources, create interface and develop reports and dashboards using tools such as Power BI, to track KPIs, manager ad hoc requests and regular required measurements (such as the monthly Bonus & Credit processes used to measure contractor performance).

+ Create dashboards/reports to support the management and monitoring of contractor performance, including accessing multiple data sources and providing visualization output.

+ Create dashboards and reports to assist in the management and monitoring of customer experience, including accessing multiple data sources and providing visualizations. Collaborate with business subject matter experts to identify new data sources or reporting that support the output.

+ Maintain existing dashboards and reports, ensuring data links are maintained and monitored for completeness.

+ Provide development expertise for ad hoc data or visualization requests, identifying proper sources of data and developing output to support requests.

2. Provide data science and analytical expertise, to monitor trends and gather insight for additional tracking metrics or operational improvements to ensure contractor performance and customer service goals are being met.

+ Maintain business knowledge and work with business subject matter experts to identify new data sources or reporting structures that facilitate the management of business processes.

+ Propose and develop new analytics and statistical evaluations to support reporting solutions and improve operational efficiencies.

+ Utilize machine learning and statistical modeling methods to track and identify opportunities for improving reporting to support processes and efficiencies.

3. Monitor, audit, and maintain reports to ensure data accuracy and rationalize reports as business processes or report requirements change.

+ Regularly audit the data sets used for reporting to ensure completeness and accuracy.

+ Regularly audit dashboards and reports to ensure calculations and visualizations are complete and accurate.

+ Regularly review dashboards and reports to determine usage and efficacy and rationalize or replace any that are not helping in the management or efficiency of business processes.

4. Supervise the work of a Business Analyst for systems support (TRAPEZE, APEX, MTS Invoicing/Incident) to ensure business-critical systems are operational and maintained to support business needs.

+ Oversee end-user support for business-critical systems (TRAPEZE, APEX, MTS Invoicing/Incident), ensuring that training and interface with Council IS staff regarding maintenance schedules are properly managed.

+ Manage Business Analyst work in support of business-critical systems, including providing feedback on performance and managing goals and expectations.

+ Determine priorities and assign work as needed to support business requests for enhancements and ongoing support.

5. Maintain a knowledge base (through education and learning) to act as an expert resource to ensure best practices for analytics/reporting and act as a business representative with IS for supporting initiatives and development.

+ Represent the business unit with IS on development and support activity, such as steering teams or development groups.

+ Provide feedback to IS on toolset improvements or replacements they are managing.

+ Coordinate with other data analytics group within the Council to share best practices.

+ Ensure continuing education on data analytics and reporting changes, identifying potential usage for future business unit needs.

What education and experience are required for this job (minimum qualifications)

Any of the following combinations of progressively responsible experience with data analytics and/or reporting,AND two (2) years of supervisory or managerial work experience.

+ High school diploma/GED with nine (9) years of experience, including two (2) years of experience in management or supervision.

+ Associate degree with seven (7) years of experience, including two (2) years of experience in management or supervision.

+ Bachelor’s degree or higher with five (five) years of experience, including two (2) years of experience in management or supervision.

What knowledge, skills, and abilities you should have within the first six months on the job:

Knowledge of:

+ Principles, methods, and techniques for gathering and evaluating data using data access tools.

+ Principles, methods, and techniques for developing and communicating information using a variety of reporting and visualization tools.

+ Contract administration and performance requirements.

+ Public transportation processes and requirements.

+ Financial analysis strategies and techniques.

Skills in:

+ Proficiency in Microsoft Word, Excel, PowerPoint, Access, or equivalent packages.

+ Proficiency in data querying tools such as Business Intelligence (BI) and SQL.

Ability to:

+ Effectively present information and communicate concepts to all levels of an organization.

+ To be creative in working with reporting software to gather data necessary for evaluations.

+ To write reports, business correspondence, and procedure manuals.

+ To innovate solutions to improve reporting and business processes.

+ To manage and lead others to support critical systems and processes.

+ To evaluate data results/trendlines and advise on operational and strategic decision-making.

What additional skills and experience would be helpful in this job (desired qualifications):

+ Intermediate to advanced skills and experience using Trapeze, Apex, and BI software.

+ Public Sector or Transportation Industry experience.

+ Experience with auditing data, budgets, and maintaining dashboards.

+ Experience working with diverse populations of internal and external customers.

Additional information

Union / Grade: MANA / Grade I

FLSA: Exempt

Safety Sensitive: No

Full Salary: $45.05 -$73.11 hourly/ $93,704 -$152,069 annually

Anticipated Hiring Range: $93,704 - $130,000 annually.

Work Environment:

Work is performed in a standard office setting and in the field. Requires conducting field inspections and off site duties as required. Position has exposure to working near moving parts, fumes airborne particles, outdoor weather conditions and vibration. Some positions may require travel between primary worksite to other sites.

The responsibilities listed are typical of the positions included in the job classification; however, not all duties are necessarily performed by each specific position. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential duties of the position. Regular attendance is an essential responsibility.

What steps the recruitment process involves:

+ We review your minimum qualifications.

+ We rate your education and experience.

+ We conduct a structured panel interview.

+ We conduct a selection interview.

Once you have successfully completed the steps above, then:

If you are new to the Metropolitan Council, you must pass a drug test and a background check, which verifies education and employment, and covers your driving record (if applicable to the job) and any criminal record. If you have a criminal conviction, you do not automatically fail. The Metropolitan Council considers felony, gross misdemeanor, and misdemeanor convictions on a case-by-case basis, based on whether they are related to the job and whether the candidate has demonstrated adequate rehabilitation.

If you are already an employee of the Metropolitan Council, you must pass a criminal background check if the job you're applying for is safety-sensitive, is a supervisory or management job, is in the Finance, Information Services, or Human Resources departments, or has access to financial records, files/databases, cash, vouchers or transit fare cards.

IMPORTANT:If you make a false statement or withhold information, you may be barred from job consideration.

IMPORTANT:If you make a false statement or withhold information, you may be barred from job consideration. The Metropolitan Council is an Equal Opportunity, Affirmative Action, and veteran-friendly employer. The Council is committed to a workforce that reflects the diversity of the region and strongly encourages persons of color, members of the LGBTQ community, individuals with disabilities, women, and veterans to apply. If you have a disability that requires accommodation during the selection process, please email [email protected].

We believe our employees are a key to our agency's success! In order to attract and retain high quality employees, the Council provides a highly competitive benefits package both in choice and coverage levels. Some highlights about our benefits are listed below:

+ Guaranteed monthly retirement income through Minnesota State Retirement System pension fund

+ Opportunity to save additional funds for retirement on a tax-deferred basis through a voluntary deferred compensation (457) plan

+ Two or more medical plans from which to choose, with employer contribution towards premiums over 80%

+ Dental insurance, life insurance and vision insurance

The following benefits are provided to all employees as part of working for the Council. You will have access to free:

+ Well@Work clinic

+ bus/rail pass valued at over $1200 per year

+ parking at many job locations

+ fitness centers at many job locations

+ Employee Assistance Program

+ extensive health and wellness programs and resources

.

01

Applicant Instructions: It is important thatyour application shows all relevant education and experienceyou possess. The supplemental questions listed below are to further evaluate your education and experience and to determine your eligibility for this position. Answer each question completely, and please do not type "see resume" otherwise your application will be considered incomplete, and you will not receive further consideration for this position. The experience you indicate in your responses should also be consistent with the Work History section of this application. If you attach a resume and/or cover letter to your application, it will be reviewed at the education and experience review step. I have read and understand the above instructions regarding my application and supplemental questions.

+ Yes

+ No

02

How did youfirsthear about this job opening?

+ CareerForce Center

+ Community Event/Organization

+ Employee Referral

+ Facebook

+ Glassdoor

+ Indeed

+ Job Fair

+ LinkedIn

+ Metro Transit Bus Advertisement

+ Twitter

+ Website: governmentjobs.com

+ Website: metrocouncil.org

+ Website: metrotransit.org

+ Website: minnesotajobnetwork.com

+ Other

03

If you selected 'Other', please describe where you first heard about this job. If you selected 'Employee Referral' please enter the employee's first and last name, ID number (if known), and job title. Type N/A if not applicable.

04

Select the option that best indicates your completed education:

+ Associate's degree in Computer Information Systems, Business Administration, Data Science or related area, or closely related field.

+ Bachelor's degree in Computer Information Systems, Business Administration, Data Science or related area, or closely related field.

+ Master's degree in Computer Information Systems, Business Administration, Data Science or related area, or closely related field.

+ None of the above

05

Please select the option that reflects your total years of experience in data analytics and/or reporting:

+ Less than five (5) years

+ Five (5) years but less than seven (7)

+ Seven (7) but less than Nine (9)

+ Nine (9) or more

06

Do you have at least two (2) years of supervisory or managerial work experience?

+ Yes

+ No

07

If you indicated "Yes" in the previous question, describe your experience in a lead, supervisory, or management role. Include where you obtained this experience, job title, and a general description of your job duties. I you do have this experience, indicate, N/A. If you type "See Resume, you will not be given credit for your response.:

08

Please check all you have work experience in:

+ Trapeze

+ Transit Operations

+ Apex

+ Power BI

+ SQL Queries

+ Tracking Key Performance Indicators (KPIs)

+ Creating Dashboards/Reports to include accessing data sources and providing visualization output

+ None of the above

09

Describe your professional experience with reporting and data analysis. Be sure to include details such as the name of the employer(s), your title, the company/organization name, and your overall duties and the software you used to support this role. Be sure to provide detailed responses. If you do not have this experience, type N/A. If you type "See Resume, you will not be given credit for your response.

10

Describe your experience, or efforts made, to foster equity, diversity, and inclusion competency and understanding. If you type "See Resume, you will not be given credit for your response.

Required Question

Employer

Metropolitan Council

Address

390 Robert St. N.St. Paul, Minnesota, 55101

Website

https://metrocouncil.org

Apply

Please verify your email addressVerify Email