We are currently recruiting an exciting opportunity for a Senior Data Engineer with significant advanced experience to join our Business Intelligence team. As the business looks to take an increasingly data driven approach to change, we are expanding the team to provide additional capabilities and support, ensuring we continue to deliver the best outcomes and service for our clients and stakeholders.
The Role
The successful candidate will initially be focused on supporting a significant project as we migrate from on premise to the cloud. This will involve designing, implementing and monitoring automated data pipelines. There will also be a responsibility to build and maintain new and existing data infrastructure in response to business needs. As the successful candidate comes to understand the business further there will be more integration of BAU work into the role. Due to the variety of work that will be undertaken, some projects may be longer term pieces that take months to complete and others may involve working to shorter 2 week cycles.
Primary Responsibilities:
- Liaise with experts within the business to understand how you can best support their data needs.
- Fleshing out business requirements relating to data, utilising your previous experience and colleagues' understanding of the business.
- Designing and implementing new automated data pipelines.
- Maintaining and monitoring newly created and existing automated live data pipelines, ensuring the data is accurate and is still fit for purpose.
- Building and maintaining data infrastructure.
- Support and mentor other members of the Business Intelligence team, outlining best practice and knowledge sharing to achieve business objectives.
Other duties and Responsibilities:
- Maintain accurate version control using Git.
- Ensuring schema design supports high query efficiency and scalability.
- Use CI/CD to automate testing, deployment and monitoring of data pipelines.
- Keeping up to date with data best practice within a regulated Financial Services environment.
Person Specification
The role requires an individual with significant relevant data engineering experience, so they are comfortable problem solving with minimal supervision on large scale projects. The ideal candidate will also be comfortable working as part of a small team and have strong communication skills to liaise with business stakeholders. Candidates must have advanced SQL and Snowflake experience including optimization and best practice understanding. They must also have Azure Dev Ops experience and be comfortable with Data Warehousing concepts.
We offer a competitive remuneration package, including company discretionary bonus, excellent pension contributions, an attractive staff share scheme, BUPA health insurance, buying and selling of annual leave and sponsorship of relevant professional qualifications.
The role is based in our central London office, working a minimum of two days a week in the office and three days a week from home.
About Us
Transact is the leading independent investment wrap platform in the UK. Established in 2000, we have over £62 billion of funds under direction (as at June 2024) on behalf of over 7,900 advisers and 234,000 investor clients. Our service includes an online platform, owned and built by us, and dedicated regional adviser support to help bring clients' assets and investments together in a smarter, more tax efficient way. We offer access to a wide range of tax wrappers (including ISAs, pensions and life insurance investment bonds) and funds which advisers use to build client investment portfolios. Portfolio valuations, purchases and sales are all supported via Transact Online which is available 24/7. Transact's parent company, IntegraFin Holdings plc, is listed on the London Stock Exchange and is a constituent of the FTSE 250 index.
Equal Opportunities
We provide a diverse and inclusive workplace and ensure that all of our staff respect and understand individual differences. We are an equal opportunities employer and positively encourage applications from suitably qualified and eligible candidates regardless of age, disability, gender reassignment, marital or civil partner status, pregnancy or maternity, race, religion or belief, sex or sexual orientation.