Data Analyst

The State of Utah State Board of Education is seeking a Data Analyst (Research Consultant II) to support statewide Career and Technical Education (CTE) research and accountability reporting.

Responsibilities

• Analyze statewide student, program, accountability, fiscal, workforce, and performance data to support CTE programs and initiatives.
• Develop recurring and ad hoc reports for program management, accountability reporting, strategic planning, policy analysis, and leadership decision-making.
• Write and maintain T-SQL queries and scripts to extract, transform, validate, reconcile, and analyze data from Microsoft SQL Server and other enterprise data systems.
• Support data integrity and reliability through data validation, quality assurance processes, and resolution of data discrepancies.
• Design, develop, and maintain reports, dashboards, semantic models, visualizations, and business intelligence solutions using Microsoft Power BI, Microsoft Fabric, and related analytics tools.
• Use R or comparable statistical tools for statistical analysis, trend analysis, research, and program evaluation.
• Identify trends, patterns, anomalies, and performance gaps, and communicate findings through reports, visualizations, presentations, and briefing materials for technical and nontechnical audiences.
• Conduct research studies, program evaluations, needs assessments, and analyses of program effectiveness and student outcomes.
• Develop and maintain methodologies, performance measures, business rules, calculations, reporting processes, and supporting documentation for accountability and analytics activities.
• Support Perkins V and other state and federal accountability reporting, including data collection, validation, calculation, submission, and documentation.
• Support audit responses, compliance reviews, monitoring activities, corrective actions, and continuous improvement efforts through accurate analysis and documentation.
• Collaborate with CTE staff, USBE information technology teams, districts, charter schools, postsecondary partners, and other stakeholders to define data needs and reporting requirements.
• Provide consultation, technical assistance, and training related to data definitions, reporting processes, dashboards, accountability measures, and interpretation of results.
• Manage multiple projects and deadlines while maintaining confidentiality, accuracy, and attention to detail.
• Serve on committees and complete other duties as assigned.

Requirements

• Professional experience conducting research, data analysis, program evaluation, performance measurement, or business intelligence work.
• Experience writing T-SQL queries and working with Microsoft SQL Server, including relational databases, data structures, and data quality practices.
• Experience with large, complex datasets, including extraction, transformation, reconciliation, validation, and quality assurance activities.
• Experience developing dashboards, reports, semantic models, and visualizations using Microsoft Power BI, Microsoft Fabric, or similar analytics platforms.
• Experience using R, Python, SAS, SPSS, or similar statistical and analytical tools.
• Experience automating recurring reports or developing repeatable analytical processes.
• Experience with educational data systems, longitudinal student data, accountability reporting, or state and federal education reporting.
• Knowledge of CTE programs, Perkins V accountability requirements, workforce education, or labor market data.
• Experience conducting research, program evaluation, or policy analysis and communicating findings through reports, visualizations, presentations, and recommendations.
• Strong communication, analytical, project management, and problem-solving skills, with the ability to work independently and collaboratively while managing multiple priorities and deadlines.
• Degree in statistics, data analytics, statistics, education, or a closely related field.

Technology Stack

• T-SQL
• Microsoft SQL Server
• Microsoft Power BI
• Microsoft Fabric
• R
• Python
• SAS
• SPSS

Work Location and Schedule

• Salt Lake City, UT (Hybrid)
• Location: 250 East 500 South, Salt Lake City, UT, 84111, United States
• Regular office work required with the opportunity for a hybrid schedule

Compensation

• USD 30 - 46 per hourly

Benefits

• Eligible for a full benefits package

Application Deadline

• 10/1/2026*

Additional Requirements (Analytical Work Sample)

• In addition to your resume, submit one analytical work sample demonstrating your ability to analyze data, identify meaningful findings, and communicate results.
• Cover the following prompts: purpose (question/problem/decision), applicant role, data sources, methods/tools used, intended audience, and outcome (decision/action/recommendation/improvement).

Submission Requirements

• Maximum of five pages for the analytical product.
• Maximum of 250 words for the cover statement.
• PDF format preferred.
• Dashboard samples may be submitted as PDF exports or screenshots.
• Links alone will not be accepted due to potential restricted reviewer access.
• Remove or appropriately de-identify confidential, proprietary, personally identifiable, and otherwise restricted information.
• If created collaboratively, clearly identify your individual contribution.
• Publicly available or simulated data may be used when prior work cannot be shared; clearly identify any simulated data.

Examples of Acceptable Work Samples

• Data dashboard
• Research or evaluation report
• Statistical analysis
• Accountability or performance report
• Data-quality or validation analysis
• Executive data brief
• Data visualization with written findings

Assurance / Background Screening

• Background Check Required: Yes
• Drug Test Required: No
• Schedule Code: AE - Employees of the State Board of Edu. This is a career service exempt at will position.