Job Description

Line of Service Internal Firm ServicesIndustry/Sector Not ApplicableSpecialism IFS - Information Technology (IT)Management Level Associate & Summary A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.Our team helps businesses develop data management technology that addresses architecture and governance frameworks that transform data into insight and action. We help organisations better manage the complexity of their enterprise data, reducing costs, ensuring the integrity of information assets, and enhancing performance through better information and refined decision making capabilities.To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be a purpose-led and values-driven leader at every level. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.As an Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:

• Invite and give in the moment feedback in a constructive manner.
• Share and collaborate effectively with others.
• Identify and make suggestions for improvements when problems and/or opportunities arise.
• Handle, manipulate and analyse data and information responsibly.
• Follow risk management and compliance procedures.
• Keep up-to-date with developments in area of specialism.
• Communicate confidently in a clear, concise and articulate manner - verbally and in the materials I produce.
• Build and maintain an internal and external network.
• Seek opportunities to learn about how PwC works as a global network of firms.
• Uphold the firm's code of ethics and business conduct.

Position Intermediate Database AdministratorService Line Africa TechnologyTeam Data Engineering Services to be providedxe2x97x8f Monitor and report on the health of our SQL db environment - databases and integrations.xe2x97x8f Providing monthly stakeholder reports and proactive input on the health of their products database environment, potential risks and improvements.xe2x97x8f Assist teams with implementing and configuring SQL databases, integrations and data models - local network and Azure. xe2x97x8f Assist the Data Engineering team with the migration of their local on-premise SQL data warehouse environment to Azure.xe2x97x8f Remediation of any security audit findings to ensure that the data environment is secure and effectively managed.xe2x97x8f Monitor the data requests job queue and deal with business requests and incidents.xe2x97x8f Adhere to our IT change and release processes.xe2x97x8f Creating and updating backlog and sprint tasks in Azure DevOps.xe2x97x8f Collaboration within the data team to help bring about improvements and efficiencies relating to the technical data environment.xe2x97x8f Collaboration with our security and risk teams to ensure that our environment and deliverables meet PwC and industry standards.xe2x97x8f Technical documentation of the data environment, updating this with any changes implemented. Scope of services included Database administration tasks and projects in support of the Africa data environment.Delivery of assigned tasks as captured and assigned in the Data teamxe2x80x99s product backlog and job queue. Engagement with, and support to, our internal business teams, ensuring that we apply best practices and standards across the Africa firm. Scope of services excluded Any tasks not specified in the Data teamxe2x80x99s product backlog or job queue, unless agreed with the Team Lead. Approachxe2x97x8f The position will report to the DBA stream lead with overall feedback to the Data Engineering team lead as a capability within the Africa Data Office.xe2x97x8f Projects and work tasks will be assigned through the Scrum process as prioritized and approved by the DE team lead in Azure DevOps.xe2x97x8f Adherence to PwC technical best practices and standards.xe2x97x8f Adherence to PwC software development and release processes including, but not limited to, change and release controls, security, risk and governance.xe2x97x8f Development of professional relationships and communication with key stakeholders to manage expectations and build trust. DeliverablesDatabase implementation and support requirements, such as:xe2x97x8b Environment design (with assistance from the DBA stream lead)xe2x97x8b Environment upgradesxe2x97x8b Environment patchingxe2x97x8b Environment backup and ensuring high availabilityxe2x97x8b Environment securityxe2x97x8b Environment tuningxe2x97x8b Environment monitoringxe2x97x8b Task automation/schedulingxe2x97x8f Data environment documentation and reportingxe2x97x8f Product and environment support tasks as assigned through the product backlogs and helpdesk.xe2x97x8f Data Engineering team project tasks related to internal projects.xe2x97x8f Technical input into delivery plans.Skills required Essential skills:xe2x97x8f SQLxe2x97x8f T-SQLxe2x97x8f SSISxe2x97x8f SSASxe2x97x8f Database designxe2x97x8f Database securityxe2x97x8f Database tuningxe2x97x8f Database monitoringxe2x97x8f Task automation/scheduling Advantageous skills:xe2x97x8f Alteryx server managementxe2x97x8f Power BIxe2x97x8f Azure Data Factoryxe2x97x8f Azure Data Lakexe2x97x8f Azure Blob Storagexe2x97x8f Azure SQLxe2x97x8f Azure SynapseTerraform Minimum qualificationsxe2x97x8f A Bachelorxe2x80x99s Degree in Computer Science, Information Technology or Equivalent Qualificationxe2x97x8f Technology certifications AZ-900 , DP - 300 or AZ-104 Minimum experiencexe2x97x8f 3+ years Database Administrationxe2x97x8f 3+ years DataWarehouse and reportingEducation (if blank, degree and/or field of study not specified) Degrees/Field of Study required:Degrees/Field of Study preferred:Certifications (if blank, certifications not specified)Required SkillsOptional SkillsDesired Languages (If blank, desired languages not specified)Travel Requirements Up to 20%Available for Work Visa Sponsorship? NoGovernment Clearance Required? YesJob Posting End Date March 28, 2024

PwC