Business Intelligence Analyst II (CEMI)- 2 Year Term Appointment

Weill Cornell Medicine; New York (NY); On-site; USD 105,000 - 124,000; Full time

Job summary

Weill Cornell Medicine in Midtown, New York, is seeking a Business Intelligence Analyst II (CEMI) for a 2-year term appointment. The role serves as a bridge between business stakeholders and technical teams, translating needs into actionable data and reporting solutions.

Required 5–8 years BI experience, Power BI, and data warehousing knowledge (Redshift). A Bachelor's in Business, Information Systems, CS or related field (or equivalent experience) is preferred.

Qualifications

• Bachelor's Degree in Business, Information Systems, Computer Science or related field preferred; equivalent work experience will be considered.
• 5–8 years of experience in business intelligence, data analysis, or related field.
• Experience with Power BI and data warehouses such as Amazon Redshift.

Responsibilities

• Gather and document business requirements and translate them into functional and technical specifications.
• Partner with business stakeholders to understand reporting needs, KPIs, and data definitions.
• Collaborate with developers and data engineers to ensure accurate delivery of data and reporting solutions.
• Validate and test reports, dashboards, and datasets to ensure accuracy and alignment with business requirements.
• Serve as a liaison between business users and technical teams to support issue resolution and enhancements.
• Work with data teams to understand data models, data lineage, and data availability across systems.
• Support data migration and transformation initiatives by defining reporting and historical data requirements.
• Assist in building or modifying reports and dashboards (e.g., Power BI) when required.
• Document business processes, report logic, and data definitions for governance and knowledge sharing.
• Provide user support, training, and guidance on analytics tools and reporting solutions.

Skills

Communication

Analytical thinking

Independence

KPIs

Data lifecycle

Stakeholder collaboration

Adaptability

Education

Bachelor's degree or equivalent

Tools

Power BI

Amazon Redshift

Job description

Title: Business Intelligence Analyst II (CEMI)- 2 Year Term Appointment

Location: Midtown

Org Unit: Business Intelligence

Work Days

Weekly Hours: 35.00

Exemption Status: Exempt

Salary Range: $105,000.00 - $124,100.00

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

Position Summary

The Business Intelligence Analyst II serves as a bridge between business stakeholders and technical teams, translating business needs into clear and actionable data and reporting solutions. This role requires strong business domain understanding, analytical thinking, and communication skills, with working knowledge of data platforms and tools to support analytics and reporting initiatives.

This is a term position anticipated to be needed through Fall 2028 but may be ended or extended based on organizational needs, funding availability, and performance.

Job Responsibilities

• Gather, analyze, and document business requirements and translate them into functional and technical specifications.
• Partner with business stakeholders to understand reporting needs, KPIs, and data definitions.
• Collaborate with developers and data engineers to ensure accurate delivery of data and reporting solutions.
• Validate and test reports, dashboards, and datasets to ensure accuracy, quality, and alignment with business requirements.
• Serve as a liaison between business users and technical teams to support issue resolution and enhancements.
• Work with data teams to understand data models, data lineage, and data availability across systems.
• Support data migration and transformation initiatives by defining reporting and historical data requirements.
• Assist in building or modifying reports and dashboards (e.g., Power BI) when required.
• Document business processes, report logic, and data definitions for governance and knowledge sharing.
• Provide user support, training, and guidance on analytics tools and reporting solutions.

Education

• Bachelor's Degree in Business, Information Systems, Computer Science or related field preferred
• equivalent work experience will be considered.

Experience

• Minimum of 5-8 years of experience in business intelligence, data analysis, or related field
• Experience gathering and documenting business requirements and translating to technical specifications
• Experience working with reporting and analytics tools such as Power BI
• data warehouses such as Amazon Redshift
• Experience working with cross-functional teams including business stakeholders and technical developers
• Basic understanding of data modeling concepts and data warehouse structures
• Solid experience supporting reporting and analytics projects in Finance, HCM, Research or related domains preferred

Knowledge, Skills and Abilities

• Strong communication skills with ability to translate complex business needs into technical requirements.
• Strong analytical thinking and problem-solving skills with attention to detail.
• Ability to work independently and manage multiple priorities in a fast-paced environment.
• Solid understanding of reporting concepts, KPIs, and business process analysis.
• Working knowledge of data systems, integration concepts, and data lifecycle processes.
• Ability to collaborate effectively with both technical and non-technical stakeholders.
• Adaptability and willingness to learn new tools, technologies, and business domains.

Working Conditions/Physical Demands

Position requires working in an office environment where there some physical discomforts such as dust, dirt, noise, and the like are present. Ability to work off-hours and weekends for go-lives, testing and emergencies, as well as travel between office locations, primarily within NYC is required. Occasional meetings or clinical staff interactions in typical patient care areas may be required though direct patient exposure is not expected. Occasional moving of computer equipment or similar objects up to approximately 50lbs may be required to expedite projects.

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.