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.
• Work under deadlines; manage multiple job requests simultaneously.
• 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 .NET, C#, Visual Studio, Azure, Power Platform
• 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
• Tuition reimbursement plan
• 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.