DATA ANALYST

Montgomery County Juvenile Court is seeking a Data Analyst to serve as a subject matter expert for data analytics, reporting, and performance measurement within the Juvenile Division. This onsite role in Dayton, OH focuses on turning operational and program data into actionable reporting, KPI monitoring, and program evaluation to support court objectives including grant renewals and public records requests.

Role focus

• Design, develop, maintain, and optimize complex SQL queries, stored procedures, views, and datasets using Oracle SQL and Microsoft SQL Server.
• Build automated reports, dashboards, and interactive visualizations using Tableau, Microsoft Power BI, Telerik Reporting, .NET reporting tools, or other business intelligence platforms.
• Create self-service reporting solutions so departments can 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 and evaluate court programs, including internal and external reporting requirements.
• Perform descriptive and inferential statistical analyses to support evidence-based decision making.
• Transform complex datasets into clear data storytelling through written reports, dashboards, and presentations.
• Present findings to judges, executive leadership, directors, managers, committees, and external stakeholders in an understandable format.

Collaboration, quality, and support

• 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.
• Protect data integrity and accuracy by identifying anomalies, performing QA reviews, and recommending corrective actions.
• Train and educate staff on data entry standards, reporting procedures, and the importance of accurate data collection.
• Provide technical assistance related to reporting, database structure, data definitions, and business intelligence solutions.
• Support software implementations, system upgrades, database conversions, and application enhancements through testing, validation, and impact analysis.
• Work extensively within the Juvenile Court case management system and associated relational databases.
• Research and recommend emerging technologies, reporting tools, and analytical methods to improve organizational reporting capabilities.
• Perform other duties as assigned.

What you’ll bring

• Bachelor’s Degree in Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Criminal Justice, Business Analytics, Public Administration, or a closely related field (as listed).
• Master’s Degree preferred.
• 3 to 5 years of experience in data analytics, business intelligence, database reporting, statistical analysis, or a related field.
• Experience within a court, criminal justice, government, or public sector environment is preferred.
• Demonstrated proficiency writing complex SQL queries in Oracle SQL and/or Microsoft SQL Server.
• Experience developing reports using Tableau, Microsoft Power BI, Telerik Reporting, SQL Server Reporting Services (SSRS), .NET reporting tools, or comparable BI software.
• Strong understanding of relational database design, data modeling, data validation, and data integrity principles.
• Knowledge of statistical concepts, performance measurement, trend analysis, forecasting, and program evaluation.
• Excellent data storytelling and written communication and presentation skills.
• Highly proficient in Microsoft Excel, including advanced formulas, pivot tables, and data analysis functions.
• Ability to prioritize multiple projects with minimal supervision.
• Ability to maintain confidentiality and exercise sound judgment with sensitive information.
• Strong interpersonal skills and ability to collaborate with technical and non-technical stakeholders.
• Valid Ohio Driver’s License with an acceptable driving record and proof of insurance.
• Ability to document identity and employment eligibility within three (3) days of appointment in accordance with the Immigration Reform and Control Act.

Tools and systems

• Oracle SQL, Microsoft SQL Server, SQL queries
• Stored procedures, views, datasets
• Tableau, Microsoft Power BI, Telerik Reporting
• .NET reporting tools, SQL Server Reporting Services (SSRS)
• Microsoft Office Suite, Microsoft Excel
• Oracle SQL Developer/Toad or equivalent SQL development tools
• Database management systems and the Juvenile Court case management system

Position details

• Location: Dayton, OH (onsite)
• Salary: USD 69,524 (per year)
• 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
• Scope of supervision: None

Confidential information

This role includes daily access to confidential juvenile records, personal identifying information, court records, case information, sealed records, financial information, and other non-public information. The position requires regular computer use and the ability to communicate verbally and in writing with judges, court administration, magistrates, directors, managers, staff, outside agencies, vendors, and the public.

At-will employment

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