Data Engineer / Developer at PricewaterhouseCoopers (PwC)

Job Description & Summary

A career in our Enterprise Data Management practice 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. You'll 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 a Senior 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:

• Use feedback and reflection to develop self awareness, personal strengths and address development areas.

• Delegate to others to provide stretch opportunities, coaching them to deliver results.

• Demonstrate critical thinking and the ability to bring order to unstructured problems.

• Use a broad range of tools and techniques to extract insights from current industry or sector trends.

• Review your work and that of others for quality, accuracy and relevance.

• Know how and when to use tools available for a given situation and can explain the reasons for this choice.

• Seek and embrace opportunities which give exposure to different situations, environments and perspectives.

• Use straightforward communication, in a structured way, when influencing and connecting with others.

• Able to read situations and modify behavior to build quality relationships.

• Uphold the firm's code of ethics and business conduct.

Services to be provided

• Technical design and architecting of data and integration solutions.

• Development and delivery of data and integration solutions.

• Technical support of existing products and platforms within the data environment.

• Collaboration within the data team to help bring about improvements and efficiencies relating to the technical data environment.

• Technical mentorship to junior staff within the data team and technical coaching as required to development teams.
   

Scope of services included

Delivery of assigned tasks as captured and assigned in the Data Engineering team’s product backlog or approved and assigned through a supported Africa Technology product line backlog or approved and assigned through the helpdesk solution by the Team Lead.

Scope of services excluded

Any tasks not specified in the Data Management team’s product backlog or supported Africa Technology product line backlog or helpdesk, unless agreed with the Team Lead.

Approach

• The position will report directly to the Team Lead.

• Projects and work tasks will be assigned through the Africa Technology scrum delivery process as prioritised and approved by the Team Lead.

• Adherence to PwC technical best practices and standards.

• All work tasks to be recorded, managed and delivered within the PwC standard work management platform (Azure DevOps).

• Adherence to PwC software development and release processes including, but not limited to, change and release controls, security, risk and governance.

• Maintenance of professional relationships and communication with key stakeholders.
   

Deliverables

• Product and environment support tasks as assigned through the product backlogs and helpdesk.

• Service Line project tasks as assigned through the Africa Tech Product Line backlogs.

• Data Engineering team project tasks related to internal projects.

• Technical documentation of solutions.

• Technical test cases.

• Technical input into delivery plans.

• Product analysis and evaluations.
   

Skills required

Essential skills:

• SQL

• T-SQL

• SSIS

• SSAS

• Alteryx (development)

• Power Bi (development)

• Azure Key Vault

• Azure Data Factory

• Azure Data Lake

• Azure SQL (serverless, memSQL)

• API development

• Database design

• Database security

• Database tuning

• Database monitoring

• Task automation/scheduling

• Data Warehouse (design and implementation)

• Data structures

Advantageous skills:

• Azure Purview

• Azure Databricks

• Python (Pyspark)

• Machine learning (basic understanding)

• Containerisation (basic understanding)

• Real-time data streaming (design and implementation)

• Azure Synapse (Pipelines, SQL, Python)