Skip to Main Content

Kaiser Permanente Careers

Information Technology

Data Consultant - SAS and SQL

Location: Oakland, CA Job Number: 717434 Date posted: 07/11/2018
Description: Under general supervision, this position exists to assist the organization in making strategic data-related decisions by analyzing, manipulating, tracking, internally managing and reporting data. This position functions both as consultant and as a high-level statistical analytics programmer.

Essential Functions:
  • Designs and enhances databases.
  • Designs menu systems that are effective and user-friendly.
  • Develops reports with accurate, easy to read, useful information.
  • Designs and generates tracking and monitoring tools.
  • Participates in the development of outcomes and process measures, including technical specifications, to enable population measurement, guideline implementation, and evaluation.
  • Builds and maintains complex statistical routines using macros, vendor software, and software written by self and others.
  • Tests and maintains data integrity across multiple databases (internal SAS, DB2, VSAM; external: Adobe, Excel, SAS parsing routines, COBOL).
  • Builds sophisticated statistical models and forecasting tools using these databases.
  • Defines and frames complex multi-dimensional healthcare issues and develops time tables/processes for decision making.
  • Translates needs, issues, and ideas into effective strategies and action plans.
  • Formulates specific implementation plans and evaluates the effectiveness of actions/programs implemented.
  • Develops creative alternative solutions.
  • Works closely with IT and outside partners (and physicians for TPMG departments).
  • May coordinate team/project activities and schedules.
  • May assist in the determination of goals and priorities with team, clients, or project management sponsors.
  • May provide leadership to multi-disciplinary project teams.
  • Communicates results/recommendations to project sponsors, clients, and various senior level audiences (including physicians for TPMG departments).

  • Basic Qualifications:
    Experience
  • Minimum three (3) years of programming in SAS, SQL, VBA, .net or equivalent statistical analytical programming language.
  • Minimum of three (3) years of related analytical consulting experience.
    Education
  • Bachelor's degree in economics, finance, health care administration, public health administration, statistics, mathematics, operations
    research, or related field required OR four (4) years of experience in a directly related field.
  • High School Diploma or General Education Development (GED) required.
    Licenses, Certifications, Registrations
  • N/A.

    Additional Requirements:
  • Broad familiarity with medical practices, especially population management and process and outcomes measurement.
  • Experience with MVS/TSO operating systems required
  • Experience with analytical manipulation and interpretation of large databases required.
  • Microsoft Office skills required.
  • Very strong analytic and critical thinking skills, writing skills, communication skills, consulting skills, and ability to work within a team.
  • Ability to express complex analytical and technical information to senior management or to audiences with clinical training.
  • Must be an independent self-starter.
  • Must be able to work in a Labor/Management Partnership environment.

    Preferred Qualifications:
  • Master's degree preferred.
  • Analytical consulting experience in the healthcare field.
  • Knowledge of JCL strongly preferred.

    Additional Preferred Qualifications:
  • Previous Kaiser Permanente NCAL analytic experience preferred, with experience working with data sources from Health Connect, IDR, and KP Insight.
  • Substantial experience in acquisition of data from KP HealthConnect, including data extraction from Clarity.
  • Proven ability to aggregate data from disparate data sources.
  • Proven ability to analyze and synthesize large data sets using SAS and SQL, and communicate the story by highlighting operational implications.
  • Proven ability to work collaboratively with analytic staff from various departments.
  • Proven ability to be self directed and work independently.



    Primary Location: California,Oakland,1950 Franklin 1950 Franklin Scheduled Weekly Hours: 40 Shift: Day Workdays: Mon - Fri Working Hours Start: 8:00 AM Working Hours End: 5:00 PM Job Schedule: Full-time Job Type: Standard Employee Status: Regular Employee Group/Union Affiliation: Salaried, Non-Union, Exempt Job Level: Individual Contributor Job Category: Information Technology Department: Supportive Care Services Travel: No
    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.

    External hires must pass a background check/drug screen. Qualified applicants with arrest and/or conviction records will be considered for employment in a manner consistent with federal and state laws, as well as applicable local ordinances, including but not limited to the San Francisco and Los Angeles Fair Chance Ordinances.
  • Glassdoor Logo

    See What People are Saying About Working at KP

    Jan 18, 2018

    "Best place I've ever worked"

    Glassdoor Ratings

    Current Employee - Pharmacy Operations Regional Offices Manager in Downey, CA

    • Recommends
    • Positive Outlook
    • Approves of CEO

    I have been working at Kaiser Permanente full-time (More than 10 years)

    Pros

    A company that consistently focuses on doing the right thing for members, patients, employees, and communities. Employees are collaborative and consensus is prized. Company's mission is progressive. Employees' quality of life is an important consideration for management. Excellent benefits.Full Review

    More Kaiser Permanente Ratings & Reviews (3,975)

    Thanks
    to Our
    Employees

    Kaiser Permanente has been named one of the 2018 Best Places to Work. Check out what our employees like best about working at KP!

    glassdoor 2018 Best Places to Work - Employees' Choice

    Our Events

    Come introduce yourself to a member of the Kaiser Permanente team at an upcoming career or professional event. We look forward to meeting you in person.

    Recently Viewed Jobs

    You do not have any recently viewed jobs.

    Join Kaiser Permanente's Talent Network

    Please fill out the fields below and click "Join Now" to receive information about opportunities that relate to your selections.

    Interested InSearch for a category and select one from the list of suggestions. Search for a location and select one from the list of suggestions. Finally, click “Add” to create your job alert.

    • Information Technology, Oakland, California, United StatesRemove

    Interested in internships or early career opportunities? Click here to join our University Talent Network. Are you a Veteran? Click here to join our Military Talent Network.