Consultant V - Database Developer/Integration Architect
Primary Location Pleasanton, California
Job Number 1250624 Date posted 02/15/2024
Navigating the Hiring Process
We're here to support you!
Having trouble with your account or have questions on the hiring process?
Please visit the FAQ page on our website for assistance.
Need help with your computer and browser settings?
Please visit the Technical Information page for assistance or reach out to the web manager at kp-hires@kp.org.
Do you need a reasonable accommodation due to a disability?
A reasonable accommodation is any modification or adjustment that enables you to fully participate in completing the following:
- Online Submissions
- Pre-Hire Assessments
- Interview Process
Please submit your accommodation request and an HR Representative will contact you.
Description:
Essential Responsibilities:
Job Summary:
The Applied Intelligence Solutions (AIS), is a Techno-Business Operations Team specializing in Automation and Technology, as it interacts with daily operational work. The work primarily involves understanding Operations in Claims, Membership Admin etc. and introducing effectual automations and solutions that simplify them and assist with quality that augments existing manual work. The incumbent must bring a strong understanding and knowledge of database design, implementation, troubleshooting and maintenance in both Oracle and MS SQL; that would be used to design and solutions that reduce some of the existing dependencies and integration with other applications/sources. The role would require working with and partner with multiple individuals and teams, and provide technical support to projects and solutions through recommendations and implementations. The role will also provide critical backup and on call support as needed.
Essential Responsibilities:
- Promotes learning in others by communicating information and providing advice to drive projects forward; builds relationships with cross-functional stakeholders. Listens, responds to, seeks, and addresses performance feedback; provides actionable feedback to others, including upward feedback to leadership and mentors junior team members. Practices self-leadership; creates and executes plans to capitalize on strengths and improve opportunity areas; influences team members within assigned team or unit. Adapts to competing demands and new responsibilities; adapts to and learns from change, challenges, and feedback. Models team collaboration within and across teams.
- Conducts or oversees business-specific projects by applying deep expertise in subject area; promotes adherence to all procedures and policies. Partners internally and externally to make effective business decisions; determines and carries out processes and methodologies; solves complex problems; escalates high-priority issues or risks, as appropriate; monitors progress and results. Develops work plans to meet business priorities and deadlines; coordinates and delegates resources to accomplish organizational goals. Recognizes and capitalizes on improvement opportunities; evaluates recommendations made; influences the completion of project tasks by others.
- Serves as a lead consultant to ensure the alignment, buy-in, and coordination of diverse stakeholders to drive the implementation of successful business initiatives and projects across multiple functional tracks or complex workstreams by identifying and ensuring representation and inclusion of appropriate stakeholders; building rapport and partnerships with key stakeholder teams, third party vendors, and senior management; working with stakeholders to develop goals and set the prioritization of deliverables; discussing involvement of business processes (e.g. project change management, communication) and facilitating decisions necessary for the delivery of business initiatives; communicating and resolving tough issues with stakeholders while maintaining an independent perspective; and making formal presentations and providing reports to executive level audiences.
- Develops requirements, or leads a team of consultants in the development of requirements, for complex or specialized business, process, or system solutions which may span multiple business domain(s) by partnering with stakeholders and cross-functional teams as appropriate; leveraging multiple business requirements gathering methodologies to identify business, functional, and non-functional requirements; and leading and overseeing the development and documentation of comprehensive business cases to assess the costs, benefits, and ROI of proposed solutions.
- Provides expertise and drives the development and implementation of business initiatives, systems, and/or processes to a desired future state by maintaining a comprehensive understanding of how current processes impact business operations across multiple domains; mapping current state against future state processes; identifying the operational impact of requirements on upstream and downstream solution components; providing options and recommendations to senior management and business stakeholders on how to integrate solutions and deliverables with current systems and business processes across regions or domains; and identifying and validating value gaps and opportunities for process enhancements or efficiencies.
- Develops business strategy and ensures alignment and prioritization of organizational objectives and business initiatives by defining, developing, and evaluating performance metrics, standards, and methods to establish business success; partnering with senior stakeholders, often with competing/conflicting objectives, to ensure cohesive and reachable metrics; refining strategic plans and performance metrics as appropriate; and managing complex initiatives or portfolio to ensure delivery of measurable results and alignment with strategic objectives.
- Serves as a lead advocate for continuous learning and professional development by keeping abreast of cutting edge industry practices, standards, and benchmarks; attending and presenting at roadshows, conferences, and speaking events; leading the ongoing enhancement and innovation of consulting practices, standards, and methods across KP; serving as an advocate to ensure continuous learning and improvement is championed as a people strategy; providing training and guidance to stakeholders as appropriate; and providing ongoing coaching to build a continuous improvement mindset and build capabilities that drive results.
- Manages complex projects or project components by coordinating stakeholder contacts; assembling team based on project needs and team member strengths; consulting in the development, analysis, and management of project plans; coordinating project schedules and resource forecasts; proactively monitoring and identifying project or business initiative risks, issues, and trigger events; developing mitigation plans and strategies; and resolving or escalating risks or issues as appropriate.
- Leads change management activities associated with business initiatives by engaging stakeholders to obtain support and buy in for changes; partnering with senior management, project champions, and process owners to communicate align improvement initiatives with business objectives; determining appropriate change management method and approach; and ensuring stakeholders embrace a change management mindset, understand intent and purpose, and foster a culture of change.
- Performs complex data analyses to drive business initiatives by identifying appropriate data analysis tools and approach to assess business performance; determining suitable data gathering and analysis methods (e.g., process observation, hard data, etc.); defining data requirements and obtaining customer agreements, including customer requirements as appropriate; conducting advanced analyses and performing experimental tests to evaluate the effectiveness of business solutions; and identifying and alleviating risks through data-driven analysis.
- Participates in vendor management as required by reviewing vendor performance levels; ensuring service level agreements are met; managing vendor invoices; and partnering with Procurement and/or Legal to develop service level and/or scope of work agreements as appropriate.
- Monitors compliance of work activities by ensuring business plans and team members adhere to KP, departmental, and/or business line policies and procedures.
Minimum Qualifications:
- Minimum two (2) years experience in a leadership role with or without direct reports.
- Bachelors degree from an accredited college or university and Minimum eight (8) years experience in consulting, project management, data analytics, operations or a directly related field OR Masters degree in Business, Public Health, or a directly related field and Minimum six (6) years experience in consulting, project management, data analytics, operations or a directly related field OR Minimum ten (10) years experience in consulting, project management, data analytics, operations or a directly related field.
Additional Requirements:
- Knowledge, Skills, and Abilities (KSAs): Business Acumen; Change Management; Negotiation; Creativity; Applied Data Analysis; Financial Acumen; Conflict Resolution; Managing Diverse Relationships; Process Validation; Project Management; Risk Assessment; Service Focus; Requirements Elicitation & Analysis
Preferred Qualifications:
- Three (3) years data analytics experience.
- Three (3) years experience working with advanced Excel functions including, formulas, pivot tables, vlookup, macros, etc.
- Five (5) years of relational database experience
- Three (3) years experience setting up architectures and data modelling
- Six (6) years experience working with MS SQL
- Six (6) years experience working with Oracle
- Seven (7) years programming experience
- One year experience of health care payer development experience
- Knowledge in text analytics
Primary Location: California,Pleasanton,Pleasanton Tech Cntr Building B
Scheduled Weekly Hours: 40
Shift: Day
Workdays: Mon, Tue, Wed, Thu, Fri
Working Hours Start: 08:00 AM
Working Hours End: 04: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: Consulting
Department: Po/Ho Corp - HPPSA AIS Team - 0315
Pay Range: $140600 - $181940 / 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
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
