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

KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES

Required

• Technical Skills: Strong in SQL, Power BI, SSRS, data modeling, and data validation.
• Business Acumen: Ability to understand business processes and align data solutions to organizational goals.
• Problem Solving: Identifies root causes of data anomalies and proposes practical solutions.
• Communication: Effectively communicates findings and technical concepts to non-technical stakeholders.
• Collaboration: Works well in a team environment and across departments to deliver results.
• Continuous Learning: Keeps up with data analytics trends and tools to improve processes and outcomes.

EDUCATION AND EXPERIENCE

Required

• Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or related field.
• 3 years of experience in business intelligence, data analysis, or data warehousing.
• Proficiency in writing complex SQL queries and optimizing query performance.
• Hands-on experience with BI tools, especially Power BI and SSRS.
• Familiarity with dimensional data modeling and ETL processes.
• Understanding data governance, data quality, and mastering management concepts.
• Strong analytical and critical thinking skills with attention to detail.
• Excellent written and verbal communication skills to work effectively across teams.

Preferred

• Experience working in the healthcare industry or with health plan data (e.g., claims, authorizations, membership, providers).
• Knowledge of regulatory and compliance reporting such as HEDIS, DSNP, or CMS submissions.
• Exposure to cloud-based data platforms (e.g., Snowflake, Azure).
• Experience with Agile/Scrum development practices.

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.

WHAT YOU WILL BE DOING:

Under general supervision, the BI Data Analyst, Intermediate is responsible for supporting HPSJ’s data-driven decision-making by analyzing, interpreting, and visualizing data from various business domains. This role contributes to the development and enhancement of HPSJ’s data warehouse and business intelligence capabilities, including data modeling, dashboard development, ad hoc reporting, and data validation. The analyst collaborates with stakeholders across the organization to gather requirements, create insights, and ensure data accuracy and accessibility.

ESSENTIAL FUNCTIONS:

• Partner with business teams to gather requirements and translate them into functional data solutions and BI reports.
• Design, develop, and maintain interactive dashboards and reports using Power BI and SQL Server Reporting Services (SSRS).
• Analyze large datasets to identify trends, anomalies, and actionable insights.
• Perform data profiling, validation, and QA to ensure accuracy and consistency of reporting.
• Develop and maintain data models and views to support business reporting and analytics.
• Assist in enhancing and maintaining HPSJ’s enterprise data warehouse and data marts.
• Support data migration and transformation projects as part of the data lifecycle process.
• Document data definitions, transformation logic, and metadata for transparency and governance.
• Provide support and training to end-users on BI tools, dashboards, and data interpretation.
• Adhere to HIPAA and other privacy and security guidelines in handling PHI and sensitive data.