Investigation and Data Reporting Analyst

Title: Investigation and Data Reporting Analyst

Location: Midtown

Org Unit: The Office of Compliance

Work Days:

Weekly Hours: 35.00

Exemption Status: Exempt

Salary Range: $96,500.00 - $108,900.00

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

Position Summary

Supports the Office of Compliance (OOC) investigation functions by assuming responsibility for supporting the day-to-day usage of database systems integral to the OOC operations and preparing various management reports through data consolidation and data analysis on a weekly, monthly, quarterly, and annual basis for and on behalf of the OOC.

This role will support the data needs to conduct Compliance and Privacy investigations. This role has primary responsibility for administration of Weill Cornell Medicine’s (WCM) use of the Splunk database to monitor access and use of the electronic medical record.

In addition, this role serves as a cross-functional resource to support continuity of operations by providing back-up support to the Compliance Investigation Manager and Data and Reporting Analyst functions during periods of absence, surge capacity, and operational need.

Job Responsibilities

• Supports compliance investigations by tracking cases, reviewing documentation, coordinating interviews, maintaining evidence records, and managing investigation files and timelines.

• Assist in case monitoring to ensure timely completion, escalation and reporting deadlines.

• Provides backup support for reporting activities, including creating reports, updating dashboards, validating data, and maintaining reporting tools.

• Coordinates across Compliance, Privacy, IT, and other stakeholders to ensure seamless data flow and issue resolution during coverage periods.

• Assists in identifying process gaps and recommending workflow improvements to strengthen investigation and reporting continuity.

• Creates and runs system queries for investigation related data requests and weekly, monthly and annual metrics from various internal database systems and other systems such as Splunk, CaseIQ, MDaudit and RADAR.

• Compiles data for routine and ad hoc reports and prepares meeting materials and presentations using information from internal systems.

• Prepare summary findings of investigations for various stakeholders, including clinical departments, HR, Faculty Affairs, Legal and various oversight committees.

• Assists OOC by synthesizing large or disparate data sets and is able to communicate or relay information in a meaningful way.

• Maintains a centralized repository of reports and materials and is responsible for database management, data analysis, and reporting.

• Provides operational administrative support to OOC leadership, including coordination of investigation and reporting workflows to ensure continuity of operations.

Education

• Bachelor’s Degree required in Healthcare related field

Experience

• Approximately 3-5 years’ experience in healthcare preferred.

• 2-3 years of experience in a data analysis handling administrative duties and working with large data sets to produce reports and presentations.

Knowledge, Skills and Abilities

• Strong analytical skills with the ability to interpret and present large datasets.

• Proficiency in SQL (MS Server or similar) and/or Python for querying databases and generating reports.

• Experience with data analysis and management reporting.

• Excellent communication skills to effectively convey complex data findings to non-technical stakeholders.

• Understanding of compliance investigation lifecycle and case management processes.

• Ability to manage sensitive and confidential information with discretion.

• Demonstrated ability to operate in a cross-functional role supporting multiple operational areas.

• Strong organizational skills with the ability to prioritize competing operational needs, particularly during coverage periods.

• Detail-oriented with a focus on data quality and integrity.

• Ability to collaborate with team members and other departments.

• Ability to meet multiple deadlines and handle multiple priorities with independence.

• Excellent computer skills including good working knowledge of Adobe and MS Office-Excel, Word, PowerPoint and SharePoint.

• Ability to learn new computer software and applications.

• Experience in creating executive presentations and/or preparing data for executive presentations/review is preferred.

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, 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). We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.