Data Ops Engineer @ EFG Hermes

General Info

• Department: IT & Digital – Data Engineering / Data Services
• Work time Percentage: 100%
• Location: Geneva

Our Company

EFG International is a global private banking group, offering private banking and asset management services. We serve clients in over 40 locations worldwide. EFG International offers a stimulating and dynamic work environment and strives to be an employer of choice. EFG is committed to providing an equitable and inclusive working environment that is founded on the principle of mutual respect. Joining our team means experiencing a supportive environment, where your contributions are valued and recognised. We strongly believe that the diversity of our teams gives us a competitive advantage by fostering better decision-making and greater innovation.

Our Purpose and Mission

Empowering entrepreneurial minds to create value – today and for the future. We are a private bank, offering personalised solutions on a global scale to private and institutional clients. Our sustainable success is based on our talents and on how we partner with our clients and communities to create lasting value.

Job Description

As a Data Ops Engineer (Authorised Officer) within our IT & Digital division, you will play a key role in the DeltaFlow programme, which is migrating EFG’s analytics platform from SQL Server / Talend / SSAS to a modern Databricks lakehouse with a Microsoft Fabric semantic layer.

You will be responsible for onboarding datasets from core banking systems and existing SQL Server environments into governed, production-grade data products using an established, configuration‑driven framework. This is a delivery‑focused role in a FINMA‑regulated environment, requiring strong technical skills, high attention to detail and a rigorous approach to data quality, documentation and controls.

In addition, you will contribute to the smooth day‑to‑day operation of our data integration services, including change management, SLA monitoring, quality assurance and continuous improvement of operational procedures and documentation. You will collaborate closely with IT, Data, and business support stakeholders to ensure robust governance and reliable data for reporting and analytics across the bank.

Key Responsibilities

• Deliver end‑to‑end onboarding of new datasets from core banking systems and existing SQL Server environments through the Databricks medallion layers (Bronze/Silver/Gold) into governed Gold data products in production.
• Apply and enhance the existing configuration‑driven framework (declarative pipelines and configuration files) by following established patterns, standards and conventions to ensure consistency and maintainability.
• Design and implement robust data transformations in Databricks using PySpark and SQL, including data cleansing, historisation (e.g. SCD1/SCD2) and dimensional modelling aligned with agreed business requirements and data models.
• Define, implement and monitor data quality controls (e.g. completeness, uniqueness, referential integrity, source‑to‑target reconciliations) to ensure reliable data for Finance, Risk, Compliance and Front Office stakeholders.
• Deploy changes across DEV, UAT and PROD environments using CI/CD practices and tooling (e.g. Git, Databricks Asset Bundles, Azure DevOps), ensuring traceability, reproducibility and adherence to internal release processes.
• Analyse and interpret existing SQL Server data warehouse models, stored procedures and datamarts to correctly map and migrate data into the Databricks lakehouse and Microsoft Fabric semantic layer.
• Support operational activities for data integration services, including change management, incident follow‑up, SLA and KPI monitoring, and timely escalation of issues impacting critical business processes.
• Maintain and continuously improve operational documentation and standard operating procedures (SOPs) to ensure they remain accurate, compliant with internal and regulatory requirements, and easy to follow for IT and business support teams.
• Collaborate with IT, Data Governance, Finance, Risk and other business stakeholders to strengthen governance around integration processes, gather feedback and propose improvements to ways of working and operational efficiency.

Requirements and Qualifications

Education

• Minimum: University degree (Bachelor or equivalent) in Computer Science, Information Systems, Engineering, Mathematics or a related field.
• Preferred: Master’s degree or equivalent further education in Data Engineering, Data Science or a related technical discipline.

Professional Experience

• Minimum 3–5 years of hands‑on experience in data engineering or data operations roles, ideally within financial services or another highly regulated industry.
• Proven track record delivering end‑to‑end data integration and analytics solutions on Databricks or similar cloud‑based data platforms.
• Experience working with data warehouse environments based on SQL Server, including migration or modernisation projects.

Technical and Functional Knowledge

• Strong, practical experience with Databricks, including PySpark, Delta Lake, Unity Catalog and the medallion (Bronze/Silver/Gold) architecture.
• Excellent SQL skills and solid experience with SQL Server, including the ability to read and analyse existing data warehouse models, stored procedures and datamarts.
• Sound data modelling expertise, particularly dimensional modelling (facts/dimensions), business keys, grain definition and historisation (SCD1/SCD2).
• Solid CI/CD mindset, including use of Git, automated deployments and “data integration as code” practices.
• High level of rigour and discipline in a regulated environment, with strong focus on reproducibility, traceability, testing principles and robust release patterns for data pipelines.
• Good knowledge of private banking products and associated data (e.g. positions, transactions, portfolios, client hierarchies) and their use in reporting and analytics.
• Preferred: Experience with Databricks Asset Bundles, Azure DevOps and streaming or change‑data‑capture (CDC) ingestion patterns.

Languages

• French: working proficiency (spoken and written).
• English: working proficiency (spoken and written).

Our Values

• Accountability: Taking ownership for tasks and challenges, as well as seeking continuous improvement
• Hands-on: Being proactive to rapidly deliver high-quality results
• Passionate: Being committed and striving for excellence
• Solution-driven: Focusing on client outcomes and treating clients fairly with a risk-aware mindset
• Partnership-oriented: Promoting collaboration and teamwork. Working together with an entrepreneurial spirit.