Open Data Analyst (Management Analyst 2)

Print


Open Data Analyst (Management Analyst 2)

Salary

$61,232.48 - $90,768.14 Annually

Location

(Ramsey County Courthouse) Saint Paul, MN

Job Type

Full Time

Job Number

2024-00245

Department

22C01-Countywide Communications/Admn

Opening Date

05/01/2024

Closing Date

5/21/2024 11:59 PM Central

Basic Function

Are you passionate about leveraging the power of data to drive transparency, accountability, and engagement? Ramsey County is seeking a dynamic and innovative individual to join our team as an Open Data Analyst (Management Analyst 2) in the Communications & Public Relations department.

In this role, you will collaborate closely with the Open Data Administrator to enhance public access to the county's data through Open Ramsey County. By leveraging your analytical skills and creativity, you'll play a pivotal role in improving transparency, promoting research, and enhancing performance management.

As an Open Data Analyst, your responsibilities will include:

  • Leading and managing data projects from inception to completion, driving impactful outcomes for community and stakeholders.
  • Developing captivating data visualizations, interactive dashboards, and compelling stories to engage audiences.
  • Providing training, onboarding, and ongoing support to users of the data portal, empowering them to leverage the software effectively.
  • Cleaning, extracting, transforming, and loading public-facing data to ensure accuracy and accessibility.

An ideal candidate will have excellent analytical skills, experience with datasets and databases, and a strong ability to communicate information. While experience with open data is beneficial, it is not a requirement for this role. We encourage all individuals who are passionate about data and community to apply.

Basic Function

To analyze and evaluate, design, and implement solutions, programs, methods, and procedures, in order to increase the efficiency of departmental operations and improve the quality and accessibility of business functions, information and processes; to provide instruction regarding the use of line of business systems; to run and modify data reports; and to perform related duties as assigned. (This is the journey or full performance class in this class series. It differs from Management Analyst 1 in that assignments typically require the application of knowledge, skills and abilities typically obtained through previous management analysis experience. Employees in this class may act as project leaders on designated projects.)


Flexible Workplace
This position is identified under the designation of ‘flex work eligible’, meaning that the employee can formally opt to be in-office full-time or work a flex schedule in which at least two-days per week are performed in office and other days can be performed in a remote-first environment. Regardless of selection, the position carries expectations regarding on-site responsibilities and will require schedule flexibility beyond the minimum expectations set forth in the county’s flexible workplace policy. To view Ramsey County’s Flexible Workplace policy, go to: Flexible Workplace Policy - Ramsey County

If an internal candidate is selected, salary will be set in accordance with the personnel rules (i.e., promotion, transfer, or voluntary reduction).

To view or print a copy of the complete Ramsey County job (class) description for this position, go to: Job Descriptions. Once at this page, you can browse the alphabetical list or search for a job description.  

Examples of Work Performed

  1. Work closely with subject matter experts (SME’s) to gain an understanding of various department operations and business functions; analyze operational systems, programs, methods and procedures by obtaining and discussing relevant information with affected parties; research problems, prepare necessary documentation (such as work distribution charts, flow charts, reference materials, procedures and relevant reports); and apply other appropriate analytical methods in order to develop the information needed to evaluate current operations, determine if existing processes could be enhanced, or to identify operational needs.
  2. Evaluate on a continuous basis the results of analyses to be used by the department to ensure they meet business needs by identifying redundancies, unnecessary or wasteful procedures, inappropriate methods, inefficient practices and defining other procedural or operational problems in order to develop plans for optimizing, revising or creating new solutions.
  3. Provide initial and ongoing instruction and expertise in the use of line of business and other county, state, or collaboratively operated systems.
  4. Design new or improved solutions by establishing a time frame for a scoping phase, design concept or project to be completed, setting priorities for work to be done including proposing work distribution plans, investigating and determining the feasibility of changing procedures through the use of electronic or other means; conduct applications testing, and/or developing other plans to revise or create new solutions of maximal efficiency; and prepare present and provide instruction  appropriately to affected parties.
  5. Prepare reports on the analysis, evaluation, design or implementation of systems and/or services as required; build, run and modify data reports via query or other tools.  This may include extraction of data from internal or external databases. 
  6. Implement plans for new or revised systems or solutions by planning, scheduling and coordinating related activities, which may include managing system access and backup to lie of business applications; may act as system administrator for line-of-business applications.
  7. Identify department training needs; develop and update training plans and curricula; plan and execute recurring training programs for new and current employees, including preparing and updating training guides and job aids, as needed.

 

(The work assigned to a position in this classification may not include all possible tasks in this description and does not limit the assignment of any additional tasks in this classification.  Regular attendance according to the position’s management approved work schedule is required.)

 

ESSENTIAL FUNCTIONS:  1, 2, 3, 4, 5, 6, 7.

Minimum Qualifications

Education:  Bachelor's degree in Public Administration, Business Management or Administration, Information Science, or a related field.

 

Experience:  Two years of experience in management analysis or related analytical experience.

 

Substitution:  Master's Degree in a related field may substitute for two years of the experience requirement. Relevant work experience in excess of the experience requirement may substitute for the education requirement on a two to one basis.


Certifications/Licensure:  Valid class D driver’s license required depending on assignment. 

 

Preferred Experience:  Project management, business analysis, data analytics, training, process mapping and reporting.

Exam/Screening Process Information

The examination process will consist of the following section with each section weighted as indicated:
Training and Experience Rating = 100%
 
The examination for Management Analyst 2 will consist of a training and experience rating, comprised of the questions in the attached supplemental questionnaire. Not all applicants who meet the minimum qualifications will pass the training and experience rating.  The rating on this supplemental questionnaire will depend on your answers to the questions – do not mark “see resume” or “see work history” as a response. Please answer all your questions clearly and completely.  Failure to respond could affect your score and final rank on this examination.
 
Eligible List:  The names of all applicants who filed a properly completed application and passed the examination/screening process shall be placed on the eligible list for an employment opportunity as a Management Analyst 2 This list will be certified to the appointing authority which may use this list to conduct interviews to fill a vacancy. Candidates will remain on the Management Analyst 2 Rule of 10 list for 1 month or until hired, whichever occurs first. A notice will be sent to applicants at the time the eligible list is posted, informing them that the list has been posted and their rank on the list.
 
Veteran's Preference:  This is a classified position requiring an open, competitive selection process.  Veteran's Preference points will be applied after a candidate passes the examination process.  Applicants who are eligible for veteran's preference should update their veteran's DD214, and other supporting documents, and submit them as an attachment at the time of application.
 
Criminal Background Checks:  All employment offers are conditioned upon the applicant passing a criminal background check. Convictions are not an automatic bar to employment. Each case is considered on its individual merits and the type of work sought. However, making false statements or withholding information will cause you to be barred from employment, or removed from employment.
 

E-Verify Participation:  Ramsey County participates in the federal E-Verify program. This means that Ramsey County will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization. If the Government cannot confirm that you are authorized to work, Ramsey County is required to give you written instructions and an opportunity to contact DHS and/or the SSA before taking adverse action against you, including terminating your employment. Employers may not use E-Verify to pre-screen job applicants and may not limit or influence the choice of documents you present for use on the Form I-9.
 
Equal Opportunity Employer:  Ramsey County provides equal access to employment, programs, and services without regard to race, color, creed, religion, age, sex (except when sex is a Bona Fide Occupational Qualification), disability, familial or marital status, sexual orientation or gender identity, public assistance status, place of residence, political affiliation, or national origin. Ramsey County is deeply committed to advancing racial equity and promoting diversity and inclusion within all areas of our workforce.
 
To print a paper application for this posting click Paper Application (Download PDF reader). You will need to print this posting and answer the supplemental questions associated with this exam and submit them with your completed paper application.
 
For further information regarding this posting, please contact Jessica.Damm@ramseycounty.us 

Ramsey County provides a wide range of employee benefits to support health, well-being, and work/life balance. Benefits eligibility can vary depending on union status/contract language. A summary of benefits is provided below. Detailed information is available for review at https://www.ramseycounty.us/employees/employee-open-enrollment-2024-benefits
 

  • Medical, dental and vision insurance
    • The County contributes a bargained percentage to the medical and dental monthly premium
    • Employees choose from four enrollment tiers: Single, Employee + legally married spouse, Employee + Child(ren), Family
    • Blue Cross Blue Shield Medical insurance – three plan options including a High Deductible Plan with a Health Saving Account offered. Earn up to $20/month in electronic gift cards for each enrolled employee or spouse for wellness activity
    • MetLife Dental Insurance – two plan options offered
    • VSP Vision Insurance – Advantage Plan offered
 
  • Pre-tax Benefit Program
    • Pre-tax medical, dental, vision monthly premium deduction option
    • Dependent and Health Care Flexible Spending Accounts
    • County monthly contribution to a Health Savings Account for employees who elect the High Deductible medical plan
 
  • Paid time off
    • Vacation hours, accrued based on years of service, ranging from 12 to 25 days per year (pro-rated for part-time employees)
    • 11 scheduled holidays and one floating holiday
    • Up to three weeks of 100% paid parental leave, plus additional use of sick time as noted below
    • Sick hours accrued at a rate of three weeks per year, which can be used for medical and dental care; injury or illness for you, your spouse or children; the birth or adoption of a child (up to 80 hours) or the death of a family member (up to 40 hours)
    • Wellness incentive allows conversion of unused sick time to vacation or pay
 
  • Retirement benefits
    • Pension - The county contributes at least 7.5% of your salary to your pension, depending on bargaining unit. Unlike other retirement investments, pension payments are a lifetime benefit once you start collecting payments
    • New employees become vested after five years. For the Police and Fire union, employees are vested after 10 years
    • Deferred compensation - 457(b) account with employer match
    • Health Care Savings Plan - all benefits-eligible employees contribute 1% of gross regular salary to a Health Care Savings Plan account for eligible health care expenses after retirement. Interest accrues tax free. County provides a scheduled contribution after five years of participation
 
  • Transit and parking
    • Fully funded Metropass.
    • Transportation/parking expenses reimbursement account
 
  • Employee well-being
    • Employee assistance program, including telephone counseling, financial counseling, rideshare benefits, etc.
    • Wellness programming
    • Flexible work policy with hybrid work options for eligible positions
 
  • Life Insurance and Disability leave
    • County provided Basic Life coverage - 1x annual salary, minimum $10,000 up to a maximum of $50,000. Optional supplemental coverage available 
    • Long-term Disability – County provided coverage replaces 40% of the employee’s lost income after six months of disability, subject to a $5,000 monthly maximum. Option to purchase an additional 20% income replacement up to $7,500 monthly maximum
    • Short-term Disability – option to purchase 60% income replacement coverage with 30, 60 or 90-day waiting period
 
  • Career development
    • Tuition reimbursement, up to $4,000 per year
    • Online professional development opportunities through the Learning & Development Center
    • County employment qualifies as a public service organization for the Public Service Loan Forgiveness Program
    • Employee resource groups – help employees build connections through common bonds with colleagues

For information about Ramsey County's 2024 benefits, visit: https://www.ramseycounty.us/employees/employee-open-enrollment-2024-benefits

01
Each applicant must complete this supplemental questionnaire as a part of the application screening process. The supplemental questionnaire will be used as a scored evaluation of your knowledge, skills and experience. Provide complete information for each question. Do not write "see resume" as it is not an acceptable answer. The experiences you indicate in your responses will be reviewed and used to determine your eligibility to move forward in the selection process. Select "yes" if you have read and understand.
  • Yes
  • No
02
Select the option that best describes your highest level of education completed in Public Administration, Business Management or Administration, Information Science, or a related field.
  • High school diploma or GED
  • Associate's degree
  • Bachelor's Degree
  • Master's Degree or higher
  • None of the above
03
Please describe your educational background. List the major on the degree(s) or certificate(s), if applicable, and the name of the institution(s). If you do not have a degree/certificate, enter N/A in the space below.
04
Which best describes your management analysis or related analytical experience?
  • I do not have this experience
  • Less than 2 years
  • 2 years or more, but less than 8 years
  • 8 years or more, but less than 10 years
  • 10 years or more
05
Describe your experience using software for data analysis, data visualization or project management. Provide the name of the software programs you've used and your level of proficiency. Include in your answer where you gained this experience. If you do not have this experience, write N/A in the space below.
06
Describe your experience working with data focused on people or communities. Include any practices or principles you employ to view this type of data through an equity lens. Provide in your answer where you gained this experience. If you do not have this experience, write N/A in the space below.
07
Describe your experience explaining technical concepts or solutions to a non-technical audience. Include specific examples and any methods or tools you utilized. If you do not have this experience, write N/A in the space below.
08
Describe your education, training, and/or experience in a collaborative team environment, including experience teaching or coaching co-workers and staff on a new subject matter, business system or solution. Include in your answer where you gained this experience. If you do not have this experience, write N/A in the space below.

Required Question

Agency
Ramsey County
Address
121 East Seventh Place
Suite 4000
Saint Paul, Minnesota, 55101
Phone
(651) 266-2700
Website
http://agency.governmentjobs.com/ramsey/default.cfm
Job Opportunities
Account
Terms Of Use
Cookie Settings
Copyright © 2024