Data Analyst for Preparing and Retaining Educators through Partnerships (PREP) Allotment (Data Analyst IV)

Responsibilities

• Design, develop, test, and execute SAS code to query, compile, and manipulate data required for PREP Allotment client units; perform complex analysis on data relationships, build visualizations, interpret findings, identify patterns, and communicate results and key insights to respond to identified client units; support the creation of state, federal, and internal reporting, including Public Information Requests
• Design, develop, test, and implement data collection tools including surveys and forms using software such as Qualtrics and Smartsheet's; review and manipulate collected data using SAS and BI software to identify trends, generate insights, and present key findings to identified client units
• Serve as an essential partner to identified client units, guide decision-making, and align EDRS collaborations with clients' needs and goals
• Conduct quality reviews of data sets and other analytical products created or received by the EDRS - EPCE unit, acting on feedback from team members to systematically improve data and visualization products
• Develop, implement, test, and document technical work related to the EDRS-EPCE unit and other TEA internal projects; maintain data governance standards, management tools, usage guidelines, and storage procedures

Requirements

• Education: Graduation from an accredited four-year college or university
• Experience: At least three (3) years of experience in data analysis, research, compilation, and/or reporting work
• Substitutions: An advanced degree may substitute for two years of required experience
• Belief that all Texas students can achieve at high levels and succeed in college, career, or the military
• Experience working with large data sets and educational systems is preferred
• Knowledge of statistical procedures used in the analysis of data sets
• Proficiency with software and programming languages used for statistical analysis and database interaction, including SAS, SQL, and other applicable languages and packages
• Experience using Qualtrics to design surveys and analyze findings based on responses
• Expertise in developing engaging data visualizations using BI software, with Power BI preferred
• Experience designing, generating, and updating high-quality reports for a range of audiences based on user requirements
• Ability to plan, organize, and manage multiple work streams using project management techniques with general supervision
• Experience analyzing systems and procedures to identify improvements to data production, reporting, or analytics
• Strong communication skills, both verbal and written
• Ability to compose, review, and edit technical documents
• Proficiency in interpreting and applying guidelines, policies, procedures, laws, and regulations
• Experience with Texas education data is preferred
• Desire to self-reflect, give and receive feedback, and continuously improve
• Ability to maintain effective working relationships with a variety of individuals and groups

Technologies

• SAS
• SQL
• Qualtrics
• Smartsheet
• Power BI
• Microsoft Office

Essential Functions

• 1. Client support: Datasets and Reports — Design, develop, test, and execute SAS code to query, compile, and manipulate data required for PREP Allotment client units; perform complex analysis on data relationships, build data visualizations, interpret findings, identify data patterns, and communicate results and key insights to respond to identified client units; support the creation of all necessary state, federal, and internal reporting, including Public Information Requests
• 2. Client support: Data Collection tools — Design, develop, test, and implement data collection tools including surveys and forms using software such as Qualtrics and Smartsheet's; review and manipulate collected data using SAS and BI software to identify trends, generate insights, and present key findings to identified client units
• 3. Client support: Strategic Advising — Serve as an essential partner to identified client units, guide decision-making and align EDRS collaborations with clients' needs and goals
• 4. Quality Assurance — Conduct quality reviews of data sets and other analytical products created or received by the EDRS-EPCE unit, acting on feedback from team members to systematically improve data and visualization products
• 5. Documentation — Develop, implement, test, and document technical work related to the EDRS-EPCE unit and other internal TEA projects; maintain data governance standards, management tools, usage guidelines, and storage procedures