Lead Programmer Analyst - Enterprise Analytics - Stony Brook University : Job Details

Job DescriptionPosition SummaryStony 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 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.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 clinical and administrative leadership in making strategic data-driven decisions by finding actionable insights to drive change across Stony Brook Medicine's reporting enterprise.Duties of a Lead Programmer Analyst – 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 various clinical and administrative departments 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 the development and maintenance of the Enterprise Analytics report catalog, data dictionaries, and data marts.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 reports, data marts, and dashboards that are used throughout the Stony Brook Medicine Health System.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.QualificationsRequired:Bachelor's Degree in Computer Science, Computer Engineering, Mathematics, Statistics, or other related applied science field. In lieu of the above, an Associate's degree or higher with at least five years' experience as stated herein.3 to 5+ 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.Experience extracting data to produce reports and files.Experience creating reports via Crystal Reporting or similar report writing tools.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.Experience with Tableau or other statistical visualization software.Experience with supporting production systems used for data analytics or statistical data modeling.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 usage of joins to aggregate data sets between multiple tables.Experience with optimizing large complicated SQL statements using indexes and knowledge of best practices.Experience with statistical data analytics, visualization, and/or 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 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)###-####.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 $71,798 - $87,520 / 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 ($3,400).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.Job Number: 2404290Official Job Title: Lead Programmer/AnalystJob Field: Information TechnologyPrimary Location: US-NY-St. JamesDepartment/Hiring Area: Enterprise Analytics and Population HealthSchedule: Full-timeShift: Day ShiftShift Hours: 8:30am to 5pmPass Days: Sat, SunPosting Start Date: Posting End Date: Feb 12, 2025, 8:59:00 PMSalary Grade: SL3#J-18808-Ljbffr