Sr. Decision Support Analyst

San Juan Regional Medical Center; Farmington (NM); On-site; USD 95,000 - 125,000; Full time

Job summary

San Juan Regional Medical Center seeks a Senior Decision Support Analyst to serve as a strategic partner to executive leadership by delivering advanced financial, operational, and clinical analytics. The role oversees cost accounting, service line analytics, budgeting support, and data governance while mentoring junior analysts.

The ideal candidate will have a strong foundation in statistics, finance, and healthcare data, with expertise in Excel, data visualization, and relevant systems

Qualifications

• Bachelor’s degree required in Finance, Mathematics, Statistics, Computer Science, or a related field; equivalent combination of education and relevant work experience may be considered in lieu of a degree.
• Demonstrated knowledge of statistical analysis and modeling techniques, with the ability to apply these methods to financial and operational healthcare data.
• Advanced analytical skills, ability to interpret and explain complex analyses; proficiency with financial/analytical systems; strong interpersonal and communication skills; advanced Excel and data tools.

Responsibilities

• Budgeting, Forecasting & Financial Planning: coordinate annual operating budget, volume, revenue, expense and FTE planning.
• Prepare monthly forecasts and long-term financial projections.
• Develop revenue models and IBNR analyses across service lines or product lines.
• Build financial models to evaluate government regulations, reimbursement changes, and market conditions on profitability.

Skills

Statistical analysis

Advanced Excel

Data visualization

Autonomous work

Communication skills

Education

Bachelor’s degree in Finance/Math/Statistics/CS

Tools

SQL

Workday

Cerner

StrataJazz

Job description

The Senior Decision Support Analyst serves as a strategic partner to executive leadership, providing advanced financial, operational, and clinical analytics to support data-driven decision-making. This role is responsible for overseeing decision support functions including cost accounting, service line analytics, budgeting support, and data governance, while supervising and developing junior analysts.

Required Behaviors:

• As you go about fulfilling this mission, your work habits and work relationships should embody SJRMC's values. These values are our culture, our identity as an organization. Sacred Trust, Personal Reverence, Thoughtful Anticipation, Team Accountability and Creative Vitality ask more of us than merely completing some list of tasks. Our values ask for a deeper level of commitment, and what is asked of us we freely give because we believe in our mission.

Required Qualifications:

• Bachelor’s degree required in Finance, Mathematics, Statistics, Computer Science, or a related field; equivalent combination of education and relevant work experience may be considered in lieu of a degree
• Demonstrated knowledge of statistical analysis and modeling techniques, with the ability to apply these methods to financial and operational healthcare data
• Advanced analytical skills, proven ability to interpret and explain complicated statistical analysis; proficiency working with complex information management, financial, and analytical systems; Advanced interpersonal and communication skills, Microsoft Office skills (verbal and written)
• Advanced Excel skills, such as data simulation, power pivot, power query, complex data analyses, advanced formulas, charts and graphs, advanced charting, data validation, etc.
• Knowledge of any data visualization tool
• Ability to work autonomously
• Demonstration of critical thinking.
• Validate reports/analyses to ensure accuracy via comparison to internal and external benchmarks
• Thorough knowledge of accounting policies, procedures, controls, and system

Preferred Qualifications:

• SQL knowledge and utilization to create ad-hoc queries against databases
• Knowledge of hospital decision support and EMR systems, StrataJazz Decision , Workday and Cerner preferred
• Understanding of healthcare coding systems (e.g., ICD-10-CM/PCS, UB-04, HCPCS, MS DRG, CPT, etc.)
• Familiarity with commercial HMO/PPO, Medicare, and Medicaid reimbursement mechanisms for hospitals and physicians
• Experience with hospital Medicare cost report preparation

Duties and Responsibilities:

• Budgeting, Forecasting & Financial Planning:
• Directly support leadership in the coordination of the annual operating budget, including volume, revenue, expense, and FTE planning
• Prepare monthly forecasts and long-term financial projections
• Develop revenue models and IBNR analyses across service lines or product lines
• Build financial models to evaluate the impact of government regulations, reimbursement changes, and market conditions on profitability

Strategic Financial Analysis & Proformas:

• Develop financial proformas to evaluate new service lines, capital investments, and cost-saving initiatives
• Support organizational decision-making through ROI analysis and financial feasibility studies
• Assist in establishing and tracking key performance indicators (KPIs) across departments Departmental Support & Performance Analysis:
• Provide ongoing analytic and consultative support to operational and clinical departments
• Partner with leadership to evaluate productivity, workforce planning, and operational efficiency
• Develop and deliver productivity reporting and follow-up analysis
• Support benchmarking initiatives across departments and service lines

Variance Analysis, Reporting & Dashboards:

• Prepare variance analysis (budget vs. actual, volume, rate, mix, labor, expense drivers)
• Develop and maintain financial and statistical dashboards to monitor performance at the department and service line level
• Present findings through clear written reports and executive-level presentations

Decision Support & Cost Accounting:

• Maintain responsibility for costing processes, reporting, and analysis, ensuring alignment with financial statements
• Prepare costing summaries and audit reports; serve as a backup for costing processes when needed
• Recommend and implement enhancements to cost accounting methodologies and techniques
• Analyze patient-level and financial data, identifying and resolving discrepancies with source systems

Month-End Close & Financial Reporting:

• Participate in the month-end close process, including validation of financial results and preparation of supporting analyses
• Partner with Accounting to ensure accurate financial reporting and reconciliation across systems

Systems, Data Governance & Process Improvement:

• Support and enhance decision support systems, ensuring data quality, integrity, and consistency
• Assist in maintaining and optimizing budgeting and planning systems
• Identify opportunities to automate processes and reduce manual effort using advanced analytics tools
• Lead or support system enhancements and integrations (e.g., Workday, Cerner, Strata)

Regulatory Reporting & Compliance:

• Prepare and submit required regulatory reports (local, state, federal)
• Prepare Medicare and Medicaid cost reports in compliance with applicable regulations
• Respond to and manage third-party audit requests and correspondence