Data Analytics Engineer

Posted 2 Days Ago
Be an Early Applicant
Basel, Basel-Stadt, CHE
In-Office
Entry level
Information Technology • Consulting • Pharmaceutical • Chemical
The Role
Build and maintain SQL-based analytical data models in cloud warehouses, translate business needs into reusable datasets and consistent KPIs, implement data testing and monitoring, resolve quality issues, document lineage, optimize performance and costs, and apply software engineering practices to analytics workflows.
Summary Generated by Built In
About the role

As a Data Analytics Engineer, you’ll turn raw data into reliable datasets that teams can use to make decisions. You’ll work with data engineers, analysts, and business stakeholders to define metrics, build reusable data models, and make data easier to find, understand, and use.

You’ll own the analytics transformation layer, from gathering requirements and designing models through testing, deployment, and ongoing maintenance.


Key responsibilities
  • Design, build, and maintain SQL-based data models in the cloud data warehouse to support reporting, self-service analytics, and business analysis.
  • Translate business requirements into reusable datasets and work with stakeholders to define consistent KPIs across reports and dashboards.
  • Build and maintain automated data tests and monitoring. Investigate data quality issues, trace them to their source, and coordinate fixes with the teams responsible.
  • Document data models, metric definitions, and data lineage so users can understand where data comes from and how to use it.
  • Improve query and transformation performance while managing warehouse compute costs.
  • Apply software engineering practices to analytics workflows, including version control, code reviews, and automated deployments.

RequirementsRequired qualifications
  • Professional experience in analytics engineering, data engineering, BI engineering, or a related role, with hands-on ownership of production data models or pipelines.
  • Advanced SQL skills, including complex joins, window functions, and query optimization.
  • Experience designing analytical data models, including defining table grain and working with facts and dimensions.
  • Hands-on experience with a cloud data warehouse such as Snowflake, BigQuery, Redshift, or Databricks SQL, and a transformation framework such as dbt or an equivalent.
  • Experience with Git, code reviews, automated data testing, and deployment workflows.
  • Ability to translate business questions into data requirements and communicate modeling decisions to technical and non-technical stakeholders.
  • Professional proficiency in English, both written and spoken.
Preferred qualifications
  • Experience with Python for data processing or automation, or with orchestration tools such as Airflow or Dagster.
  • Experience with BI tools such as Looker, Power BI, or Tableau, or with a semantic layer for managing shared metrics.
  • Familiarity with data observability, data catalogs, or governance practices such as lineage tracking and access management.

Skills Required

  • Professional experience in analytics engineering, data engineering, BI engineering, or a related role, including ownership of production data models or pipelines
  • Advanced SQL skills, including complex joins, window functions, and query optimization
  • Experience designing analytical data models, defining table grain, and working with facts and dimensions
  • Hands-on experience with a cloud data warehouse such as Snowflake, BigQuery, Redshift, or Databricks SQL
  • Experience with dbt or an equivalent transformation framework
  • Experience with Git, code reviews, automated data testing, and deployment workflows
  • Ability to translate business questions into data requirements and communicate modeling decisions to technical and non-technical stakeholders
  • Professional proficiency in written and spoken English
  • Experience with Python for data processing or automation, or orchestration tools such as Airflow or Dagster
  • Experience with BI tools such as Looker, Power BI, or Tableau, or a semantic layer for shared metrics
  • Familiarity with data observability, data catalogs, or governance practices such as lineage tracking and access management
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Sissach
66 Employees

What We Do

Avacone is a Swiss-based service provider specializing in IT infrastructure and pharmaceutical engineering, delivering specialized solutions for regulated and non-regulated environments in the pharmaceutical, chemical, and medical technology sectors.

Similar Jobs

Qualtrics Logo Qualtrics

Paralegal

Artificial Intelligence • HR Tech • Information Technology • Software • Business Intelligence
Remote or Hybrid
27 Locations
7500 Employees

MongoDB Logo MongoDB

Senior Solutions Architect

Big Data • Cloud • Software • Database
Easy Apply
Remote or Hybrid
Switzerland
5550 Employees

RapDev Logo RapDev

Senior Cloud Engineer

Information Technology • Productivity • Professional Services • Software
Remote or Hybrid
27 Locations
130 Employees
75K-95K Annually

Pfizer Logo Pfizer

Data Scientist

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Remote or Hybrid
28 Locations
121990 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account