Data Analyst; Austin

Texas Workforce Commission connects people with careers across the state. While we are based in Austin on the north lawn of the Texas State Capitol, we have offices statewide. We're a Family Friendly Certified Workplace with great work-life balance, competitive salaries, extensive opportunities for training and development, and fantastic benefits.

This position is located at 101

E. 15th Street, Austin, Texas, in the Division of Information Innovation & Insight (I/3).

TWC is not considering applications from individuals who require sponsorship for an employment visa, including those with H1B visas or those currently on student or postgraduate visas.

You must be a Texas resident to work for the Texas Workforce Commission or willing to relocate to Texas.

We are looking for a creative and experienced Data Analyst IV to join the ETL team in TWC’s Division of Information Innovation and Insight (I|3). The division supports the agency’s mission by leveraging data to improve decision-making and service efficiency. That is, we leverage Data for Prosperity.

The data analyst will support I|3’s mission to extract, transform, and load data for reporting to better serve the employers, individuals, families, and communities of Texas. Our ideal candidate is a self-starting, motivated, and collaborative problem solver who understands the value of teamwork, critical thinking, attention to detail, interpersonal skills, and data analysis to assist in management of TWC programs.

Candidates must be enthusiastic about working collaboratively with teammates, TWC staff, and other state agency staff to deliver accurate information on deadline to a wide variety of stakeholders, including other State Agencies and Local Workforce Development Areas (LWDA).

Candidates will have the opportunity to apply their mindset to develop, maintain, and improve current ETL processes, and ultimately make a difference in the lives of Texans.

The Data Analyst IV performs complex (journey-level) data analysis and data research. Works under general supervision, with moderate latitude for the use of initiative and independent judgment.

• Consult with internal and external customers to identify user needs for business requirements and data sources.
• Compile and query data, via an Oracle Enterprise Data Warehouse, based on business requirements to ensure accuracy and understanding of the requirements for development, optimization, and maintenance of data.
• Analyze data using standard statistical tools, methods, and techniques with Oracle SQL Developer, DBeaver, and Microsoft Excel for analysis, development, and optimization.
• Identify data gaps, errors, anomalies, inconsistencies and redundancies by analyzing the content, structure and relationships within data.
• Interpret results to identify significant differences in data.
• Identify and interpret data patterns and trends and assess data quality.
• Clean and prune data to discard irrelevant information.
• Prepare concise, comprehensive technical reports to present and interpret data, identify alternatives and make and justify recommendations on data revisions.
• Assist in defining, developing and implementing data standards.
• Assist in developing data quality measures, analyzing data quality results and implementing necessary changes to ensure data quality improvement.
• Assist with developing software applications or programming to use for statistical modeling and graphic analysis.
• Perform other duties as needed.

• Three years of full-time experience in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field.
• Relevant academic credits may be applied toward experience qualifications for this position.

• Three years of full-time experience converting legacy ETL solutions to contemporary ETL implementations.
• Three years of full-time experience developing and reverse engineering SQL and PL/SQL code bases.
• Three years of full-time experience with large data sets.
• Three years of full-time experience coding within Oracle…