Data Analyst

Socket.dev; Salt Lake City (UT); Hybrid; USD 41,000 - 63,000; Full time

Benefits offered by this job

Hybrid schedule

Benefits package

Job summary

Utah State Board of Education (USBE) is seeking a Data Analyst to support statewide Career and Technical Education (CTE) research, accountability, and program evaluation. You will collect, validate, and analyze data from multiple systems to inform policy and improve student outcomes.

The role involves creating dashboards and reports, performing statistical analysis with tools like R or Python, and ensuring data quality for federal and Perkins V reporting.

Qualifications

• Experience conducting research, data analysis, program evaluation, or business intelligence work.
• Experience writing T-SQL queries and working with Microsoft SQL Server, including relational databases and data quality practices.
• Experience developing dashboards, reports, and visualizations using Power BI, Fabric, or similar analytics platforms.
• Knowledge of educational data systems, accountability reporting, or state/federal reporting.
• Strong communication, analytical and project management skills.

Responsibilities

• Analyze statewide student, program, accountability, fiscal, workforce, and performance data.
• Develop recurring and ad hoc reports for program management and leadership decision-making.
• Write and maintain T-SQL queries to extract, transform, and analyze data from SQL Server and other sources.
• Design, develop, and maintain BI reports and dashboards.
• Support Perkins V and other accountability reporting requirements.

Skills

T-SQL

SQL Server

Power BI

Fabric

R/Python

Data analysis

Dashboards

Reporting

Data validation

Accountability reporting

Tools

Microsoft SQL Server

Power BI

Job description

Data Analyst

FT / PT Status – Full-Time
Benefits Eligibility – This position is eligible for a full benefits package.
Salary – $30.47 - $46.08 Hourly Wage
Remote Work / In-Office – Hybrid
Application Deadline – 10/1/2026*

Key Responsibilities

The Utah State Board of Education (USBE) invites you to apply for an opportunity to make ameaningful impact on Career and Technical Education (CTE) programs throughout thestate. USBE is seeking a Research Consultant II, with a working title of Data Analyst. Thisposition supports statewide CTE research, accountability, reporting, program evaluation,and data-informed decision-making.

The Data Analyst works with complex educational data from multiple systems and sources. Responsibilities include collecting, validating, analyzing, and communicating data to supportagency priorities. The position supports state and federal reporting requirements, includingPerkins V accountability measures and other CTE performance indicators. This work helpsensure data accuracy, strengthen reporting systems, evaluate program effectiveness, andprovide actionable information that supports student success.

Would you like to achieve success and fulfillment while helping improve the lives of Utah students?

Principal Duties

This position requires strong research, analytical, database, reporting, and communicationskills. Duties include:

• Analyze statewide student, program, accountability, fiscal, workforce, and performancedata to support CTE programs and initiatives.


• Develop recurring and ad hoc reports for program management, accountabilityreporting, 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 datasystems.


• Ensure data integrity, accuracy, consistency, 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, andrelated analytics tools.


• Use R or comparable statistical tools to conduct statistical analysis, trend analysis,research, and program evaluation.


• Identify trends, patterns, anomalies, and performance gaps and communicatefindings through reports, visualizations, presentations, and briefing materials fortechnical and nontechnical audiences.


• Conduct research studies, program evaluations, needs assessments, and analysesof program effectiveness and student outcomes.


• Develop and maintain methodologies, performance measures, business rules,calculations, reporting processes, and supporting documentation for accountabilityand analytical activities.


• Support Perkins V and other state and federal accountability reporting, including datacollection, validation, calculation, submission, and documentation activities.


• Support audit responses, compliance reviews, monitoring activities, correctiveactions, and continuous improvement efforts through accurate analysis anddocumentation.


• Collaborate with CTE staff, USBE information technology teams, districts, charterschools, postsecondary partners, and other stakeholders to define data needs andreporting requirements.


• Provide consultation, technical assistance, and training related to data definitions,reporting processes, dashboards, accountability measures, and interpretation ofresults.


• Manage multiple projects and deadlines while maintaining confidentiality, accuracy,and attention to detail.


• Serve on committees and complete other duties as assigned.

Qualifications

The Ideal Candidate

The ideal candidate is an experienced research and data professional who is committed toaccuracy, collaboration, continuous improvement, and using data to improve educationalopportunities and outcomes for Utah students.Preference may be given to applicants who possess:

• 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, includingrelational databases, data structures, and data quality practices.


• Experience working with large, complex datasets, including extraction,transformation, reconciliation, validation, and quality assurance activities.


• Experience developing dashboards, reports, semantic models, and visualizationsusing 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 analyticalprocesses.


• Experience with educational data systems, longitudinal student data, accountabilityreporting, or state and federal education reporting.


• Knowledge of Career and Technical Education programs, Perkins V accountabilityrequirements, workforce education, or labor market data.


• Experience conducting research, program evaluation, or policy analysis andcommunicating findings through reports, visualizations, presentations, andrecommendations.


• Strong communication, analytical, project management, and problem-solving skills,with the ability to work independently and collaboratively while managing multiplepriorities and deadlines.


• A degree in statistics, data analytics, statistics, education, or a closely related field.

Assurance/Minimum Requirement

• This position is located in Salt Lake City, Utah. You will be required to work in the office on a regular basis with the opportunity for a hybrid schedule.


• In addition to your resume, please submit one analytical work sample that demonstrates your ability to analyze data, identifymeaningful findings, and communicate results. Your submission must include the analyticalproduct and a brief cover statement addressing the following:


• Purpose: What question, problem, or decision did the analysis address?


• Applicant’s role: What portions of the work did you personally complete?


• Data: What type of data or data sources were used?


• Methods: What tools and analytical methods did you use?


• Audience: Who was the intended audience?


• Outcome: What decision, action, recommendation, or improvement resulted from the analysis?

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 because reviewer access may be restricted.


• Confidential, proprietary, personally identifiable, and otherwise restricted informationmust be removed or appropriately de-identified.


• If the work was 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

About the Role

Location –
250 East 500 South
Salt Lake City, Utah, 84111
United States
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.

Why You Should Join Our Team

In Utah, we believe hard work is important, but balance is essential. Finding work/life balance is a vital element to our culture. To find out more about WHY Utah, Other benefits may include:

• Job Stability: Enjoy the security and reliability of employment within a well-established organization.


• Career Growth: Develop valuable skills and gain opportunities for leadership within a large organization.


• Meaningful Work: Contribute to an important service that benefits the community and supports organizational goals.


• Supportive Work Environment: Be part of a team that values cooperation, strong work ethics, and mutual support.

The Agency

For more information

EEO Statement

The State of Utah is committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. For accommodations, please contact [phone].