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 provided Monitor and report on the health of our SQL db environment - databases and integrations. Providing monthly stakeholder reports and proactive input on the health of their products database environment, potential risks and improvements. Assist teams with implementing and configuring SQL databases, integrations and data models - local network and Azure. Assist the Data Engineering team with the migration of their local on-premise SQL data warehouse environment to Azure. Remediation of any security audit findings to ensure that the data environment is secure and effectively managed. Monitor the data requests job queue and deal with business requests and incidents. Adhere to our IT change and release processes. Creating and updating backlog and sprint tasks in Azure DevOps. Collaboration within the data team to help bring about improvements and efficiencies relating to the technical data environment. Collaboration with our security and risk teams to ensure that our environment and deliverables meet PwC and industry standards. 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 teams 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 teams product backlog or job queue, unless agreed with the Team Lead. Approach 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. Projects and work tasks will be assigned through the Scrum process as prioritized and approved by the DE team lead in Azure DevOps. Adherence to PwC technical best practices and standards. Adherence to PwC software development and release processes including, but not limited to, change and release controls, security, risk and governance. 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/scheduling Data environment documentation and reporting Product and environment support tasks as assigned through the product backlogs and helpdesk. Data Engineering team project tasks related to internal projects. Technical input into delivery plans.Skills required Essential skills: SQL T-SQL SSIS SSAS Database design Database security Database tuning Database monitoring Task automation/scheduling Advantageous skills: Alteryx server management Power BI Azure Data Factory Azure Data Lake Azure Blob Storage Azure SQL Azure SynapseTerraform Minimum qualifications A Bachelors Degree in Computer Science, Information Technology or Equivalent Qualification Technology certifications AZ-900 , DP - 300 or AZ-104 Minimum experience 3+ years Database Administration 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