Business Intelligence Data Engineer

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.