IT Junior Data Warehouse Engineer - UK - Jersey

Job Description

DescriptionStonehage Fleming is one of the worlds leading independently owned family offices and the largest in Europe, Middle East and Africa (EMEA), as measured by its breadth of services, geographic reach and by assets under management, advice and administration. 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. WORKING RELATIONSHIPS The position sits within the Business Systems Team and reports to the Head of Data Architecture based in Jersey. Other working relationships include all members of the Infrastructure, Security & Networking, Service Delivery, Site Management, Unified Communicationteams as well as all users worldwide and external suppliers. The workplace is in Jersey. Key ResponsibilitiesOVERALL PURPOSE The purpose of the role is to assist with the design, development and maintenance of the data warehouse environment and associated applications, used for analytics, reporting and application master data management. The role also encompass some specific developmentsfor wider data processes and integration, regulatory work as well as some ad hoc ETL and data extraction tasks. PRINCIPAL ELEMENTS & ACCOUNTABILITIES • Working closely with the Data Team, Business and Programme Manager across the Stonehage Group to design and develop and enhance the Data Warehouse in line with our corporate strategies, plus reporting and analytics capabilities. The design and development of ingesting and or distributing various collective data sources / sets between applications, internal and external parties. • Working with the data colleagues to identify and resolve data issues through configuration of data cleansing and master data / de-duplication projects and repositories. • Managing and improve monitoring of the data related jobs and processes to ensure that jobs are successfully run and any remediation actions are applied. • Working with business analysts and project managers to develop and refine the Warehouse and reporting/ analytics requirements. • Data Documentation - Ensure that data flows configured internally within the data warehouse are reflected in as-built documentation (data lineage diagrams) where all new marts should have documentation available immediately on production release. • Communication - Ensure that all data warehouse issues are logged and communicated appropriately immediately after the issue occurs. QUALIFICATIONS AND EXPERIENCE • A degree level qualification and/or equivalent experience in a relevant field • At least 4 years experience working with standard structured query language including MS SQL. • At least 4 years experience working on MS database technology used for business intelligence and/or analytics • Any experience of other ETL tools would be beneficial. • Experience working with Wealth and Investment applications and data. • Experience with analysing complex requirements • Experience in creating / maintaining as-built documentation. • A strong desire to learn new technologies and expand knowledge in the MS SQL and data-warehousing environment. SKILLS • English at business level • Good written, oral, and interpersonal communication skills • Keen attention to detail • Team-oriented and skilled in working within a collaborative environment • Project Management skills or knowledge • Business Analysis knowledge • Technical skills. • Financial Services knowledge COMPETENCIES AND BEHAVIOURS • Self-starter and ability to independently manage work • Follows up and ensures things get done in time • Strong communication to people at all levels, written, verbal and establishing and developing relationships • 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 • Practiced in project management methodologies • Understands and satisfies client needs at all time • Takes prompt action and sees tasks through to completion • Comfortable working in a collaborative team