Business Intelligence Data Engineer

Straumann Group; Madrid; On-site; EUR 60,000 - 90,000; Full time

Job summary

The Straumann Group is a global leader in aesthetic dentistry and analytics. We seek a BI Data Engineer who builds trusted data foundations, turning complex data into reliable datasets and semantic models to support reporting, insights and AI across the business.

You will collaborate with engineering, analytics and business teams to deliver quality data pipelines, semantic models and dashboards. Strong Python, SQL and Power BI skills, plus cloud experience, are essential in this fast-paced

Qualifications

• Experience in data modeling, data management and analysis principles.
• Proficiency with SQL databases and data platforms; writing queries and optimization.
• Proficient in Python or similar languages.
• 2+ years delivering solutions using Power BI and/or Fabric.
• Experience developing semantic models with complex business logic.
• Familiarity with Fabric, Azure, AWS, Databricks, SAP Datasphere.
• Experience writing DAX or query languages for metrics.
• Quick learner with passion for new tech; strong ownership and teamwork.
• English proficiency for collaboration.

Responsibilities

• Build, maintain, troubleshoot and support semantic models, schemas and data pipelines from diverse sources.
• Translate business requirements into technical solutions within the data ecosystem.
• Ensure quality, delivery and reliability within development standards.
• Collaborate with stakeholders and tech teams to deliver sustainable data solutions.

Skills

Data modeling

SQL databases

Python

Power BI

Data analysis

DAX

Analytical thinking

Communication

Cloud data services

CI/CD

Education

University degree

Tools

Power BI

Fabric

Databricks

Azure

AWS

PostgreSQL

Python (Pandas)

VSCode

Airflow

Job description

The Straumann Group is a global leader in the field of aesthetic dentistry. We combine expertise, scientific evidence, and innovation with passion, committing to uncompromising quality to provide dentists and patients worldwide with the best possible solutions. As pioneers and market leaders in dental implantology, we have consistently expanded our product portfolio in recent years. Today, we operate in all areas of aesthetic dentistry: from tooth preservation, regeneration, restoration, orthodontics with transparent aligner trays to tooth loss solutions.

The BI Data Engineer builds trusted data foundations that help analytics teams and business stakeholders make informed decisions. Working across engineering, analytics, and business functions, they turn complex data into reliable, accessible datasets and semantic models that support reporting, strategic insights, advanced analytics, and AI.

Success in this role means delivering reliable, well documented technical solutions that can be confidently used across different businesses; positively impacting consistency in business metrics, reducing preparation and validation times for faster access to meaningful insights that can contribute to a fast evolving business.

Your Responsibilities

• Actively apply your technical and analytical skills to build, maintain, troubleshoot or provide operational support for new or existing semantic models, schemas and data pipelines from various source systems.
• Analyze and translate business requirements in collaboration with stakeholders and project teams, translating them into appropriate requirements to build technical solutions within our data ecosystem.
• Ensure quality, delivery, and reliability within development standards.
• Act as a trusted partner to stakeholders, analysts, and collaborate with technology teams to deliver sustainable and working solutions.

Your Profile - Qualifications

• Data modeling experience and knowledge of data management and analysis (principles, good practices, dimensional models, schemas, ETL, data pipelines).
• Proficiency in working with SQL Databases and data platforms, writing queries, maintenance and optimization.
• Proficient in Python or similar programming languages.
• 2+ years of experience delivering solutions using Microsoft Power BI and/or Fabric.
• Experience developing and optimizing semantic models with complex business logic and understanding of common analytical issues.
• Understanding of cloud data services such as Fabric, Azure, AWS, Databricks, SAP Datasphere.
• Experience in writing DAX or similar languages to query, model and create business metrics.
• Quick learner who is passionate about new technologies.
• Strong sense of ownership, customer centricity, and drive with a can-do attitude.
• Team player with proficient skills in English.
• Excellent problem-solving skills, ability to work independently in a fast-paced environment.
• University degree or equivalent experience.

Additional Qualifications And Skills

• Experience on Power BI Premium Capacity administration and resource management.
• Administration of Fabric Data warehousing, Workspaces, Lakehouses, Dataflows, RLS, UDFs or related Fabric objects.
• Experience with data modeling optimization tools such as DaxStudio, Tabular Editor or similar.
• Develop and maintain data pipelines using AWS/Azure native services like ADLS Gen 2, AWS Glue, AWS AppFlow, Azure Data Factory, Spark, Python, Databricks.
• Experience in working with structured/unstructured data sources, file based sources, Social data sources, (Google Analytics, Google Firebase, SQL, Postgres, SAP, APIs, JSON).
• Experience with API based, Powershell or similar solutions to trigger events, query or deploy solutions.
• Proficiency in Python Pandas/Polaris/Spark.
• Experience with admin and automation tools such as VSCode, Airflow, Luigi, Prefect, etc.
• Experience of cloud based data warehousing platforms for querying, analyzing, sharing structured and unstructured data such as Snowflake, Databricks, etc.
• Experience with CI/CD frameworks such as Azure DevOps, Jenkins, and Bamboo for version control, testing & deployment.
• Experience working with data engineers and data scientists to deliver high quality data analytics solutions.
• Experience in developing applications in cloud platforms such as AWS, Microsoft Azure

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability.