Data Analytics Engineer: Build Data Models & Insights

avacone Switzerland; Basel; On-site; CHF 110,000 - 150,000; Full time

Job summary

avacone Switzerland is seeking a Data Analytics Engineer in Basel to turn raw data into reliable datasets that teams can use to make decisions. You will own the analytics transformation layer from gathering requirements and designing models through testing, deployment, and ongoing maintenance.

You will design SQL-based data models in a cloud data warehouse (Snowflake, BigQuery, Redshift, or Databricks SQL), translate business questions into reusable datasets, and define KPIs across reports.

Qualifications

• Hands-on ownership of production data models or pipelines.
• Advanced SQL skills with complex joins and window functions.
• Experience with a cloud data warehouse (Snowflake/BigQuery/Redshift/Databricks).
• Experience with Git, code reviews, and deployment workflows.
• Proficiency in English (written and spoken).

Responsibilities

• Design, build, and maintain SQL-based data models in the cloud data warehouse to support reporting and analytics.
• Translate business requirements into reusable datasets and define consistent KPIs across reports and dashboards.
• Build and maintain automated data tests and monitoring; investigate data quality issues.
• Document data models, metric definitions, and data lineage so users can understand where data comes from and how to use it.
• Improve query performance while managing warehouse compute costs.
• Apply software engineering practices to analytics workflows, including version control and automated deployments.

Skills

Advanced SQL

Stakeholder communication

English proficiency

Analytical thinking

Tools

Snowflake

BigQuery

Redshift

Databricks SQL

dbt

Git

Airflow

Dagster

Job description

avacone Switzerland is seeking a Data Analytics Engineer in Basel to turn raw data into reliable datasets that teams can use to make decisions. You will own the analytics transformation layer from gathering requirements and designing models through testing, deployment, and ongoing maintenance.

You will design SQL-based data models in a cloud data warehouse (Snowflake, BigQuery, Redshift, or Databricks SQL), translate business questions into reusable datasets, and define KPIs across reports.