Data Management IT Officer

Data Management IT Officer – Stonehage Fleming (Cape Town or Johannesburg, South Africa)

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

The position sits within the Data Management Team and reports directly to its Team Leader. It interacts with members of Infrastructure, Security & Networking, Service Delivery, Site Management, Unified Communication teams, users worldwide, and external suppliers.

The individual will be responsible, under line‑manager supervision, for developing, reviewing, monitoring and supporting the Data Management tools, system projects, and external tools the team uses.

• Monitoring of daily data pipeline to our databases and Data Lakehouse. Maintain and troubleshoot to ensure stability, performance and data integrity.
• Ensure timely and accurate delivery of data to external providers and external clients.
• Create load for new data pipeline using a standardized onboarding framework.
• Integrate new data sets into our automated reconciliation and posting tools.
• Build and maintain Power BI dashboards to support operational transparency and provide business insights.
• Support and troubleshoot our managed file transfer system.
• Maintain a holistic view of information assets by creating and maintaining blueprints that illustrate how data is stored, processed and accessed.
• Assist in monitoring and management of Data Management internal system projects and track progress against milestones and deadlines. Report on these items to the line manager.
• Anticipate, manage and resolve issues linked to Data Management tools and act as the point of contact.
• Understand the high‑level technical architecture and be able to facilitate debate and drive decisions on appropriate solutions.

• Strong skills in SQL queries and optimization
• Python, Mage.ai – scripting and automation
• Visual Studio – development and debugging
• Power BI – data visualization and reporting
• Go Anywhere MFT – secure file transfer (SFTP/FTP) (a plus)
• dbt – data transformation and modeling (a plus)
• Familiarity with Data Store, Dremio and Autorek (a plus)
• Knowledge of Business Central and Advent – ERP and investment systems (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

• Entry level

• Full‑time

• Information Technology