Data Analyst
Administrative Office of Pennsylvania Courts Mechanicsburg, Pennsylvania, United States · $70K–$115K/yr
Government Administration · 1,001-5,000 employees
About the role
The Data Analyst will design and maintain dashboards to provide insights into court operations and performance. They will also collaborate with stakeholders to translate business needs into effective analytical solutions using SQL and visualization tools.
What they look for
Requirements
Candidates must have a bachelor's degree in an IT field and at least five years of experience in data analytics or business intelligence. Proficiency in SQL and Tableau, along with strong data storytelling and analytical skills, is required.
Benefits
Full 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 (717) 231-3309 or human.resources@pacourts.us.
Similar roles
-
Global HSW Data Analyst
Arcadis Bangalore, Karnataka, India
-
Senior Game Data Analyst
Socialpoint Barcelona, Catalonia, Spain
-
Business Data Analyst
EXL Noida, Uttar Pradesh, India
-
HR Data Analyst
Lane Clark & Peacock Winchester, England, United Kingdom
-
Senior Market Data Analyst
Man Group London, England, United Kingdom
-
Data analyst F/H - stage
mk2 Paris, Ile-de-France, France · €9K/yr