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.  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 used throughout the reporting enterprise.  The candidate will also work closely with team members to define and execute best practice processes and procedures used 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 throughout the hospital.  Qualified candidates will demonstrate superior patient care and possess outstanding communication skills while adhering to our high standard of excellence.

As a Lead Programmer Analyst the candidate will bring a balance of creative problem solving, hands-on data analytics and practical software integration skills.  The candidate will support leadership in making strategic data-related decisions by analyzing data, finding actionable insights to drive change across the hospital's reporting enterprise.

Duties of Lead Programmer Analyst in the Enterprise Analytics Department may include but are not limited to the following: 

• Clinical and Patient reporting producing data and reports as requested by the hospital community for the purpose of patient care, process monitoring or regulatory requirements.  This data will be extracted from multiple source systems and will be provided in the format requested.
• Help improve performance and accuracy of existing reports by optimizing existing SQL queries as necessary and establishing best practice techniques.
• Assist team in maintenance of existing report catalog.
• 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 hospital initiatives.
• Author technical requirements 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 reports.
• Work in a high paced team environment with the ability to multitask when required based on project plan and business priorities.
• Provide technical support to production systems as needed.

• Bachelor's Degree in Computer Science, Computer Engineering, Mathematics, Statistics, or other related applied science field.
• 3+ years' experience in data mining, data acquisition, transformation, cleansing and validation of both structured and unstructured data from disparate data sources.
  • Minimum of 3 years professional experience in a similar role as a Data Reporting Analyst within a fast paced data driven environment.
• Extensive experience creating reports in Crystal Report or similar report writing tool.
• Experience extracting data to produce reports and files.
• 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.

• 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 electronic health record review, abstraction and analysis.
• Experience with the Cerner or other Electronic Medical Record applications.

Special Notes:  Resume/CV and cover letter 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 maybe 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 5 panel drug screen*
• Successfully complete a Background Check investigation.
• 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.