Apply on Employer Site

State of Utah · 12 hours ago

Medicaid Claims Manager

Salt Lake County, UT

Full-time

Hybrid

Mid Level

The State of Utah is seeking a Medicaid Claims Manager to join the Office of Medicaid Operations. This role involves advanced programming with SQL and relational databases, focusing on data querying, analysis, and reporting to support departmental needs and ensure data quality.

GovernmentInformation TechnologyLaw Enforcement

H1B Sponsor Likely

Responsibilities

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

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

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

Qualification

Advanced SQLData EngineeringData Quality & ValidationHealthcare Claims ProcessingRegulatory ComplianceStakeholder PartnershipCritical ThinkingIndependent Work

Required

Advanced programming experience with SQL and relational databases

Critical thinking is a must as the right answer is not always obvious or known

Experience with claims processing and data analysis

Proven ability to architect and implement production-ready data solutions and data transformation routines using advanced SQL

Experience designing and building reliable analytical data models to deliver high-quality, trusted datasets for stakeholders and leadership

Skill in reverse-engineering and translating complex business logic from legacy End-User Computing (EUC) tools (such as Microsoft Excel and Access, including VBA macros) into stable, version-controlled code

Experience implementing automated data quality checks, monitoring, and validation processes to ensure solution accuracy and reliability

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

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

Excellent written and verbal communication skills, with the ability to partner with non-technical stakeholders to capture business processes and technical specifications

Ability to plan, organize, and prioritize workload, meet deadlines, and work independently to find efficient solutions to technical challenges

Preferred

Experience with healthcare claims processing and data analysis

Benefits

On-site fitness center, for a minimal membership fee

UTA Eco Pass, at a discounted monthly rate

Teleworking opportunities with a minimum 2 office days

On-site day care center at the Cannon Health Building with First Steps Day Care - contact for rates and availability, 385-382-4012 or firststepschildcareslc@gmail.com

Company

State of Utah

Glassdoor3.8

State of Utah provides links to government information sites and departments.

Founded in 1896

Salt Lake City, Utah, USA

10001+ employees

http://www.utah.gov/

H1B Sponsorship

State of Utah has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (1)

2022 (1)