Lead Programmer Analyst - Cancer Center Enterprise Analytics

at  Stony Brook University Hospital

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.

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.

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