Job Description
Job Title: Data Warehouse Engineer / ETL Developer
Location: Central Nottingham (1 day a week, remote for the rest)
Company: Large UK-Wide Energy Provider
Job Purpose:
We are seeking a Data Warehouse Engineer / ETL Developer to join our team. You will be responsible for database design and modelling, setting up ETL processes, and managing data pipelines. Your expertise in SQL and Python will be crucial for database development and integration.
Key Responsibilities:
Data Modelling and Design:
1. Create and maintain data models on Snowflake.
2. Optimize data structures for performance and scalability.
ETL Process:
3. Extract, transform, and load data from various sources into the Snowflake platform.
SQL Proficiency:
4. Strong skills in SQL for database queries and optimization.
Cloud Computing:
5. Experience with Azure and Snowflake's cloud-native architecture.
Collaboration:
6. Work with data engineers, analysts, and business users.
7. Communicate technical concepts to non-technical stakeholders.
8. Gather and understand business requirements.
Enterprise-Level Application Development:
9. Develop and maintain applications on the Snowflake platform.
Desirable:
10. Experience with Power BI for data modelling and visualization.
Key Requirements:
11. Extensive experience with data warehousing, modelling, and ETL processes in an Azure environment.
12. Proficiency in SQL and Python.
13. Strong collaborative and communication skills.
Contract Details:
14. Outside IR35, initially 9 months with potential for extension.