Hybrid Data Analyst: Tableau Dashboards & SQL

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

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