Job Description

Performs complex (journeylevel) analytical and reporting support for the Juvenile Justice System of Texas. Leads complex analytical projects, designs or adapts analytical approaches, develops advanced reporting and decisionsupport products, and resolves complex data and methodological issues. Provides technical guidance to analysts and works with program, research, technical, and leadership stakeholders to translate business needs into effective analytical solutions. Facilitates agency data governance process. Reviews analytical work for accuracy and methodological soundness and presents findings and recommendations to leadership.

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

Leads complex analytical projects and highimpact reporting assignments from problem definition through analysis, validation, interpretation, and delivery.

Designs or adapts analytical methodologies, measures, models, and validation strategies appropriate to complex business questions.

Conducts advanced statistical, multivariate, predictive, or other complex analysis when appropriate to the question and available data.

Develops complex dashboards, analytical models, executive reporting products, visualizations, and decisionsupport analyses.

Designs dataquality controls, audit procedures, and validation methods and resolves complex data, reconciliation, and reporting issues.

Writes and facilitates data governance documentation in consultation with subject matter experts and other agency stakeholders.

Leads requirements discussions with program, research, technical, and leadership stakeholders; identifies underlying business needs and translates them into analytical approaches and deliverables.

Reviews analytical work products, calculations, methodologies, and documentation for accuracy, consistency, reproducibility, and methodological soundness.

Uses SQL and Microsoft Power BI proficiently and applies Python as appropriate for analysis, automation, or repeatable analytical processes.

Communicates complex findings, assumptions, limitations, risks, and recommendations in clear, actionable language appropriate to the audience.

Trains and mentors analysts and coordinates analytical contributions across projects without exercising supervisory authority.

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. Four (4) years of fulltime wageearning professional experience in data or statistical analysis.

A cover letter is required.

Preferred Qualifications

• Experience leading complex analytical, reporting, research, or programevaluation projects.
• Advanced experience with SQL and Microsoft Power BI and experience using Python for analysis or automation.
• Experience designing dataquality controls, validation methods, performance measures, or executive 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 advanced statistical and analytical concepts and their appropriate application.
• Knowledge of research design, program evaluation, measurement, testing, and analytical methodology.
• Knowledge of dataquality assurance, validation, reconciliation, and analytical review practices.
• Knowledge of data visualization, dashboard design, executive reporting, and decisionsupport principles.
• Knowledge of data structures, querying, analytical datasets, and repeatable reporting processes.
• Skill in leading complex analytical projects and designing analytical approaches.
• Skill in conducting advanced statistical or multivariate analysis when appropriate.
• Skill in using SQL for complex querying and analysis, Microsoft Power BI for advanced reporting and data modeling, and Python for analysis or automation.
• Skill in developing complex reports, dashboards, models, and decisionsupport products.
• Skill in reviewing analytical work for accuracy and methodological soundness.
• Skill in leading stakeholder discussions, clarifying complex business needs, and communicating recommendations to leadership.
• Skill in mentoring and providing technical guidance to analysts.
• Ability to exercise sound independent judgment on complex analytical matters.
• Ability to evaluate alternative analytical approaches and explain methodological tradeoffs.
• Ability to translate complex business needs into practical analytical solutions.
• Ability to convey complex findings and recommendations to technical, nontechnical, and leadership audiences.
• Ability to lead work across multiple stakeholders without formal supervisory authority.
• Ability to develop and implement effective analytical procedures and solutions.
• Ability to manage multiple highpriority assignments and meet critical 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 https://www.ers.texas.gov . 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: https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_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.

https://erphcmprd.cpa.texas.gov/psc/candidateportal/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?FOCUS=Applicant

How to Apply

Your application must contain complete job histories, which include job titles, name of employer, dates of employment (month & year), name of direct supervisor and phone number, and a description of duties performed, and whether it was fulltime or parttime and hours per week. If any of this information is not provided, your application may be rejected as incomplete.

Resumes do not take the place of this required information.

Applicants must be able to pass a Criminal Background Check and any other requirements listed under Minimum Qualifications.

APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS: Work in Texas (WIT) applicants must complete the CAPPS Recruit Prescreening Questionnaire to be considered for the posting.

To complete the Prescreening Questionnaire, go to CAPPS Recruit to register or login:

https://erphcmprd.cpa.texas.gov/psc/candidateportal/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?FOCUS=Applicant