Position Summary: We have an exciting opportunity to join our team as a Sr. Data Analyst.
In this role, the successful candidate The Senior Data Services Analyst develops, maintains, and supports the daily programming and reporting requirements of the Office of Development and Alumni Affairs. In collaboration with the entire Data Services Team this individual also defines and analyzes data requirements in support of business processes and reporting deliverables
Maintain proficiency in the most current content and structural use of the Development Offices donor database system, Advance.
Execute the specifications for standard and custom donor reporting in the Department. Maintain existing and write/program new reports in SQL for general and specific Departmental use and retrieval through Crystal Server or SSRS.
Ability to create and modify new and existing Crystal Reports (SAP 2013).
Utilizing SQL to assist in the development of data reporting in order to perform complex queries and data mining as required by the Office of Development.
Assists in the management of SSRS functions.
Design and develop SQL Server stored procedures, functions and views to be used during the ETL Process.
Designs, develops, and maintains various user-friendly dashboards in Tableau server using various reproducible data sources, stored procedures, view, calculations, and parameters.
Translates and refines departmental reporting requests into actionable objectives, including identifying criteria, fields, grouping, summary options, time frames and other components required to build a successful report/Viz in Tableau.
Uses Tableau to measure performance of business rules and models, interprets results, and makes recommendations based on analytic findings to business areas.
Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
Manages the maintenance of existing Development reporting infrastructure including all objects and support scripts.
Manages the augmentation / clean up of existing data sources and ensure constituent data is current and enhanced to ensure the most effective use of all the information available.
Defines and manages the definition and development of data models which consist of entity types, attributes, relationships, integrity rules, and the definitions of those objects.
Defines and manages the design and development of the structure of data reporting tools to provide consistency of data across systems and to ensure that compatibility and access to data through different applications can be achieved.
Manages the development of integrated data streams and datasets from one platform to another. Assist in the on-going efforts to develop data dashboards pushing real time data for the Development Office.
Ability to troubleshoot SSIS packages and daily job scripts.
Qualified candidates must be able to effectively communicate with all levels of the organization.
NYU Langone Health provides its staff with far more than just a place to work. Rather, we are an institution you can be proud of, an institution where you'll feel good about devoting your time and your talents.
NYU Langone Health is an equal opportunity and affirmative action employer committed to diversity and inclusion in all aspects of recruiting and employment. All qualified individuals are encouraged to apply and will receive consideration without regard to race, color, gender, gender identity or expression, sex, sexual orientation, transgender status, gender dysphoria, national origin, age, religion, disability, military and veteran status, marital or parental status, citizenship status, genetic information or any other factor which cannot lawfully be used as a basis for an employment decision. We require applications to be completed online. If you wish to view NYU Langone Health's EEO policies, please click here. Please click here to view the Federal 'EEO is the law' poster or visit https://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm for more information. To view the Pay Transparency Notice, please click here.
Please See Above
Internal Number: 61634820
About NYU Langone Health
NYU Langone Health, a world-class patient-centered integrated academic medical center, is one of the nation's premier centers for excellence in clinical care, biomedical research, and medical education. Located in the heart of Manhattan, NYU Langone is composed of four hospitals – Tisch Hospital, its flagship acute care facility; Rusk Rehabilitation; the Hospital for Joint Diseases, one of only five hospitals in the nation dedicated to orthopaedics and rheumatology; and Hassenfeld Children's Hospital, a comprehensive pediatric hospital supporting a full array of children's health services across the medical center – plus the NYU School of Medicine, which since 1841 has trained thousands of physicians and scientists who have helped to shape the course of medical history. The medical center's tri-fold mission to serve, teach, and discover is achieved 365 days a year through the seamless integration of a culture devoted to excellence in patient care, education and research. For more information, go to www.nyulangone.org.