Skip to main content

Data Engineer, Internal facing Data Intelligence, UKIT

Posted: 18 Nov 2020 Closes: 18 Dec 2020
Leeds, Manchester, North Region UK Competitive
Permanent & Full-time 891299590

Job description

The UKDI data team continues to grow the UK Enterprise Data Platform (EDP). The team is modernising its data engineering practice and technology. This role is a vital part of that transformation and the successful candidate can expect to contribute to the growth of the in-house capability to build and operate a modern data platform. Candidates will need to be flexible and multi-skilled, clearly able to evidence technology pathfinding and mentoring skills that enable them to lead and develop others whilst also demonstrating flexibility and willingness progress work at all levels to a final deliverable. Candidates will be able to evidence a significant background in the "traditional" Microsoft data stack (SSIS, SSAS, SSRS, etc.) but must also have recent experience of the technologies associated with "big data" such as using Spark based platforms and data lakes in ETL/ELT solutions, such that they can clearly communicate how their own experience profile supports the transition described above.

PwC offers a fantastic work environment with offices throughout the UK and bases in all major regions. The team is highly distributed and team members enjoy world-class collaboration facilities which support staff to be productive whether they work from home or office.

Essential Skills
  • 4 months' experience developing data pipelines on a spark based platform such as Databricks with languages such as Python/PySpark (preferred), R or Scala and libraries such Pandas (or Koalas).
  • 18 months' commercial experience working with the Microsoft Azure data engineering platform...Azure Data Factory (v1-v2), Azure Data Lake (Gen1 & Gen2), Azure Blob Storage, Azure SQL Server, ADF Integration Runtime and SSIS IR.
  • 5 years' commercial experience developing developing SQL server database solutions using declarative development in Visual Studio and skills in T-SQL, SSIS, JSON, Powershell and C#
  • 3 years' experience of acting as a lead/senior data developer across at least 3 distinct projects with responsibility for overseeing/mentoring junior developers.
  • 3 years' commercial experience on logical and physical data modelling and strong knowledge of techniques such as dimensional modelling
  • Use of GIT and Azure DevOps (VSTS) with good understanding of code merges, pull requests, unit tests, branching strategies, build and release pipelines within a CI/CD DevOps model
  • Familiarity working within an Agile (Kanban/Scrum) environment in a product based development approach. In particular the definition, estimation, tracking and refinement of work items, acceptance criteria, identification of the MVP, approaches to vertical slicing and breaking work into manageable deliverables aligned to commercial value.

Personal Qualities

Candidates will be...
  • Demonstrating leadership and gravitas and able to evidence operating in a technology leadership/consultative mode, as against simply a developer working to specs
  • Flexible, responsible and self-starting, willing to "get stuck in" to get the job done, whatever task is needed from mundane to strategic and architectural
  • Experienced with clear evidence of successful assignments.
  • Excellent written and oral communication skills
  • Able to work independently but judge when to seek guidance and authority
  • Tenacious, able to work in and understand the issues associated with both mature and developing environments e.g. code-drift, management of legacy objects and tech-debt, balancing user-demand and platform growth
  • Demonstrate the ability to mentor technically and to "pathfind" with new technologies with a willingness to share knowledge and learn from others.

Beneficial skills

Candidates possessing the core skills will be particularly attractive where they can demonstrate the following (as commercial experience where stated) in addition to core skills.
  • 6+ months experience working with NoSQL data sources such as Mongo DB, CosmosDB and/or JSON/XML payloads from REST APIs
  • 6 month experience of developing or supporting the deployment of machine learning models
  • Experience of Data Vault 2
  • Commercial experience working on Azure SQL Data Warehouse
  • Authoring BIML and BIML script in automated development cycles or similar (T4)
  • VBA development
  • SAP ECC data use through SAP BW and/or HANA
  • Commercial experience of alternate cloud platforms e.g. AWS/GC
  • Commercial experience of the Hadoop ecosystem
  • Familiarity working within controlled application lifecycles and regulated industries.
  • Familiarity with the use of Google office productivity,
  • Experience of working with distributed teams, colleagues and stakeholders
  • The use of formal change control procedures, in particular use of the Service Now platform
Not the role for you?

Did you know PwC offer flexible contract arrangements as well as contingent work (ie temporary or day rate contracting)?
The skills we look for in future employees

All our people need to demonstrate the skills and behaviours that support us in delivering our business strategy. This is important to the work we do for our business, and our clients. These skills and behaviours make up our global leadership framework, 'The PwC Professional' and are made up of five core attributes; whole leadership, technical capabilities, business acumen, global acumen and relationships.

Learn more here:

Valuing Difference. Driving Inclusion.

We work in a changing world which offers great opportunities for people with diverse backgrounds and experiences. We seek to attract and employ the best people from the widest talent pool because creating value through diversity is what makes us strong as a business, enabling us to solve important problems and deliver value to our clients. We encourage an inclusive culture where people can be themselves, are valued for their strengths and are empowered to be the best they can be. As an organisation with an increasingly agile workforce, we also support different ways of working offering flexible working arrangements. Learn more here about our work to support an inclusive culture.


Share Job