Senior Financial Analyst - Strategic Analytics

Position Summary

At Stony Brook Medicine, our Sr. Financial Analyst is a valuable member of our Strategic Analytics team. 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 also 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 basis. They will modify revenue rules within DSS, audit results and reconcile results to source data. They will participate in testing any system upgrades or changes to the data extract interfaces. This position works closely with others in Finance and IT.

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

• Responsible for the design, development and timely dissemination of complex reports and dashboards that align with the business needs of our end users.
• Executes and validates data integrations and results yielded, on a recurring basis.
• Executes integration processes and addresses errors in a timely and efficient manner.

o Performs 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 Participate in data validation during system upgrades and changes to the data extract 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, make appropriate modifications to revenue rules as well as updates values in the 3M grouper modules in Syntellis to ensure estimated revenue is accurately calculated by the system.

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 and the billing system.

• Performs other duties as assigned.

Qualifications

Required:

• Bachelor's degree or higher in Accounting, Business, Finance, or related field.
• At least 4 years progressive related analytical experience.
• Advanced proficiency in using Microsoft Office Suite, including Excel and Access.
• Experience with SQL.
• Experience in Business Intelligence/Visualization tools (Tableau, Power BI, etc.)
• Strong analytical skills with the ability to collect, organize, synthesize, and disseminate significant amounts of data with consistent attention to detail and accuracy.
• Understanding of database relationships and structures.
• Strong interpersonal and communication skills to effectively interact with employees throughout the organization.

Preferred:

• Knowledge of hospital financial analysis and cost accounting.
• Experience with accounting concepts, analytics, service line profitability.
• Experience with interfacing and integration of data feeds from source systems to hospital Decision Support/Cost Accounting Systems.
• Experience utilizing hospital Decision Support Systems.
• Understanding of hospital coding, billing, and reimbursement.
• Experience in the use of SSIS packages.

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 maybe 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.

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

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.