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 225 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.
Internship – Data Integration Specialist (6 months)
As part of our Data Integration team in the Data Office, the intern will participate in the implementation and industrialization of data pipelines to feed our data warehouse. This internship is a concrete opportunity for the intern to train in modern data engineering tools and to contribute to a structuring data integration project.
YOUR ROLE
-
Analyze the current business flows in different sources: databases, KAFKA, etc.
-
Design and develop batch data processing pipelines to feed the data warehouse.
-
Implement complex data transformations (enrichment, joins, cleaning, etc.).
-
Participate in data modelling (star or snowflake model) and the creation of fact and dimension tables.
-
Contribute to the implementation of validation tests and non-regression tests to guarantee the quality and stability of flows.
-
Document the processing carried out and participate in the continuous improvement of processes.
YOUR PROFILE
-
Bachelor’s or master's student in computer science, data engineering, or equivalent course
-
Strong interested in ETL/ELT principles and data warehouse modelling. A previous experience with an ETL framework/tool will be appreciated (SSIS, Talend, xDi, Apache NiFi, Airflow…)
-
Strong interest in relational databases (Oracle, SQL, etc.)
-
Knowledge of Kafka, Json, Avro, Xml formats will be appreciated
-
Curious, rigorous, with a good analytical mind and a desire to progress in a technical environment
-
Fluent in French and English
-
Residence in Switzerland
TECHNICAL ENVIRONMENT
-
Development under an ETL framewor
-
Database: Oracle, SqlServer
-
Language / Format: SQL, Json, Avro
-
Kafka streaming
-
Tools: Git, Jira
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.
Top Skills
What We Do
For over 225 years, Lombard Odier has focused 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 3000 dedicated professionals who continue to shape the future of global wealth management.
