Open Data Analyst (Management Analyst 2)
Full-Time Open Data Analyst (Management Analyst 2) at Ramsey County
Available Openings: 1
Industry: Government, Analytics
Pay Type: Salary
Compensation: $61,232.48 - $90,768.14 Annually
Education Preferred: Yes
Education Level: Bachelor's Degree
E-Verify: Yes
Criminal Background: Yes

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 toFlexible 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 DescriptionsOnce at this page, you can browse the alphabetical list or search for a job description.  

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) (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 


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.

Ramsey County

Contact: Jessica Damm
Phone 651-266-2700
Ramsey County Courthouse
15 Kellogg Blvd. W.
Saint Paul, Ramsey, Minnesota 55102
Transit: On bus line, On the Green Line