Position Summary

Stony Brook Medicine is seeking a highly skilled Lead Programmer Analyst to join Stony Brook Medicine's Enterprise Analytics team, reporting to the Assistant Director of Enterprise Analytics. The candidate will focus on providing reports and data analytics to the clinical and administrative leadership from the Stony Brook Cancer Center located in the Medical Research and Translation (MART) building. The Medical and Research Translation (MART) building is a transformative model for cancer research and treatment, providing an ideal environment for researchers and doctors to collaborate, investigate and innovate in developing breakthrough cancer medicines, treatments and cures.

As a Lead Programmer Analyst, the candidate will become a key member of a multi-disciplinary project team operating within a fast-paced environment acquiring data from multiple sources, assisting team members with data modeling, extraction, translation and load patterns that will be primarily be used to support our Stony Brook Cancer Center. The candidate will also work closely with team members to define and execute best practice processes and procedures to validate reports sourced from the various applications used across the Stony Brook Medicine Health system. The candidate must have strong analytical skills with the ability to support and interface with all levels of management. Qualified candidates will demonstrate outstanding communication skills while adhering to our high standard of excellence.

Duties of a Lead Programmer Analyst - Cancer Center Enterprise Analytics may include the following but are not limited to:

• Extract data from multiple source systems and produce reports in the format requested by the Stony Brook Medicine community for the purposes of patient care, process monitoring or regulatory requirements.
• Work closely with the Cancer Center leadership team to review project requirements, develop data marts, reports and dashboards as needed.
• Help improve performance and accuracy of existing reports by optimizing existing SQL queries as necessary using best practice techniques.
• Assist team in maintenance of our existing report catalog, with the Cancer Center being the main area of focus.
• Assist the Enterprise Analytics team with technical projects, integrating data sourced from disparate clinical and administrative applications.
• Design, code and operationalize end to end database models and schemas that will be used to develop custom data marts, dashboards and reports used across the enterprise.
• Create dashboards and visualizations of data as requested by project stakeholders to satisfy key Stony Brook Medicine initiatives.
• Author technical requirements documents and design specifications as needed for usage by internal and external team members.
• Document and communicate results of data analyses in a clear and effective manner to appropriate stakeholders.
• Assess database implementation policies and procedures to ensure compliance with internal and external regulations.
• Improve performance and accuracy of existing Cancer Center reports, data marts and dashboards.
• Provide technical support across the various production systems used by the Enterprise Analytics team.
• Work as a core member of the Enterprise Analytics team with the ability to multitask when required based on project plan and business priorities.

Qualifications

Required:

• Bachelor's Degree in Computer Science, Computer Engineering, Mathematics, Statistics, or other related applied science field.
• In lieu of the above, Associates degree or higher with at least five years' experience as stated herein.
• Three (3) to Five (5)+ years' experience in data mining, data acquisition, transformation, cleansing and validation of both structured and unstructured data from disparate data sources.
• Minimum of three (3) years professional experience in a similar role as a Data Reporting Analyst within a fast paced data driven environment.
• Experience creating reports via Crystal Reporting or similar report writing tools.
• Experience extracting data to produce reports and files.
• Proficient working knowledge of Relational Databases and Structured Query Language.
• Experience with SQL server and or Oracle with the ability to write sound, efficient, and proper SQL statements ensuring stability, reliability, and performance of databases.
• Detail oriented, customer focused and strong organizational skills with excellent verbal and written communication skills.
• Strong skills with the MS Office Product suite.

Preferred:

• Experience with database schema design, modeling and designing database tables that facilitate efficient information retrieval.
• Experience with stored procedures and able to query complex datasets and derive conclusions, including using all types of joins between multiple tables.
• Experience with optimizing large complicated SQL statements using indexes and knowledge of best practices.
• Experience with Tableau or other data statistical, visualization, and predictive modeling software.
• Experience with the Cerner or other Electronic Medical Record applications performing Electronic Health Record review, abstraction and analysis.

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.

Visit our 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 has been established as - $70390 - $80856.

The above salary range (or hiring range) represents SBUH's good faith and reasonable estimate of the range of possible compensation at the time of posting.

In addition, all UUP positions have an additional $3,087

Some positions offer shift differentials for Night ($3,700) & Evening ($2,500) as well as $575 for positions not on day shift. Please visit these links to learn more.

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.