Data Analyst

Posted 22 Days Ago
Mechanicsburg, PA, USA
In-Office
70K-115K Annually
Senior level
Other
The Role
Design and maintain dashboards and visualizations, analyze complex court datasets, write and optimize SQL, validate data quality, partner with stakeholders to translate business questions into BI solutions, and advance reporting best practices.
Summary Generated by Built In
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 [email protected].

Skills Required

  • Bachelor's degree in an information technology field (or equivalent combination of education, experience, and/or training)
  • Five or more years of experience in data analytics, business intelligence, data visualization, or a related field
  • Demonstrated experience using Tableau to develop interactive dashboards and 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 relationships between source data, analytical datasets, and reporting solutions
  • Satisfactory criminal background check
  • Strong analytical and problem-solving skills with a curious, investigative approach to data
  • Ability to explain what data means and why it matters
  • Excellent written, verbal, and visual communication skills
  • Ability to communicate analytical and technical concepts 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
  • Collaborative and empathetic approach to working with stakeholders of varying technical expertise
  • Strong customer service orientation and commitment to delivering high-quality analytics solutions
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
318 Employees
Year Founded: 1968

What We Do

The Unified Judicial System of Pennsylvania is the judicial branch of the Pennsylvania government, dedicated to promoting access to justice for all and ensuring accessible and safe courts for all citizens. It encompasses all three levels of Pennsylvania courts—including the Supreme Court, appellate courts, and courts of common pleas—along with their administrative offices.

Similar Jobs

CDW Logo CDW

Data Analyst

Information Technology
Remote or Hybrid
US
15100 Employees
130K-160K Annually

OpenX Technologies Logo OpenX Technologies

Data Analyst

AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
Easy Apply
Remote or Hybrid
US
420 Employees
94K-110K Annually

Comcast Logo Comcast

Analyst, Enterprise Data Analytics - Comcast Advertising

Digital Media • Information Technology • News + Entertainment
Remote or Hybrid
Pennsylvania, USA
115000 Employees

TransUnion Logo TransUnion

Senior Analyst – Alternative Data

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
4 Locations
13000 Employees

Similar Companies Hiring

T-Mobile Thumbnail
Other • Utilities
Bellevue, WA
89016 Employees
Rosendin Thumbnail
Other • Manufacturing
San Jose, CA
6219 Employees
OmniCable Thumbnail
Other
Houston, Texas
815 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account