Role Summary
This role requires an experienced and technically skilled Senior Data Engineer to play a key role in our Data & Reporting team and drive the transformation of reporting services and data infrastructure, whilst acting as a mentor to Engineers.
You’ll be accountable for developing and optimising our Azure-based data warehouse and pipelines, with a specific focus on enhancing and optimising SSAS (SQL Server Analysis Services) models and architecture. You will lead ETL processes, ensure high data quality, and enable robust, scalable data solutions.
You will facilitate data from multiple custom internal and external sources, using a wide range of applications, to target endpoints such as Power BI. You will work with internal and external stakeholders across the organisation to develop fit-for-purpose, analytically correct datasets and will be constantly looking at architectural improvements whilst ensuring the reliability, accuracy, and performance of ETL processes.
Responsibilities
* Apply best practice to Star/Snowflake schema data modelling
* Lead the addition of new data sources to the Data Lake from 3rd party sources
* Assist with understanding internal customer requirements, technical design, and estimation
* Lead ETL, common data structures and business intelligence architectures
* Operate in a support capacity to the business, troubleshooting issues with data pipelines
* Develop Data models from existing Data Sources
* Undertake code reviews and provide constructive feedback
* Assist other members of the Data & Reporting team with integration and system-specific tasks
* Develop and update technical documentation
* Act as a mentor to junior team members
Skills and Experience
* 2.1 or higher degree in Computer Science, or related Information Technology subject
* 3+ years experience working with cloud infrastructure and data modelling
* Significant experience working with Azure Data Factory and LogicApps creating pipelines ingesting data from multiple sources
* Advanced T‑SQL skills and Python essential
* Experience of Azure cloud stack services – Dynamics D365, Databases, Warehouses, Storage, Datalake, Power Automate, Data Factory, Visual Studio, Devops, Power BI, MS Fabric
* Strong interest in analytics, data architecture and modelling
* Experience of enterprise software, Azure Cloud apps, databases, data models
* Understanding of Business Intelligence services and data integration processes (ETL)
* Adept at disseminating large sets of mixed content unstructured data into clean, efficient, correctly modelled datasets
Key Contacts and Relationships
* Data & Reporting Team – collaborate closely to support ETL processes, troubleshoot data pipeline issues, and improve data architecture
* Internal Stakeholders – work with various departments (finance, operations, marketing) to understand data requirements and provide fit-for-purpose analytical datasets
* External Vendors – coordinate with third‑party providers for integration of external data sources into the Data Lake
* IT and Digital Teams – collaborate on infrastructure improvements, cloud architecture optimisation, and technical design
Benefits
* 60% off FatFace products
* 25% discount at Next stores (full price products)
* Discounted gym membership
* Cycle to Work scheme
* EV vehicle scheme
* Pension scheme – with net deduction and salary sacrifice options
* Dental insurance (colleague funded)
Learning & Development
* Day‑one access to learning resources
* 1,000s of learning resources available
* Sabbatical leave (in line with service)
* Enhanced family‑friendly policies – including enhanced maternity leave
* Flexible Working Opportunities – flexibile working requests can be made from day one of employment and are considered on an individual basis
* Refer a Friend scheme
We are committed to building a diverse and inclusive team. If you’re excited about this role but your experience doesn’t align perfectly, we encourage you to apply — you might be just the right fit.
#J-18808-Ljbffr