2 days ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
South African Technology & Innovation Centre (SATIC) is the latest part of PwC, a global brand delivering services for the biggest clients in the world. PwC leads the way in human led, technology enabled professional services, working with clients to transform their business and make it fit for the future.
We are looking for candidates who bring in-depth market experience, who see technology as a way to enable and drive human innovation and who want to be a part of a community of solvers, to tackle the biggest challenges in society.
If you are looking for a career where every day is different, where challenges are complex and where you can make a real difference, then we want to hear from you. By choosing to join SATIC, you are choosing to work with teams all over the world, harnessing the power of world leading tech and making a difference to real people’s lives.
Requirements :
Qualifications / certifications
- Relevant tertiary qualification
- Certified in MS SQL (advantageous)
- Certified in Power BI (advantageous)
Experience & skills
3-5 relevant years’ experience in data engineering / data infrastructureStrong analytical skills to troubleshoot and optimize data infrastructure environments and services.Ability to collaborate with data engineers and other LoS stakeholders to understand data needs and convey technical concepts clearly.Ability to ensure data service availability through monitoring, troubleshooting and improvement.Ability to determine environment health metrics and measures and report on concerns and improvements to stakeholders.Technical skills :
Ability to develop Terraform scripts used for Azure Infrastructure as Code deployments.Strong understanding and experience with implementing Azure security controls.Solid understanding of Azure data services and tuning e.g. Synapse.Ability to develop a robust Azure data services and pipeline monitoring capability.Ability to automate pipeline tasks and scheduling.SQLT-SQLSSISPower BIKey responsibilities :
A senior Data Infrastructure Engineer has proven skills, ability and a delivery track record over several years and is able to work independently as well as within teams as a subject matter expert. Depending on the level of seniority, the engineer will be given responsibility for more technically challenging projects with greater financial impact and risk to the firm. Responsibilities will include, but not be limited to :
System Management
Overseeing the day-to-day operations of the Africa cloud data environment and warehouse, ensuring it runs smoothly and efficiently.Ensure the availability of services and data in line with SLA requirements.Perform root cause analysis of issues occurring in the data services environment and warehouse to ensure permanent resolution.Power BI gateway support for local Africa data access to cloud.Data Accuracy
Ensuring the accuracy and integrity of data stored in the warehouse by resolving any issues that arise.Environment Services Design and Implementation
Designing and implementing the Africa data environment services to meet business needs.Deployment of new data infrastructure services or changes through Terraform scripts.Deployment of pipeline workloads to staging and production environments.Set up and management of data connections.Set up of APIM service connectivity.Set up of data catalogue service connectivity.Performance Monitoring
Monitoring the performance of the data warehouse to ensure high availability and optimal performance.Documenting and reporting on environment services and workload performance, including identification of issues, adherence to SLAs and proactive improvement suggestions.Backup and Recovery
Ensure that effective disaster recovery (DR) and backup processes are in place.Perform annual DR testing.Ensure that any database backups run correctly, and data is accurate, secure and recoverable.Security and Compliance
Ensuring that the data warehouse complies with security and regulatory requirements by monitoring access and usage.Set up and management of system and user accounts and security.Encryption of data at rest and in transit.Conduct quarterly access reviews and confirmations.Ensure that end point security and access is managed and restricted to least privilege.Ensure that security reviews are done whenever there are significant changes to the environment services.Application of retention management to data stored in the data warehouse in line with the PwC retention policy and schedule.Upgrades and Maintenance
Testing and verifying upgrades and patches made by GHC to keep the environment services up-to-date and secure.Performing annual upgrades of the Terraform scripts used to deploy environment services.Application Database Support (On Demand)
Provide SQL DBA consulting services to teams.Assist teams with DB patching and configuration in line with PwC requirements and standards.Working with product teams and LoS stakeholders to understand data needs and ensure data environment services are available and usable.Engagement with PwC IT Services and Global Hosting Centre teams to manage environment hosting services and issue resolution.Attend design session to provide input into data infrastructure requirements for solutions.Develop technical designs and technical steps to meet data infrastructure requirements and provide timelines that feed into overall project delivery.Engage with local and global technical teams to determine dependencies and incorporate timelines and dependency steps into delivery considerations and timelines.Technical Mentorship and Training
Act as a mentor to junior staff within the team.Provide input into the development of technical training curriculums.Provide technical input into data communities of interest and practice.Role Overview :
The Data Infrastructure Engineer implements and supports the data services architecture and environment services (the Africa Data Warehouse). The Infrastructure Engineer monitors the environment and ensures that the necessary management processes are applied to optimise efficiency and provide a secure, robust, and scalable service. The Infrastructure Engineer also provides additional data services relating to tool and application database support e.g. Power BI and SQL
Seniority Level
AssociateEmployment Type
Full-timeJob Function
Information Technology and ConsultingIndustries
Business Consulting and ServicesIT ServicesIT Consulting#J-18808-Ljbffr
