Data Analyst (Austin) (827127)

About the role

The Data Analyst IV position is located at 101 E. 15th Street, Austin, Texas, in the Division of Information Innovation & Insight (I/3) of the Texas Workforce Commission (TWC).

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.
• Aid in defining, developing and implementing data standards.
• Aid in developing data quality measures, analyzing data quality results and implementing necessary changes to ensure data quality improvement.
• Aid with developing software applications or programming to use for statistical modeling and graphic analysis.
• Perform other duties as needed.

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

Qualifications

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

Skills

• Proficient in Oracle SQL Developer, DBeaver, VS Code, or other industry-standard SQL IDEs.
• Experience with Informatica Cloud Services (IICS) taskflows.
• Ability to analyze and interpret data using standard statistical tools and techniques.
• Experience with large data sets and coding within Oracle database environments.
• Strong interpersonal and communication skills.
• Ability to present thoughts, observations, and findings clearly and concisely in written and oral forms.

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.

Pay

$6,290.00 - $7,156.00/month

Schedule

N/A