Address
Form of workJob Description
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 athttp://www.tjjd.texas.gov/index.php/doc-library/category/304-forms):
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=00037920&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: http://www.tjjd.texas.gov/index.php/doc-library/category/304-forms).
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. (20%)
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. (15%)
Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions. (15%)
Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality. (5%)
Utilizes software to generate metrics and develops actionable recommendations; identifies, manages, and discovers process improvements as they relate to reporting delivery (10%)
Collaborates with various stakeholders to identify needs for reporting. Collaborates closely with technical support, database administrators, software developers, and other business groups (15%)
Trains new and existing staff on how to develop and/or use queries, including the development of training materials. (5%)
Aids in data discovery for cleanup activities with users and project teams (5%)
Ensures successful conversion of reports during/following system upgrade (5%)
Reports any presence or perception of racial, ethnic and/or gender disparities.
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.
Qualifications:
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 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.
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.
• Master data, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture.
• Enterprise information management processes and methodologies, relational database management systems, metadata management, and business intelligence and business analytics tools.
• Local, state, and federal laws and regulations relevant to data management and data governance.
• Limitations and capabilities of computer systems.
• Technology across all network layers and computer platforms.
• Operational support of networks, operating systems, Internet technologies, databases, and security applications.
• Business intelligence tools such as Tableau, Power BI, QlikView, or similar
• Design, development, and maintenance of data marts and data warehouses.
• Computer programming languages.
• Data processing flowcharting techniques.
Skill in:
• Database report development and business intelligence
• SQL for data manipulation and retrieval
• Data modeling and ETL
• Complex problem-solving and critical thinking.
• Operating computers and using applicable computer software.
• System development lifecycle.
• 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 Information Technology MOS Codes.
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.
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 athttp://www.tjjd.texas.gov/index.php/doc-library/category/304-forms):
- TJJD Employment Application Supplement (HR-003)
- Child Abuse Registry Check Consent Form (HR-028)
- Disclosure of PREA Employment Standards Violation (HR-975)
- Authorization to Release Information (HR-074)
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=00037920&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: http://www.tjjd.texas.gov/index.php/doc-library/category/304-forms).
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. (20%)
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. (15%)
Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions. (15%)
Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality. (5%)
Utilizes software to generate metrics and develops actionable recommendations; identifies, manages, and discovers process improvements as they relate to reporting delivery (10%)
Collaborates with various stakeholders to identify needs for reporting. Collaborates closely with technical support, database administrators, software developers, and other business groups (15%)
Trains new and existing staff on how to develop and/or use queries, including the development of training materials. (5%)
Aids in data discovery for cleanup activities with users and project teams (5%)
Ensures successful conversion of reports during/following system upgrade (5%)
Reports any presence or perception of racial, ethnic and/or gender disparities.
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.
Qualifications:
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 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.
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.
• Master data, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture.
• Enterprise information management processes and methodologies, relational database management systems, metadata management, and business intelligence and business analytics tools.
• Local, state, and federal laws and regulations relevant to data management and data governance.
• Limitations and capabilities of computer systems.
• Technology across all network layers and computer platforms.
• Operational support of networks, operating systems, Internet technologies, databases, and security applications.
• Business intelligence tools such as Tableau, Power BI, QlikView, or similar
• Design, development, and maintenance of data marts and data warehouses.
• Computer programming languages.
• Data processing flowcharting techniques.
Skill in:
• Database report development and business intelligence
• SQL for data manipulation and retrieval
• Data modeling and ETL
• Complex problem-solving and critical thinking.
• Operating computers and using applicable computer software.
• System development lifecycle.
• 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 Information Technology MOS Codes.
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.
