Data Engineer - Tesco Mobile

Data Engineer

Location: This is a Hybrid role with a mix of WFH and office. Our offices are based in London / Manchester / Slough and Welwyn Garden City. The Data squad come together at our Slough office every 3 weeks for Agile planning, retros etc.

About the role

The Data Platforms Squad is primarily concerned with sourcing, managing and providing data. The data comprehensively records customer interactions with the business and helps Tesco Mobile deliver industry-leading customer experience as well as the ability to be innovative and profitable.

As a member of the squad you will be tasked with providing innovative and resilient solutions to the various challenges that arise.

You will be undertaking all aspects of the development lifecycle and be experienced in data modelling, process design, development and testing.  Most development will initially be in the form of SQL stored procedures and scripting, with some use of SSIS and PowerBI.

With ambitious plans to better exploit the data lake at our disposal by migrating data to an Azure/Databricks environment this is an opportunity to be at the cutting edge of data engineering.

You will work closely with the Data Platforms Product Owner to deliver capability wherever the greatest business need exists.

About the team 

The Data, Insight & Analytics Tribe is building a platform for the future that delivers capability to delight customers (external and internal) whilst also driving a culture where every decision is powered by data.

The Data Platforms Squad is the fulcrum point for data within Tesco Mobile, sourcing data from multiple sources and making it available to various teams / systems / third parties around the business for BI / CRM and various BSS systems. 

The team manages multiple data platforms, among them the core Insight database, an Azure/Databricks analytics platform, an operational data store in Azure supporting APIs and a platform supporting the data generated by a real-time billing system.

In support of the business’ long-term strategic ambition to become a leader in data-driven modelling and decision-making it has a vital role to play in all activities the business undertakes.

As a Data Engineer you will:

• Belong to the Data Platforms Squad responsible for end-to-end delivery of a product to deliver value
• Bring your individual expertise to the squad to deliver at pace using short cycles of experimentation with a ‘fail-fast-learn-fast’ attitude
• Participate in all squad ceremonies and events, raising impediments as soon as identified to facilitate delivery
• Inspect and adapt your way of working for continuous improvement
• Embody an Agile mindset and culture to contribute to the growth in agile maturity of our business
• Work in cycles of sprints, using priorities set through the product backlog
• Be an autonomous, trusted decision maker able to self-organise use your knowledge and expertise to deliver the right solution for the customer
• Develop and support applications using SQL Server 2012 through SQL Server 2019, T-SQL, SSIS, VB Script, Python
• Be responsible for maintaining data security
• Provide project support
• Perform SQL server database administration
• Monitor performance 
• Perform database housekeeping
• Complete requirements capture/design
• Perform data modelling
• Provide ad-hoc support to Tribes and Centres of Excellence across the business

Essential

• Extensive SQL Server development experience
• Stored procedure development
• Experience of dealing with large datafeeds / files
• Understanding of database encryption
• Understanding of GDPR and management of data
• Understanding performance tuning and optimisation
• Ability to resolve data-related problems
• Ability to communicate with both technical and non-technical people, effectively and constructively
• Ability to collaborate and work effectively in a team

Desired

• CRM experience
• SQL Server 2012-2019
• QlikView
• PowerBI
• SSIS
• Python
• Exposure to Azure/Databricks
• Knowledge of SQL server database administration
• Job scheduling
• VBScript/Powershell
• sFTP \ S3 
• Excel
• Data modelling
• API/Web services development

We offer excellent benefits that help make Tesco a great place to work. These include but aren’t limited to:

• Annual bonus scheme 
• Holiday starting at 25 days plus a personal day rising to 22 days after 12 months (plus 8 Bank holidays)
• On-site state of the art gym at our Welwyn Campus with discounted “Gympass” membership & free health checks via Nuffield Health
• Retirement savings plan - save between 4% and 7.5% and Tesco will match your contribution
• Life Assurance - 5 x contractual pay
• Share Schemes – Join our ‘Buy As You Earn’ & ‘Save As You Earn’ share schemes after 3 months service
• Colleague Clubcard (including a 2nd card for a family member) after 3 months service
• Colleague Discounts:
  • 10% increasing to 15% after every pay day for a four day period, off most purchases at Tesco
  • 10% off One Stop
  • 10% off pay monthly & SIM only deals with Tesco Mobile
  • 20% off all F&F purchases
  • 20% off car, pet and home insurance at Tesco bank. T&C’s apply
  • 25% off Tesco Café
  • 50% off complete glasses purchases & free eye tests (other offers available) at Vision Express
  • 50% off health checks at Tesco Pharmacy
• An exclusive deals and discounts website saving you money on everyday purchases, treats for the family, eating out and utility bills for the home
• Cycle to work scheme
• Shuttle Bus Service to/from Welwyn Garden City Station to Welwyn Campus
• Opportunities to get on - take advantage of our ongoing learning opportunities and award-winning training, to help you achieve the job and career you want
• Our Employee Assistance Programme helps you deal with life’s challenges
• Financial wellness - Tesco has partnered with experts to help you make the most of your money
• Get involved in a range of fundraising activities with our long-term charity partners

A 50-50 joint venture between Tesco and Telefónica O2 that was established back in 2003, Tesco Mobile has gone from strength to strength as we’ve launched into new services and markets. With more than 5 million customers, we’re the largest mobile virtual network operator in the UK. We’re proud to have an inclusive culture that’s uniquely Tesco Mobile, with a strong sense of community, plus all the benefits of working for one of the shareholders.

We care for human connection and we keep our customers at the heart of everything we do, which is why we’ve embraced the Agile way of working. Agile is more than just a methodology – it’s a liberating journey that puts customers and purpose first. It empowers us to self-organise, collaborate, co-create and rapidly inspect and adapt everything we do – allowing us to respond at pace to our customers’ needs. It encourages variety of thought and enables us to thrive, both individually and collectively.

We pride ourselves on being a company where everyone’s welcome and truly feels able to be themselves. We not only celebrate diversity but recognise the value and opportunity it brings in helping us to serving our customers, communities and planet a little better every day. We strive to build a workforce that reflects our customers, not only here in the UK, but worldwide. In offering many varying working patterns across our business, our aim is to attract a diverse range of applicants from all walks of life. If you’re as passionate as we are about providing the best customer experience, we’d love to hear from you.

We have recently announced that we will be moving towards a more blended working week – combining office and remote working.  Our base will be the office, where we connect, collaborate and innovate – and there will be the expectation for everyone to be in the office more often than not. For Head Office roles we therefore expect colleagues to spend a proportion of their time at our offices.

 We are supportive of colleagues having conversations with hiring managers about what office presence will look like in the context of the role.