Note: this role is no longer available. Find roles from actively hiring companies at the link below.
Go Home
Kaiser Permanente

Kaiser Permanente

Data Reporting and Analytics Consultant III - Medicare Actuarial

Data Reporting and Analytics Consultant III - Medicare Actuarial

Apply Now
Job Details
""
Uploaded On
July 23, 2023
""
Location
Oakland, United States
""
Remote?
No
Company Overview
""
Headquarters
Oakland, CA
""
Number of Employees
218000
Estimated Number of Actuaries
124
Salary
$
97
k-$
125
k
Glassdoor Ratings
""
Recommend to a Friend
72%
""
Overall Score
3.9 / 5
[ Description: Job Summary:

This individual contributor is primarily responsible for supporting data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, and preparing data for analytic efforts.

This position supports the execution of creative data analytic approaches leading to actionable outcomes, develops, implements, and automates business and reporting solutions, supports data analysis interpretation, and supports and develops analytical and/or statistical models enabling informed business decisions.

Essential Responsibilities:

  • Pursues self-development and effective relationships with others by proactively providing resources, information, advice, and expertise with coworkers and customers; influencing others through technical explanations and examples; providing occasional mentoring to team members; listening and responding to, seeking, and addressing performance feedback; creating plans to capitalize on strengths and develop weaknesses; anticipating and responding to the needs of others; and adapting to and learning from change, difficulties, and feedback.
  • Completes work assignments by applying up-to-date expertise in subject area to generate creative solutions; ensuring all procedures and policies are followed; leveraging an understanding of data, and resources to support projects or initiatives; collaborating cross-functionally to solve business problems; identifying and monitoring priorities, deadlines, and expectations; communicating progress and information; identifying, recommending, and implementing ways to address improvement opportunities; and escalating issues or risks as appropriate.
  • Supports and develops analytical and/or statistical models enabling informed business decisions by determining data and analytical requirements; creating models leading to actionable insights; and testing, refining, and validating models.
  • Gathers data and information on targeted variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across sources; completing routine data refresh and update; developing and/or delivering tools for electronic data collection; and providing user training, support, and documentation.
  • Supports data analysis interpretation by applying findings to contextual settings under the guidance of more senior employees; and developing reports and presentations telling a compelling story to stakeholders to enable and influence decision making.
  • Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; summarizing data and results; creating summary statistics; organizing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
  • Prepares data for analytic efforts by consolidating data; reviewing data for quality and accuracy; profiling data inaccuracies; and cleaning and creating final data set(s) for analysis.
  • Supports data-informed decisions by consulting with clients to identify and clarify key business needs; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.
  • Supports the execution of creative data analytic approaches leading to actionable outcomes by identifying metrics to be analyzed; calculating algorithms; and conducting analyses under the guidance of more senior employees, including descriptive, correlational, inferential, and/or predictive statistics.
Minimum Qualifications:

  • Bachelors degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field and Minimum three (3) years experience in data analytics or a directly related field. Additional equivalent work experience in a directly related field may be substituted for the degree requirement.

  • N/A

  • Preferred Qualifications:

    • Two (2) years experience working with Excel.
    • Two (2) years experience working with data extraction and manipulation language.
    • Two (2) years programming experience.
    • Two (2) years experience working with SQL.
    • Two (2) years experience working with health care data, e.g., membership, claims, encounters, capitations, premiums
    • As a member of the Medicare Actuarial team, you will have a critical role in the success of the team across the nation. You will be part of a small group of analysts that work closely together to meet the data and analytical needs of the department. This role provides support for sourcing, interpretation, and preparation of all the data used in key analysis of KP's Medicare Advantage products which generate over $25 billion in annual revenue. This role relies heavily on the use of SQL including transact SQL and Oracle SQL. The Medicare Actuarial team maintains an on-site Oracle database that will be the primary data source, and, in this role, you will be able to implement views, procedures and functions as needed to meet analysis and reporting requirements. Your technical and critical thinking skills will be consistently challenged with new and unique problems.


Primary Location: California,Oakland,Kaiser Center
Additional Locations:

East Annex - Parsons, 75 N. Fair Oaks Ave., Pasadena,California, 91103
Regional Admin Low Rise, 711 Kapiolani Blvd., Honolulu,Hawaii, 96813
Regional Office - 9 Piedmont, 9 Piedmont Center 3495 Piedmont Rd. NE, Atlanta,Georgia, 30305
Rockville Regional Offices, 2101 E. Jefferson St., Rockville,Maryland, 20852
Waterpark I, 2500 S. Havana St., Aurora,Colorado, 80014
California Service Center - Rio S.D., 8954 Rio San Diego Dr., San Diego,California, 92108
Lowry Administration, 7901 E. Lowry Blvd. Ste 150 and 400, Denver,Colorado, 80230
Riverway-1, 6133 North River Rd., Rosemont,Illinois, 60018
Alexandria Medical Center, 3000 Potomac Ave., Alexandria,Virginia, 22305
Scheduled Weekly Hours: 40
Shift: Day
Workdays: Mon, Tue, Wed, Thu, Fri
Working Hours Start: 08:00 AM
Working Hours End: 05:00 PM
Job Schedule: Full-time
Job Type: Standard
Employee Status: Regular
Employee Group/Union Affiliation: NUE-PO-01|NUE|Non Union Employee
Job Level: Individual Contributor
Specialty: Data Analytics & Reporting
Department: Po/Ho Corp - HP PROD MGMT-Actuarial SVCS - 0308
Pay Range: $96800 - $125290 / year The ranges posted above reflect the location in the job posting. The salary range may vary if you reside in a different location or state than the location posted.
Travel: No At Kaiser Permanente, equity, inclusion and diversity are inextricably linked to our mission, and we aim to make it a part of everything we do. We know that having a diverse and inclusive workforce makes Kaiser Permanente a better place to receive health care, a more supportive partner in our communities we serve, and a more fulfilling place to work. Working at Kaiser Permanente means that you agree to and abide by our commitment to equity and our expectation that we all work together to create an inclusive work environment focused on a sense of belonging and wellbeing.

Kaiser Permanente is an equal opportunity employer committed to a diverse and inclusive workforce. Applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), age, sexual orientation, national origin, marital status, parental status, ancestry, disability, gender identity, veteran status, genetic information, other distinguishing characteristics of diversity and inclusion, or any other protected status. Submit Interest ]
Apply Now

Working at 

Kaiser Permanente

Kaiser Permanente, a distinguished healthcare organization, offers exceptional actuarial career opportunities for talented professionals in the field. With a strong commitment to delivering high-quality care and innovative solutions, Kaiser Permanente is at the forefront of the industry. Actuaries at Kaiser Permanente play a vital role in analyzing complex data, assessing risks, and making informed financial decisions. By utilizing their expertise, actuaries contribute to the organization's long-term sustainability and help shape the future of healthcare. Kaiser Permanente provides a collaborative and supportive environment for actuaries to thrive. The organization recognizes the value of continuous professional development and offers ample opportunities for growth and advancement. Actuaries at Kaiser Permanente have access to cutting-edge tools, technologies, and resources to enhance their analytical capabilities and make data-driven decisions. Joining the team at Kaiser Permanente means becoming part of a renowned institution that values excellence and innovation. Actuaries have the chance to work alongside industry experts and make a meaningful impact on the healthcare landscape. If you are a talented actuary seeking a rewarding and impactful career in healthcare, Kaiser Permanente offers a dynamic and fulfilling environment where your skills and expertise can flourish. Take the next step in your actuarial journey with Kaiser Permanente and be part of a team that is revolutionizing healthcare through actuarial science.