Sales Analyst

Job Reference: /HS/08-01/1046/24

Job Title: Sales Analyst

Location: Ipswich

Salary: Competitive

Hours per week: Monday to Friday - 37.5 hours per week

Business Overview

Atalian Servest and OCS have merged to create a new organisation, the OCS Group UK & Ireland. We are a leading facilities management company providing a range of both standalone and integrated services including cleaning, catering, security, technical services, energy management and compliance, front of house, landscaping, logistics, waste management and pest control services. The company has a turnover of GBP1.5bn and operates across the UK and Ireland with 50,000 colleagues delivering innovative award-winning services to the private and public sectors and supporting the local communities in which it operates.

Role Overview

We are currently recruiting for a Sales Analyst to join our passionate and driven team.

As a leading provider of Facilities Management services, OCS UK & Ireland is committed to creating sustainable solutions that align with our clients goals and objectives. To support our mission, we are looking for a Sales Analyst to join our internal sales organisation. This role is essential for managing the reporting from Salesforce on all sales activity using centralised Power BI tools. The Sales Analyst will have strong analytical skills, attention to detail, and excellent communication skills.

The Sales Analyst will collaborate with Client Solutions Director and the Chief Commercial Officer to design and develop metrics that are consistent with OCS business strategy. By leveraging data insights, visualisations, and analytical expertise, the Sales Analyst will help facilitate informed decision-making, and drive organisational growth. The Sales Analyst will also be responsible for implementing best practices for sales operations, such as forecasting, pipeline management, and performance analysis. The Sales Analyst will be a leader in promoting sales excellence and efficiency across the organisation.

The role will have the opportunity to work with a dynamic team, and to make a significant impact on the growth and success of the business.

Benefits

• Informal hybrid/flexible working arrangements
• 25 days holiday + bank holidays
• Free fruit in our office
• Employee Referral Scheme (if you refer a successful candidate to one of our vacancies)
• Wide range of retail discounts
• Regular social and charity events are held in our offices
• Get involved in charity events in the local community

Wellbeing

• Discounted gym membership
• Eye test GBP25 voucher and up to GBP100 towards glasses
• Join our Cycle to Work scheme via salary sacrifice
• Access to CHROMA , our internal colleague-led diversity and inclusion community join a committee or take part in our D&I initiatives and events
• Access to internal Mental Health First Aiders

Career development and recognition

• Immediate access to Opportunity our internal Learning and Development platform
• Required professional membership fees paid for
• Opportunity to win monthly Atalian Servest Superstar Awards
• Long service awards

Key Responsibilities:

The Sales Analyst plays a vital role inside OCS, as they are responsible for transforming data from Salesforce and other sources into actionable insights using Power BI. The Sales Analyst is expected to have the following skills and competencies:

• Pipeline Data Management: Collaborate with Sales Teams to ensure pipeline hygiene and data consistency.
• Data Analysis & Visualisation: Design, build, and maintain data models, reports, and dashboards using Power BI and Salesforce reporting, translating complex data into actionable insights.
• Collaboration with Sales Team: Work closely with the UK & Ireland sales teams to understand key performance indicators (KPIs) and deliver precise analyses that support sales strategy and objectives.
• Data Integrity & Security: Implement data quality checks and adhere to data governance and compliance standards across the Salesforce platform.
• Salesforce Data Management: Extract, transform, and load data from Salesforce using various tools and methods.
• Power BI Mastery: In-depth knowledge of Power BI, including designing and deploying compelling data visualisations and reports, managing Power BI services, and creating custom content packs, dashboards, and reports.
• Data Modelling Expertise: Ability to create and manage complex data models, including measures, calculated columns, and relationships, using DAX expressions.
• SQL Proficiency: Extensive experience in writing and optimising SQL queries and working with various relational databases.
• Data Transformation and Integration: Skill in data transformation, cleansing, and integration with various data sources, both structured and unstructured.
• Data Governance and Security Compliance: Understanding of data governance principles, including security protocols, user permissions, data quality checks, and GDPR compliance within Power BI.
• Excel and Office 365 Integration: Experience in integrating Excel and other Office 365 tools with Power BI, creating cohesive and user-friendly interfaces for stakeholders.
• Cloud Platforms Knowledge: Experience in working with cloud platforms like Salesforce and Azure, managing data gateways, and ensuring seamless data connectivity.
• Version Control and Collaboration Tools: Utilising version control systems and collaboration tools like SharePoint to manage projects and ensure alignment with team members.
• Continuous Learning and Certification: Commitment to continuous professional development, staying abreast of the latest Power BI updates, tools, and acquiring relevant certifications, such as the Microsoft Certified: Data Analyst Associate.
• Performance Optimisation: Skill in identifying and resolving performance issues, utilising best practices in Power BI report and query optimisation.
• API Integration: Experience in integrating Power BI with different APIs and third-party tools to enhance reporting capabilities.
• Continuous Improvement: Stay updated with the latest industry trends and actively engage in upskilling, driving innovative solutions in alignment with business goals.

About You:

• Applicants must have the right to work in the UK

The ideal candidate will demonstrate the following personal attributes that align with our company's culture and values:

• Qualifications: Power BI Data Analyst Associate or equivalent accreditation. Salesforce accreditation would be valuable
• Analytical Mindset: Ability to think critically and analyse data with precision.
• Effective Communication: Strong verbal and written communication skills to articulate complex data findings to non-technical stakeholders.
• Collaborative Spirit: Eager to work in a team environment and effectively engage with various departments.
• Proactive Attitude: Takes initiative, anticipates needs, and seeks opportunities for continuous improvement.
• Ethical Responsibility: Committed to maintaining the highest standards of integrity, transparency, and confidentiality.
• Adaptability: Willingness to adapt to a fast-paced and dynamic work environment, managing changes with resilience.

Core Expectations:

• Be willing to travel to client sites across the UK &