Data Analyst

Administrative Office of PA Courts; Mechanicsburg (Cumberland County); Hybrid; USD 70,000 - 115,000; Full time

Benefits offered by this job

Two telework days/week

Health benefits

Paid holidays

Job summary

Administrative Office of PA Courts is seeking a Data Analyst to design and maintain dashboards and analytics solutions that support operational and strategic decisions. The role is based in Mechanicsburg, PA and follows a hybrid work model with strong benefits including comprehensive medical, dental, and vision coverage from day one.

The successful candidate will collaborate with stakeholders, write SQL queries, and apply statistical methods to derive actionable insights, while communicating

Qualifications

• Bachelor's degree in information technology or related field.
• Five or more years of experience in data analytics, BI, or related field.
• Experience using Tableau to build dashboards and visualizations.
• Strong SQL proficiency with relational databases and complex datasets.
• Experience identifying trends, patterns, anomalies, and actionable insights.
• Experience gathering requirements and translating business questions into reporting solutions.
• Understanding of data visualization principles and dashboard design best practices.
• Satisfactory criminal background check.

Responsibilities

• Design, develop, and maintain dashboards, reports, and data visualizations for court operations and performance.
• Analyze data to identify trends, patterns, relationships, anomalies, and opportunities for improvement.
• Apply statistical analysis and modeling techniques to evaluate business questions.
• Collaborate with stakeholders to understand needs and translate them into analytics solutions.
• Use data storytelling and visualization best practices to communicate findings to diverse audiences.
• Write and optimize SQL queries to extract and analyze data from multiple sources.
• Perform data profiling and validation to ensure data accuracy and integrity.
• Work with IT teams and data owners to improve data quality and reporting processes.
• Evaluate existing dashboards and reporting solutions and recommend usability and performance improvements.
• Identify opportunities to improve data collection, processes, and analytics practices.

Skills

Tableau

SQL

Data modeling

Data analytics

Data visualization

Education

Bachelor's degree

Tools

Relational databases

Job description

Join a mission-driven organization where your data work turns complex court information into clear, actionable insights. As a Data Analyst for the Administrative Office of PA Courts, you will partner with stakeholders to build dashboards and analytics solutions that support both operational and strategic decision-making. This hybrid role is based in Mechanicsburg, PA and offers a strong benefits package, including comprehensive medical, dental, vision, and prescription coverage starting on the first day.

What You'll Do

• Design, develop, and maintain dashboards, reports, and data visualizations focused on meaningful insights into court operations and performance.
• Analyze data to identify trends, patterns, relationships, anomalies, and improvement opportunities.
• Apply statistical analysis and modeling techniques to evaluate business questions and support informed decisions.
• 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 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 support accuracy, consistency, and integrity across 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, then recommend improvements to usability, performance, visualization, and analytical value.
• Identify opportunities to improve data collection, business processes, reporting standards, and analytics practices.
• Support and advance business intelligence capabilities through best practices, reusable solutions, and visualization standards.
• Guide stakeholders in interpreting dashboards, metrics, and analytical findings to help them become more effective data consumers.

What You'll Bring

• A Bachelor's degree in any information technology field.
• 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.
• Demonstrated experience using Tableau to build interactive dashboards and compelling visualizations.
• Strong SQL proficiency and experience working with relational databases and complex datasets.
• Experience analyzing data to surface 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 how source data relates to 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 explain what the data means and why it matters beyond presenting numbers.
• 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 with others.
• Collaborative and empathetic approach with stakeholders at varying levels of technical and data expertise.
• Customer service orientation and commitment to delivering useful, high-quality analytics solutions.

Benefits and Work Options

• Comprehensive, low-cost medical, dental, vision, and prescription plans for employees and eligible family members starting 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

USD 70,497 - 114,696 per year. Starting annual salary range: $70,497 - $85,230. Maximum annual salary: $114,696.