Sr Decision Support Analyst

sjrmc; United States; On-site; USD 90,000 - 130,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 drive data‑driven decisions. You will oversee cost accounting, service line analytics, budgeting support, data governance, and mentor junior analysts, promoting accuracy and actionable insights across the organization.

This role requires strong Excel and SQL skills, knowledge of healthcare data systems, and the

Qualifications

• Bachelor's degree required in Finance, Mathematics, Statistics, Computer Science, or related field; equivalent combination may be considered
• Demonstrated knowledge of statistical analysis and modeling techniques for financial/operational healthcare data
• Advanced analytical skills with ability to interpret and explain complex analyses; proficient with MS Office and analytics systems
• Advanced Excel skills: data simulation, power pivot, power query, complex analyses, charts/graphs
• Data mining
• Knowledge of data visualization tools
• Ability to work autonomously
• Demonstration of critical thinking
• Validate reports/analyses against benchmarks
• Thorough knowledge of accounting policies, controls, and systems

Responsibilities

• Budgeting, forecasting & financial planning: support annual budget coordination, monthly forecasts, and long-term projections
• Strategic financial analysis & proformas: develop pro formas for new service lines and ROI analyses
• Departmental support & performance analysis: provide analytic support to departments and evaluate productivity
• Variance analysis, reporting & dashboards: prepare variance analyses and maintain dashboards
• Decision support & cost accounting: costing processes, reporting, and enhancements to methods
• Month-end close & financial reporting: assist in month-end close and reconciliation

Skills

Statistical analysis

Advanced Excel

Data mining

Data visualization

SQL

Budgeting

Communication

Autonomy

Critical thinking

Report validation

Education

Bachelor's degree in Finance/Math/Stats/CS

Tools

SQL

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 acros