Data Analyst

Administrative Office of Pennsylvania Courts; Mechanicsburg (Cumberland County); On-site; USD 70,000 - 115,000; Full time

Job summary

The Administrative Office of Pennsylvania Courts (AOPC) is seeking a Data Analyst to transform court data into insightful dashboards and BI solutions. You will partner with stakeholders across court administration to analyze data from multiple sources and design intuitive dashboards that support both operational and strategic decisions.

The ideal candidate has strong Tableau and SQL skills, experience with data visualization, and a proven ability to translate analytical findings into clear

Qualifications

• Tableau proficiency to develop interactive dashboards and visualizations.
• Strong SQL skills and experience with relational databases and complex datasets.
• Experience analyzing data to identify trends, anomalies, and actionable insights.
• Experience gathering requirements and translating business questions into analytical/reporting solutions.
• Understanding of data visualization principles and dashboard design best practices.

Responsibilities

• Design, develop, and maintain dashboards, reports, and data visualizations for court operations and performance insights.
• Explore and analyze data to identify trends, patterns, relationships, anomalies, and opportunities for improvement.
• Apply statistical analysis and modeling to evaluate questions and support informed decisions.
• Collaborate with stakeholders to understand needs and translate them into analytics solutions.
• Use data storytelling and visualization best practices to communicate complex information clearly to audiences.

Skills

Tableau

SQL

Data visualization

Data analysis

Stakeholder communication

Education

Bachelor’s degree in information technology

Tools

Relational databases

Data modeling

Job description

AOPC/IT is hiring an experienced Data Analyst with strong skills in data analysis, visualization, and business intelligence to transform complex court data into clear, meaningful insights. This role is ideal for a data professional who enjoys exploring data, identifying trends and opportunities, and using visualization techniques to tell compelling stories with data.
The successful candidate will partner with stakeholders across court administration to understand business questions, analyze data from multiple sources, and design intuitive dashboards and analytical solutions that support both operational and strategic decision-making. This position combines data analysis, visualization, SQL, and business intelligence skills. The ideal candidate is naturally curious, comfortable working with complex datasets, and skilled at translating analytical findings into visualizations that make information easier to understand and act upon.

Job Duties

• Design, develop, and maintain dashboards, reports, and data visualizations that provide meaningful insights into court operations and performance.

• Explore and analyze data to identify trends, patterns, relationships, anomalies, and opportunities for improvement.

• Apply statistical analysis and modeling techniques to identify trends and patterns, evaluate business questions, and support informed decision-making.

• Collaborate with stakeholders across court administration to understand business needs, define requirements, and translate them into effective analytics solutions.

• Use data storytelling and visualization best practices to communicate complex information clearly to technical and non-technical audiences.

• Write and optimize SQL queries to extract, combine, validate, and analyze data from multiple sources.

• Perform data profiling and validation to ensure accuracy, consistency, and integrity of analytical and reporting data.

• Work with IT teams, data owners, and business stakeholders to investigate data issues and improve data quality and reporting processes.

• Evaluate existing dashboards and reporting solutions and recommend enhancements to usability, performance, visualization, and analytical value.

• Identify opportunities to improve data collection, business processes, reporting standards, and analytics practices.

• Support and advance the organization’s business intelligence capabilities through best practices, reusable solutions, and visualization standards.

• Help stakeholders become more effective consumers of data by guiding their interpretation of dashboards, metrics, and analytical findings.

Minimum Qualifications

Bachelor’s degree in any information technology field; AND

Five or more years of experience in data analytics, business intelligence, data visualization, or a related field.

An equivalent combination of education, experience, and/or training may be considered.

Requirements

• Demonstrated experience using Tableau to develop interactive dashboards and compelling visualizations.

• Strong proficiency in SQL and experience working with relational databases and complex datasets.

• Experience performing data analysis to identify trends, patterns, anomalies, and actionable insights.

• Experience gathering requirements and translating business questions into analytical and reporting solutions.

• Understanding of data visualization principles, dashboard design, and reporting best practices.

• Working knowledge of data modeling and the relationships between source data, analytical datasets, and reporting solutions.

• A satisfactory criminal background check is required.

Preferred skills

• Strong analytical and problem-solving skills with a curious, investigative approach to data.

• Ability to move beyond presenting numbers to explain what the data means and why it matters.

• Excellent written, verbal, and visual communication skills.

• Ability to communicate analytical and technical concepts clearly to non-technical audiences.

• Strong attention to detail and commitment to data accuracy and quality.

• Ability to manage multiple priorities and work independently while collaborating effectively with others.

• A collaborative and empathetic approach to working with stakeholders with varying levels of technical and data expertise.

• Strong customer service orientation and commitment to delivering useful, high-quality analytics solutions.

Job Highlights

• Excellent benefits program, including comprehensive, low-cost medical, dental, vision, and prescription plans for employees and eligible family members on the first day.

• 13 paid holidays, 12 paid sick days, and 12+ paid vacation days per year.

• Salary increases, employee assistance programs, and retirement plans.

• Two telework days per week available after training.

• Healthcare flexible spending account.

• 6 weeks of paid parental leave for eligible employees.

Salary information

Starting Annual Salary Range: $70,497 - $85,230

Maximum Annual Salary: $114,696

Applicants requiring accommodation, for any part of the application and/or interview process, should contact Human Resources at [phone] or [e-mail].