Data Analyst

United Trading Group; Salt Lake City (UT); Hybride; USD 72 244 000 - 148 486 000; Plein temps

Résumé du poste

United Trading Group seeks a Data Analyst in Salt Lake City, UT for a hybrid role combining in-room work with remote days. The analyst will extract, analyze, and synthesize datasets from our Data Warehouse and health claims systems to drive business intelligence and policy development.

This role requires advanced SQL, statistical and actuarial analysis, and cross‑departmental collaboration. The position emphasizes data privacy, HIPAA compliance, and data quality, with opportunities to influence

Qualifications

• Proven ability to architect and implement production‑ready data solutions using advanced SQL.
• Experience designing reliable analytical data models for stakeholders and leadership.
• Experience implementing automated data quality checks and validation processes.
• Strong written and verbal communication to partner with non‑technical stakeholders.
• Ability to plan, organize, and work independently to solve technical challenges.
• Critical thinking to determine the right answer when it is not obvious.

Responsabilités

• Develop, write, and execute complex SQL queries to extract data from the Data Warehouse and PRISM.
• Prepare data to support trends, claims processing evaluations, and policy development.
• Perform statistical and actuarial analysis to derive actionable insights.
• Analyze, summarize, and report findings with recommendations for management.
• Act as SME for data availability, structure, and extraction methods.
• Review data production for issues and propose improvements for quality.

Connaissances

SQL querying

Statistical analysis

Actuarial analysis

Data extraction

Data quality checks

Outils

PRISM

Description du poste

Data Analyst

FT / PT Status – Full-Time

Benefits Eligibility – This position is eligible for a full benefits package.

Salary – $25.22 - $51.82 Hourly Wage

Remote Work / In-Office – Hybrid

Key Responsibilities

The Data Analyst is responsible for extracting, analyzing, and synthesizing complex datasets from our Data Warehouse and health claims systems (such as PRISM) to drive business intelligence, program evaluations, and strategic policy development. Serving as a technical subject matter expert, this role combines advanced SQL querying, statistical and actuarial analysis, and cross-departmental collaboration to deliver actionable insights while ensuring strict adherence to healthcare data privacy and compliance standards.

Core Data Querying and Analysis

• Develop, write, and execute complex SQL queries, including the use of joins, subqueries, aggregates, and functions, to extract and manipulate data from the Data Warehouse and other relevant systems (e.g., PRISM claims system).
• Extract and prepare data to support various departmental needs, including examining trends, evaluating claims processing, conducting program evaluations, and informing policy development.
• Perform statistical and/or actuarial analysis by applying appropriate protocols to analyze data and draw accurate conclusions.
• Analyze, summarize, and review data to report findings, interpret results, and/or make recommendations for management.

Data Systems and Troubleshooting

• Act as a subject matter expert and technical resource for management and staff on data availability, structure, and extraction methods.
• Resolve difficult and unusual data problems, leveraging expert knowledge and experience with interfacing automated data systems.
• Review data production for potential issues and propose solutions, enhancements, and procedural changes to improve data quality and efficiency.

Reporting and Collaboration

• Write or draft technical reports, articles, or related materials based on in-depth research, investigation, and data analysis.
• Meet and confer with management, end-users, and external contract providers to understand data needs, resolve problems, and coordinate services.
• Ensure all data access and handling practices adhere to strict confidentiality policies, especially when dealing with sensitive information like applicant or recipient data, as mandated by Medicaid/DHHS policy.

Supplemental Information

• An offer of employment will be contingent on the applicant successfully passing a DHHS background check.
• This position may currently be a hybrid of both two (2) in‑office and three (3) remote work days. Please note, a position's eligibility for remote work is established by agency management and is subject to change at their discretion, at any time, and for any reason.
• Risks found in the typical office setting, which is adequately lighted, heated and ventilated, e.g., safe use of office equipment, avoiding trips and falls, observing fire regulations, etc.
• Typically, the employee may sit comfortably to perform the work; however, there may be some walking; standing; bending; carrying light items; driving an automobile, etc. Special physical demands are not required to perform the work.

Qualifications

Minimum or "day-one" qualifications:

Technical Expertise

• Data Engineering Expertise: Proven ability to architect and implement production‑ready data solutions and data transformation routines using advanced SQL.
• Analytical Data Modeling: Experience designing and building reliable analytical data models to deliver high‑quality, trusted datasets for stakeholders and leadership.
• Data Quality & Validation: Experience implementing automated data quality checks, monitoring, and validation processes to ensure solution accuracy and reliability.

Soft Skills and Work Ethic

• Stakeholder Partnership: Excellent written and verbal communication skills, with the ability to partner with non‑technical stakeholders to capture business processes and technical specifications.
• Independent Work: Ability to plan, organize, and prioritize workload, meet deadlines, and work independently to find efficient solutions to technical challenges.
• Critical Thinking: Critical thinking is a must, as the right answer is not always obvious or known.

Preferred or trainable/on-the-job qualifications:

Policy and Domain Knowledge

• Regulatory Compliance: Strong understanding of data security principles and experience designing systems that ensure technical compliance with HIPAA, CMS, and state data governance policies when handling Protected Health Information (PHI) and PII.
• Policy Interpretation: Ability to read, interpret, and accurately apply state and federal laws, rules, regulations, and policies related to the Medicaid/Medicare system to inform data solution design.
• Domain Preference: Having experience with healthcare claims processing and data analysis is strongly preferred.

About the Role

Location –
288 North 1460 West
Salt Lake City, Utah, 84116
United States

Background Check Required – You must successfully pass a criminal history check.

Drug Test Required – No

Schedule Code – B - Competitive Career Service

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.

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 on the Division of Integrated Healthcare and it's programs, please visit our website.

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