Database Architect/Management V - Azure Databricks

Overview:

Interacts and consults with cross-functional stakeholders to understand needs for KP Sales & Marketing Experience (KPx) Platform-spriorities (epics, features, stories) as a member of the integrated KP Sales & Marketing Experience Platform-sDevOps team. Interprets requirements to align with technical architecture and development priorities, developing them into agile requirements. Designs and architects database models and schemas for the KPx Platform-sunified profile, activation, reporting, and analytics solutions in collaboration with the development team and partners to align data architecture and regulatory requirements. Ensures quality, validation, and efficiency of solutions through ongoing performance and scalability optimizations, while championing and enforcing modern best practices and standards-enterprise-wide and industry-recognized-in data management, architecture, and warehousing to guarantee consistency, reliability, and compliance.

Job Summary:

This individual contributor is primarily responsible for driving strategic data-informed decisions, driving efforts to ensure data and resources are available to users in an orderly and secure way through data provisioning and ongoing security, and analyzing and developing database designs, data models, and relational data definitions in support of systems requirements. This position provides ongoing database support, maintenance, and troubleshooting, drives data strategy efforts, and designs, implements, and automates business and reporting solutions.

Essential Responsibilities:

• Practices self-leadership and promotes learning in others by building relationships with cross-functional stakeholders; communicating information and providing advice to drive projects forward; influencing team members within assigned unit; listening and responding to, seeking, and addressing performance feedback; adapting to competing demands and new responsibilities; providing feedback to others, including upward feedback to leadership and mentoring junior team members; creating and executing plans to capitalize on strengths and develop weaknesses; and adapting to and learning from change, difficulties, and feedback.
• Conducts or oversees business-specific projects by applying deep expertise in subject area; promoting adherence to all procedures and policies; developing work plans to meet business priorities and deadlines; determining and carrying out processes and methodologies; coordinating and delegating resources to accomplish organizational goals; partnering internally and externally to make effective business decisions; solving complex problems; escalating issues or risks as appropriate; monitoring progress and results; recognizing and capitalizing on improvement opportunities; and evaluating recommendations made by others.
• Designs, implements, and automates business and reporting solutions by partnering with stakeholders to advise in their design, planning, and implementation while ensuring consistency and coherency; evaluating and summarizing data and results; creating summary statistics; designing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; reporting to stakeholders on key findings; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
• Drives efforts to ensure data and resources are available to users in an orderly and secure way through data provisioning and ongoing security by translating business analytics needs into data access requirements; creating, preparing, and enabling systems to provide data to users; granting users access to data repositories or systems, applications, and databases based on a unique user identity; managing and monitoring data access on an ongoing basis; tracking and documenting version control; designing and generating tracking and monitoring tools; tracking and reporting on data access; and ensuring data provisioning efforts adhere to IT compliance standards, policies, and procedures.
• Provides ongoing database support, maintenance, and troubleshooting by identifying and fixing problems; locating and correcting oversights; ensuring the database meets expectations; identifying trends in the database users; ensuring optimized database performance; recommending new ways to improve the existing database; and scheduling times for upgrades and repairs for minimal impact to the company.
• Drives strategic data-informed decisions by consulting with clients and leadership to identify and clarify key business needs across functional areas, business and/or clinical lines; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing complex analysis plans; evaluating the impact of business decisions on clients, customers, and/or members; partnering with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.
• Analyzes and develops database designs, data models, and relational data definitions in support of systems requirements by assessing the current data infrastructure; identifying areas in need of change; determining how the database should look and function; scoping the database using the ETL Architecture Standards; developing code to create the database; creating database security standards; and testing and maintaining data integrity across multiple internal and/or external databases.
• Drives data strategy efforts by ensuring proper identification and representation of content; determining optimal data storage methodologies; ensuring data are packaged in a way to be reused and shared; developing and ensuring adherence to data rules and access guidelines; determining best strategy for combining data residing in disparate systems into a unified, consistent data view; and establishing, managing, and communicating information policies and mechanisms for effective data usage.
  
  

Minimum Qualifications:

• Minimum three (3) years experience in a leadership role with or without direct reports.
• Bachelors degree in Mathematics, Statistics, Computer Science, Engineering, Social/Physical/Life Science, Business, or related field and Minimum eight (8) years experience in database configuration, architecture or management, or a directly related field. Additional equivalent work experience in a directly related field may be substituted for the degree requirement.
  
  

Additional Requirements:

• Knowledge, Skills, and Abilities (KSAs): Negotiation; Data Extraction; Data Visualization Tools; Statistical Programming Language; Relational Database Management; Vendor Management; Delegation; Project Management
  
  

Preferred Qualifications:

• Three (3) years database maintenance experience, including performance tuning and query optimization.
• Three (3) years experience working with cloud database services (e.g., Microsoft Azure).
• Three (3) years experience working with quality management and data profiling tools.
• Three (3) years experience working with SQL.
• Three (3) years experience working with Open Source Tools (e g , R, Python).
• Two (2) years experience delivering presentations to senior management.
• Three (3) years project management experience.
• Two (2) years experience in process improvement.
• Three (3) years experience working with business intelligence tools.
• Three (3) years experience working with data extraction and manipulation language and ETL tools (e.g., SSIS, Informatica, Ab Initio, etc.).
  
  

Primary Location: California,Oakland,Ordway

Scheduled Weekly Hours: 40

Shift: Day

Workdays: Mon, Tue, Wed, Thu, Fri

Working Hours Start: 09:00 AM

Working Hours End: 05:00 PM

Job Schedule: Full-time

Job Type: Standard

Worker Location: Remote

Employee Status: Regular

Employee Group/Union Affiliation: NUE-PO-01|NUE|Non Union Employee

Job Level: Individual Contributor

Department: Po/Ho Corp - HP PROD-MRKTG Resrch & Analyss - 7016

Pay Range: $166100 - $214940 / year Kaiser Permanente is committed to pay equity and transparency. The posted pay range is based on possible base salaries for the role and does not include the value of our total rewards package. Actual pay determined at offer will be based on years of relevant work experience, education, certifications, skills and geographic location along with a review of current employees in similar roles to ensure that pay equity is achieved and maintained across Kaiser Permanente.

Travel: Yes, 10 % of the Time

Remote: Work location is the remote workplace (from home) within KP authorized states. Worker location must align with Kaiser Permanente's Authorized States policy. Kaiser Permanente is an equal opportunity employer committed to fair, respectful, and inclusive workplaces. Applicants will be considered for employment without regard to race, religion, sex, age, national origin, disability, veteran status, or any other protected characteristic or status.