Data Analyst V ¿ Finance Division
To apply for any posted position with the Texas Commission on Law Enforcement, please register or log in at:
https://erphcmprd.cpa.texas.gov/psc/candidateportal/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?FOCUS=Applicant
Resumes are not accepted in lieu of State of Texas application
The Texas Commission on Law Enforcement (TCOLE) is seeking a Data Analyst V to join the Finance Division located at 6330 E HWY 290, Suite 200, Austin, TX.
The employee performs data analysis work involving conducting extensive data research and analyzing and reporting the results. Performs complex data analysis and data research work. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.
Salary is dependent on qualifications and experience. The salary range is $85,000 $105,000. Job Class for this position is 0654 and salary group is B26.
Essential Job Duties
Examples of Work Performed
Reporting, report building, data cleaning, dashboard creation, KPI's, visualizations, and financial data analysis.
Collects, queries, and analyzes data using standard statistical tools, applications, methods, and techniques.
Interprets data analysis results to identify significant differences and trends in data to inform decisions.
Consults with internal and external customers to identify data analytics needs.
Creates data visualizations to represent the data.
Cleans and prunes data to discard irrelevant information.
Responds to time sensitive adhoc record requests.
Identifies and interprets data patterns and trends and assess data quality.
Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions.
Establishes and maintains standard work procedures governing the appropriate use of data.
Guides the selection of data management tools and the development of standards, usage guidelines, and procedures for those tools.
Defines, develops, and implements data and reporting standards.
Develops data quality measures, analyzes data quality results, and implements necessary changes to ensure data quality improvement.
Develops software applications or programming to use for statistical modeling, data analysis, and graphic analysis.
Other duties as assigned.
Minimum Qualifications
Experience in data analysis, research, compilation, and/or reporting work.
Graduation from an accredited fouryear college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is generally preferred.
An advanced degree may substitute for two years of required experience.
At least four (4) years of relevant work experience primarily in data analysis, data compilation and reporting.
Preferred Qualifications
Knowledge of legal restrictions governing allocation of funds.
Advanced knowledge of presenting information visually.
Strong knowledge of CAPPS, Power BI, Microsoft 365 tools, and Business Objects.
State government experience.
Knowledge/Skills/Abilities
Knowledge of statistics and analyzing data sets; running queries, report writing, and presenting findings; and record keeping, including security procedures for handling, protecting, and distributing confidential data.
Skill in the use of computers and applicable software, in conducting data searches, in evaluating and translating large amounts of data, and in critical thinking.
Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; and to communicate effectively.
Knowledge of data models, database design development, data mining, and segmentation techniques.
Skill in analyzing problems and devising effective solutions.
Strong SQL database query skills.
Ability to utilize data visualization tools.
Ability to find patterns in data and interpret data.
Ability to prep and clean data.
Experience with data management and data quality tools.
Strong communication skills.
Problem solving, critical thinking, and decisionmaking skills.
Physical Requirements
Ability to sit at a desk and work on a computer for extended periods throughout the day.
May travel up to 5% of the time including occasional overnight travel.
Consistent use of office equipment, such as computers, phones, printers, and database systems.
Adequate handeye coordination for typing, computer use, and document review.
Ability to perform repetitive tasks efficiently including data entry and record review.
Basic mobility for occasional walking within the office and travel to field locations.
Benefits
Why work at TCOLE?
Working for the Texas Commission on Law Enforcement (TCOLE) empowers you to make an impact on public safety while engaging in continuous learning within a supportive environment. You'll play a crucial role in upholding high law enforcement standards, collaborating with local agencies, and enhancing the wellbeing of Texans. As a Texas State employee, you will have access to our comprehensive benefit programs including:
Comprehensive health, dental, and vision insurance plans with several types of coverage to State employees and their eligible family members
For new hires and rehires, health insurance is available the 1st of the following month after a 60day waiting period. More information about benefits is available at https://ers.texas.gov/benefitsataglance
12 16 days of annual paid holidays
At least ¿ eight hours of paid vacation and up to eight hours of paid sick leave ¿ each month for FullTime employees
Retirement options with the State of Texas Retirement that provide flexibility and security
Health and Wellness programs including wellness leave, fitness and weight management programs, and personalized wellness tools
TCOLE is a qualifying organization for the Public Service Loan Forgiveness Program
The Discount Purchase Program provides access to an online marketplace offering discount on a wide range of products and services
Additional Information
All positions with TCOLE are security sensitive. Applicants are subject to an indepth background investigation including criminal history, employment history and references, military, education, and personal references. Employment is contingent upon the verification of credentials and/or other information required.