WHO WE ARE:
The mission of the Texas Workforce Commission (TWC) is to promote and support a workforce system that creates value and offers employers, individuals and communities the opportunity to achieve and sustain economic prosperity. To support our mission, we are seeking a Data Analyst to join the Unemployment Insurance Administration and Operational Support (UIA&OS) team. 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 will have an on-site work schedule in one of our facilities in Austin, El Paso, Fort Worth, McAllen, or San Antonio.

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.

WHO YOU ARE:
We are seeking a highly motivated and skilled Data Analyst to join our growing team. In this role, you will be responsible for analyzing data, identifying trends, and providing insights that drive business decisions. You will work closely with project managers, business analysts, and system analysts to ensure data accuracy and integrity across various systems.

WHAT YOU WILL DO:
The Data Analyst I-II performs entry-level to routine (journey-level) data analysis and data research work. Works under close to moderate supervision, with minimal to limited latitude for the use of initiative and independent judgment.

YOU WILL BE TRUSTED TO:
-Design, develop, and execute SQL scripts, VB Scripts, and other technologies to extract, transform, and load (ETL) data from various sources, particularly user interface (UI) data.
-Conduct thorough data analysis to identify trends, patterns, and anomalies.
-Develop and maintain data visualizations (graphs, charts, dashboards) using tools like Excel, Power BI and Tableau to communicate findings effectively.
-Generate daily, weekly, monthly, quarterly, and annual reports on business activities, as well as ad-hoc reports as needed.
-Conduct audits to validate data accuracy and completeness.
-Participate in the full execution of data conversions, including mapping, extraction, transformation, and validation.
-Troubleshoot and resolve data issues in test and production environments.
-Tune and optimize database objects, queries, and scripts for speed and efficiency.
-Design, implement, and maintain new and existing database objects (tables, indexes, constraints, stored procedures, user-defined functions).
-Identify, analyze, and recommend improvements to existing data processes and procedures.
-Collaborate with project management, business analysts, and system analysts to ensure data aligns with business rules and requirements.
-Stay up-to-date with the latest data analysis technologies and database concepts.
-Support operations and projects in alignment with the organization's mission and vision.
-Adhere to internal standard operating procedures to support project needs.
-Perform other job-related duties as assigned.

YOU QUALIFY WITH:
-Data Analyst I: Graduation from an accredited high school or successful completion of GED certification. Acceptance into a TWC Internship or TWC Apprenticeship will satisfy the minimum qualifications.
-Data Analyst II: One year 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.
-Both Levels: Relevant academic credits may be applied toward experience qualifications for this position.

YOU ARE A GREAT FIT WITH:
-Proficiency in SQL.
-Experience with data visualization tools such as Excel, Power BI and Tableau.
-Familiarity with scripting languages (e.g., VBA, Python, R).
-Knowledge of data warehousing concepts and ETL processes.
-Familiarity with JSON and Google APIs.
-Strong analytical and problem-solving abilities with a keen attention to detail.
-Ability to identify, analyze, and interpret trends in data sets.
-Excellent organizational, time management, and prioritization skills.
-Ability to learn new systems and retain information quickly.
-Excellent oral and written communication skills, with the ability to present data effectively to various audiences.
-Strong collaboration skills and the ability to work effectively within a team.
-Professionalism and a commitment to quality.

YOU GAIN:
- A Family Friendly Certified Workplace.
- Competitive starting salary: $4,325.37 - $5,521.16/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.

Security sensitive position. Criminal background check to be conducted. May work outside of normal business hours for special projects, outages, upgrades, or service affecting maintenance. Duties require up to 10% travel within the state of Texas and the ability to lift 15 Lbs. TWC may use all available information, including past unemployment claims, to evaluate an applicant’s suitability for the position. Security sensitive position. Criminal background check conducted on final candidate.
PLEASE NOTE: All applications should contain complete job history entries, which includes job title, dates of employment, name of employer, supervisor's name and phone number and a description of duties performed. If
this information is not submitted; your application may be rejected because it is incomplete. Resumes do not take the place of this required information

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.
TWC is not considering applications from individuals who require sponsorship for an employment visa, including 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.