Financial Decision Support Analyst

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 Decision Support Analyst will provide overall support in accurately preparing and assembling financial & statistical data required for internal use as well as third-party and governmental agencies. Prepares cost studies or reimbursement analysis. Assist with operating & capital budget development. Creates reports as needed using multiple systems. 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 in Finance, Economics. Mathematics, Healthcare Administration, Computer Science, or related field. It can be supplemented or substituted by relevant work experience.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 miningKnowledge of any data visualization toolAbility to work autonomouslyDemonstration of critical thinking.Validate reports/analyses to ensure accuracy via comparison to internal and external benchmarksThorough knowledge of accounting policies, procedures, controls, and systems Preferred Qualifications:SQL knowledge and utilization to create ad-hoc queries against databasesKnowledge of hospital decision support and EMR systems, StrataJazz, Workday and Cerner preferredUnderstanding 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 physiciansExperience with hospital Medicare cost report preparationDuties and Responsibilities:Directly support management with coordination of annual operating budget and preparation of monthly forecast and long-term financial projections.Prepares revenue models and IBNR analysis for all product lines.Creates financial models to evaluate the financial impact of government regulations and market conditions on the overall profitability of each line of business.Supports the organization in the development of financial proformas to evaluate cost-saving initiatives and/or financial feasibility when adding new lines of business.Assists in the collection and establishment of KPIs for all the areas in the organization to facilitate financial and operational analysis.Assists in the preparation of variance analysis and financial and statistical dashboards to illustrate gross margin financial performance and budget to actual analysis for each admin unit in the organization.Takes an active role in the development of analytical methodologies to evaluate workforce planning approach in all areas of the organization, provider contracting & utilization, performance by type of service & risk group, and benchmarking across the organization.Assists in the maintenance and support of the budget software system. Identify opportunities to automate current systems by using software planning tools and lead the implementation of projects that will minimize manual processes and allow a higher level of efficiency and accuracy when preparing financial models.Prepares all costing and reporting summaries and analyses. Understands the costing structure and processes necessary to create costing. If necessary, it serves as a substitute for the costing process and frequently prepares reports to audit costing activity.Prepares and files all necessary required reporting with all regulatory agencies, including local, state, or federal.Performs the ongoing maintenance & improvement of decision support systems, including data quality, integrity, and enhancement; Makes recommendations for new cost accounting methodologies and techniques.Prepare cost reimbursement reports for Medicare and Medicaid to obtain reimbursement in full compliance with federal and state regulations and organizational policies and procedures. Follows up with governmental third party correspondence and audit requests.Prepares periodic productivity reporting and follow-up.Maintains confidentiality of all information handled.Reviews patient level and financial data and remediates any discrepancy with source systems.Design and implement system structures to support costing and patient data teams.Participates in system enhancements.Provide analytic and consultative support to a broad spectrum of internal customer areas and external business partners.Develop and foster internal relationships across the corporation.Mentor colleagues with less experience in both the technical and business aspects of project and consultative work.Provide assistance and, depending on skill and experience, lead with the interpretation of raw data, statistical results, or otherwise compiled information, identify follow-up action items, and prepare or assist in the preparation of written reports and/or oral presentation of findings to internal and external audiences, customer managers, clinical staff, compliance agencies, group accounts, providers, agent plans, and brokers. Each employee is responsible for implementing SJRMC's Service Standards into their daily work: Safety, Courtesy, Effectiveness, and Stewardship Other duties as assigned.Physical Demands and Environmental Work Conditions:The majority of work is performed in a sitting positionNear visual acuity is needed to read and post figuresWork is in a well-lit, temperature-controlled office areaSits, stands, bends, lifts, and moves intermittently throughout the dayWork may involve some stooping and bending for filing purposes (e.g., once a year files are emptied into storage boxes) A portion of job duties involve the application of manual skills requiring motor coordination in combination with finger dexterity (e.g., typing on a computer keyboard, using a 10-key calculator, etc.)