At a Glance
- Tasks: Analyze eCommerce data and create insightful dashboards to drive business decisions.
- Company: Join Connect, a leader in appliance spare parts, backed by the Kingfisher Group.
- Benefits: Enjoy retail discounts, employee support funds, and a learning management system.
- Why this job: Be part of a dynamic team transforming data into impactful strategies for eCommerce growth.
- Qualifications: Experience in data analysis and expertise in Power BI required; strong Excel and SQL skills preferred.
- Other info: Work 3 days in-office with a supportive culture and opportunities for professional development.
The predicted salary is between 36000 - 60000 £ per year.
About us: Connect, operating under the Screwfix banner and owned by the Kingfisher Group, is a leading name in the distribution of high-quality appliance spare parts and accessories. We are dedicated to delivering exceptional products and services to our diverse clientele across various sectors. We have over 50 years’ experience in the appliance spare parts industry. Our most recent opportunity has been becoming part of Screwfix, which has allowed us to continue to expand with the extensive support, knowledge and resources that the Kingfisher group has to offer. About the role and team: We are seeking a highly skilled and motivated eCommerce Power BI Analyst to join our team. The successful candidate will be responsible for analysing eCommerce data, building insightful dashboards, and providing actionable insights to drive business decisions. As an expert in Power BI and data analytics, you will support the marketing, product, and sales teams by transforming data into visually compelling reports and performance metrics that enhance our eCommerce strategies. This role will be working Monday – Friday 37.5 hours per week (3 days per week office based B37 7HG) The role will involve: Analysing eCommerce performance metrics (e.g., traffic, conversion rates, sales, customer behaviour) using Power BI and other BI tools Creating, maintaining, and updating interactive dashboards, reports, and visualizations that provide actionable insights to stakeholders Developing automated reporting processes to streamline data analysis for the marketing, product, and sales teams Monitoring and analyse eCommerce KPIs, trends, and forecasts to identify growth opportunities Providing insights into customer behaviour, product performance, and campaign effectiveness, helping to shape marketing and product strategies Collaborating with IT, data engineering, and marketing teams to ensure proper integration of eCommerce data from various sources (e.g. Google Analytics, Google ads, Microsoft ads, Google Big query) Maintaining data accuracy and integrity by performing regular audits and implementing data governance best practices Working cross-functionally with marketing, product management, operations, and sales teams to provide insights that enhance decision-making Supporting ad-hoc requests for data analysis and reporting from various stakeholders To be successful for this role you will have: Experience in data analysis, preferably in an eCommerce or digital marketing environment Proven expertise in using Power BI for data visualization and reporting Proficiency in Power BI, including DAX queries, Power Query, and report creation Strong understanding of eCommerce platforms (e.g. Google Analytics, Google ads, Microsoft ads, Google Big query Advanced Excel skills, including pivot tables, charts, and complex formulas Experience with SQL for querying and manipulating large datasets Knowledge of data integration tools (e.g., Power Automate, ETL processes) What we offer: Retail Trust – a free online support and counselling service Employee support fund – non-repayable loan to help you in times of need Enhanced Parent Policy Enhanced Company Sick Pay HapiApp – Lots of retail discounts (shops, gyms etc) Speak Up – a confidential service to report any incidents at work People Forum committee – a way for our people to have a say in the future of our business 20% discount within our retail stores Discount on all our stock Skillshub – a learning management system to boost your knowledge both in and out of the workplace PepTalk – a hub of hundreds of Pep Talks from industry professionals A generous Length of Service scheme Peakon Surveys – for you to have your say Charity events open for all to get involved in Company engagement events
BI Analyst employer: Connect a ScrewFix Company
Contact Detail:
Connect a ScrewFix Company Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Analyst
✨Tip Number 1
Familiarize yourself with the specific eCommerce metrics that Connect focuses on, such as traffic, conversion rates, and customer behavior. Understanding these key performance indicators will help you demonstrate your analytical skills during the interview.
✨Tip Number 2
Showcase your Power BI expertise by preparing a sample dashboard or report that highlights your ability to transform data into actionable insights. This practical demonstration can set you apart from other candidates.
✨Tip Number 3
Network with current or former employees of Connect or the Kingfisher Group on platforms like LinkedIn. Engaging with them can provide you with valuable insights about the company culture and expectations for the BI Analyst role.
✨Tip Number 4
Prepare to discuss your experience with data integration tools and SQL during the interview. Being able to articulate how you've used these tools in past projects will demonstrate your technical proficiency and readiness for the role.
We think you need these skills to ace BI Analyst
Some tips for your application 🫡
Understand the Role: Take the time to thoroughly read the job description for the BI Analyst position. Understand the key responsibilities and required skills, especially focusing on Power BI, data analysis, and eCommerce metrics.
Tailor Your CV: Customize your CV to highlight relevant experience in data analysis and eCommerce. Emphasize your expertise in Power BI, SQL, and any other tools mentioned in the job description. Use specific examples of past projects or achievements that align with the role.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data analytics and eCommerce. Mention how your skills can contribute to the company's goals and provide insights that drive business decisions. Be sure to reference your experience with Power BI and data visualization.
Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. Ensure that your application is clear, concise, and professional, as attention to detail is crucial in data analysis roles.
How to prepare for a job interview at Connect a ScrewFix Company
✨Showcase Your Power BI Expertise
Be prepared to discuss your experience with Power BI in detail. Highlight specific projects where you created dashboards or reports that provided actionable insights, and be ready to demonstrate your proficiency with DAX queries and Power Query.
✨Understand eCommerce Metrics
Familiarize yourself with key eCommerce performance metrics such as traffic, conversion rates, and customer behavior. Be ready to discuss how you've used these metrics in past roles to drive business decisions and improve strategies.
✨Collaboration is Key
This role involves working cross-functionally with various teams. Prepare examples of how you've successfully collaborated with marketing, product management, or IT teams in the past to achieve common goals.
✨Data Integrity Matters
Emphasize your commitment to maintaining data accuracy and integrity. Discuss any experiences you have with data audits or implementing best practices for data governance, as this will be crucial for the role.