IT Health Data Analyst II

Health Plan of San Mateo; Golden Horseshoe; Hybrid; USD 92,000 - 119,000; Full time

Job summary

An established industry player seeks a skilled Data Analyst to enhance health management programs through data-driven insights. In this dynamic role, you will analyze and validate healthcare data, develop database tools, and generate impactful reports for senior management. Your expertise in SQL and Microsoft Power Platform will be pivotal in navigating complex data structures and ensuring data integrity. Join a team that values innovation and collaboration, where your contributions will directly influence the quality of healthcare services. If you're passionate about data and its impact on health outcomes, this opportunity is tailored for you.

Benefits

Medical, dental and vision coverage

Fully paid life, AD&D and LTD insurance

Retirement plan with 10% contribution

12 paid holidays per year

12 paid sick days per year

Vacation starting at 16 days per year

Employee wellness program

Qualifications

• Bachelor’s degree in computer science or similar field required.
• 4 years of experience in data analysis and programming needed.

Responsibilities

• Analyze health management programs and validate data.
• Create and generate reports using SQL and Microsoft tools.

Skills

Data Analysis

SQL

Microsoft Power Platform

Data Warehousing

Business Intelligence

Education

Bachelor’s degree in computer science

Four years of work experience in DB reporting

Tools

Microsoft SQL Server

MS-Excel

MS-Access

Power BI

Power Apps

Power Automate

Job description

801 Gateway Blvd, South San Francisco, CA 94080, USA ● Virtual Req #121

Monday, April 14, 2025

This position is open to candidates based anywhere in California, with the understanding that occasional in-office meetings may be required.

Plan and evaluate activities through the design and development of data/reports and the analysis and interpretation of data. This includes the development of database tools and analysis to produce data support for various company-wide programs and activities.

Position overview

Essential Functions:

• Analyze health management programs including data collection, validation and outcome measurement.
• Strong ability to analyze Provider, Member, Pharmacy, Claims, and healthcare data
• Internal data cleansing and data reconciliation analysis
• Trend analysis in various functional areas of health care management.
• Create and generate reports through MS-Excel, MS-Access, MS-Power Platform and SQL using Business Objects interface and direct links to core databases
• Navigate complex data structures in SQL Server to retrieve data
• Produce reports for and interface with senior management and internal and external stakeholders.
• Gather and interpret business requirements and monitor data trends to proactively identify issues
• Execute data changes and update core systems as needed
• Handle multiple projects and timelines effectively and communicate risks and issues to manager regularly
• Assist with training Associate Data Analyst.
• Responsible for analytical data needs. Handle complex data requests, reports, and predictive data modeling.
• Perform data cleaning, loading, extraction, processing, storage and manipulation.
• Build and maintain program source code written by self and others.
• Maintain detailed documentation of programming and analyses.
• Communicate project results to managers and various users.
• Design and develop relational databases for collecting data and create data collection screens.
• Participate in decisions regarding study design, data collection, and data analysis.

Secondary Functions:

• Backup EDI analyst in job duties
• Perform other duties as assigned.

Requirements

These are the qualifications typically needed to succeed in this position. However, you don’t need to meet every requirement to apply.

Education and experience

• Bachelor’s degree in computer science, statistics, mathematics, economics or similar field.
• Four (4) years’ work experience in DB reporting data analysis and programming.
• Solid experience with SQL and DB design and maintenance with Microsoft SQL is a must.
• Experience in interpreting and reporting results of analysis, data processing and management, HIPAA EDI, and the use of health data codes.

Knowledge of:

• Basic statistical concepts, models, and procedures.
• Medi-Cal and/or Medicare programs highly preferred.
• Personal computers and proficiency in Microsoft Power Platform include Power BI, Power Apps, and Power Automate.
• API Endpoints management and development.

Ability to:

• Analyze data and create reports/data extractions.
• Organize work, manage time, and meet deadlines.
• Communicate effectively and provide a high standard of customer service.
• Thoroughly document work adapts to changes in requirements/priorities for daily and specialized tasks.
• Translate users need to program functional specifications.
• Communicate and work with users having a wide range of computer skill levels.
• Problem-solve and consider the entire solution.
• Work independently as well as part of a team; support team decisions.
• Effectively interact with internal and external contacts.
• Work cooperatively with others.
• Work as part of a team and support team decisions.
• Communicate effectively, both verbally and in writing.
• Adapt to changes in requirements/priorities for daily and specialized tasks.

Skills:

• Microsoft SQL Server, Data Warehousing, Database Administration, Business Intelligence

Salary and benefits

The starting salary range is $92,240 - $118,485 per year, depending on the candidate’s work experience.

Excellent benefits package includes:

• HPSM-paid premiums for employee’s medical, dental and vision coverage (employee pays 10% of each dependent’s premiums)
• Fully paid life, AD&D and LTD insurance
• Retirement plan (HPSM contributes equivalent of 10% of annual compensation)
• 12 paid holidays a year, 12 paid sick days a year and paid vacation starting at 16 days a year
• Employee wellness program

It is HPSM's policy to provide equal employment opportunities for all applicants and employees. HPSM does not unlawfully discriminate based on race, religion, color, national origin, ancestry, physical disability, mental disability, medical condition, marital status, sex, age, sexual orientation, veteran status, registered domestic partner status, genetic information, gender, gender identity, gender expression, or any other characteristic protected by applicable federal, state, or local law. HPSM also prohibits discrimination based on the perception that an applicant or employee has any of those characteristics or is associated with a person who has or is perceived to have any of those characteristics.