BI Business Analyst, Specialist

The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

This position is remote; Candidates MUST reside in California.

What You Will Be Doing:

Under limited supervision, the BI Business Analyst, Specialist is responsible for SQL, data analysis, and requirements gathering, along with strong knowledge of data warehousing concepts. This role will collaborate effectively with peers and stakeholders to drive data-driven decision-making across the organization.

Our Vision:

Continuously improve the health of our community.

Our Mission:

We provide healthcare value and advance wellness through community partnerships.

Essential Functions:

• Collaborate with business stakeholders to gather, analyze, and document detailed requirements for BI projects and reports.
• Develop, maintain, and enhance SQL queries, stored procedures, and views to extract and analyze data from various systems.
• Ensure data integrity and quality through rigorous data validation and testing.
• Design and implement data models, reports, and dashboards in alignment with business needs and industry best practices.
• Assist in building and maintaining data warehouses, including ETL processes and data pipelines.
• Provide insights and recommendations through data analysis to support business decisions.
• Work closely with cross-functional teams to translate business requirements into technical solutions.
• Support peers and junior team members by providing guidance, training, and mentorship.
• Ensure adherence to data governance policies and compliance requirements, particularly in a healthcare environment.
• Troubleshoot and resolve issues related to BI tools, data integration, and reporting systems.

What You Bring:

Knowledge, Skills, Abilities and Competencies

Required

• Basic knowledge of: SQL and data analysis.
• Basic knowledge of health care data.
• Basic knowledge of data warehousing concepts, data modeling, and ETL processes.
• Basic knowledge of BI tools (Power BI, Tableau and similar platforms).
• Basic knowledge of cloud-based data platforms.
• Ability to read, design and implement reports.
• Ability to troubleshoot and resolve issues.
• Ensures adherence to data governance polices within the healthcare environment.

Preferred

• Working with cloud-based data platforms.
• Agile project management methodologies.

What You Have:

Education and Experience

Required

• Bachelor s degree in computer science, Information Systems, Business, or a related field.
• Minimum of 5+ years of experience in business analysis, data analysis, or related BI roles.
• Proficient in SQL, with the ability to write complex queries for data extraction and reporting.
• Strong understanding of data warehousing concepts, data modeling, and ETL processes.
• Experience with BI tools such as Power BI, Tableau, or similar platforms.
• Knowledge of healthcare data, including claims, membership, and provider data, is a plus.
• Proven experience in gathering and translating business requirements into technical solutions.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills, with the ability to work collaboratively and mentor peers.
• Familiarity with regulatory and compliance requirements in healthcare is preferred.

Preferred

• Experience working with cloud-based data platforms (e.g., AWS, Azure, Google Cloud).
• Knowledge of advanced data analysis techniques, including predictive modeling and machine learning.
• Familiarity with Agile project management methodologies.

Licenses, Certifications

None

What You Will Get:

HPSJ Perks:

• Competitive salary
• Robust and affordable health/dental/vision with choices in providers
• Generous paid time off (accrue up to 3 weeks of PTO, 4 paid floating holidays including employee s birthday, and 9 paid holidays)
• CalPERS retirement pension program, automatic employer-paid retirements contributions, in addition to voluntary defined contribution plan
• Two flexible spending accounts (FSAs)
• Employer-Paid Term Life and AD&D Insurance
• Employer-Paid Disability Insurance
• Employer-Paid Life Assistance Program
• Health Advocacy
• Supplemental medical, legal, identity theft protection
• Access to exclusive discount mall
• Education and training reimbursement in addition to employer-paid elective learning courses.
• A chance to work for an organization that is mission-driven our members and community are at the core of everything we do.
• A shorter commute if you re commuting from the Central Valley to the Bay Area.
• Visibility and variety you have a chance to work with people at all levels of the organization, and work on diverse projects.

We are an equal opportunity employer and diversity is one of our core values. We believe that differences including race, ethnicity, gender, sexual orientation and other characteristics, will help us create a strong organization that is sensitive to the needs of those we serve. Employment decisions are made on the basis of qualifications and merit.

HPSJ provides equal employment opportunities to employees and applicants for employment and prohibits discrimination based on color, race, gender (including gender identity and gender expression), religion (including religious dress and grooming practices), marital status, registered domestic partner status, age, national origin (including language use) or ancestry, physical or mental disability, medical condition (including cancer and genetic characteristics), sex (including pregnancy, childbirth, breastfeeding or related medical condition), genetic information, sexual orientation, military or veteran status, political affiliation or any other characteristic made unlawful by applicable Federal, State or local laws. It also prohibits unlawful discrimination based on the perception that anyone has these characteristics, or is associated with anyone who has or is perceived to have these characteristics.

Important Notice: This job description is not a contract between HPSJ and the employee performing the job. The duties listed in the job description may be changed at the discretion of HPSJ, and HPSJ may request the employee to perform duties that are not listed on the job description.