TJJD Data Analyst II - Associate Data Analyst - (AUS)

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

Agency Information

We are committed to transforming lives and building safter communities by working collaboratively, communicating openly, and upholding the highest standards of integrity and professionalism. Our team models accountability, transparency, and respect, taking proactive steps to ensure the physical and emotional safety of youth, staff, and the community. We strive for excellence through continuous growth, thoughtful decision making, and mission driven collaboration, supporting one another while embracing challenges that lead to meaningful, longterm impact.

Job Description

Provides analytical and reporting support for the Juvenile Justice System of Texas. Performs entrylevel data preparation, validation, analysis, and reporting using established methods. Creates reports, dashboards, and visualizations; identifies trends and dataquality issues; and works with stakeholders to understand data and reporting needs. Assists with agency data governance process. Develops proficiency in agency data systems and analytical tools, including SQL, Microsoft Power BI, and Python.

Works under close supervision, with minimal latitude for the use of initiative and independent judgment. Hybrid inoffice / workfromhome role but not restricted to Austin Metropolitan area (agency has locations throughout the state). May be required to work more than 40 hours per workweek and travel occasionally.

Essential Job Duties

• 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 dataquality concerns.
• Creates and maintains recurring reports, dashboards, visualizations, tables, and presentations for program and operational staff.
• Performs established dataquality assurance checks and dataset preparation procedures; identifies and escalates unusual or complex issues.
• Works with stakeholders to understand the purpose of data and reporting requests, clarify definitions and intended use, and translate defined needs into analytical requirements with guidance as needed.
• Documents data sources, definitions, calculations, assumptions, methods, and reporting procedures.
• Learns data domain and governance knowledge from subject matter experts, senior data office staff, and other agency stakeholders.
• Learns and applies agency data systems and analytical tools, including SQL, Microsoft Power BI, and Python; candidates with experience in comparable analytical tools are expected to develop proficiency in the agency's toolset.
• Communicates findings clearly and accurately to technical and nontechnical stakeholders.
• Performs a variety of related duties not listed, to be determined and assigned as needed.
• Performs all duties in compliance with agency safety policies and procedures:
  • Reports safety hazards and corrects hazards when possible.
  • Completes required documentation in the event of an accident/injury within requested time frames.
• Attends work on a regular and predictable schedule in accordance with agency attendance and leave policies.
• Will be required to travel up to 10% of the time.
• Actively embody and support the Texas Model by demonstrating its core values in daily tasks and interactions with others.

Minimum Qualifications

Bachelor's degree. One (1) year of fulltime wageearning professional experience in data or statistical analysis required.

A cover letter is required.

Preferred Qualifications

• Major coursework or experience in computer science, statistics, public policy, sociology, criminal justice, business analytics, data science, or a related field.
• Experience working with case management, customer relations, human services, government, or juvenile justice data.
• Experience or coursework using SQL, Microsoft Power BI, Python, or comparable analytical tools.

Experience and Education Substitutions:

Completed graduate study in a relevant field may be considered in evaluating qualifications.

Completion of a relevant data analysis or data science training program may be considered based on the hours and content of study.

Experience requirements may be satisfied by the prorated parttime equivalent.

Note: Any degree, diploma, high school equivalent, or course hours required to meet minimum qualifications must be from an accredited educational institution.

Knowledge/Skills/Abilities

• Knowledge of statistical concepts and methods used in data analysis.
• Knowledge of data preparation, dataquality assurance, validation, and visualization principles.
• Knowledge of spreadsheet, database, reporting, and analytical concepts.
• Skill in compiling, cleaning, reviewing, and analyzing data.
• Skill in critical thinking and problem solving related to data and reporting issues.
• Skill in creating clear reports, dashboards, visualizations, and presentations.
• Skill in using or developing proficiency in SQL, Microsoft Power BI, and Python.
• Skill in listening to stakeholders, asking clarifying questions, and understanding the business need behind a data request.
• Ability to learn new data systems, analytical tools, and techniques.
• Ability to apply established analytical methods and procedures consistently.
• Ability to maintain accuracy and attention to detail.
• Ability to prepare reports and explain analytical results clearly, orally and in writing.
• Ability to work collaboratively with stakeholders and maintain effective working relationships.
• Ability to prioritize multiple assignments and meet deadlines.
• Ability to work in excess of 40 hours per work week and travel occasionally.

Physical Requirements

The following physical demands and working conditions are representative of those encountered and/or necessary for the employee to successfully perform the essential functions of this job. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions.

• Alphabetizing
• Lifting up to 25 lbs.
• Carrying up to 25 lbs.
• Pulling
• Pushing
• Repeated bending
• Identify colors
• Reaching above shoulder
• Manual/finger dexterity
• Dual simultaneous grasping

Benefits

State of Texas Benefits and Retirement Information can be found at . Benefits include: Retirement plan, paid group health & life insurance for employee, paid holidays, paid vacation leave, paid sick leave, longevity pay, educational assistance program, employee assistance program. Optional addon benefits include: Dental, Vision, Optional Life Insurance, Voluntary AD&D Insurance, Dependent Health & Life insurance, Health & Dependent care flexible spending accounts, etc. Additionally, certain designated positions are eligible for hazardous duty pay, and career ladder advancements.

Military/Veteran Information

In order to receive veteran s preference, a copy of your DD Form 214 (Certificate of Release or Discharge from Active Duty), VA disability rating (if applicable), or a DD Form 1300 (Report of Casualty) must be attached to your application.

For Military Occupational Specialty (MOS) Code or Crosswalk, please visit: _ProgramManagement.pdf

Additional Information

If you are scheduled for an interview and require any reasonable accommodation in our interview process, please inform the hiring representative who calls you to schedule your interview. Whenever possible, please give the hiring representative sufficient time to consider and respond to your request.

Only candidates selected for an interview will be contacted.

Due to the high volume of applications, we do not accept telephone calls.

If you submitted your application through the CAPPS Career Center you may also check the status of your application by accessing your profile and selecting My Job Applications on the threedot menu in the top right corner.

The Texas Juvenile Justice Department does not discriminate on the basis of race, color, religion, sex, national origin, age, or disability in employment or the provision of services.

Thank you for considering employment with the Texas Juvenile Justice Department.

AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER

SPONSORSHIP

Candidates must be eligible to work in the United States without requiring sponsorship.