Senior Data Engineer
4 days ago
Havant
Role Title: Senior Data Engineer Department: IT and Business Change Reports To: Lead Stack Azure BI Developer Contract Type: Permanent Working Arrangements/Pattern: Full Time, 35 hours Working Location: FatFace HQ, Havant Who are we? For over 30 years, we’ve travelled, we’ve laughed, we’ve grown. We believe life is for living and more fun with those we love. We are Made for Life. Our mission statement: Crafting clothes for life’s everyday adventures. Today, tomorrow and always. Our Product formula: Considered style. Trusted Quality. B Corp certified. We are proud to have featured in the Sunday Times top 10 best places to work 2025 and best places to work for women 2025. Equality and inclusion isn’t an aspiration but the standard. We promote and drive equality within our workforce to ignite an inclusive foundation for us all to build from and truly connect with our customers, colleagues, and communities alike. You play a key part in creating an environment free from prejudice, racism, sexism, harassment, bullying and any other form of marginalisation in our workplaces. 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. This role is ideal for someone with strong experience in Azure cloud architecture, SSAS, data modelling, and BI pipelines, who thrives in a collaborative environment and is eager to drive innovation in data infrastructure. Role Responsibilities • Apply best practice to Star/Snowflake schema data modelling with considerations in challenging and verifying data quality and accuracy., • Lead the addition of new data sources to the Data Lake from 3rd party sources., • Assisting 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, errors, and maintaining production data., • Development of Data models from existing Data Sources., • Undertaking code reviews and providing constructive feedback., • Assist other members of the Data & Reporting team with integration and system-specific tasks., • Develop and update technical documentation., • Experience with reporting software (Power BI) is essential, • Act as a mentor to junior team members, • Align self to the company's social and environmental mission and champion any actions that you can directly impact at all times. 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 (SQL database, data warehouse, SQL servers, datalake storage and lakehouses, structured and unstructured data), • 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), • Knowledge of Power BI for financial reporting, dashboards and KPIs preferred but not essential Role Competencies • Adept at disseminating large sets of mixed content unstructured data into clean, efficient, correctly modelled datasets, • Analytical, a natural problem solver, able to find patterns and trends in data and support incidents, • Determined, persistent and proactive. Keen to understand, analyse and improve., • Ability to explain technical solutions to non-technical members of staff., • Ability to self-teach new BI technologies and be resourceful in finding appropriate documentation and community support, • Ability to interpret complex data and able to convert data into useful, actionable information. Key Contacts and Relationships: Data & Reporting Team: Collaborate closely with team members to support ETL processes, troubleshoot data pipeline issues, and improve data architecture. Internal Stakeholders: Work with various departments (e.g., 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 optimization, and technical design. Accountable for Resources: Data Architecture: Responsible for designing, maintaining, and improving Azure-based data models and architectures. Data Pipelines: Ensure the reliability and accuracy of ETL processes and data integration workflows. Documentation: Maintain up-to-date technical documentation for processes, data models, and architecture. Tools and Platforms: Oversee the development and operation of tools like Power BI, Azure Data Factory, and Datalake. Data Quality: Accountable for validating and improving the accuracy and quality of data from both internal and external sources. FatFace Benefits: Financial & Protection Benefits • Sick pay allowances, • Critical Illness Income protection/ Death in service (for salaried colleagues), • Pension scheme – with net deduction and salary sacrifice options, • Dental insurance (colleague funded) Discounts & Perks • 60% off FatFace products, • 25% discount at Next stores (across full price products), • O2 phone discount, • Discounted gym membership, • Cycle to Work scheme (for salaried colleagues), • EV vehicle scheme (for salaried colleagues), • Perkbox – our online platform offering:, • Day-one access, • Exclusive brand discounts, • Wellbeing content, • Home workouts and more Health & Wellbeing • Specsavers eye care scheme, • Eye tests and contributions to glasses, • Free period products, • EAP support 24/7 via UNUM, Retail Trust, and Fashion & Textiles Support Learning & Development • THRIVE – our learning management system:, • Day-one access, • 1,000s of learning resources Time Off & Leave • 25 days holiday plus bank holidays, • Sabbatical leave (in line with service), • Enhanced family-friendly policies – including enhanced maternity leave, • Flexible Working Opportunities – flexible working requests can be made from day one of employment and are considered on an individual basis. Additional Perks • 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.