Senior Data & Research Analyst

Title: Senior Data & Research Analyst

Location: Upper East Side

Org Unit: Emergency Medicine

Work Days: Monday-Friday

Weekly Hours: 35.00

Exemption Status: Exempt

Salary Range: $95,150.00 - $104,150.00

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

Position Summary

Responsible for designing and maintaining data reports and data infrastructure for the department. This role helps build and maintain reporting infrastructure with Epic and Allscripts SCM data, works closely with clinical and analytics leadership to create data reports for clinical, business and research needs, and takes on unique reporting projects in healthcare operations and research to improve patient care.

Job Responsibilities

• Works with departmental leaders to identify ED reporting needs and discuss data reports.

• Attends meetings as needed/requested to plan/review/present data reports; documents/tracks reporting requests, data requirements and resources; designs/maintains analytics processes to support reporting.

• Uses SQL data warehouse queries, business intelligence software and/or other analytics tools/products to design/maintain reports; writes queries to extract data; creates dynamic automated scripts that aggregate data; creates interactive dashboards.

• Collaborates with other reporting analysts to maintain reports, ensuring they are up-to-date, accurate, and fair representations of ED performance.

• Maintains all reports and ensures that they are up-to-date, accurate, and fair representations.

• Monitors system performance and response times.

• Rapidly identifies and proactively troubleshoots data performance issues and reporting errors.

• Streamlines and automates data analytics processes wherever possible to maximize efficiency.

• Provides programming and/or analytical support for relevant departmental system, subsystems, and related software products, in support of the department's clinical and operational need.

• As needed, creates or modifies change management procedures as per departmental standards.

• Develops, tests and implements enhancements to existing data systems, support scripts, or other improvements to the interface engine environment.

Education

• Bachelor's Degree in related field

Experience

Bachelor's Degree in Computer Science, Information Technology, Engineering or a related discipline. Advanced degree is preferred.

At least 4 years of experience as a Reporting Analyst, Consultant or Associate using EPIC.

At least 4 years of experience in a clinical setting, or experience with healthcare administration, data analysis and healthcare operations best practices.

Prior experience working with project managers, clinical leaders, and other data analysts to achieve deliverables in accordance with project schedule.

Prior experience with ALLSCRIPTS/SCM preferred. While most data analysis and reporting will occur using EPIC data, some will use legacy data through ALLSCRIPTS/SCM. While EPIC proficiency is a minimum requirement, incumbent will be trained in legacy system proficiency as needed.

EPIC Certification (Clinical Data Model).

Knowledge, Skills and Abilities

• High proficiency in database management and querying languages (Transact-SQL, Microsoft SQL Server, Oracle).

• High proficiency in data visualization tools (Tableau, Power BI, and/or Looker).

• Proficiency in Python programming to create loops, error handling, data analysis, and automated emails.

• Proficiency in biostatistics and programming in Stata, R, SAS or SPSS desired.

• High technical proficiency in data analytics and visualization.

• Highly detail oriented with exceptional organizational skills.

• Excellent time management skills and ability to work under tight deadlines and manage changing priorities.

• Ability to troubleshoot programming issues independently.

Licenses and Certifications

• Epic Certification (Clinical Data Model).

Working Conditions/Physical Demands

Standard office work.

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.