Required skills
Languages: German
Job description
We are looking for a Senior Snowflake Data Engineer with strong SQL and dbt skills to contribute to the development of an energy procurement data model. The role focuses on technical implementation and enhancement of the ENMA/E2E data model on the Snowflake platform.
Project overview
With this request, we are looking for a Senior Snowflake Data Engineer with very good SQL and dbt skills.
DEADLINE FOR OFFERS: 26.11.2026
ATTENTION: We can only offer Nearshore for this.
Activity:
As part of Market Dynamics, the client is further developing the "MaLo-sharp E2E Energy Procurement Data Model" project. The goal is to expand a central and consistent data foundation for energy industry procurement, forecasting, and risk management processes for electricity and gas. The E2E data model is primarily based on ENMA/Snowflake and integrates and harmonizes data from various source systems at the individual market location (MaLo) level.
The further development aims in particular to increase transparency of volume flows, forecast deviations, and risk positions along the procurement chain and to create a reliable "Single Source of Truth". Based on this, Long-Term Forecasting, iMSys use cases, data quality and forecast accuracy analyses, as well as risk and HOP backtesting will be supported, among other things. The data model thus forms an essential basis for more reliable volume forecasts and better procurement and risk management decisions within the client.
In the first half of 2027, the focus will be on, among other things, the further development of the ENMA data foundation for BANG data integration, the optimization of DSO target plan quantities, the initial B2SME-ILP rollout, and the integration of weather and solar data for allocation and forecasting. In addition, the foundations for HOP backtesting and risk reporting, as well as for the provision of harmonized data for downstream Long-Term Forecast processes, will be further developed.
Job Description
In the context of the "Market Dynamics – MaLo-sharp E2E Energy Procurement Data Model" project, the external resource will take on clearly defined development packages based on defined requirements or user stories. The focus is on the technical implementation and further development of the ENMA/E2E data model on the Snowflake platform.
Key activities include in particular:
The services will be provided based on clearly defined user stories or sub-tasks within the project. The external resource will organize the processing of the assigned work packages independently. Separate coordination meetings can be arranged with the responsible client contact persons to clarify business or technical issues required for service provision.
The created deliverables will be presented as part of the agreed review and acceptance process and accepted by the responsible SPOC or Product Owner of the client. The involvement of the external resource in regular internal team meetings is generally not planned.
Mandatory Requirements
Soft Skills
Utilization:
960 hours
Fee:
max. € 63.00 / hour for Remote
Payment Term:
30 days
01.01.2027 - 30.06.2027
- Development and expansion of data models and data structures in Snowflake
- Development and optimization of SQL-based transformation and processing logic
- Technical connection and integration of data sources into the E2E data model
- Further development, optimization, and refactoring of existing data processing logic
- Analysis and resolution of errors as well as data processing and performance problems
- Execution of necessary deployments for implementation
- Execution of development-related tests and quality assurance measures
- If necessary, creation or updating of technical documentation and ad-hoc coordination of business or technical issues with the responsible client contact persons
- Very good practical knowledge of Snowflake, ideally at a senior level with at least 3 years of relevant development experience
- Very good to expert knowledge in SQL, especially in developing and optimizing complex queries and data processing logic
- Sound experience in Data Warehousing and Data Modeling, including the conception and further development of scalable data models
- Practical experience with dbt (data build tool) for developing, structuring, and managing data transformations
- Experience with Git and CI/CD processes for versioning, automated provisioning, and deployment of development artifacts
- Experience in integrating different data sources as well as developing and further developing data processing processes
- Ability to independently analyze and resolve technical errors as well as optimize existing implementations
- German language skills at least at B2 level, especially for coordinating business and technical requirements
Project details
- Start: 2027-01
- Duration: 6 Monate
- Remote: remote
- Location: Remote, Deutschland, DE
- Rate: unknown-63 EUR/h
- Languages: German
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on FreelancerMap DE