TJJD - Data Analyst IV - IT Data Reporting Specialist (AUS) - 49541 (00049541)
Organization: TEXAS JUVENILE JUSTICE DEPARTMENT
Primary Location: Texas-Austin
Work Locations: Austin Central Office George H.W. Bush Building, Suite 13.1400 1801 N. Congress Ave. Austin 78701
Job: Computer and Mathematical
Employee Status: Regular
Schedule: Full-time
Standard Hours Per Week: 40.00
State Job Code: 0653
Salary Admin Plan: B
Grade: 24
Salary (Pay Basis): 5,425.33 - 7,000.00 (Monthly)
Number of Openings: 1
Overtime Status: Exempt
Job Posting: Apr 21, 2025, 2:25:03 PM
Closing Date: Ongoing
Description

GENERAL DESCRIPTION

Performs complex (journey-level) data analysis and data reporting work. Work involves designing, developing, and maintaining database reports that provide key insights and support decision-making processes within the agency. Collaborates closely with stakeholders to understand their reporting needs, extract and analyze data from various sources, and deliver effective, visually appealing, and interactive reports. Ensures data quality by analyzing the content, structure, and relationships within data to identify data gaps, errors, anomalies, inconsistencies, and redundancies. May train others on the development and querying of data reports.
Works under general supervision, with moderate latitude for the use of initiative and independent judgment. May work in excess of 40 hours per work week and some travel may be required.

MINIMUM QUALIFICATIONS

Bachelor’s degree. Six (6) years of full-time wage-earning experience that may be a combination of implementing and managing database systems, data warehouses, data analytics work.
OR
High School diploma or equivalent. Ten (10) years of full-time wage-earning experience that may be a combination of implementing and managing database systems, data warehouses, or data analytics work.

Preferred:

• Experience designing, developing and maintaining data marts and data warehouses.
• Experience with Power BI reporting tool;
• Experience with SQL Server Management Studio, SQL Server Analysis Services, SQL Server Integration Services and SQL Server Reporting Services.
• Bachelor’s degree with major course work in data processing, computer science, computer information systems, management information systems, business administration, or a related field.
• Experience working for a governmental entity.

Experience and Education Substitutions:

• One year of appropriate experience may substitute for one year of college (30 course hours) on a year for year basis.
• Completed course hours of undergraduate study may substitute for up to four years of experience on a basis of 30 course hours for one year of experience.
• 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.
• Pro-rated part-time experience may satisfy the experience requirement.

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 Microsoft SQL Server.
Knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture.
Knowledge of enterprise information management processes and methodologies, relational database management systems, metadata management, and business intelligence and business analytics tools.
Knowledge of local, state, and federal laws and regulations relevant to data management and data governance.
Knowledge of limitations and capabilities of computer systems.
Knowledge of technology across all network layers and computer platforms.
Knowledge of operational support of networks, operating systems, Internet technologies, databases, and security applications.
Knowledge of business intelligence tools such as Tableau, Power BI, QlikView, or similar
Knowledge of design, development, and maintenance of data marts and data warehouses.
Knowledge of computer programming languages.
Knowledge of data processing flowcharting techniques.
Skill in database report development and business intelligence
Skill in SQL for data manipulation and retrieval
Skill in data modeling and ETL
Skill in complex problem-solving and critical thinking.
Skill in operating computers and using applicable computer software.
Skill in system development lifecycle.
Skill in project management.

Ability to:

• Identify and define user task needs.
• Process information logically.
• Conduct short-range and long-range project planning studies.
• Communicate effectively, both orally and in writing.
• Work in excessive of 40 hours per work week.

Designs, builds, tests, and generates reports utilizing information databases; reviews, revises formats, and analyzes data to ensure information meets user needs.
Assists in defining, developing, and implementing data standards. Assists in developing data quality measures, analyzing data quality results, and implementing necessary changes to ensure data quality improvement.
Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions.
Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
Utilizes software to generate metrics and develops actionable recommendations; identifies, manages, and discovers process improvements as they relate to reporting delivery
Collaborates with various stakeholders to identify needs for reporting. Collaborates closely with technical support, database administrators, software developers, and other business groups
Trains new and existing staff on how to develop and/or use queries, including the development of training materials.
Aids in data discovery for cleanup activities with users and project teams
Ensures successful conversion of reports during/following system upgrade
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.
Actively embody and support the Texas Model by demonstrating its core values in daily tasks and interactions with others.
Qualifications