Overview
The Data Engineer position is a contractual role focused on enhancing and evolving the existing data platform within a hybrid working environment. This hands-on role involves collaborating with Data Analysts and business stakeholders to develop scalable data structures and pipelines, maximizing the value of data across the organization. The successful candidate will engage throughout the data lifecycle, from ingestion to reporting, while ensuring strong governance and quality control of data processes.
Responsibilities
- Design, develop and maintain data pipelines within Microsoft Fabric.
- Build and enhance scalable data warehouse solutions and dimensional data models.
- Develop and maintain Star and Snowflake schema designs to support reporting and analytics.
- Manage data ingestion, transformation and modelling processes across multiple data sources.
- Develop and support Python-based data engineering solutions where appropriate.
- Maintain and improve existing SSIS-based ETL and transformation processes.
- Support the development and optimisation of Power BI datasets, semantic models and reporting solutions.
- Collaborate with operational, commercial and technical stakeholders to translate business requirements into effective data solutions.
Requirements
- Proven experience as a Data Engineer or in similar roles such as BI Developer or Data Warehouse Developer.
- Strong hands-on experience with Microsoft Fabric.
- Proficient in SQL and T-SQL development.
- Experience designing and developing ETL/ELT pipelines.
- Strong understanding of data warehousing principles and best practices.
- Expertise in designing and implementing Star Schema and Snowflake Schema models.
- Strong Python skills for data engineering tasks.
- Familiarity with Power BI security models, including Row-Level Security.