About this Data Analyst – Microsoft Fabric (6-month contract) role at Lombard Odier
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.
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.