Azure Data Engineer
360 Resourcing Solutions · Birmingham ·
- Category
- Data engineering
- Salary
- GBP 50,000 / year
An Azure Data Engineer joins the BI/database team of a retail data consultancy, building and optimizing SQL databases, data warehouse models and Azure Data Factory ingestion pipelines, and troubleshooting ETL and query performance. Mostly remote with 1 office day per month in Thame, at £50,000.
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. Interested? Apply now for an immediate interview.
#INDMM