Kaiser Permanente Work Values

Daily Duties at Kaiser Permanente:

• Worked on a team of three programmers to provide support to a business team that fulfills 1,800+ requests for information each year from many groups within Kaiser. This includes Medicare Bid, Charity Care, and MediCal Fee for Service – three high priority projects that either are a significant piece of revenue (Medicare Bid) or are part of Kaiser Permanente’s goal of giving back to the community (Charity Care, MediCal Fee for Service) • Maintained a collection of 70+ SAS programs and macros that create a membership-level Expense and Revenue data source of Northern and Southern California members. This information is used by the National Pricing System (NPS) project and provides an unprecedented level of insight into the profitability of any individual member or group of members • Maintained Service Population (SPOP) and Intra-Facility Referral System (IFRS). • Re-developed the SPOP process, which manages the allocation of over 50% of the NCAL Budget. • Wrote and ran SQL queries to pull data from various sources. • Modified complex SQL queries to make them easier to understand and manipulate. • Re-developed the IFRS process, which manages adjustments to the Northern California region Budget. • Maintained Excel VBA code during data exchange/processes • Developed a method to simplify extracting data from a variety of sources and putting it together with other relevant information. • Developed "One Stop Data Shop", a simple method that provides an auditable method for the general user to get data without doing any programming. • Documented and rewrote old programs that process the Outside Medical Services and Billed Revenue source data. – two parts of Product Line Accounting and Reporting (PLAR), a collection of programs that produces a profit and loss statement for all business lines at Kaiser Permanente

What they like about Kaiser Permanente:

Working in an organization that is technologically advanced, creative, and innovative is critical in your assessment of hiring companies. Less important to you are stability of the organization, the length of time an organization has been in business, and the business' plans for the future. You prefer a fast-moving company that will take risks to achieve its goals and objectives. The length of time the company has been in business is irrelevant. Maintaining status quo is unnecessary. You thrive on change, uncertainty and the upside of potential business risks, especially those associated with innovation. Stability for the long haul is not nearly as important as is working in an atmosphere that is charged with a sense of urgency and constant change.

Tags

SAS, Programmer, Clarity, Epic, SQL

Skills

These are some of the questions we asked our climbers about their experiences with Kaiser Permanente: