Data Operations Engineer (Snowflake & Power BI)

Company Description

Swiss Delivery Excellence: Transforming Life Science Consulting Worldwide.

Fusion Consulting is a globally leading Business and IT boutique consultancy specialized in the Life Sciences industry, partnering with leading companies in pharma, healthcare, and animal health.

With over 450 employees and 25 offices worldwide, our mission is to revolutionize our clients' business transformation challenges and set new industry standards through innovative solutions.

Focused on S4HANA, Data & Cloud, and innovative technologies, Fusion Consulting brings unparalleled expertise and commitment to excellence to every project we undertake.

Grounded in our commitment to fast and intelligent decision-making, our client-first and open-hearted approach defines our ethos. With unwavering support and an entrepreneurial spirit, our global teamwork transcends boundaries and turns shared visions into reality.

Job Description

We are looking for a hands-on Data Operations Engineer to support a life sciences digital transformation initiative by owning the operation and maintenance of a robust reporting pipeline built on Snowflake and Power BI. This role is perfect for someone who excels in maintaining stable data systems and enjoys cross-functional collaboration across technical and business teams.

What You Will Be Doing:

• Own and monitor the end-to-end Snowflake to Power BI reporting pipeline.
• Investigate and resolve pipeline failures promptly to maintain reliable reporting.
• Troubleshoot and correct broken metrics by validating SQL logic and clarifying definitions with business stakeholders.
• Work with internal CRM and data owners to diagnose and rsolve upstream data issues.
• Maintain and update SQL metric definitions in response to business logic changes.
• Ensure Power BI DAX calculations are consistent with Snowflake outputs and configuration tables.
• Collaborate with external consultants and internal business stakeholders to address edge cases, drive quality assurance, and implement improvements.
• Document all changes thoroughly and communicate potential risks and impacts clearly.

Qualifications

• 3+ years of hands-on experience with Snowflake, including stored procedures, access control, data loading, and transformation logic.
• 2+ years of experience with Power BI, with a strong focus on writing and debugging DAX queries and working with config-driven logic.
• Excellent communication skills, with the ability to engage clearly and responsively with both developers and business leadership.
• Reliable and transparent working style, including proactive issue flagging, consistent documentation, and the ability to work independently.

Preferred Qualifications:

• Familiarity with SQL Server and legacy SQL logic.

Additional Information

Why Fusion? 

At Fusion, we unite entrepreneurial minds from around the globe to develop and implement game-changing solutions that build lasting relationships with our clients.

We value employees who challenge the status quo through innovation, adapt to diverse client needs in ever-changing environments, and commit to continuous learning—for themselves and their colleagues.

We provide a competitive salary and benefits package, along with an outstanding work environment that fosters long-term career development opportunities.

Our Benefits:

• Workflex: Enjoy 25 days of flexibility to work from your preferred global location.
• Flexible Time Off: Take the time you need to recharge and maintain a healthy work-life balance, with flexibility beyond standard holiday allowances.
• Annual Training Budget: Access CHF 1,500 to invest in your professional development and skill enhancement.
• Continuous Learning: Thrive in an environment that encourages ongoing learning, with opportunities to develop new skills and broaden your expertise.
• Global Mobility Support: Gain assistance with international assignments, visa/permit support, and relocation services.
• Unity Scheme: Benefit from loyalty rewards starting after 3 years of service.
• Referral Program: Earn a referral fee for every successfully hired referee.
• Local Benefits: Access a range of country-specific benefits tailored to your location.
• People Focus: Unite with the best global talent in life sciences, empowered to grow and collaborate in a vibrant environment.
• Truly Global: Join a truly global organization where mutual support, teamwork, and diversity drive our collective success.