Data Analyst 2

Salary :

$73,199.36 - $86,863.40 Annually

Location :

Madison Parks, WI

Job Type:

PERMANENT FULL TIME

Job Number:

2024-00200

Department:

Parks Division

Opening Date:

06/12/2024

Closing Date:

7/8/2024 11:59 PM Central

Comp. Group/Range:

18/08

General Description

This is responsible professional data analytics work supporting the City's performance excellence goals and outcome-based budgeting. The position will use data to provide innovative solutions to complex problems in relation to City-wide or agency plans, goals, strategies and operational effectiveness. This position will support the Parks Division's data needs. This position will perform the work of a Data Analyst 1, with a higher degree of professional complexity; initiative; judgment and discretion; and personal accountability in the preparation, presentation and justification of recommendations. This position will complete diverse data analytic assignments; prepare comprehensive reports and recommendations; present and defend findings; and exercise fully developed professional skills. Under general supervision of the Parks Finance & Admin Manager, employees are expected to independently exercise professional judgment and discretion.

Please attach a one-page cover letter in the Attachments section of the application. In your cover letter please highlight the following: •Your experience in applying statistical concepts to real-world data and situations. •Your experience working with stakeholders on issues relating to data. •Your ability in at least two of the areas highlighted in the General Position Description above.

Failure to submit the cover letter and responses with your application will result in immediate elimination from the recruitment process. Stated salary is scheduled for a 2% increase in July 2024.

Employees may be eligible for loan forgiveness through the .

The City of Madison is an equal opportunity employer functioning under an affirmative action plan. We value diversity, equity, inclusion, and belonging. Black, Indigenous, people of color, women, trans, nonbinary, and individuals with disabilities are encouraged to apply! Examples of Duties and Responsibilities

Develop and lead implementation of Parks Division Data action plan and dataset inventory Work under the direction of the Parks Division's Management team to develop specifications to automate reports and process large data sets, which includes dataset inventory and complex operating and capital budgets. Build and maintain data visualizations using business intelligence tools.

Build data collection and analysis tools to Parks with incorporating data collection and management into existing business processes, including establishing metrics for performance excellence.

Produce summary performance reports highlighting insights gained from data.

Perform analysis of large longitudinal data set, present key findings and make recommendations to Parks leadership regarding datasets and asset management. Provide expertise and advise on a wide variety of related management activities and initiatives.

Act as Parks Division's liaison with and contribute towards ongoing efforts of City Data Team, through maintaining Parks' dataset inventory.

Build tools and processes to maintain and update Parks Division's dataset inventory.

Perform other related duties as assigned.

Develop and maintain communications related to Parks Division Data Implement publishing plans to regularly publish datasets to the City's Open Data Portal. Automate reports and process large data sets using computer-programming software. Visualize data using business intelligence tools. Be able to tell a data story that is digestible for others. Prepare content for systems and data analysis and facilitate trainings for Parks Division staff aimed at improving organizational capacity and competencies to work with data for a variety of audiences. Work with entire Parks Team to conduct individualized trainings to improve data analysis capacity and data collection practices. Stay current on emerging trends in the application of data science tools to improve government service delivery. Conduct or participate in varied and complex management analysis, program evaluations and special studies regarding departmental operations, performance excellence, information requests, and general City data analysis. Collect and analyze data for citywide indicators. Research and draft recommendations for projects as part of the city's annual research agenda.

Participate in identifying and scoping research projects carried out through a data partnership with University partners.

Support long-term planning and development needs of the Parks Division Play lead role in implementation and maintenance of CityWorks Asset management system, including scrubbing of data set and system set up to ensure effective collection of informative data. Develop reports and processes from CityWorks responsive to staff and community needs.

Assist Parks Planning staff with determination of Impact Fees and updating annual memo, plat spreadsheet and the deposit slip each year.

Assist with upkeep of the Impact Fee Data Base and the impact fee workbook. Calculate impact fees and manage the fee collection process, answer requests for fee deposit slips, collect fees, and process fee payments as per our current practice. Assist with quarterly audits of impact fee collection and proper documentation.

Prepare the State Statute required annual report on impact fee revenues and expenditures. Assist in the development of annual Capital Improvements Plan through collection and analysis of GIS data specific to Parks Asset Management, including various facility conditions, such as paved paths, various sport courts, parking lots, playgrounds, sun shelters, etc.

Produce tools that improve the effectiveness of the Parks Division's Capital Improvement planning and expenditure documents/tracking tools to better meet the needs of staff and for more effective decision-making, including tracking investments by alder district. Support the development of the annual Capital and Operating Budgets with input from Parks Management Team. Perform all other duties as required.

Minimum Qualifications

Four (4) years of professional data collection, analytics, and management experience. Associate's Degree in business analytics, computer science, data science, mathematics, statistics, urban planning, geography, sociology, earth science, natural resources and design, economics, public administration, public policy, political science, or a related field.

If an applicant does not possess the specific requirements outlined above, HR will review the application materials to determine if the applicant possesses the following equivalent experience:

Four (4) years of experience in applying the following: Principles of data administration, analytics and management.

Computer software applicable to the duties of the position, including Word, Outlook, Excel, Analytical software (such as Crystal Reports, GIS, SQL and related extension), and programming and or query languages.

Two (2) years of experience in applying the following: Data governance, data quality, data security principles and best practices.

Computer-assisted data analysis techniques.

Familiarity with the following: Racial equity and social justice issues/concerns.

The City of Madison strives to provide exceptional customer service to all its residents and visitors. Therefore successful candidates will have demonstrated ability to effectively work with multicultural communities.

For a complete list of Knowledge, Skills and Abilities, please visit the Data Analyst 2

Training and Experience : Two years of professional data collection, analytics, and management experience. Such experience would normally be gained after graduation from an accredited college or university with a Bachelor's Degree in business analytics, computer science, data science, math, statistics, economics, public administration, public policy or a related field. Other combinations of training and/or experience which can be demonstrated to result in the possession of the knowledge, skills and abilities necessary to perform the duties of this position will also be considered.

Knowledge, Skills and Abilities : Thorough knowledge of the principles of data administration and management. Thorough knowledge of and ability to use computer software applicable to the duties of the position. Working knowledge of data governance, data quality, data security principles and best practices. Working knowledge of computer-assisted data analysis techniques. Ability to evaluate the effectiveness of work programs. Ability to conduct interviews, collect and evaluate data, and compile related financial, statistical and narrative reports and recommendations. Ability to independently prepare, present, and defend analytic findings. Ability to develop and maintain effective working relationships with a wide variety of City and external business contacts. Ability to work effectively with multi-cultural populations. Ability to perform accurate calculations. Ability to communicate effectively both orally and in writing. Ability to attend meetings outside the regular work schedule, including evenings. Ability to maintain adequate attendance.

Special Requirements

Ability to meet the transportation requirements of the position.

This position will be expected to attend meetings of the Common Council and related bodies as required to discuss issues related to the budget. This includes budget deliberation meetings that are scheduled on consecutive evenings usually in November.

Physical Requirements : Work is primarily sedentary in nature and performed in an office environment. Employees will be expected to use standard office equipment such as a telephone, computer, calculator, copier, and fax machine.

The City of Madison offers excellent pay and benefits for employees. City Ordinances, handbooks, and labor contracts provide specifics; the description here is not to be considered a binding statement but offers an informal summary.

Compensation

The City of Madison strives to pay competitive wages. View the current for pay for all classifications. Employees receive increases based on tenure with the City.

Benefits

The City offers a competitive benefits package, including a generous leave package, a variety of insurance options, and non-traditional benefits such as optional pet insurance, a bus pass for all employees, and the possibility of flexible work schedules. A brief summary of benefits is listed below. Please visit our for more information.

Leave

Vacation is earned upon starting employment and can be used after completion of probation. The general vacation schedule is below.

0-3 years 10 work days of vacation After 3 years 12-1/2 days After 7 years 15 days After 11 years 17-1/2 days After 15 years 20 days After 19 years 25 days After 27 years 27 days

Employees earn 3.5 personal days in addition to vacation.

Employees receive eight official paid holidays (New Year's Day, Martin Luther King, Jr. Holiday, Memorial Day, Juneteenth, Independence Day, Labor Day, Thanksgiving, Christmas Day), as well as 3 paid leave days (the Friday after Thanksgiving, Christmas Eve, New Year's Eve).

Employees also earn 13 sick days annually that may accrue to a total of 150 days.

Retirement

The City of Madison participates in the Wisconsin Retirement System through the State of Wisconsin Department of Employee Trust Funds.

Insurance

The City of Madison offers a variety of optional insurance programs including: Health Insurance

Dental Insurance

Vision Insurance

Pet Insurance

Life Insurance

Income Continuation Insurance (for short and long-term disability)

Long Term Care Insurance

Other Benefits

The City offers numerous other benefits and programs for employees, including: •457(b) deferred compensation plans •Employee Assistance Program •Bus Pass on Madison Metro •Flexible Work Schedules •Employer-paid Training

01

Your one-page cover letter that addresses the following is uploaded in the Attachments section of the application.•Your experience in applying statistical concepts to real-world data and situations.•Your experience working with stakeholders on issues relating to data.•Your ability in at least two of the areas highlighted in the General Position Description above.

AGREED

02

Please indicate with which of the following statistical techniques you have at least ONE year of study and/or applied use (check all that apply)

Inferential statistics Predictive modeling Regression and/or anaylsis of variance Time-series analysis Benefit-Cost analysis Sensitivity analysis Qualitative analysis Other related statistical technique None of the above

03

If you indicated in your previous response that you have experience with another related statistical technique, please list that statistical technique.

04

Please indicate with which of the following computer programming languages or statistical software packages you have at least ONE year of experience working (check all that apply)

Microsoft Excel Python Qualtrics Survey Monkey Java C/C++ R SAS SQL Dax PowerBI Tableau GIS Other related software None of the above

05

If you indicated in your previous response that you have experience with other related software, please list that software.

06

Please indicate with which of the following data management tasks you have at least two (2) years of hands-on experience. (check all that apply)

Data collection Data entry Data maintenance Data cleaning Data analysis Data reporting Data visualization Data presentation Other related data management task None of the above

07

If you indicated in your previous response that you have experience with Other related data management task, please list the data management task.

08

Please indicate level of degree you possess in Business Analytics, Computer Science, Data Science, Math, Statistics, Economics,Public Administration, Public Policy, or a closely related field?

Bachelor's degree or higher Associate's Degree Unrelated degree No Degree

09

Please list your major/field of study (if applicable)

Required Question