Business Intelligence Analyst II (CEMI)

Location: Midtown, NYC • Exemption Status: Exempt • Term position anticipated through Fall 2028 (may be ended or extended based on organizational needs, funding, and performance).

About the role

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.

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.

Requirements

• Bachelor’s Degree in Business, Information Systems, Computer Science, or related field (equivalent work experience will be considered).
• Minimum of 5–8 years of experience in business intelligence, data analysis, or related field.
• Experience gathering and documenting business requirements and translating them to technical specifications.
• Experience working with reporting and analytics tools such as Power BI.
• Experience with 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).

Skills

• 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.

Pay

$105,000 – $124,100 per year.

Schedule

• 35 hours per week.
• Occasional off-hours and weekends for go-lives, testing, and emergencies.
• Travel between office locations, primarily within NYC, is required.

Working Conditions

• Office environment with some physical discomforts such as dust, dirt, and noise.
• Occasional meetings or interactions in typical patient care areas (direct patient exposure not expected).
• Occasional moving of computer equipment or similar objects up to approximately 50 lbs to expedite projects.