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.

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.

Key responsibilities

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

Key skills

 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