Job Description HOW TO APPLY Complete a State of Texas Application for Employment and the following additional forms (available at)
- 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
&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
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:
and can be submitted via email to:
.
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 . 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.
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 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
. click apply for full job details