Business Intelligence Analyst New Oakland, CA, Remote

Elders; Oakland (CA); Remote; USD 96,000 - 145,000; Full time

Job summary

Center for Elders’ Independence in Oakland is seeking a Business Intelligence Analyst to build and optimize enterprise reporting using SSRS and Power BI. You will interface with Salesforce, eClinicalWorks, and claims data to deliver regulatory-ready insights for leaders and operations.

The role emphasizes data governance, data quality, and a unified data foundation across fragmented systems to support CMS and state reporting. Collaboration with the Data & Analytics team is essential.

Qualifications

• 7+ years BI/Reporting/Data Analytics experience.
• Strong hands-on with SSRS and Power BI.
• Healthcare regulatory reporting experience (CMS/state).
• Data integration and interoperability knowledge.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Develop, maintain, and enhance SSRS and Power BI reports for leadership, operations, 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 new reports; optimize dashboards for usability and performance.
• Collaborate with cross-functional teams to translate business needs into BI solutions.
• Support data governance initiatives by contributing to data standards and quality rules.

Skills

BI/Analytics

Communication skills

Tools

SSRS

Power BI

Job description

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 requirementsas prescribed byCMS 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—including 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:
• SSRS
• Power BI
• Demonstrated expertise with healthcare reporting, especially:
• CMS regulatory 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 ofthementioned 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.

Placement within the compensation range listed here is determined by job‑related qualifications, experience, internal equity, and market factors, consistent with CEI compensation practices.

Salary Range

$95,721 - $145,496 USD

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self‑identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Center for Elders' Independence’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service‑connected disability.

A "recently separated veteran" means any veteran during the three‑year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval, or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.