Data Integration Engineer at Stonehage Fleming

OVERALL PURPOSE

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

PRINCIPAL ELEMENTS & ACCOUNTABILITIES

• Drawing on best practise 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 / re engineering 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.

QUALIFICATIONS AND EXPERIENCE

• Strong skills in SQL queries and optimization
• Python, Mage.ai – scripting and automation
• dbt and WhereScape 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)

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