jobapplier

Data Engineer

Nemetschek SE2

Skills

Required

  • Data Engineering
  • GCP
  • BigQuery
  • Dataform
  • SQLX
  • incremental processing
  • dependency management
  • SQL
  • window functions
  • MERGE
  • ARRAY
  • STRUCT
  • Terraform
  • GitHub

Preferred

  • ELT
  • Bronze
  • data layers
  • dimensional data models
  • JavaScript
  • workflow configurations
  • partitioning
  • clustering
  • query performance

About Nemetschek SE2

The Nemetschek Group is a leading global vertical software and AI provider driving the digital transformation of the AEC/O and media industries.

With our deep domain expertise and intelligent, connected software solutions, we enable customers to turn data into real-time insights and smarter decisions throughout the entire lifecycle of buildings and infrastructure from ideation through planning, visualization, construction, operation, and renovation.

Our AI-powered technologies and open standards approach boost productivity, collaboration, and sustainability for architects, engineers, contractors, building operators, and creative professionals.

Over 7 million users worldwide rely on our customer-centric, human-led AI solutions.

Founded by Professor Georg Nemetschek in 1963, today we employ over 4,000 experts globally across 14 subsidiaries.

Responsibilities

  • Design and maintain ELT pipelines using Dataform, SQLX, and BigQuery.
  • Implement Bronze, Silver, and Gold data layers and dimensional data models.
  • Develop incremental models, reusable JavaScript functions, assertions, and workflow configurations in Dataform.
  • BigQuery SQL, partitioning, clustering, query performance, and compute and storage costs.
  • Build and maintain CDC pipelines using Datastream, including handling updates, deletes, and schema evolution.
  • GCP infrastructure using Terraform, including BigQuery datasets, Datastream, IAM, and service accounts.
  • Implement GitHub-based CI/CD, pull requests, code reviews, and automated Dataform validation.
  • Ensure data quality, security, governance, and pipeline monitoring.
  • Troubleshoot production failures, perform root-cause analysis, and implement preventive measures.
  • Collaborate with BI teams and business stakeholders to deliver reliable, analytics-ready data.

Requirements

  • Skills 6–10 years of experience in Data Engineering.
  • Strong hands-on experience with GCP and BigQuery.
  • Production experience with Dataform, SQLX, incremental processing, assertions, and dependency management.
  • Advanced SQL skills, including window functions, MERGE, ARRAY, STRUCT, UNNEST, and deduplication.
  • Experience with BigQuery architecture, dimensional modeling, and cost optimization.
  • Working knowledge of Datastream and CDC concepts.
  • Experience with Terraform, GitHub, and CI/CD practices.
  • Strong troubleshooting, problem-solving, and communication skills.