Data Analyst

Tishman Speyer Properties; Mechanicsburg (Cumberland County); Hybrid; USD 70,000 - 115,000; Full time

Benefits offered by this job

Telework 2 days per week

Comprehensive benefits

Paid time off

Job summary

Pennsylvania Courts' AOPC/IT is seeking an experienced Data Analyst to transform court data into clear insights. You will partner with stakeholders, explore data from multiple sources, and design dashboards and analytical solutions that support operational and strategic decisions.

The role combines SQL, data modeling, and BI best practices, with a focus on storytelling through visuals and ensuring data quality. Strong Tableau experience and communication skills are essential.

Qualifications

• Bachelor's degree in information technology or related field with at least 5 years in data analytics, BI, or visualization.
• Equivalent combo of education and experience may be considered.

Responsibilities

• Design, develop, and maintain dashboards, reports, and data visualizations for court operations and performance.
• Explore and analyze data to identify trends, patterns, relationships, and opportunities for improvement.
• Collaborate with stakeholders to translate business needs into analytics solutions.
• Use data storytelling and visualization best practices to communicate complex information clearly.
• Write and optimize SQL queries to extract and analyze data from multiple sources.
• Perform data profiling and validation to ensure accuracy and integrity of analytics data.
• Work with IT teams and data owners to investigate data issues and improve data quality.
• Evaluate dashboards and reporting solutions for usability and value.
• Identify opportunities to improve data collection, processes, and analytics practices.
• Support and advance BI capabilities through reusable solutions and standards.
• Guide stakeholders in interpreting dashboards and metrics.

Skills

Tableau

SQL

Data visualization

Business intelligence

Data analysis

Stakeholder communication

Education

Bachelor's degree in Information Technology

Tools

Relational databases

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

In the Pennsylvania Courts, people are our priority. Become part of a dynamic and diverse branch of government focused on promoting access to justice for all. Discover fulfilling opportunities that align with your passion, and be part of a team dedicated to making a positive impact through public service. Explore the possibilities with us at the Pennsylvania Courts - where career meets purpose.