About The Role
Purpose
Work within the transformation program to develop new data ingestion and storage structures and capabilities. Work within 7IM Azure cloud environment to enhance 7IM platform data and reporting capabilities.
Develop and build, along with the Data Architect and Squad Engineering capabilities, the data reporting landscape within Azure to provide greater and more efficient data access. This role is a 6 month fixed term contract.
Responsibilities
Develop and build Data ingestion framework into Azure. Build the ETL/ELT loading, logging and Auditing templates and structure. Enhance the existing development resources and provide education and knowledge sharing of approaches to increase data teams’ development velocity.
About You
Knowledge
Data ingestion, Data Lake, Datawarehouse knowledge based on Azure Data Services and Cloud Analytics approaches including Delta, Medallion Architecture or other Datawarehouse approaches.
ETL/ELT framework and best practise Loading for Azure Cloud Storage and Compute.
Batch processing, Streaming and real time reporting experience.
Skills/Other relevant information
Experience of Azure Data Factory/Azure Fabric Pipelines, Azure SQL, Azure Synapse Analytics and Spark. Knowledge of Azure Fabric capabilities an advantage. Azure Purview knowledge or other relevant Data Governance working knowledge.
Understanding of SQL Server Integration Services, Reporting Services and SQL Server structure.
Qualifications
Relevant Data qualifications, including Microsoft and other recognised Data Certifications in Data Engineering, analytics and Architecture.
About Us
About 7IM
The ‘7’ in 7IM refers to the seven original founders of the business. Back in 2002, they couldn’t find a firm they trusted to manage their families’ money properly – big banks seemed impersonal and greedy, while most boutiques lacked the necessary investment process and structure. They started the kind of organisation they’d like to invest with themselves.
Their aim was to deliver steady returns over the long term, while keeping an eye on risk, using the best technology. They wanted everyone to have access to the kind of service and expertise that institutional investors would expect.
We’ve evolved since then. In 2015 Caledonia Investments joined us as a major shareholder. In 2018 we acquired Tcam Asset Management, a firm we felt closely aligned with our investment philosophies and multi-asset approach. In 2020 we continued our long-term growth strategy and acquired the award-winning London based financial planning firm Partners Wealth Management (PWM). PWM will continue to operate as an independent company, retaining its brand, identity, and leadership.
Our team, our clients and our funds under management have grown steadily over the years. From our offices in London, and Edinburgh more than 400 talented people manage over £19 billion for a range of clients, including individuals and families, financial advisers, corporates, charities and trustees.
We still follow our founders’ plan and aim to get the simple things right all wrapped up with real, honest, human service – that’s what sets us apart from everyone else.