Business Intelligence Analyst

Center for Elders; United States; On-site; USD 96,000 - 145,000; Full time

Job summary

The Center for Elders’ Independence is seeking a Business Intelligence Analyst to support the Data & Analytics team by developing, maintaining, and optimizing enterprise reporting solutions using SSRS and Power BI, with integration across Salesforce, eClinicalWorks, and claim systems.

The role requires strong technical and healthcare regulatory knowledge (CMS and state), enhances data governance, and contributes to a unified data foundation to enable reliable, auditable reporting for leadership

Qualifications

• 7 years of experience in Business Intelligence, Reporting, or Data Analytics.
• Strong hands-on experience with SQL Server / T-SQL, SSRS, Power BI.
• Demonstrated expertise with healthcare reporting, CMS regulatory reporting, and state-level reporting.

Responsibilities

• Develop, maintain, and enhance SSRS and Power BI reports for leadership, operational, clinical, and regulatory needs.
• Produce accurate, timely leadership, operational, and regulatory reporting deliverables.
• Partner with stakeholders to define requirements and deliver insights for auditability and regulatory readiness.
• Work with data from Salesforce, eCW, and Claim systems; map data flows.
• Perform data analysis to validate, cleanse, and reconcile data across sources.
• Design and develop reports and dashboards; optimize usability and performance.
• Collaborate with cross-functional teams to translate business needs into BI solutions.
• Support data governance by contributing to standards, definitions, and quality rules.
• Help establish a unified data foundation and improve data reliability.

Skills

SQL Server

SSRS

Power BI

CMS reporting

Data analysis

Data integration

Stakeholder communication

Tools

Salesforce

eClinicalWorks

Claim systems

Job description

Description

Business Intelligence Analyst

The Center for Elders’ Independence is a PACE (Program of All-Inclusive Care for the elderly) organization (PO) that uses an interdisciplinary team approach for care planning and implementing purposeful high quality, affordable, and integrated health care services to the elderly. Our elderly meet PACE requirements as prescribed by CMS and are referred to as participants. Our PO includes Adult Day Health Centers and primary care clinics, promoting participant autonomy, quality of life and the ability for individuals to live in their communities

THE POSITION: The Business Intelligence Analyst will support the Data & Analytics team by developing, maintaining, and optimizing enterprise reporting solutions-include SSRS, Power BI, and regulatory submissions. This role requires strong technical expertise, healthcare regulatory knowledge (CMS and State), and the ability to integrate and analyze data across fragmented clinical and operational systems such as Salesforce and eClinicalWorks (eCW). The analyst will play a key role in enhancing data governance practices and contributing to the creation of a unified data foundation.

The annual salary range for the Business Intelligence Analyst position at Center for Elders’ Independence is $95,721 to $145,496. Placement within the range is determined based on job-related factors such as relevant experience, skills, abilities, internal equity, and market data, consistent with CEI’s annual compensation review and established compensation practices.

DUTIES AND RESPONSIBILITIES:

• Develop, maintain, and enhance SSRS and Power BI reports supporting leadership, operational, clinical, and regulatory needs.
• Produce accurate, timely leadership, operational, and regulatory reporting deliverables.
• Partner with stakeholders to define reporting requirements and deliver insights that support auditability and regulatory readiness.
• Work extensively with data from Salesforce, eClinicalWorks (eCW), and Claim systems; understand and map data flows.
• Perform data analysis to validate, cleanse, and reconcile data across disparate sources.
• Business Intelligence Development
• Design and develop new reports, and optimize existing reports/dashboards to improve usability, performance, and accuracy.
• Partner with cross-functional teams to translate business needs into BI solutions.
• Support data governance initiatives by contributing to data standards, definitions, and quality rules.
• Help establish a unified data foundation and improve data reliability across the organization.
• Work closely with data engineering to ensure consistent and accurate data ingestion.

QUALIFICATIONS:

• 7 years of experience in Business Intelligence, Reporting, or Data Analytics.
• Strong hands-on experience with:
• SQL Server / T-SQL
• SSRS
• Power BI
• Demonstrated expertise with healthcare reporting, especially:
• CMS regulatory reporting
• State-level medical/clinical reporting
• Solid understanding of data integration, data modeling, and interoperability concepts.
• Excellent analytical, problem-solving, and communication skills.

PREFERRED QUALIFICATIONS:

• Experience supporting data governance programs or enterprise data initiatives.
• Familiarity with healthcare operational workflows and clinical terminology.
• Background in a mission-driven or healthcare organization.

The above job description is intended to communicate the general function of the mentioned position and by no means shall be considered an exhaustive or complete outline of the specific tasks and functions that will be required. CEI reserves the right to change job descriptions, site assignments, and or work hours as required by the needs of the program. All employees are expected to perform their duties within their ability as required by the job and/or as requested by management.

Center for Elders’ Independence is a PACE (Program of All-Inclusive Care for the Elderly) organization that uses an interdisciplinary team approach to care planning and care implementation for the purpose of providing high quality, affordable, integrated health care services to the elderly, including an Adult Day Health Center, and promoting autonomy, quality of life and the ability of individuals to live in their communities. Unlike other healthcare plans, CEI is not a “fee-for-service” plan. It is a “capitation” healthcare plan. CEI is paid a set amount for each person enrolled in our program, whether or not that individual seeks care. We are a growing company that offers stability and continues to thrive.