Systems Analyst for Educator Savings Account Data (Systems Analyst V)

Texas Education Agency • Austin, TX

29d • Remote

About The Position

The Division of Educator Data, Research, and Strategy (EDRS) provides analytical leadership and support for departments across the Office of Educator Systems and Support. EDRs supported the Authorizing department in support of their mission. The Authorizing department cultivates innovative, high-quality learning opportunities and provides Texas families with the necessary information to access these options. The aim is to support more students in finding high-quality, best-fit schools. TEA assists LEAs in creating diverse options, including charter and virtual/hybrid schools, through start-up and replication grants, accelerator programs, and incubation supports. It establishes authorizing best practices across Texas through multiple technical assistance pathways and ensures the portfolio of opportunities for Texas families is of high quality through evaluation, monitoring, and oversight. The Systems Analyst for Educator Savings Account Data plays a critical role in providing usable, useful, and timely data required for the execution of the Educator Savings Account program. Reporting to the Director for Educator Data, Research and Strategy - Authorizing team, this person uses SAS, SQL, PowerBi, Excel, Smartsheets, Visual Basic, and other tools to ensure strong data collection practices and transparent communication of data with internal and external stakeholders. This analyst leverages data expertise to build requirements and prioritize improvements in collaboration with key intra-TEA teams to construct and continuously improve the relevant data infrastructure. This professional designs and executes quality assurance processes to ensure accurate and repeatable result. In addition, this expert various software tools to provide timely communication of data related to ESAs and other initiatives of the Authorizing department. The person makes use of Smartsheet and other specialized TEA systems to manage their own project load. This professional works under limited supervision, with moderate latitude for the use of initiative and independent judgment. Flexible work location within the state of Texas may be considered for qualified candidates.

Requirements

• Graduation from an accredited four-year college or university
• At least four (4) years of experience in systems analysis and design work
• An advanced degree may substitute for two years of required experience

Nice To Haves

• Share the belief that all Texas students can achieve at high levels and are able to succeed in college, career, or the military
• Experience working with large data sets and educational systems are preferred
• Ability to plan, organize, manage, and execute multiple work streams and projects at a high quality with minimal supervision
• Familiarity with interpreting Texas statutes, administrative codes, and written policies; Texas Administrative and Education Code preferred
• Excellent writing and oral communication skills, including proficiency with documenting standards and procedures of work
• Experience coordinating with cross-functional teams to enhance APIs
• Skill in using statistical software, including strong skills in SAS
• Expertise with programming techniques and languages used in relational databases, including SQL
• Experience in developing tools in business intelligence software, including Microsoft PowerBI, Microsoft Excel, and Smartsheets
• Knowledge of documentation best practices
• Experience with designing and generating high-quality reports suitable for a range of audiences including file and accessibility management
• Experience with analyzing computer systems and procedures to identify areas for improvement
• Knowledge of Texas Education Saving Account policy preferred
• A desire to self-reflect, give & receive feedback, and continuously improve

Responsibilities

• ESA Data Coordination: Design, implement, update, document, and standardize processes related to Education Savings Account data to meet statutory and technical requirements; this includes writing and revising SQL queries and SAS Programs, using Visual Basic, Excel, and Citrix Sharefile to efficiently share data with external stakeholders, and Microsoft Word to document requirements and technical processes; manages work independently with minimal oversight.
• ESA Data Transmission: Develop, update, and test protocols for transmission of ESA data, including creation and documentation of protocols and tests, monitor and report on transmission health for all EDRS Authorizing data products, including those using PowerBI Data Gateways and Smartsheet Data Shuttle; collaborates with internal and external stakeholders to ensure high quality data transmission.
• ESA Data Infrastructure: Develop, implement, document, and improve data infrastructure to support the efficient reception, storage, packaging, and transmission of ESA-related data, including SharePoint, AWS, ShareFile, and SmartSheets; leveraging feedback to calibrate and improve the system.
• Quality Assurance: Conducts quality review of data sets and other analytical products created or received by the EDRS - Authorizing unit, acting on feedback from other team members to systematically improve data and visualization products.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Administration of Human Resource Programs
• Number of Employees: 1-10 employees