Data Integration Engineer

3 Dock Rd, Cape Town City Centre, Cape Town, 8002, South Africa

Posted Thursday, December 18, 2025 at 4:00 AM

Data Integration Engineer

Stonehage Fleming provides a range of services from long-term strategic planning and investments to day-to-day advice and administration to over 250 families of wealth. The Group employs over 1000 people in 18 offices in 14 jurisdictions around the world.

The position sits within the Data Integration Team and reports directly to the Team Leader in the Data Integration Team. Other working relationships include all members of the Infrastructure, Security & Networking, Service Delivery, Site Management, Unified Communication teams as well as all users worldwide and external suppliers. The workplace is in South Africa.

The design, development and maintenance of data pipelines into the Lakehouse / warehouse framework from various structured and unstructured sources (ETL). Transform, catalogue, secure and manage availability of varied data types (i.e. transactional, reference and master data with varied availability requirements). Design and develop automated processes and solutions to integrate data with other applications and processes.

• Drawing on best practice and experience, assist in transitioning to and maturing the Lakehouse framework and associated technologies.
• Design and build ETL / ELT processes within the parameters of the framework, from various sources (including DB’s, API and other unstructured sources) into the Lakehouse framework.
• Transform data to ensure quality, consistency, secure and available data.
• Develop, support and document integration solutions between the data Lakehouse and downstream applications and third parties (Migrations, new/reengineering of existing solutions).
• Assist team to support and maintain existing data/business process and application (e.g. Payments, FX rates, MDS, etc) in both the existing SQL data warehouse and newly developed solutions in the Lakehouse environment.
• Assist with data mastering and data store solutions within MDS with the prospect of refining / reengineering within the Lakehouse framework.

• Strong skills in SQL queries and optimization
• Python, Mage.ai – scripting and automation
• dbt and Where Scape Red – data transformation and modeling (a plus)
• SCORCH and Alteryx – processing and automation tools (a plus)
• Familiarity with Dremio and Data Bricks (a plus)
• Knowledge of MDS (Master Data Management) and APIs (a plus)

• English at business level
• Ability to learn quickly and a willingness to share knowledge with colleagues
• Willingness to learn new technologies
• Flexibility, well developed sense of organization and personal responsibility
• Adaptability to a constantly evolving environment
  
  Team-oriented and skilled in working within a collaborative environment
• A knowledge of the financial environment and its terminology would be an advantage
• Ability to handle out-of-band requests
• Experience using project management tools is an advantage
• Follows up and ensures things get done in time
• Appropriate communication to people at all levels
• Ability to present ideas in business-friendly language
• Proven analytical and problem-solving abilities
• Ability to effectively prioritise and execute tasks in a high-pressure environment
• Understands & satisfies client needs at all time
• Takes prompt action & sees tasks through to completion

This role is for Cape Town or Johannesburg

3 Dock Rd, Cape Town City Centre, Cape Town, 8002, South Africa