TJJD - Data Analyst IV - IT Data Reporting Specialist (AUS) - 49111

***This is a remote position and some travel to Austin is required***

HOW TO APPLY

Complete a State of Texas Application for Employment and the following additional forms (available at https://www.tjjd.texas.gov/careers/)

Failure to complete and submit the above forms will cause delays in your consideration for this position.

Apply Online at https://capps.taleo.net/careersection/644/jobdetail.ftl?job=00012896&tz=GMT-05:00 and attach to the application the above additional forms along with copies of high school/college diploma(s), copy of official college transcripts, any licenses/certifications, and, if a military veteran, any Certificate of Release or Discharge from Active Duty (DD Form 214).

Apply through Work-In-Texas at https://www.workintexas.com/vosnet/loginintro.aspx. You will also need to complete and attach to the application the supplemental questions/forms indicated above along with a copies of high school/college diploma(s), copy of official college transcripts, any licenses/certifications, and, if a military veteran, any Certificate of Release or Discharge from Active Duty (DD Form 214). The additional forms are available at: https://www.tjjd.texas.gov/careers and can be submitted via email to: HRJobs@TJJD.Texas.gov.

PLEASE NOTE

Your job application must be completely filled out and include all employment, do not limit employment to the past 10-15 years. Your application must contain complete job histories, which include job titles, name of employer, dates of employment (month & year), supervisor’s name and phone number, and a description of duties performed, and whether it was full-time or part-time 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.

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 add-on 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, career ladder advancements, and free meals while on duty.

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.

ESSENTIAL FUNCTIONS

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.

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.

PHYSICAL DEMANDS AND WORKING CONDITIONS

The following physical demands and working conditions are representative of those encountered while performing the essential functions of this job. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions.

Analyzing

Alphabetizing

Ability to communicate effectively, orally and in writing

Ability to see

Ability to hear (with or without aid)

Ability to perform tactile discernment

Identify colors

Depth perception

Operate motor equipment

Lifting, up to 25 lbs.

Carrying, up to 25 lbs.

Pulling

Pushing

Walking

Standing

Sitting

Repeated bending

Reaching above shoulder

Manual/finger dexterity

Dual simultaneous grasping

Twisting

Kneeling

Stooping

Climbing stairs

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.

VETERANS

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.

Go to https://texasskillstowork.com/, https://www.onetonline.org/, or http://www.careeronestop.org/ for assistance translating your military experience and training courses into civilian job terms, qualifications/requirements, and skill sets.

Additional Military Occupational Specialty (MOS) Code or Crosswalk information is available from the Texas State Auditor’s Office at Administrative Support MOS Codes.
Information Technology MOS Codes.
Planning, Research, and Statistics MOS Codes.
Education MOS Codes.
Accounting, Auditing, and Finance MOS Codes.
Inspectors and Investigators MOS Codes.
Program Management MOS Codes.
Human Resources MOS Codes.
Information and Communication MOS Codes.
Property Management and Procurement MOS Codes.
Engineering and Design MOS Codes.
Safety MOS Codes.
Employment MOS Codes.
Legal MOS Codes.
Medical and Health MOS Codes.
Criminal Justice MOS Codes.
Social Services MOS Codes.
Public Safety MOS Codes.
Custodial MOS Codes.
Maintenance MOS Codes.

Library and Records MOS Codes.

SPONSORSHIP

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

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 (https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=en), you may also check the status of your application by accessing your profile and selecting My Jobpage and selecting My Submissions.

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

AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER

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.