Skip to content
freelancermapOpen

Senior Snowflake Data Engineer with very good SQL and dbt skills Remote - NEARSHORE

Original title: KU - Senior Snowflake Data Engin mit sehr guten SQL- und dbt-Kenntnissen Remote- NEARSHORE

ProTIP ProjektService AG · Remote, Deutschland, Germany · Remote · SENIOR

  • Remote, Deutschland, Germany · Remote
  • 6 Monate
  • German

Indexed (today) · refreshed constantly

Budget
up to €63 / h
Start
2027-01
Duration
6 Monate
Work mode
Remote
Contract
Freelance / B2B
Seniority
SENIOR
Reference
3075451

Required skills

Nice to have:Data VirtualizationDatabase DevelopmentInfosphere DatastageForecastingSQL DeveloperSmart DataDatabase EnginesCloudflareAWS Data AnalyticsData Pipeline

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

  1. Job boardNew

    Data Engineer

    Confidential· Australian Capital Territory· SENIOR

    • SQL
    • ETL
    • Data Warehousing

  2. Job boardNew

    Data Analyst

    Confidential· Australian Capital Territory· Senior

    • Statistical Modelling
    • Python
    • SQL
    • +3

Browse all jobs
Sign up free to apply