Database Architect​/Management V - Azure Databricks

Overview:

Interacts and consults with cross‑functional stakeholders to understand needs for KP Sales & Marketing Experience (KPx) Platform‑s priorities (epics, features, stories) as a member of the integrated KP Sales & Marketing Experience Platform‑s Dev Ops 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‑s unified 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.

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.

• 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;…