
Posted 12 days ago
Data Analytics EngineerAvacone
Data Analytics Engineer
Basel, BS, CHOn-siteFull-time
AI Summary
Builds and maintains SQL-based analytics data models and metric definitions in a cloud warehouse, translating business requirements into reliable, documented datasets owned through testing and deployment.
About this role
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.
Requirements
Required 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
AirflowAutomated Data TestingBigQueryDagsterDatabricks SQLData LineageData ModelingDbtGitLookerPower BIPythonQuery OptimizationRedshiftSnowflakeSQLTableau
Explore related jobs
More jobs at Avacone
Similar SQL jobs
- J
Airflow Platform EngineerJade Global Software Pvt LTD · Hyderabad, Telangana - S
Airflow Python DeveloperSutherland · Hyderabad, TS - C
Category Manager - AirflowCFO Trane U.S. Inc.-CFO · Davidson, North Carolina - B
Airflow Operator 3rd ShiftBurke Aerospace · Farmington, Connecticut - M
Systems Engineer, Thermal and AirflowMill · San Bruno, California - C
Sr. Mechanical Engineer - AirflowCFO Trane U.S. Inc.-CFO · Clarksville, Tennessee
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.