Kaiser Permanente Sr Data Consultant - SQL, SAS in Oakland, California
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 takes an active leadership role both as a consultant and as a high-level statistical analytics programmer.Essential Functions:- Leads, makes significant contributions, &/or provides technical leadership to high visibility projects to identify & resolve issues of strategic importance to the organization.- Interfaces regularly w/ Sr Mgmt to produce timely & valuable results.- Directs the development of outcomes & process measures, including technical specifications, to enable population measurement, guideline implementation, & evaluation.- Builds & maintains complex statistical routines using macros, vendor software, & software written by self & others.- Tests & maintains data integrity across multiple databases (internal SAS, DB2, VSAM; external: Adobe, Excel, SAS parsing routines, COBOL).- Builds sophisticated statistical models & forecasting tools using these databases.- Designs & enhances databases.- Designs menu systems that are effective & user-friendly.- Develops reports w/ accurate, easy to read, useful information that satisfies the client's needs.- Designs & generates tracking & monitoring tools.- Designs research plans for data gathering & analysis; participates significantly in interpreting analyses & developing action plans accordingly. - Defines & frames complex multi-dimensional healthcare issues & develops time tables/processes for decision making.- Translates needs, issues, & ideas into effective strategies & action plans.- Formulates specific implementation plans & evaluates the effectiveness of actions/programs implemented. Develops creative alternative solutions. - Works closely w/ IT & outside partners (& physicians for TPMG Depts).- Sets the strategic direction of projects.- Determines goals & priorities w/ team, clients, or project Mgmt sponsors (when appropriate).- May coordinate team/project activities & schedules.- May establish team membership & project participants, provide leadership to multi-disciplinary project teams, as well as manage work of outside consultants when used.- Communicates results/recommendations to project sponsors, clients, & various Sr level audiences (including physicians for TPMG Depts). - May participate in the development & Mgmt of the Dept, including coaching & recruiting for consultants/analysts & other departmental activities.- KP conducts compensation reviews of positions on a routine basis. At any time, KP reserves the right to reevaluate & change job descriptions, or to change such positions from salaried to hourly pay status. Such changes are generally implemented only after notice is given to affected employees.
This position is part of a large, talented, and collaborative team of analytic programmers who enjoy working in a fast-paced, improvement oriented environment using SAS and/or SQL as the primary programming tools.- Our work supports strategic imperatives sponsored by medical group executive leadership in the areas of clinical quality and healthcare operations.
We foster a learning environment for further development of technical and consulting skills.
You will be responsible for scoping out new projects, managing multiple projects, maintaining open lines of communication with clients and sometimes consulting with other departments and regions.
The work involves analyzing multiple large relational data sources, extracting and processing needed data into an accurate and intuitive visualization (in Tableau or Excel) for analysis and reporting.- Other duties include problem solving data and reporting issues, and researching the electronic medical record.
Basic Qualifications:Experience- Minimum five (5) years of programming in SAS, SQL, VBA, .net or equivalent statistical analytical programming language.- Minimum five (5) years of related analytical consulting experience.Education- Master's degree in economics, finance, health care administration, public health administration, statistics, mathematics, operations research, or related field required, or equivalent bachelor's degree and two (2) years additional work experience in lieu of a master's degree.License, Certification, Registration- N/A Additional Requirements:- Experience with analytical manipulation and interpretation of large databases.- Experience with MVS/TSO operating systems.- Exceptional 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.- Proven leadership in consulting and, for some areas, project management. Must exhibit efficiency, collaboration, candor, openness, and results orientation.- Broad familiarity with medical practices, especially population management and process and outcomes measurement.- Must be an independent self-starter.- Microsoft Office skills required.- Must be able to work in a Labor/Management Partnership environment.
Preferred Qualifications:- Knowledge of JCL strongly preferred.
TITLE: Sr Data Consultant - SQL, SAS
LOCATION: Oakland, California
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, state and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran, or disability status.