Data Analyst II

Vermont Judiciary; Montpelier (VT); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health benefits

Paid leave

Retirement plan

Tuition reimbursement

Wellness program

Job summary

Vermont Judiciary is seeking a Data Analyst II to perform enterprise data analysis, reporting, and information management to support statewide Judiciary operations, strategic planning, and decision-making. The role combines business and technical expertise and collaborates with divisions to enhance data quality and accessibility.

The ideal candidate has solid analytical skills, communicates clearly to both technical and non-technical audiences, and is proactive in improving reporting processes,

Qualifications

• Bachelor's degree and three years of experience in database management, reporting, or data analysis.
• Associate degree in a related technical field with four years of progressively responsible experience.
• High school diploma with six years of progressively responsible experience in database management, reporting, or data analysis.

Responsibilities

• Confer with Judiciary divisions to identify complex data needs and build data solutions.
• Design, build, and maintain complex reports and dashboards across multiple systems.
• Create and optimize advanced database queries to extract, validate, integrate, and analyze data from multiple systems.
• Establish data standards and reporting methodologies to ensure data quality across the Judiciary.
• Guide or coordinate enterprise reporting initiatives and assigned data projects involving multiple business areas.
• Analyze trends.

Skills

Relational DBs

Complex queries

Data validation

Data analysis

Automated reporting

Translate requirements

Project leadership

Analytical skills

Education

Bachelor's degree + 3 years data experience

Associate degree + 4 years data experience

High school diploma + 6 years data experience

Tools

SQL

Data visualization tools

Job description

The Data Analyst II performs professional and technical work involving enterprise data analysis, reporting, and information management to support statewide Judiciary operations, strategic planning, and decision-making. Combines both business and technical expertise with complex reporting and data analysis initiatives by integrating data from multiple sources. Constructs reporting solutions, advises on reporting standards that support business requirements, and collaborates with Judiciary divisions to enhance the quality, accessibility, and use of data. Work is performed with moderate oversight from Technology Services Center management.

The ideal candidate brings solid analytical and technical skills, communicates clearly with both technical and non-technical audiences, and works collaboratively across divisions. They are detail-oriented, proactive in improving reporting processes, and committed to data quality, consistency, and professional public service.

Desired Skills

• Knowledge of relational databases, reporting tools, and data management principles.
• Ability to design and optimize complex database queries and reporting solutions.
• Knowledge of data validation techniques and best practices for ensuring data quality.
• Ability to analyze large and complex datasets, identify trends, and communicate findings to technical and non-technical audiences.
• Ability to design automated reporting processes and improve reporting efficiency.
• Ability to translate business requirements into effective technical reporting solutions.
• Ability to lead data-related projects and coordinate work across multiple business areas.
• Strong analytical, organizational, communication, and problem-solving skills.

Minimum Qualifications

• Bachelor's degree and three years of experience in database management, reporting, or data analysis.

OR

• Associate degree in a related technical field and four years of progressively responsible experience.

OR

• High school diploma and six years of progressively responsible experience in database management, reporting, or data analysis.

Preferred Qualifications

• Experience with advanced database queries, automated reporting, and data visualization tools.
• Demonstrated ability to integrate data from multiple systems and apply validation standards.
• Success collaborating across business areas or leading data-related projects.
• Strong communication skills for presenting complex data clearly.

Total Compensation

As a State employee you are offered a great career opportunity, but it's more than a paycheck. The State's total compensation package features an outstanding set of employee benefits that are worth about 30% of your total compensation, including:

• 80% State paid medical premium and a dental plan at no cost for employees and their families
• Generous paid leave including 12 vacation days, 12 sick leave days, 5 personal days, and 14 paid holidays each year
• State Paid Family and Medical Leave Insurance (FMLI)
• Two ways to save for your retirement: A State defined benefit pension plan and a deferred compensation 457(b) plan
• Tuition Reimbursement
• Flexible spending healthcare and childcare reimbursement accounts
• Low cost group life insurance
• Incentive-based Wellness Program
• Qualified Employer for Public Service Student Loan Forgiveness Program

Essential Duties

• Confer with Judiciary divisions, leadership, and external partners to identify complex business needs and construct data solutions that support operational and strategic decision-making.
• Design, build, and maintain complex reports, dashboards, automated reporting processes, and data visualizations using multiple reporting and database tools.
• Create and optimize advanced database queries to extract, validate, integrate, and analyze data from multiple systems.
• Establish and maintain data standards, validation procedures, and reporting methodologies to promote consistency and data quality across the Judiciary.
• Guide or coordinate enterprise reporting initiatives and assigned data projects involving multiple business areas.
• Analyze trends