"Alerted.org

Title: Institutional Data Analyst

Org Unit: Institutional Reporting

Work Days:

Weekly Hours: 35.00

Exemption Status: Exempt

Salary Range: $79,500.00 - $89,350.00

*As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices

Position Summary

This role sits at the nexus of the tripartite mission of Weill Cornell Medicine – Care (Clinical Medicine), Discover (Research), Teach (Medical Education). The Office of Institutional Reporting supports the strategic mission of Weill Cornell Medicine by providing key stakeholders with valuable information, interpreting a high volume and variety of institutional data. The Institutional Data Analyst should be comfortable with balancing technical and business requirements. Doing so requires a diverse technical skillset including data engineering, data modeling, analysis, and visualization as well as critical reasoning in providing valuable insights to key stakeholders.

Job Responsibilities

+ Interprets business context related to a variety of Institutional subject matter including research, clinical practice, and education.

+ Understands a multitude of data sources used in reporting across institutional subject matter, with the ability to communicate the impact of upstream to downstream data transformations on reporting within the team and organizationally.

+ Cleanses and transforms data to align to Institutional data model, maintaining existing reporting workflows and proposing process improvements where necessary.

+ Remains diligent in maintaining consistency in reporting across systems and within reporting by performing quality control testing. Clearly communicates results from these processes to team as well as end stakeholders.

+ Creates and updates visualizations to support institutional and departmental strategic decision making.

+ Performs ad hoc analyses employing a variety of analytical techniques, to provide valuable insight to key stakeholders.

+ Supports Information Governance Initiative by analyzing data sources, coordinating meetings (materials and minutes included) for various workgroups/committees, preparing/maintaining institutional data dictionary and maintaining/updating policies.

+ Researches and proposes best practices to senior management and provides updates to institutional constituents. Maintains and updates department’s website.

+ Responsible for the collection, review and submission of various surveys, including surveys to USNWR, IPEDS, LCME and AAMC.

+ Performs other related duties as directed.

Education

+ Bachelor's Degree

Experience

Bachelor’s degree in math, statistics, computer science or related technical field.

Approximately 3-5 years experience as a Data Analyst with some experience in each of the below areas.

Programming using python for data cleansing, data analysis, and data visualization including the use of Pandas.

Accessing, cleansing and performing analysis on data from one or more of the following sources: transactional tables, OLAP data models, BI data marts, SQL based data warehouses, semi-structured/unstructured data environments.

Outlining objectives, forming hypotheses, and carrying out analysis to drive measurable business impact.

Use of MS Excel v-lookups, pivot tables, and conditional statements.

Utilizing of visualization software including Power BI, Powerpoint, and Tableau.

Knowledge, Skills and Abilities

+ Self-starter and rapid learner, with the ability to work individually and in teams.

+ Ability to prioritize multiple requests, manage expectations and meet deadlines.

+ Proven technical background with experience using Python, SQL, Excel and visualization tools.

+ Strong critical thinking skills with the ability to break a problem down into constituent components, and solve in a structured manner.

+ Excellent communication skills (both verbal and written).

Licenses and Certifications

Working Conditions/Physical Demands

Cornell welcomes students, faculty, and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities, to further the founding principle of “any person, any study.” No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving, but not limited to, such factors as race, ethnic or national origin, citizenship and immigration status, color, sex, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual’s genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Cornell University embraces diversity in its workforce and seeks job candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We hire based on merit, and encourage people from historically underrepresented and/or marginalized identities to apply. Consistent with federal law, Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRRA) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.