|Job Title:||Data Developer|
|Job Published:||January 23, 2021 18:33|
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.
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
Get similar jobs like these by email
By submitting your details you agree to our T&C's