Senior Financial Analyst - Strategic Analytics

Position Summary

At Stony Brook Medicine, our Sr. Financial Analyst is a valuable member of our Strategic Analytics team.

Candidates should possess both technical and analytical skills and demonstrate an ability to analyze and summarize data. The Sr. Financial Analyst is primarily responsible for the creation, modification, formatting, and distribution of complex reports utilizing our DSS report writer, Tableau or other Business Intelligence tools. They will maintain functionality within the Syntellis (formerly McKesson) Performance Analytics Decision Support System (DSS). They will execute and validate data integrations, and the results yielded, on a recurring, regular basis. They will modify revenue rules within DSS, audit results and reconcile results to source data. They will participate in testing system upgrades or changes to the interfaces used for data extraction. This position works closely with others in Finance and IT.

Duties of a Sr. Financial Analyst in the Strategic Analytics department may include the following but are not limited to:

* Responsible for the design, development and timely dissemination of complex, high quality, actionable reports to hospital leadership, and other end users, as per their needs. This includes aggregating, analyzing and displaying data in formats such as dashboards, scorecards, visualizations, and other reports, automating these functions wherever possible.

* Executes and validates data integrations and results yielded, on a recurring basis.

o Executes integration processes and addresses errors in a timely and efficient manner.

o Perform audits of data elements from hospital billing and other sources

o Under the direction of the manager, works with others in finance, HIM, IT, etc. to request corrections, when necessary, of source data

o Participates in data validation during system upgrades, and in changes to the data extraction interfaces.

* Maintains and validates data integrity in our Decision Support System

o Creates, maintains, and monitors dashboards (Syntellis, Tableau, Excel) used for weekly and monthly audits and investigates any variances.

o Under the direction of the manager, makes appropriate modifications to revenue rules, as well as updates values in the 3M grouper and reimbursement schedules in Syntellis, so as to ensure estimated revenues are accurately calculated.

o Creates and maintains reports and dashboards in support of revenue calculations and field audits.

o With the manager and other Sr. Analysts, reconciles final data to source systems including the GL, Payroll and the billing system.

* Perform other duties as needed or assigned.

Qualifications

Required Qualifications:

* Bachelor's degree or higher in Accounting, Business, Finance, or related field.

* Minimum 4 years of progressive relevant experience in data management, analysis, and/or quantitative report development and production.

* Proficiency with visualization software (Tableau, MS Power BI, etc.).

* Advanced proficiency in using Microsoft Office Suite, including Excel and Access.

* Strong analytical skills with demonstrated ability to collect, organize, synthesize, and disseminate significant amounts of data with consistent accuracy and attention to detail.

* Understanding of and proficiency with the use of data relationships, logical structures, data hierarchy, in reporting queries.

* Strong interpersonal and communication skills to effectively interact with employees throughout the organization.

Preferred Qualifications:

* Knowledge of hospital financial analysis and cost accounting.

* Experience with accounting concepts, analytics, service line profitability.

* Experience with interfacing and integrating data feeds from different source systems to a hospital Decision Support/Cost Accounting Systems.

* Experience with utilizing hospital Decision Support Systems.

* Understanding of hospital coding, billing, and reimbursement.

* Experience with SQL

* Understanding of SSIS packages, and ability to troubleshoot and make changes.

Special Notes: Resume/CV should be included with the online application.

Posting Overview: This position will remain posted until filled or for a maximum of 90 days. An initial review of all applicants will occur two weeks from the posting date. Candidates are advised on the application that for full consideration, applications must be received before the initial review date (which is within two weeks of the posting date).

If within the initial review no candidate was selected to fill the position posted, additional applications will be considered for the posted position; however, the posting will close once a finalist is identified, and at minimal, two weeks after the initial posting date. Please note, that if no candidate were identified and hired within 90 days from initial posting, the posting would close for review, and possibly reposted at a later date.

______________________________________________________________________________________________________________________________________

• Stony Brook Medicine is a smoke free environment. Smoking is strictly prohibited anywhere on campus, including parking lots and outdoor areas on the premises.
• All Hospital positions may be subject to changes in pass days and shifts as necessary.
• This position may require the wearing of respiratory protection, which may prohibit the wearing of facial hair.
• This function/position may be designated as "essential." This means that when the Hospital is faced with an institutional emergency, employees in such positions may be required to remain at their work location or to report to work to protect, recover, and continue operations at Stony Brook Medicine, Stony Brook University Hospital and related facilities.

Prior to start date, the selected candidate must meet the following requirements:

• Successfully complete pre-employment physical examination and obtain medical clearance from Stony Brook Medicine's Employee Health Services*
• Complete electronic reference check with a minimum of three (3) professional references.
• Successfully complete a 4 panel drug screen*
• Meet Regulatory Requirements for pre-employment screenings.
• Provide a copy of any required New York State license(s)/certificate(s).

Failure to comply with any of the above requirements could result in a delayed start date and/or revocation of the employment offer.

*The hiring department will be responsible for any fee incurred for examination.

_____________________________________________________________________________________________________________________________________

Stony Brook University is committed to excellence in diversity and the creation of an inclusive learning, and working environment. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, familial status, sexual orientation, gender identity or expression, age, disability, genetic information, veteran status and all other protected classes under federal or state laws.

If you need a disability-related accommodation, please call the University Office of Equity and Access at (631)632-6280.

In accordance with the Title II Crime Awareness and Security Act a copy of our crime statistics can be viewed here.

Stony Brook University Hospital, consistent with our shared core values and our intent to achieve excellence, remains dedicated to supporting healthier and more resilient communities, both locally and globally.

Anticipated Pay Range:

The starting salary range (or hiring range) for this position is - $102000 - $117300 / year.

The above salary range represents SBUH's good faith and reasonable estimate of the range of possible compensation at the time of posting. The specific salary offer will be based on the candidate's validated years of comparable experience. Any efforts to inflate or misrepresent experience are grounds for disqualification from the application process or termination of employment if hired.

Some positions offer annual supplemental pay such as:

* Location pay for UUP, CSEA & PEF full-time positions ($3400)

Your total compensation goes beyond the number in your paycheck. SBUH provides generous leave, health plans, and state pension that add to your bottom line.

Visit our WHY WORK HERE page to learn about the total rewards we offer.