At a Glance
- Tasks: Shape data strategies, manage dashboards, and analyse trends to drive business decisions.
- Company: Join a rapidly expanding FMCG business focused on innovation and growth.
- Benefits: Enjoy hybrid work options, competitive salary, and opportunities for professional development.
- Why this job: Be part of a dynamic team that values data-driven insights and fosters collaboration.
- Qualifications: Experience in data analysis, advanced Excel skills, and familiarity with Dynamics 365 Business Central required.
- Other info: Opportunity to influence key business decisions and work with cutting-edge technology.
The predicted salary is between 40000 - 66000 £ per year.
Are you a data-driven problem solver who thrives in a fast-paced, high-growth environment? Do you enjoy using technology and analytics to drive smarter business decisions and eliminate inefficiencies? If so, this could be the perfect opportunity for you.
We’re looking for a Data and Systems Analyst to join the finance function of a rapidly expanding FMCG business. This is a strategically important role for someone passionate about data, automation, and process optimisation. You’ll sit at the intersection of finance, commercial and operational teams, helping unlock insight, streamline reporting, and improve performance across the business.
What You’ll Be Doing:
- Shape the company’s data and systems strategy alongside the leadership team.
- Build and manage dashboards to monitor key business KPIs across commercial, customer service, and operations.
- Transform raw data from platforms like ERP, WMS, and e-commerce systems into actionable insights that support decision-making.
- Analyse monthly sales, pricing, margin, and operational data to identify trends and value opportunities.
- Partner with Marketing to track campaign ROI, customer lifetime value, and optimise acquisition spend.
- Support Commercial teams by uncovering upsell/cross-sell opportunities and evaluating pricing/promotional strategies.
- Forecast demand and support inventory planning with robust trend analysis models.
- Lead ongoing development and optimisation of Microsoft Dynamics 365 Business Central, ensuring systems are fully integrated with sales channels such as Amazon, Shopify, and eBay.
- Build the use of Power BI as a central reporting platform and support preparation of monthly Board reports.
- Troubleshoot systems/data issues and champion data quality, governance, and compliance (including GDPR).
- Support internal teams with system training and encourage a culture of data-led decision making.
What We’re Looking For:
- Solid experience in a systems, operations or data analysis role – ideally within FMCG, e-commerce, or SaaS.
- Advanced Excel skills and confident working with large datasets.
- Experience using Microsoft Dynamics 365 Business Central and Power BI (or similar tools).
- Strong attention to detail, analytical skills and a proactive approach to problem-solving.
- Exposure to fast-paced, high-growth environments is a definite advantage.
- A willingness to be based on site 3 days a week as a minimum.
Bonus Points For:
- Familiarity with Shopify, Amazon Vendor Central, or CRM tools.
- SQL or data querying experience.
- Experience in a finance business-partnering environment.
- An understanding of how AI tools (e.g., ChatGPT) can be leveraged for insight generation and efficiency.
You’ll Be:
- A natural self-starter with strong initiative and accountability.
- Comfortable navigating ambiguity and adapting to change.
- A confident communicator who can explain complex data to non-technical stakeholders.
- Collaborative and happy to work cross-functionally across teams.
This is an exciting opportunity to join a scaling business at a pivotal moment, helping to shape its data capabilities and drive real impact across the organisation.
Locations
Data and Systems Analyst (Dynamics 365 Business Central) employer: Source & Connect
Contact Detail:
Source & Connect Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data and Systems Analyst (Dynamics 365 Business Central)
✨Tip Number 1
Familiarise yourself with Microsoft Dynamics 365 Business Central and Power BI, as these are crucial tools for the role. Consider taking online courses or tutorials to enhance your skills and demonstrate your commitment to mastering these platforms.
✨Tip Number 2
Network with professionals in the FMCG and e-commerce sectors. Attend industry events or join relevant online forums to connect with people who can provide insights into the company culture and expectations, which can help you tailor your approach.
✨Tip Number 3
Prepare to discuss specific examples of how you've used data analysis to drive business decisions in previous roles. Highlight any experience with forecasting demand or optimising processes, as these are key responsibilities in this position.
✨Tip Number 4
Showcase your problem-solving skills by thinking of innovative ways to present data insights. Consider creating a mock dashboard or report that demonstrates your analytical abilities and understanding of key performance indicators relevant to the FMCG sector.
We think you need these skills to ace Data and Systems Analyst (Dynamics 365 Business Central)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data analysis, systems management, and any specific tools mentioned in the job description, such as Microsoft Dynamics 365 Business Central and Power BI.
Craft a Compelling Cover Letter: In your cover letter, express your passion for data-driven decision-making and provide examples of how you've used analytics to drive business improvements in previous roles.
Showcase Relevant Skills: Emphasise your advanced Excel skills and experience with large datasets. Mention any familiarity with e-commerce platforms like Shopify or Amazon, as well as your problem-solving abilities.
Highlight Your Adaptability: Given the fast-paced nature of the role, include examples that demonstrate your ability to adapt to change and navigate ambiguity, showcasing your self-starter attitude.
How to prepare for a job interview at Source & Connect
✨Showcase Your Data Skills
Be prepared to discuss your experience with data analysis and systems management. Highlight specific projects where you've transformed raw data into actionable insights, especially using tools like Microsoft Dynamics 365 Business Central and Power BI.
✨Understand the Business Context
Research the FMCG industry and the specific company you're interviewing with. Understand their products, market position, and challenges they face. This will help you tailor your answers and demonstrate your interest in the role.
✨Prepare for Technical Questions
Expect questions that assess your technical skills, particularly in Excel and data querying. Brush up on your knowledge of SQL and be ready to solve problems or analyse datasets during the interview.
✨Demonstrate Your Problem-Solving Approach
Share examples of how you've tackled complex problems in previous roles. Emphasise your analytical skills and proactive approach, especially in fast-paced environments, to show that you can thrive in their high-growth setting.