The role focuses on building product reports for the Connected Store, managing ETL processes, utilizing BI tools, monitoring KPIs, and collaborating with teams.
JOB ROLE
We are seeking a Business Intelligence Engineer to build and maintain productized reports for the Connected Store product, which supports multiple retailer and brand programs across the USA, UK, and South Africa. The ideal candidate will possess strong business intelligence (BI) engineering skills, complemented by a robust technical background and a solid understanding of basic data engineering practices. Proficiency in data structures, Python data tools, query languages, and Tableau will be highly beneficial for this role.
RESPONSIBILITIES
- Reporting and Analysis: Develop, standardize, and maintain product reports and dashboards to monitor the performance of connected store network operations, including media and sales performance reports.
- Data Management:
- Establish and maintain appropriate ETL (Extract, Transform, Load) processes to integrate data from various internal and external sources.
- Ensure the accuracy, consistency, and reliability of data by implementing rigorous data cleaning and validation procedures.
- Design and optimise data pipelines to facilitate efficient data flow and processing.
- Manage and organise large datasets to support business intelligence reporting and analysis.
- Continuously monitor and refine ETL processes to adapt to changing data sources and business requirements.
- Collaborate with data engineers and other stakeholders to ensure seamless data integration and accessibility.
- BI Tools Utilization:
- Utilize BI tools like Tableau and Grafana to create reports, dashboards, and visualizations that provide actionable insights.
- Optimize BI tools to ensure optimal performance when embedding reports and support upgrades, configuration, and troubleshooting.
- Performance Monitoring: Assist with establishing key performance indicators (KPIs) across the product, including network operations, system performance, and program performance defined by media and sales metrics.
- Collaboration: Work closely with cross-functional teams, including finance, operations, and sales, to support strategic initiatives.
- Documentation: Maintain clear and thorough documentation of processes, methodologies, and analyses.
- Continuous Improvement: Identify opportunities for process improvements and implement changes to enhance efficiency and effectiveness.
REQUIREMENTS
- 5+ years of experience in a related field.
- Bachelor's or Graduate's Degree in Computer Science, Engineering, Mathematics, Information Systems, or a related field.
- Proven experience working with and establishing ETL processes.
- Proficiency in data visualization tools such as Tableau.
- Strong technical background with an understanding of basic data engineering practices.
- Experience with Python and related data tools.
- Familiarity with data structures, query languages (MySQL), and database management.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills.
- Ability to work independently and collaboratively in a fast-paced environment.
- Experience with monitoring KPIs and performance metrics.
- Experience in the retail or media industry is a plus.
- Familiarity with Agile methodologies and version control systems is an advantage.
Top Skills
Grafana
MySQL
Python
Tableau
Barrows London, England Office
23 Lonsdale Road, London, United Kingdom, NW6 6RA
Similar Jobs
Beauty • Digital Media
The Senior BI Engineer will lead data projects, own the BI data platform, mentor team members, and foster a data-driven culture in finance operations.
Top Skills:
GCPPythonSQL ServerSsasSsrsSupersetTableau
Artificial Intelligence • Cloud • Machine Learning • Mobile • Software • Virtual Reality • App development
Lead a team of mobile engineers to develop and enhance Lens+ subscription products while collaborating with various stakeholders and ensuring high-quality code standards.
Top Skills:
AndroidGen AiiOS
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
The KYC Services Specialist manages client due diligence, ensuring compliance with AML and CTF regulations, conducting KYC reviews, and assessing risks. Responsibilities include verifying identities, updating systems, monitoring transactions, and engaging with clients while maintaining compliance standards.
Top Skills:
ExcelMS Office
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
