Data Analyst II - Juvenile Justice Data & Dashboards

CAPPS; Austin (TX); Hybrid; USD 65,000 - 90,000; Full time

Job summary

CAPPS is seeking a data analyst to provide analytical and reporting support for the Juvenile Justice System of Texas. The role involves data preparation, validation, analysis, and reporting using SQL, Power BI, and Python.

Hybrid in-office/work-from-home arrangement with potential travel and extended hours. The ideal candidate will have a Bachelor's degree and at least one year of professional data analysis experience, with the ability to create dashboards and communicate findings to

Qualifications

• Bachelor's degree required.
• 1 year of full-time wage-earning professional experience in data or statistical analysis required.

Responsibilities

• Collects, queries, cleans, validates, and prepares data for analysis and reporting using established methods and procedures.
• Performs descriptive and basic diagnostic analysis and interprets results to identify trends, differences, and data quality concerns.
• Creates and maintains recurring reports, dashboards, visualizations, tables, and presentations for program and operational staff.
• Performs established data quality assurance checks and dataset preparation procedures; identifies and escalates unusual or complex issues.
• Communicates findings clearly to technical and non-technical stakeholders.

Skills

SQL

Power BI

Python

Data analysis

Education

Bachelor's degree

Job description

CAPPS is seeking a data analyst to provide analytical and reporting support for the Juvenile Justice System of Texas. The role involves data preparation, validation, analysis, and reporting using SQL, Power BI, and Python.

Hybrid in-office/work-from-home arrangement with potential travel and extended hours. The ideal candidate will have a Bachelor's degree and at least one year of professional data analysis experience, with the ability to create dashboards and communicate findings to