Lombard Odier Group

Data Analyst – Microsoft Fabric (6-month contract)

Lombard Odier Group  •  Canton de Genève, CH (Onsite)  •  31 minutes ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

A career at Lombard Odier means working for a renowned global wealth and asset manager, with a strong focus on sustainable investing. An innovative bank of choice for private and institutional clients, our independently owned Firm is one of the best-capitalised banking groups in the world, managing close to CHF 300 billion and operating from over 25 offices across 4 continents.

With a history spanning over 230 years, Lombard Odier is an investment house providing a comprehensive offering of discretionary and advisory portfolio management, wealth services and custody. We also offer asset management services and investment strategies through Lombard Odier Investment Managers and provide advanced banking technology to other financial institutions.

“Rethink Everything” is our philosophy – it is at the heart of everything we do. We have grown stronger through more than 40 financial crises by rethinking the world around us to provide a fresh investment perspective for our clients.

Data Analyst – Microsoft Fabric (6-month contract)

As part of the HR team, you will contribute to a strategic transformation aimed at building a modern, scalable, and AI-ready data architecture based on Data Mesh principles, Data Products, and the Microsoft Fabric platform. The objective is to evolve from a traditional reporting-driven model to a self-service data platform that enables users to directly access trusted, governed, and reusable data assets.

Working closely with the HR Data Officer, you will help define the target architecture, design Data Products, model data structures, and implement governed semantic models that ensure consistent interpretation of HR metrics across analytical tools.

You will also contribute to the development of a data portal that enables users to discover, understand, and independently leverage certified datasets while benefiting from a strong governance and security framework.

You will work with complex but well-established datasets that already benefit from robust quality controls and a solid analytical foundation. The challenge is not to fix data quality issues, but to transform existing data into reusable, secure, and scalable analytical assets that can be leveraged by business users, analytics tools, and AI solutions.

This role combines hands-on delivery with genuine architectural responsibilities. As the Microsoft Fabric platform is currently being built, you will take part in key decisions regarding data modelling, security, governance, and self-service analytics, helping establish a sustainable foundation for future data and AI initiatives.

YOUR ROLE

  • Gather, analyze, and formalize HR business requirements and translate them into data and analytics solutions.
  • Design and model Data Products following Data Mesh and Medallion Architecture principles.
  • Develop and maintain data transformation pipelines from Silver to Gold layers, including associated dimensional models.
  • Build and maintain semantic models and enterprise HR metrics for Power BI, Excel, and Copilot.
  • Define and implement data security mechanisms, including Row-Level Security (RLS) and Column/Object-Level Security (CLS/OLS), to protect sensitive information.
  • Contribute to the implementation and continuous evolution of the Microsoft Fabric platform in collaboration with Group IT and Data Office teams.

YOUR PROFILE

  • 4-5 years of experience in Data, Business Intelligence, Analytics, or Data Engineering.
  • Very good command of Microsoft Fabric environments is strongly desired (Microsoft Fabric, Lakehouse, Medallion Architecture)
  • Excellent command of SQL and Microsoft SQL Server (MSSQL).
  • Excellent command of Data Modelling (Star Schema), Power BI Semantic Models, and DAX .
  • Excellent knowledge of Data Product design and Data Governance principles, with a strong user-centric mindset and focus on self-service analytics.
  • Comfortable operating in both hands-on delivery and solution architecture capacities.
  • Strong ability to collaborate with business stakeholders and technical teams in a data-driven environment.
  • Strong analytical and structured thinking, at ease with business requirements analysis and formalization.
  • Excellent communication skills with both business and IT stakeholders.
  • Autonomous, pragmatic, and service-oriented approach.
  • Resident in Switzerland or willingness to relocate.

Our Maison’s DNA is defined by five core values. Excellence drives us to be the best at what we do, while Innovation fuels our progress. Respect underpins every interaction, and Integrity shapes our actions. Together, we are One Team, united in serving our clients with unwavering dedication.

As a responsible and supportive employer, we promote a diverse and inclusive work environment for our employees and candidates. Diversity, Equity and Inclusion are woven into the fabric of our Maison’s DNA, and we strive to ensure that our employees can fulfill both their personal and professional aspirations by encouraging internal mobility and individual upskilling programs. We firmly believe that building Diverse Teams contributes to our successes and to deliver on this, we actively embed Diversity, Equity and Inclusion in our business strategy.

It is an exciting time to join our Teams. All applications will be handled in the strictest confidence.

Lombard Odier Group

About Lombard Odier Group

For over 225 years, Lombard Odier has focussed on its central mission: to build strong, long-lasting client partnerships based on expertise, trust and care. Our Group strives to create sustainable value for private and institutional clients, combining leading investment solutions with stability and a robust balance sheet.

Our unwavering commitment to the long-term interests of our clients is underpinned by our independent partnership model as our Firm is solely owned by our Managing Partners.

We are guided by one key philosophy: rethink everything®. We constantly rethink the world around us to provide a fresh investment perspective for our clients. By offering a comprehensive suite of services, from discretionary and advisory portfolio management to wealth planning and custody, we offer our clients quality, bespoke solutions.

Our cutting-edge banking technology not only sets industry standards, but also serves as a beacon for Swiss and European private banks and financial institutions.

At Lombard Odier, we are convinced that the transition to a net-zero, nature-positive economy will be the most profound economic transformation of all time. Our role is to help our clients navigate this major shift by identifying related investment opportunities.

Headquartered in Geneva with offices on five continents, we are guided by a team of around 3,000 dedicated professionals who continue to shape the future of global wealth management.

Industry
Finance & Insurance
Company Size
1,001-5,000 employees
Headquarters
Bellevue, CH
Year Founded
1796
Social Media