HPSM Dental
Join to apply for the
IT Health Data Analyst II
role at
Health Plan of San Mateo (HPSM) Join to apply for the
IT Health Data Analyst II
role at
Health Plan of San Mateo (HPSM) Get AI-powered advice on this job and more exclusive features. Required
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.
Required
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. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Information Technology Industries Hospitals and Health Care Referrals increase your chances of interviewing at Health Plan of San Mateo (HPSM) by 2x Sign in to set job alerts for “Clinical Data Analyst” roles.
San Francisco, CA $145,000.00-$180,000.00 3 days ago Strategy and Operations Lead - Clinical Care
San Francisco, CA $150,000.00-$170,000.00 1 month ago Senior Manager, Clinical Data Management
Millbrae, CA $152,000.00-$166,250.00 3 weeks ago Menlo Park, CA $105,000.00-$131,000.00 2 weeks ago San Francisco, CA $225,000.00-$275,000.00 3 days ago Alameda, CA $86,700.00-$173,300.00 16 hours ago San Francisco, CA $96,000.00-$125,000.00 1 month ago San Francisco, CA $100,000.00-$150,000.00 17 hours ago Alameda, CA $86,700.00-$173,300.00 15 hours ago Associate Director, Clinical Data Management
Senior Manager, Clinical Data Management
Foster City, CA $145,000.00-$165,000.00 2 weeks ago Senior Manager, Clinical Data Management
San Francisco, CA $190,000.00-$200,000.00 6 days ago Senior Director, Clinical Data Management
Redwood City, CA $265,000.00-$295,000.00 6 days ago Senior Director, Clinical Data Management
Principal Data Manager - Clinical Data Quality Leader
Senior Manager, Clinical Data Management
Director, Clinical Data and Reporting Standards
Senior Manager, Clinical Data Management
Redwood City, CA $180,000.00-$195,000.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
IT Health Data Analyst II
role at
Health Plan of San Mateo (HPSM) Join to apply for the
IT Health Data Analyst II
role at
Health Plan of San Mateo (HPSM) Get AI-powered advice on this job and more exclusive features. Required
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.
Required
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. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Information Technology Industries Hospitals and Health Care Referrals increase your chances of interviewing at Health Plan of San Mateo (HPSM) by 2x Sign in to set job alerts for “Clinical Data Analyst” roles.
San Francisco, CA $145,000.00-$180,000.00 3 days ago Strategy and Operations Lead - Clinical Care
San Francisco, CA $150,000.00-$170,000.00 1 month ago Senior Manager, Clinical Data Management
Millbrae, CA $152,000.00-$166,250.00 3 weeks ago Menlo Park, CA $105,000.00-$131,000.00 2 weeks ago San Francisco, CA $225,000.00-$275,000.00 3 days ago Alameda, CA $86,700.00-$173,300.00 16 hours ago San Francisco, CA $96,000.00-$125,000.00 1 month ago San Francisco, CA $100,000.00-$150,000.00 17 hours ago Alameda, CA $86,700.00-$173,300.00 15 hours ago Associate Director, Clinical Data Management
Senior Manager, Clinical Data Management
Foster City, CA $145,000.00-$165,000.00 2 weeks ago Senior Manager, Clinical Data Management
San Francisco, CA $190,000.00-$200,000.00 6 days ago Senior Director, Clinical Data Management
Redwood City, CA $265,000.00-$295,000.00 6 days ago Senior Director, Clinical Data Management
Principal Data Manager - Clinical Data Quality Leader
Senior Manager, Clinical Data Management
Director, Clinical Data and Reporting Standards
Senior Manager, Clinical Data Management
Redwood City, CA $180,000.00-$195,000.00 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr