Data Analyst (Austin)

State of Texas • Austin, TX

70d • Onsite

About The Position

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 St, Austin, Texas, in the Information, Innovation and Insight Division. TWC is not considering applications from individuals who require sponsorship for an employment visa, including 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 perform complex (journey-level) data analysis and data research. Works under general supervision, with moderate latitude for the use of initiative and independent judgment.

Requirements

• 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.

Nice To Haves

• Experience with data models, database design development, data mining, and segmentation techniques.
• Ability for critical thinking with an eye for information analysis, objective evaluation, and problem-solving.
• Ability for strategic thinking with an eye for self-directed planning, goal setting, vision, pattern recognition, and risk assessment with opportunities for evaluation.
• Ability to communicate effectively.
• Experience with analyzing problems and devising effective solutions.
• Experience with statistics and analyzing large data sets.
• Experience with running queries in Oracle SQL Developer, DBeaver, or other similar SQL querying tool.
• Experience presenting findings, workshops, and demonstrations of work products.
• Experience with conducting data searches.

Responsibilities

• 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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Executive, Legislative, and Other General Government Support
• Education Level: No Education Listed
• Number of Employees: 1,001-5,000 employees