Investigation and Data Reporting Analyst

Weill Cornell Medical College•New York, NY

2d•$96,500 - $108,900

About The Position

The Investigation and Data Reporting Analyst supports the Office of Compliance’s investigation functions by supporting day-to-day use of database systems and preparing management reports through data consolidation and analysis on weekly, monthly, quarterly, and annual schedules. The role supports data needs for Compliance and Privacy investigations and has primary responsibility for administering Weill Cornell Medicine’s use of the Splunk database to monitor access to and use of the electronic medical record. The position also provides cross-functional backup support for the Compliance Investigation Manager and Data and Reporting Analyst functions during absences, periods of surge capacity, and other operational needs. It supports continuity of investigation and reporting operations by coordinating workflows, maintaining data and report resources, and assisting stakeholders across the organization.

Requirements

Bachelor’s degree in a healthcare-related field.
Two to three years of experience in data analysis, handling administrative duties, and working with large data sets to produce reports and presentations.
Strong analytical skills and 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 convey complex data findings to non-technical stakeholders.
Understanding of the compliance investigation lifecycle and case management processes.
Ability to handle sensitive and confidential information with discretion.
Ability to work cross-functionally in support of multiple operational areas.
Strong organizational skills and ability to prioritize competing operational needs, particularly during coverage periods.
Attention to detail, with a focus on data quality and integrity.
Ability to collaborate with team members and other departments.
Ability to meet multiple deadlines and manage multiple priorities independently.
Excellent computer skills, including working knowledge of Adobe, Microsoft Excel, Word, PowerPoint, and SharePoint.
Ability to learn new computer software and applications.

Nice To Haves

Approximately three to five years of experience in healthcare.
Experience creating executive presentations and/or preparing data for executive presentations or review.

Responsibilities

Support compliance investigations by tracking cases, reviewing documentation, coordinating interviews, maintaining evidence records, and managing investigation files and timelines.
Assist with case monitoring to ensure timely completion and meet escalation and reporting deadlines.
Provide backup reporting support, including creating reports, updating dashboards, validating data, and maintaining reporting tools.
Coordinate with Compliance, Privacy, IT, and other stakeholders to support data flow and resolve issues during coverage periods.
Identify process gaps and recommend workflow improvements to strengthen investigation and reporting continuity.
Create and run system queries for investigation-related data requests and weekly, monthly, and annual metrics using internal database systems and systems such as Splunk, CaseIQ, MDaudit, and RADAR.
Compile data for routine and ad hoc reports and prepare meeting materials and presentations using information from internal systems.
Prepare summary findings of investigations for stakeholders, including clinical departments, HR, Faculty Affairs, Legal, and oversight committees.
Synthesize large or disparate data sets and communicate or relay information in a meaningful way.
Maintain a centralized repository of reports and materials and manage databases, data analysis, and reporting.
Provide operational administrative support to Office of Compliance leadership, including coordinating investigation and reporting workflows to ensure continuity of operations.