Data Management IT Officer at Stonehage Fleming

OVERALL PURPOSE

• The individual will be responsible, under his line manager supervision, for developing, reviewing, monitoring and supporting the Data Management tools, system projects and external tools in which Data Management is involved.

PRINCIPAL ELEMENTS & ACCOUNTABILITIES

• 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 as well as 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 his/her 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.

QUALIFICATIONS AND EXPERIENCE

• Strong skills in SQL queries and optimization
• Python, Mage.ai – scripting and automation
• Visual Studio – development and debugging
• Power BI – data visualization and reporting
• GoAnywhere MFT – secure file transfer (SFTP/FTP) (a plus)
• dbt – data transformation and modeling (a plus)
• Familiarity with DataStore, Dremio and Autorek (a plus)
• Knowledge of Business Central and Advent – ERP and Investement systems (a plus)

COMPETENCIES AND BEHAVIOURS

• 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