At a Glance
- Tasks: Shape data strategies, manage dashboards, and transform raw data into insights.
- Company: Join a rapidly expanding FMCG business focused on innovation and growth.
- Benefits: Enjoy hybrid work options and competitive salary between £50k-£55k.
- Why this job: Be part of a dynamic team driving impactful decisions through data and technology.
- Qualifications: Experience in data analysis, advanced Excel skills, and familiarity with Dynamics 365 Business Central required.
- Other info: Opportunity to work cross-functionally and influence key business strategies.
The predicted salary is between 40000 - 77000 £ 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.
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 others who work in similar roles. This can provide valuable insights and potentially lead to referrals.
✨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 you have with forecasting demand or optimising processes, as these are key aspects of the job.
✨Tip Number 4
Showcase your problem-solving skills by thinking of innovative ways to present data insights. Consider creating a portfolio of dashboards or reports that you've developed, which can help illustrate your analytical capabilities during interviews.
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 Cultural Fit: Demonstrate your adaptability and collaborative nature in your application. Mention experiences where you successfully worked cross-functionally or thrived in fast-paced environments.
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 genuine interest in the role.
✨Prepare for Technical Questions
Expect questions that assess your technical proficiency, particularly in Excel and data querying. Brush up on your skills and be ready to solve problems or analyse data on the spot during the interview.
✨Communicate Clearly
Practice explaining complex data concepts in simple terms. As a Data and Systems Analyst, you'll need to communicate findings to non-technical stakeholders, so demonstrating your ability to do this effectively will be crucial.