Data Analyst

United Trading Group; Salt Lake City (UT); Hybrid; USD 41,000 - 63,000; Full time

Benefits offered by this job

Benefits package

Hybrid work schedule

Job summary

The Utah State Board of Education in Salt Lake City seeks a Data Analyst to support statewide Career and Technical Education (CTE) research, accountability, reporting, and program evaluation. This role emphasizes data-informed decision-making and data quality across multiple systems.

You will work with complex educational data, develop dashboards and reports, and employ T-SQL, SQL Server, and BI tools to inform policy and practice aiming to improve student outcomes.

Qualifications

• 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 developing dashboards, reports, semantic models, and visualizations using Power BI, Microsoft Fabric, or similar analytics platforms.
• Experience using R, Python, SAS, SPSS, or similar statistical/analytic tools.
• Experience automating recurring reports or developing repeatable analytical processes.

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.
• Ensure data integrity, accuracy, consistency, and reliability through data validation and quality assurance processes.
• Design, develop, and maintain reports, dashboards, semantic models, visualizations, and BI solutions using Power BI, Fabric, and related tools.
• Collaborate with USBE staff, IT teams, districts, postsecondary partners, and stakeholders to define data needs and reporting requirements.

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*. * This job posting may close at any time after the minimum advertising period of three (3) business days has passed, should a sufficient applicant pool be received. Applicants are encouraged to apply as early as possible.

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 support agency priorities. The position supports state and federal reporting requirements, including Perkins V accountability measures and other CTE performance indicators. This work helps ensure data accuracy, strengthen reporting systems, evaluate program effectiveness, and provide 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 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.
• 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, and related 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 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 analytical activities.
• Support Perkins V and other state and federal accountability reporting, including data collection, validation, calculation, submission, and documentation activities.
• 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.

Qualifications

The Ideal Candidate

The ideal candidate is an experienced research and data professional who is committed to accuracy, collaboration, continuous improvement, and using data to improve educational opportunities 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, including relational 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 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 Career and Technical Education 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.
• 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, identify meaningful findings, and communicate results. Your submission must include the analytical product 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 information must 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, click here.

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

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