Job Description

The Financial Data Analyst supports the financial, operational, and strategic needs of the department. This position leads financial data management efforts, oversees medical billing and claims workflows, and monitors the transfer of data between systems. The analyst conducts a wide range of financial and operational analyses-including ROI assessments-to inform decision-making and ensure data accuracy across Medicaid and grant-funded programs. The role also maintains oversight of reporting requirements and funding match obligations while working closely with program, fiscal, and IT teams to strengthen processes and improve financial performance.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIES | To be effective, an individual must be able to perform each job duty successfully
Financial Data Management & Analysis

• Collect, organize, and analyze financial and operational data for public human services programs.
• Conduct ROI, cost-benefit, and trend analyses to support strategic and operational decisions.
• Prepare financial implication analyses for program changes, funding shifts, and policy decisions.
• Monitor and report on key financial performance indicators.

Medical Billing, Claims, and Coding Oversight

• Oversee medical billing and claims workflows for Medicaid and non-Medicaid programs.
• Support and guide the development of the medical billing platform, including requirements gathering, testing, and workflow design.
• Ensure completeness, accuracy, and compliance of claims and related billing data.
• Provide support for medical coding practices to maximize accuracy and reimbursement.

Regulatory, State, and Federal Reporting

• Prepare and submit routine and ad hoc state and federal financial reports.
• Validate accuracy of PRISM (state Medicaid) data submissions and reconcile discrepancies.
• Maintain thorough documentation to support audits, compliance reviews, and year-end financial reporting.

General Fiscal Operations & Compliance

• Perform general financial tasks including accounts receivable (A/R) and accounts payable (A/P).
• Track, monitor, and reconcile required funding match obligations across multiple programs.
• Support year-end financial processes, closeout activities, and audit preparation.
• Ensure adherence to internal controls, fiscal policies, and regulatory requirements.

Strategic Planning & Cross-Department Collaboration

• Provide financial modeling and forecasting to support strategic planning efforts.
• Collaborate with program managers, fiscal staff, and IT teams to improve data integrity and financial processes.
• Translate financial findings into clear, actionable recommendations for leadership.

QUALIFICATIONS | To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Thorough knowledge of... Considerable skill in... and Ability to...
Technical Skills

• Proficiency in Excel (advanced functions, pivot tables, data modeling).
• Experience with data analytics tools (Power BI, Tableau, or similar) preferred.
• Familiarity with medical coding, billing systems, or EHR/EHR-integrated billing platforms.
• Ability to work with large datasets and ensure data accuracy and integrity.
• Understanding of GAAP principles, general accounting processes (A/R, A/P), and financial reporting.

Analytical & Professional Skills

• Strong analytical and problem-solving abilities, including the ability to interpret complex data.
• Ability to conduct ROI analyses, forecasting, and cost modeling.
• Excellent written and verbal communication skills, with the ability to translate technical information into clear recommendations.
• Strong organizational skills, including the ability to manage multiple reporting deadlines.
• Ability to work collaboratively with fiscal, program, IT, and external stakeholders.

Additional Preferred Qualifications

• Experience participating in or supporting software development, system customization, or workflow design projects.
• Knowledge of state and federal reporting requirements for healthcare or behavioral health programs.
• Experience with grant, contract, or match-funding compliance a plus.

EDUCATION AND EXPERIENCE (or COMBINATION)

• Bachelor's degree with an emphasis finance, data analytics, accounting, health administration, or related field. Master's degree in a related field preferred.

AND

• Four to six (4-6) years of experience related to the above duties; general office practices; and progressive office management and administrative duties including bookkeeping, budgeting, technical writing, and strategic planning. An equivalent combination of education and experience.

SPECIAL QUALIFICATIONS

• Must possess a valid Utah driver's license with no DUI's/ARR's in the past five (5) years and no more than two (2) moving violations within the past 24 months.
• Certified Billing and Coding Specialist (CBCS) , or related certifications preferred.

WORK ENVIRONMENT | The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Work is performed in a controlled environment. The noise level in the work environment is usually quiet.
• Working conditions conform to the usual indoor office environment.
• Ability to occasionally travel.
• May make site visits with contractors or grant awardees

PHYSICAL REQUIREMENTS | The physical requirements described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Hand-eye coordination is necessary to operate computers and various pieces of office equipment; Required to frequently talk and hear; sit, use hands to fingers, handle, feel or operate objects, tools or controls; and reach with hands and arms. Hand dexterity is required for computer use.
• Required to stand or walk.
• Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust focus.
• Mental acuity is needed in decision making and stressful situations.
• The employee may be required to exert light physical effort, including frequent lifting of up to ten pounds and occasional lifting of up to 25 pounds.

STANDARD PERFORMANCE EXPECTATIONS

• Thoroughness, planning and organization, neatness and accuracy.
• Learning and knowing all phases of the job; recognizing and solving routine problems; knowing the office policies, systems and services.
• Compared to other employees, maintaining a competent volume of work in addition to regular tasks, and also a competent speed of work.
• Being able to perform new duties, adjust to new situations, and control of self under pressure.
• Being resourceful; volunteering suggestions for improvement of work; being self-starting; seeking new tasks; taking responsibility.
• Making decisions; studying and considering all facts; using common sense.
• Cooperating with supervisors and peers; accepting constructive criticism; seeking self-betterment through education and other means.
• Being friendly, helpful and showing self-control.
• Being punctual in attendance.
• Being professional in dress and manner; showing good housekeeping of the general work area.

**Tooele County is an equal opportunity employer and does not discriminate on the basis of race, color, national origin, sex, religion, age, disability, or any other protected class.**

Skills Required