TJJD - Data Analyst III - Data Analyst - (AUS)

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

Benefits offered by this job

Retirement plan

Health & life insurance

Paid holidays

Paid vacation leave

Paid sick leave

Longevity pay

Education assistance program

Employee assistance program

Job summary

CAPPS seeks a data analyst for the Juvenile Justice System of Texas responsibilities in Austin. You will collect, query, clean, and analyze data, develop dashboards, and present findings to stakeholders.

Hybrid in-office/work-from-home role with travel up to 10% and a focus on data governance and quality. Requirements include a Bachelor's degree and two years of professional data analysis experience; a cover letter is required.

Qualifications

• Bachelor's degree required.
• Two years of full-time wage-earning professional experience in data or statistical analysis required.
• Cover letter required.

Responsibilities

• Collect, query, clean, integrate, validate, and analyze data for recurring and ad hoc analytical assignments.
• Develop reports, dashboards, visualizations, and analytical datasets for program and operational stakeholders.
• Investigate data quality issues and implement validation controls.
• Translate business questions into analytical requirements and communicate findings clearly.

Skills

SQL

Power BI

Python

Data analysis

Stakeholder engagement

Data quality

Education

Bachelor's degree

Tools

SQL

Power BI

Python

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

Performs moderately complex (journeylevel) analytical and reporting support for the Juvenile Justice System of Texas. Independently plans and completes routine and moderately complex analytical assignments, develops reports and dashboards, investigates dataquality issues, and translates business questions into analytical requirements. Supports agency data governance process. Uses statistical and analytical methods to identify trends and support program and operational decisionmaking. Works directly with stakeholders and communicates findings, assumptions, and limitations in understandable terms.

Works under general supervision with moderate 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

• Independently collects, queries, cleans, integrates, validates, and analyzes data for recurring and ad hoc analytical assignments.
• Conducts descriptive, diagnostic, and appropriate predictive or statistical analysis using established analytical methods.
• Develops and maintains reports, dashboards, visualizations, analytical datasets, and presentations for program and operational stakeholders.
• Investigates dataquality issues, assesses their impact, and develops or recommends appropriate validation and qualitycontrol procedures.
• Works directly with stakeholders to understand business needs, clarify requests, and translate questions into analytical and reporting requirements.
• Documents data sources, definitions, calculations, methodologies, assumptions, limitations, and reporting procedures to support repeatability and review.
• Writes data governance documentation with assistance from subject matter experts, senior data office staff, and other agency stakeholders.
• Uses SQL, Microsoft Power BI, and Python, or develops proficiency in those tools when transitioning from comparable analytical technologies.
• Explains findings, trends, assumptions, and limitations clearly to technical and nontechnical audiences.
• Coordinates moderately complex analytical assignments and provides technical assistance to peers as appropriate.
• 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. Two (2) 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 using SQL, Microsoft Power BI, Python, or comparable analytical tools to deliver repeatable analysis and reporting.

Experience and Education Substitutions:

Completed course hours of graduate study may substitute for up to two years of experience on a basis of 12 graduate course hours for one year of experience.

Completion of a relevant data analysis or data science training program may count toward years of experience depending 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, including distributions, hypothesis testing, variance, correlation, and appropriate analytical techniques.
• Knowledge of data preparation, dataquality assurance, validation, and analytical documentation practices.
• Knowledge of research design, visualization, reporting, and business intelligence concepts.
• Skill in independently querying, cleaning, validating, and analyzing data.
• Skill in selecting and applying appropriate established analytical methods.
• Skill in developing reports, dashboards, visualizations, and analytical datasets.
• Skill in using SQL, Microsoft Power BI, and Python, or rapidly developing proficiency when transitioning from comparable tools.
• Skill in stakeholder engagement, requirements discovery, active listening, and translating business questions into analytical requirements.
• Skill in investigating dataquality issues and developing effective controls.
• Ability to independently manage analytical assignments from requirements through delivery.
• Ability to identify data or methodological limitations and communicate their effect on conclusions.
• Ability to explain complex information clearly to technical and nontechnical stakeholders.
• Ability to develop and implement effective solutions to moderately complex analytical problems.
• Ability to maintain accuracy and attention to detail.
• Ability to prioritize multiple assignments and meet tight deadlines.
• Ability to maintain effective working relationships within and outside the agency.
• 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.

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.

_HRAM_FL.HRS_CG_SEARCH_FL.GBL?FOCUS=Applicant

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.