Health Plan of San Mateo -posted 3 months ago
$92,240 - $118,485/Yr
Full-time • Mid Level
CA
101-250 employees

This position is open to candidates based anywhere in California, with the understanding that occasional in-office meetings may be required. The role involves planning and evaluating 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.

  • 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.
  • Backup EDI analyst in job duties.
  • Perform other duties as assigned.
  • 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 including Power BI, Power Apps, and Power Automate.
  • API Endpoints management and development.
  • Microsoft .NET, C#, Visual Studio, Azure, Power Platform.
  • Microsoft SQL Server, Data Warehousing, Database Administration, Business Intelligence.
  • The starting salary range is $92,240 - $118,485 per year, depending on the candidate’s work experience.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service