Improve International
BI Data / Analytics Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
As part of our IT team and a member of our Business Intelligence unit, you will play a pivotal role in developing the data maturity of our business and establishing a culture of data-driven commercial decision making across the organisation.
Reporting to the Commercial Finance Manager in the UK, you will build a holistic view of the context behind and commercial importance of our new and existing data solutions, and your role will focus on ensuring the underlying data is neatly stored, accurate, reliable, and readily available in the appropriate format for external analysis and reporting.
As the steward of our new data warehouse, you will also be the main source of knowledge for all data-related queries, and you will be responsible for troubleshooting any issues with our existing datasets.
There may also be opportunities to develop your skills through relevant training or professional certification where these align with your career ambitions and support business objectives.
From day 1, you will therefore be a highly-valued, core enabler of the continued growth of our business.
Key Responsibilities
Your responsibilities in this role will include:
- Reporting to the Commercial Finance Manager and attending weekly meetings with the IT team and Business Intelligence unit, providing progress updates on your live projects and helping to shape the roadmap for future projects;
- Managing our data warehouse in BigQuery, ensuring data is stored methodically and any data challenges or inconsistencies are addressed promptly;
- Extracting, transforming, and loading data from our software stack, including pre-packaged software and bespoke in-house platforms, into BigQuery – both for our core business and any new businesses that we acquire;
- Writing and maintaining Python-based ETL connectors to extract data from APIs (e.g. HubSpot, Sage HR) and relational databases (e.g. MySQL) into BigQuery;
- Building and maintaining data transformation models in dbt, including testing and documentation, to ensure trusted, analytics-ready datasets;
- Orchestrating and monitoring ETL / transformation jobs using Dagster, including troubleshooting pipeline failures and schema drift;
- Using Git for version control and collaborating on changes to the ETL codebase and dbt project;
- Managing a portfolio of data visualisation solutions in Power BI, and continuously updating user guides to help stakeholders navigate these solutions effectively;
- Developing new data visualisation solutions in Power BI at the request of various departments, liaising with key stakeholders to understand their specifications and reacting to changing priorities in line with business needs;
- Proactively communicating with your IT colleagues to discuss any technical or system-related considerations underpinning your projects.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Qualifications & Experience
The candidate must meet the following essential criteria:
- Advanced proficiency in interpreting and writing SQL;
- Prior experience of working with a data warehouse, ideally BigQuery;
- Prior experience of working with Power BI or an equivalent data visualisation platform (e.g. Tableau) for developing new dashboards;
- Prior experience with an ETL tool and managing ETL pipelines;
- Proficiency in Python for building and maintaining data extraction and transformation scripts;
- Prior experience with dbt or a similar data modelling / transformation tool;
- Prior experience with a workflow orchestration tool (e.g. Dagster, Airflow);
- Proficiency with Git or another version control system.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
It would also be desirable for the candidate to meet some or all of the following:
- Prior experience in managing a portfolio of data products / solutions;
- Prior experience of working with financial data;
- Prior experience of working in a multi-geography organisation with cross-border colleagues;
- Prior experience working with cloud platforms (e.g. GCP), including secret / credential management;
- Prior experience with Linux and bash scripting for managing data infrastructure.
Personal attributes/characteristics
The ideal candidate for this role must demonstrate the following:
- Advanced proficiency in English reading and writing;
- Strong organisation skills, and able to manage and progress multiple live projects at once;
- Flexible and agile, and able to seamlessly re-balance priorities in line with business needs;
- Confident, proactive and vocal in challenging data integrity / assumptions;
- Strong level of initiative in creating inventive, time-saving solutions that will achieve the same desired output;
- Good level of commercial acumen and business literacy, or a keen desire to build on this knowledge.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location