What are the responsibilities and job description for the Transit Operations Data Analyst 2 position at Madison, City of (WI)?
Metro Transit is responsible for a fleet of over 240 buses, 311 full time Transit Operators, and provides millions of rides to Madison and surrounding communities each year. This position will provide professional, consistent data analysis by gathering and maintaining all performance indicators related to the unit to maximize efficiency, help direct and support performance excellence, outcome-based budgeting, and equity-focused performance in the Operations unit. This position reports to the Transit Chief Operating Officer.
Please include a cover letter (1 page maximum) with your application. In your cover letter, please highlight your experience related to the following:- Your professional background and/or educational experience that would make you successful in this role. What specific responsibilities have you had in your data analyst roles?
- Your experience organizing messy, real-world data from different sources. How did you make this data digestible to a variety of audiences? What methods and systems did you use to accomplish this?
Employees may be eligible for loan forgiveness through the Public Service Loan Forgiveness Program.
Black, Indigenous, people of color, women, trans, nonbinary, and individuals with disabilities are encouraged to apply. We value the unique blend of lived experiences and diverse perspectives that comes from non-traditional education pathways and the variety of transferrable skills each candidate brings to the table. We value diversity, equity, inclusion, and belonging. Even if every item on the job posting doesn’t match your experience perfectly, we encourage you to apply and share how your skills and experience can best serve our community.
- Develop and analyze existing and proposed unit procedures and prepare related reports
- Prepare data-driven reports on possible allocation of resources
- Participate in managing operations databases and software
- Ensure that policies, procedures, analyses, and systems center racial equity and social justice
- Maintain ongoing reporting tools that merge data from different sources
- Track and monitor key performance indicators using quantitative and qualitative analytical methods
- Examine short- and long-term impacts of proposed projects
- Utilize business analytics software (Power BI, Tableau) to analyze data with multiple comparators and layers
- Create reports and presentations for various audiences
- Serve as liaison between Metro Operations and other units/departments to resolve issues and develop best practices
- Research and analyze information from a variety of sources
- Work with Metro IS and contribute to KPI dashboard development and accuracy
- Prepare requested analytic reports and audits for various managers
- Make presentations to internal and external teams, boards, committees, commissions and other groups
Perform other duties as assigned.
Minimum Qualifications
- Bachelor’s Degree in business analytics, data science, math, statistics, public administration, public policy or related field and
- Two years of experience in data analysis, business analytics or related field
-OR-
- Four years of experience in business analytics, data science or related field
The City of Madison strives to provide excellent service to all of its residents and visitors. Therefore, successful candidates will have demonstrated ability to work effectively with multicultural communities.
Special Requirements
Ability to meet the transportation needs of the position.
Physical Requirements
This position is primarily sedentary with work using standard office equipment. Employee will occasionally need to travel between locations and attend after hours meetings.
*Payroll Title for this position is Transit Data Analyst 2.
Salary : $76,879 - $91,228