DATA ANALYST

POSITION DESCRIPTION
Montgomery County Common Pleas Court
Juvenile Division

CLASSIFICATION

TITLE:

DATA ANALYST
FLSA STATUS: Exempt
EMPLOYMENT STATUS
:
Full-Time
CIVIL SERVICE STATUS: Unclassified
REPORTS TO: Information Technology
PAY GRADE: A21
WORK SCHEDULE: 40 Hours a week

DISTINGUISHING JOB CHARACTERISTICS
The Data Analyst serves as the Court's subject matter expert in data analytics, reporting, and performance measurement. This position participates in all phases of data collection to include data entry, data management, data cleaning, data training, SQL queries, Data Visualization tools, reporting, statistical analysis, and program evaluation in support of the Court's grant renewals, public records’ requests, operational, administrative, and strategic objectives.

The Data Analyst designs and develops complex SQL queries, dashboards, reports, and visualizations to transform raw data into meaningful information that supports informed decision-making. This position works extensively with the Juvenile Court's case management system and related databases to ensure accurate, timely, and actionable reporting.

The position collaborates with Court leadership, judges, magistrates, directors, managers, and staff to identify reporting needs, develop key performance indicators (KPIs), improve data quality, establish reporting standards, and communicate findings through clear visualizations and presentations.

The Data Analyst also provides technical assistance and training related to data entry standards, reporting procedures, and system enhancements to improve data integrity throughout the organization.

“In this position, you are an At-Will Employee serving at the pleasure of the Administrative Judge.”

ESSENTIAL DUTIES AND RESPONSIBILITIES
Design, develop, maintain, and optimize complex SQL queries, stored procedures, views, and datasets using Oracle SQL and Microsoft SQL Server.

Develop automated reports, dashboards, and interactive data visualizations using Tableau, Microsoft Power BI, Telerik Reporting, .NET reporting tools, or other business intelligence platforms.

Create self-service reporting solutions that enable departments to independently access meaningful operational and statistical information.

Analyze operational, financial, and program data to identify trends, opportunities, risks, and performance improvement initiatives.

Develop, monitor, and maintain Court Key Performance Indicators (KPIs), outcome measures, workload statistics, and operational metrics.

Design research methodologies and analytical approaches to answer business questions, evaluate Court programs, and fulfill internal and external reporting requirements.

Perform statistical analyses using appropriate descriptive and inferential statistical techniques to support evidence-based decision making.

Transform complex datasets into meaningful narratives through effective data storytelling, written reports, dashboards, and presentations.

Present analytical findings to judges, executive leadership, directors, managers, committees, and external stakeholders in a clear and understandable manner.

Collaborate with Court departments to identify reporting requirements, document business processes, and recommend technology or workflow improvements.

Maintain documentation for reports, dashboards, SQL code, data definitions, business rules, and reporting processes.

Ensure the integrity, consistency, and accuracy of Court data by identifying anomalies, performing quality assurance reviews, and recommending corrective actions.

Train and educate staff on proper data entry standards, reporting procedures, and the importance of accurate data collection to improve overall data quality.

Provide technical assistance related to reporting, database structure, data definitions, and business intelligence solutions.

Support software implementations, system upgrades, database conversions, and application enhancements by performing testing, validation, and impact analysis.
Work extensively within the Juvenile Court's case management system and associated relational databases.

Research and recommend emerging technologies, reporting tools, and analytical methods to improve…