Connecting to LinkedIn...

Data Developer

Job Title: Data Developer
Contract Type: Permanent
Location: London
Industry:
Salary: Not Specified
Reference: 41673020
Job Published: January 23, 2021 18:33

Job Description

Job Description

Reporting into the Data Engineering & Strategy Manager the core of this role will involve developing our profitability data models and maintaining existing data assets., Our data models currently reside in a high-availability SQL Server based environment, you will be responsible for further development of the models ranging from prioritisation of work around Asda's core business strategy, identifying requirements with the business, modelling data, hands-on development work, testing and validation back with business teams and Finance.

You will help to ensure solutions that we develop are aligned with Technology policies and roadmap and contribute to our strategies on data for Business Services, Finance, Asda Technology, and the wider Asda business. A typical day may look like monitoring daily data movements in and out of our environment and resolving any issues, spending time developing tables, stored procedures and SSIS packages to add new data assets to the system and meeting with stakeholders across the business to work on data problems and prioritise requirements.

Candidate Description

  • Previous experience using the SQL Server 2017/2016/2014 business intelligence stack in a developer or database administrator role

  • High proficiency in the use of SQL for querying of databases, database development and database administration tasks

  • Prior use of database design and data modelling techniques

  • Prior experience working with large-scale (10+ Terabyte) data warehouses and databases with a large user base (150+ users)

  • Knowledge of data warehousing and dimensional data modelling techniques (Kimball methodology)

  • Use of SQL Server Integration Services (SSIS) to manage data warehousing ETL and good knowledge of data engineering techniques

  • Use of Alteryx (or similar) to perform pre-development data profiling and analysis

  • Able to effectively communicate at the right level with technical, non-technical and senior business stakeholders alike

  • An understanding of how Business Intelligence tools (PowerBI, Tableau) consume data from data warehouse and being able to optimise data structures for consumption

  • Able to performance tune, optimise and debug SQL code