What are the responsibilities and job description for the Senior Data Management Analyst position at Stony Brook University?
POSITION SUMMARY :
The Data Analyst is responsible for overseeing our data systems and reporting frameworks, guaranteeing the integrity and precision of data. The ideal candidate will transform raw data into structured information, which will then be analyzed to glean insights that drive strategic business decisions. This position encompasses a comprehensive analysis lifecycle, covering requirement and reporting functions, as well as supervising performance and quality assurance processes to pinpoint areas for enhancement. The Data Analyst will work with all departments to identify and develop necessary reports in these systems to assist with various hospital and departmental functions. This position will work in conjunction with partners across Stony Brook Medicine to ensure operational alignment and efficiencies.
RESPONSIBILITIES :
- Analyst responsible for maintaining and processing all data used for Reporting.
- Design, code and maintain SQL queries used within Cerner's Hosted platform for reporting.
- Run attribution algorithms, maintain and execute scripts used to generate reports.
- Design, code and operationalize reports as requested by the end-user for the purpose of quality, process monitoring or regulatory requirements. This data will be extracted from multiple source systems, normalized, and ultimately provided in the format requested by the business.
- Design and develop custom data marts using SQL server to be used as input for dashboards and reporting requirements.
- Assist in the creation and maintenance of the report catalog.
- Improve performance and accuracy of existing reports by optimizing existing SQL statements as necessary and establishing best practices.
- Author technical requirements and design specifications as needed.
- Communicate results of data analyses in a clear and effective manner to appropriate stakeholders.
- Test and validate all report outputs and visualization dashboards using various queries and tools.
- Work in a high-paced team environment with the ability to multitask when required based on project plan and business priorities.
EDUCATION / EXPERIENCE / REQUIREMENTS :
Working with SQL server and Oracle; able to write sound, efficient, and proper SQL statements ensuring stability, reliability, and performance of databases.
SKILLS :
Special Notes Bachelors : Resume / CV should be included with the online application.
Prior to start date, the selected candidate must meet the following requirements :
Failure to comply with any of the above requirements could result in a delayed start date and / or revocation of the employment offer.
Stony Brook Southampton 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.
Company Overview :
Stony Brook Southampton Hospital as part of the Stony Brook Medicine provides direct access to the highest level of academic-based medical care. Located in the heart of the village of Southampton, two hours from New York City, the hospital provides healthcare services to a diverse community of year-round residents, second homeowners and vacationers. The population, about 75,000 in the winter months, increases sharply to more than 300,000 in the summer. Stony Brook Southampton Hospital has been recognized as a Long Island Top Workplace by Newsday among large employers (defined as having 500 employees).
StaffCo is a Professional Employer Organization, commonly referred to as a PEO. StaffCo and SUNY have entered into a professional employer agreement under which StaffCo is the employer of Stony Brook Southampton employees and responsible for employment, including the day-to-day direction and supervision of work.StaffCo is fully responsible for providing all Payroll and Human Resource services, including the payment of wages, collecting and reporting payroll taxes and maintaining any and all benefits for which one is eligible. SUNY Stony Brook Hospital is responsible for the operation of the hospital and provision of health care and is the co-employer as is necessary to conduct its responsibilities and for related licensure, regulatory or statutory requirements and obligations.
Given StaffCo’s employment responsibilities, it is deemed the “employer” for employment and labor law purposes. Thus, the employees are private sector employees of StaffCo, not public sector employees of SUNY. The private sector nature of the StaffCo employees has been approved by NYS Civil Service and upheld in a decision by the US National Labor Relations Board.
