Associate Data Management Analyst - (Hybrid)

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.

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

Metro Transit, a division of Metropolitan Council, is one of the country's largest transit systems, employs more than 3,000 people, and provides ridership through an integrated network of buses, light rail and commuter trains, as well as resources for those who carpool, vanpool, walk or bike in the Twin Cities.

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

The Associate Data Management Analyst is responsible for assisting Rail Operations, the Business System Analyst, the maintenance management team, and the analysis department with analyzing ridership maintenance, on-time performance, and other rail operations data. This position will also be responsible for the monthly and annual federal reporting of rail information and statistics to the National Transit Database Program.

NOTE: This position is eligible for a hybrid (both remote and onsite) telework arrangement. The candidate's permanent residence must be in Minnesota or Wisconsin.

• Collects, validates, and analyzes data interpreting ridership, maintenance, and other data.
• Assists Rail Operations Team by performing analysis of rail data.
• Gathers, analyzes and summarizes ridership/maintenance/on-time performing /running time data from various sources to help determine the need for modifications.
• Proposes changes in one or more of the following: frequency, running time. changes, operations or maintenance for Rail management team to review.
• Provides subject matter knowledge and assistance to Rail Operations team in managing the workflow of analysis projects within the department.
• Evaluates and responds to issues, investigates failures, and cleans data.
• Lead daily team meeting to collect and aggregate daily rail operational performance for National Transit Database Reporting and Key Performance Indicator training.
• Provides on-going analysis of performance before and after evaluation of changes.
• Attends staff and other departmental meetings and assists in special projects as needed, Annual Service Plan Budget, National Transit Database Reporting, and KPI (Key Performance Indicator) reporting.
• Other duties as assigned.

A bachelor's degree in Management Information Systems (MIS), economics, statistics, computer science, mathematics or related field AND one (1) year of work experience in business analysis and/or data collection.

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

• A bachelor's degree in Management Information Systems (MIS), economics, statistics, computer science, and/or mathematics.
• Experience in budget and database reporting.
• Experience in Microsoft Applications (Access, Excel, Power BI and PowerPoint).
• Experience in a statistical analysis package (SAS, SPSS, R, Minitab, etc.).
• Ability to promote and support an equitable, positive, and respectful work environment that values cultural diversity among all employees.

• Knowledge of data collection, cleaning, and analysis.
• Knowledge of rail and bus transit systems operations principles and practices.
• Basic skill level in applied mathematics and statistics.
• Basic skill level in Microsoft Access.
• Intermediate skill level in Microsoft Excel.
• Basic skill level in Microsoft PowerPoint.
• Basic skill level in Microsoft Power BI.
• Basic skill level in a statistical analysis package (SAS, SPSS, R, Minitab, etc.)
• Ability to write summary reports.
• Ability to utilize basic statistical methods to analyze data, identify trends, and determine root causes of failures (Examples: regression analysis and descriptive statistics).

• We offer the opportunity to make a difference and positively influence the Twin Cities metropolitan area.
• We encourage our employees to develop their skills through on-site training and tuition reimbursement.
• We provide a competitive salary, excellent benefits and a good work/life balance.
• More about why you should join us!

Union/Grade: Non-Represented / Grade E
FLSA Status: Non-Exempt
Safety Sensitive: No

What your work environment will be:

Most of work time is performed in a standard office setting. Travel to various locations in the nine county metropolitan areas will be required.

What steps the recruitment process involves:
You must qualify at each of the numbered steps below to be considered a final candidate for the job.

1. We review your minimum qualifications.
2. We rate your education and experience.
3. We conduct a structured panel interview.
4. 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 (safety sensitive positions only), and a background check which verifies education, employment, and criminal history. A driving record check and/or physical may be conducted if applicable to the job. 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 drug test (if moving from a non-safety sensitive position to a safety sensitive position) and 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, Audit, or Human Resources departments, or has access to financial records, files/databases, cash, vouchers or transit fare cards. A driving record check and/or physical may be conducted if applicable to the position.

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 an accommodation during the selection process, please email HR-OCCHealth@metc.state.mn.us.