Azure Data Engineer

360 Resourcing Solutions; Slough; Hybrid; GBP 45,000 - 60,000; Full time

Job summary

360 Resourcing Solutions is seeking an Azure Data Engineer for a fast-growing retail consultancy. The role focuses on architecting, maintaining and troubleshooting internal database structures while delivering high-quality data outputs for internal and client-facing reporting.

You will work with the BI team, design and optimize Azure data pipelines, and ensure data freshness and governance. The position is remote with just one day a month in the Thame office and offers a competitive salary and

Qualifications

• Strong experience developing in SQL from scratch.
• Solid understanding of Data Warehousing concepts.
• Expert in writing efficient T-SQL code.
• Proficient in query optimization, partitioning and index design.
• Good understanding of data cleansing and preparation.
• Strong analytical and problem-solving skills.
• Ability to collaborate across the BI team.
• Experience designing and deploying Azure Data Factory data pipelines.

Responsibilities

• Build and refine queries, CTEs, stored procedures, views and functions.
• Create and maintain tables, indexes, constraints, schemas and triggers.
• Diagnose slow queries using execution plans and IO statistics.
• Design optimized queries for CPU, IO and memory usage and reduce locking.
• Check job schedules, ETL pipelines and data freshness.
• Build and maintain ingestion pipelines.
• Enforce constraints, referential integrity and validation rules.
• Document data pipelines, schemas and data flows.
• Promote best practices and plan for scalability.

Skills

SQL

Data Warehousing

T-SQL

Query Optimization

Azure Data Factory

Data Cleansing

Analytics

BI Collaboration

Azure SQL

Tools

Azure Data Factory

SQL Server

Job description

Azure Data Engineer - Thame - Remote - 1 day Month in Office - £50,000

My client is a leading Retail Consultancy that work with a number of high profile Retail chains, consuming data and providing Insight and Reports.

Due to exciting growth we are looking for an ambitious and skilled Azure Data Engineer to join the Business Intelligence function and play a key role in architecting, maintaining and troubleshooting internal database structures.

As the new Azure Data Engineer you'll be part of the Database team, working closely with the reporting and QA teams to deliver top level data outputs for internal and external facing reporting, including 3rd party integrations.

On a daily basis the Azure Data Engineer will be responsible for:

• Build and Refine queries, CTE's, stored procedures, views and functions
• Create and Maintain tables, indexes, constraints, schemas and triggers
• Diagnose slow queries using execution plans, cardinality estimates, IO and wait stats
• Design optimized queries for CPU, IO and memory usage, reducing locking.
• Checking job schedules, ETL Pipelines and data freshness
• Build and Maintain ingestion pipelines
• Enforce constraints, referential integrity and validation rules
• Support compliance requirements
• Document data pipelines, schemas, stored procedures, data flows and standards
• Promote best practices
• Plan for Scalability

To be considered for this role as our Azure Data Engineer you should have experience of:

• Strong experience developing in SQL from creating database models from scratch
• Solid understanding of Data Warehousing (star schema, fact/dimension design)
• Expert in writing efficient TSQL code
• Proficient in query optimization, partitioning and index design.
• Good understanding of data cleansing and preparation
• Strong analytical and problem-solving skills.
• Ability to collaborate across the whole BI team
• Practical and proven experience in designing and deploying Azure Data Factory data pipeline.
• Translating business questions into SQL and explaining query logic clearly

This is a fantastic opportunity for an experienced Azure Data Engineer to work on high-impact, client-facing reporting solutions. You will be part of a modern, collaborative BI team with a clear structure and growth plan. The role is only 1 day a month in the office and offers competitive salary and benefits package.