Data Engineer

WHO WE ARE:

interactive investor is an award-winning investment platform that puts its customers in control of their financial future.

We’ve been helping investors for over 25 years. We’ve seen market highs and lows and been resilient throughout. We’re now the UK’s number one flat-fee investment platform, with assets under administration approaching £55 billion and over 400,000 customers.

For a simple, flat monthly fee we provide a secure home for your pensions, ISAs, and investments. We offer a wide choice of over 40,000 UK and international investment options, including shares, funds, trusts, and ETFs.

We also bring impartial, expert content from our award-winning financial journalists, highly engaged community of investors, and daily newsletters and insights.

WHAT WE STAND FOR:

It’s simple … we want our customers to feel confident and in control, for interactive investor to go from strength to strength, and for ii to be a workplace where we can all thrive. Our customer-driven approach and bold values sit at the heart of this. We are honest, straight-talking, and transparent with our customers and our colleagues. We are decisive and take ownership of what we say and deliver. We are ambitious and passionate about what we believe is right for our customers, our teams, ourselves, and interactive investor.

PURPOSE OF ROLE:

Reporting to the Head of Data and Automation, as part of the Data and Innovation team, this role will help ii to curate the firm’s Data Warehouse which collects customer data, transaction records, email campaigns, web analytics, and market data to provide a comprehensive analytics source for the business.

As a Data Engineer, you will help to collect and transform data from various sources and organise data in a way that data analysts across the business can self-serve using our BI tools. For some teams, you will also augment analytics capabilities by preparing outputs and BI dashboards to support Operational MI and ad-hoc BI queries.

We wish to extend our team’s Data Science capabilities, so you will have a desire to stay up-to-date with the latest data tools and technologies and you will be comfortable in using pre-packaged machine learning algorithms to provide advanced and predictive analytics services.   You will also have a sound understanding of key machine learning algorithms in order to select appropriate algorithms and interpret results.

We are seeking candidates with a range of experience levels, from Junior to Senior and Principal positions.

KEY RESPONSIBILITIES:

• Supporting the daily Warehouse Build, investigating and remediating any issues from overnight jobs
• Creating new jobs to ingest data that collect, transform, clean, and prepare data for the BI Mart
• Developing new and supporting existing BI dashboards and reports
• Provide Data Analysts with data extracts or SQL queries to support regular or ad-hoc BI questions
• Monitoring Data Request tickets for ad-hoc data requests within business functions or to provide transaction records for legacy data requests
• Understanding the lineage of all data surfaced in the BI Mart and advising Data Analysts on which fields are most appropriate to support a particular need
• Advancing the team’s Data Science capabilities by exploring predictive analytics/machine learning algorithms that may help with business priorities such as customer acquisition, cross-selling, engagement, and retention
• Maintaining the documentation for the Data Warehouse including design documentation to accompany new scripts/processes and corresponding Data Dictionaries

SKILLS & EXPERIENCE REQUIRED:

• In depth knowledge of fundamental database concepts (design and queries) and strong knowledge of advanced topics (management and optimising)
• Advanced SQL knowledge: can write new and interpret existing complex multi-join aggregation queries
• Advanced understanding of data mart concepts: eg, star schemas, snapshot tables, slowly changing dimensions
• Strong knowledge of Python with a focus on scripting data collection and transformation queries
• Understanding of version control software (ideally Git)
• Experience of developing dashboards using a BI visualisation tool (ideally PowerBI)
• Knowledge of statistical techniques for Hypothesis testing, Z-Test, Chi2-test
• Understanding of machine learning techniques using libraries such as H2O, Keras, PyTorch, Fast.ai, Tensorflow
• Analytical and logical thinker
• Can translate high level requirements into an appropriate set of data requirements