Open Data Analyst (Management Analyst 2)

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.

Examples of Work Performed

• 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.
• 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.
• Provide initial and ongoing instruction and expertise in the use of line of business and other county, state, or collaboratively operated systems.
• 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.
• 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.
• 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.
• 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.

Minimum Qualifications

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.

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