Data Engineer – Data Integration

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.

Within the Data Integration team, the Data Analyst specializing in data integration plays a key role within the Data Office department, also with the Business and IT Development teams. He/she contributes to, facilitates and optimizes data integration and storage activities and projects. He/she will work closely with the teams responsible for source data and related projects, as well as with the Business lines behind IT development requests that have an impact on data. The aim is to ensure that Data Integration and storage processes are efficient. He/she also helps to improve the enrichment and input of business analyses.

YOUR ROLE

• Facilitating communication between Data Integration teams, Development teams and Business stakeholders, ensuring a clear understanding of project data objectives and requirements

• Contribute to functional specifications, including data models and data flow diagrams

• Identify data from primary and secondary sources to ensure data integrity and accuracy

• Organizing the collection and validation of data integration requirements and needs

• Contribute to the management of ETL processes for integrating data into the data warehouse, ensuring efficient transformation and loading of data

• Working with the technical teams to define and implement robust and scalable data integration solutions

• Identify potential risks associated with changes and capacity constraints, and work with project managers to develop risk mitigation strategies

• Ensure the quality and integrity of project requirements and deliverables

• Identify process improvement and efficiency opportunities within data integration activities

• Developing regular reports and dashboards to present progress in an understandable and usable way

• Monitor and report on key performance indicators (KPIs) to assess the effectiveness of data integration initiatives and projects

• Knowing and understanding the basics of banking and supporting the Data Integration team on this aspect

• Participating in the support and monitoring of anomalies

YOUR PROFILE

• Bachelor's degree in data science, statistics, computer science, business management or a related field. Master’s degree will be appreciated

• 3+ years of experience in Data Engineering

• Excellent command of data collection, data analysis methodologies

• Excellent command of ELT / ETL and Datawarehouse management processes and best practices

• Excellent command of ELT / ETL tools. Experience with Microsoft SSIS and / or Semarchy xDI will be highly appreciated

• Good command of programming languages such as SQL, Python, R

• Good knowledge of CI/CD pipelines, GIT

• Good knowledge of JSON, XML formats

• Good project management and business analysis fundamental knowledge will be highly appreciated (using JIRA, Confluence, ServiceNow, M365…)

• Strong analytical thinking and problem-solving skills.

• Excellent verbal and written communication skills to effectively present data-driven information.

• Attention to detail to ensure the integrity of the analysis.

• Critical thinking to analyze, challenge and translate business requirements.

• Experience working in cross-functional teams or on significant transformation projects.

• Ability to engage and collaborate with IT and business teams.

• Residence 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.