Sr Decision Support Analyst

San Juan Regional Medical Center; Town of Farmington (WI); On-site; USD 110,000 - 150,000; Full time

Job summary

San Juan Regional Medical Center is seeking a Senior Decision Support Analyst to partner with executive leadership, delivering advanced financial, operational, and clinical analytics to support data-driven decisions. This role oversees cost accounting, service line analytics, budgeting support, and data governance while supervising junior analysts.

Required qualifications include a bachelor’s degree and strong analytics; preferred experience with healthcare data, SQL, and data visualization

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.
• Data mining
• 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

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

Job description

Creating Life Better Here starts with you. At San Juan Regional Medical Center, we’re more than a healthcare provider—we’re a values-driven organization dedicated to delivering exceptional care. As a team member, you help fulfill our mission to make life better here for our community.

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.
• Data mining
• 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