Data Analyst (Austin)

WHO WE ARE:
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.

WHO YOU ARE:
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.
 
WHAT YOU WILL DO:
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. 

YOU WILL BE TRUSTED TO:
-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. 

YOU QUALIFY WITH:
-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. 

YOU ARE A GREAT FIT WITH:
-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 database environments.
-Three years of full-time experience creating Informatica Cloud Services (IICS) taskflows.
-Professional experience coding within Oracle SQL Developer, DBeaver, VS Code, or other industry-standard SQL IDEs.
-Intra and inter team player with strong interpersonal and communication skills.
-Driven to improve processes and products when points of potential improvement are encountered.
-Strong ability to present thoughts, observations, and findings clearly and concisely in written and oral forms.
-Emphasizes consistency, accuracy, and precision in work products and communication style.

We will only consider applications that include all the following:
(1)    an attached writing sample (at least 1,000 words of business communication, technical explanation, or creative writing).
(2)    an attached cover letter explaining why you are interested in the job and how you think you’d be a good fit at the Texas Workforce Commission.
(3)    an attached resume tailored to the Data Analyst IV position that specifies how you will meet each qualification for this posting.

YOU GAIN: 
- A Family Friendly Certified Workplace.  
- Competitive starting salary: $6,290.00 - $7,156.00/month 
- Defined Retirement Benefit Plan 
- Optional 401(k) and 457 accounts 
- Medical Insurance 
- Paid time off, including time for vacation, sick and family care leave 
- Additional benefits for active employees can be found at https://www.ers.texas.gov/Active-Employees/Health-Benefits.

VETERANS:
Use your military skills to qualify for this position or other jobs! Go to www.texasskillstowork.com to translate your military work experience and training courses into civilian job terms, qualifications, and skill sets. Also, you can compare this position to military occupations (MOS) at the Texas State Auditor's Office by pasting this link into your browser: https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf 

HOW TO APPLY: 
To be considered, please complete a State of Texas Application for Employment and apply online at www.workintexas.com or on Taleo (Job Search). 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. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. A position utilizing this classification will be designated as security sensitive according to the Texas Labor Code, Section 301.042.