Junior Data Analyst in Guildford

At Penta Consulting, we believe technology reaches its full potential when powered by the right people. As a leading provider of Technology Resource Solutions, we connect businesses with top-tier talent to drive digital transformation and innovation.

With over 25 years of experience, we’ve built a global reputation for delivering high-quality expertise across key areas such as software development, artificial intelligence, project management, cloud computing, cybersecurity, enterprise architecture, and data analytics. Our clients span the globe, relying on our team of specialists to deliver tailored, impactful solutions. We’re proud to be a trusted partner in helping organisations stay ahead in a rapidly evolving digital landscape.

This person will play an active role in maintaining the best practices and adherence to our internal playbook.

DUTIES & RESPONSIBILITIES

• Data Integrity & Governance

• Conduct scheduled data quality checks within Mercury CRM, including:

• Mandatory field validation
• Vacancies Open for more than 6 months
• Reason code completeness
• Duplicate and inconsistent record checks
• Detection of backdated changes

• Monitor user adherence to workflows across Sales, Care, Operations, and Compliance in line with Mercury playbook.
• Surface issues such as missing paperwork, incorrect placement statuses, and overdue approvals.
• Maintain compliance dashboards and provide weekly summaries of key findings.

• Own the operational data inputs for departmental dashboards, including:

• Business performance (Frequency)
• Trend analysis
• Compliance tasks
• Report on company performance
• Validate accuracy of departmental submissions and ensure alignment with reporting standards.

• Coordinate between frontline systems (Mercury CRM, Business Central) and downstream models (Power BI).
• Track, document, and communicate system issues or enhancements for BI and Mercury development teams.
• Support change management as reporting logic, rules, or calculations evolve.

• Maintain all process documentation related to reporting, data controls, and audit routines.
• Manage version control for reporting logic, definitions, and workflows.
• Create clear summaries of issues, resolutions, and schema or field changes.

EXPERIENCE & QUALIFICATIONS

• Strong background in operational reporting, data quality, or business operations.
• High attention to detail and accuracy; confident validating complex datasets.
• Experience working with CRM or ERP systems (Mercury CRM or Business Central advantageous).
• Competent in Excel; familiarity with Power BI preferred.
• Ability to manage recurring reporting cycles with precision and consistency.
• Strong communication skills for cross-functional collaboration.

KEY COMPETENCIES

• Analytical thinking - ability to identify inconsistencies, anomalies, and patterns in data.
• Process ownership - takes responsibility for operational routines and service-level commitments.
• Cross-functional coordination - collaborates effectively across Sales, Delivery, Finance, and Compliance.
• Proactive problem solving - identifies issues early and escalates with solutions.

THE IDEAL CANDIDATE

• High data quality in Mercury CRM and departmental submissions.
• Well maintained templates and reporting processes.
• Clear documentation and traceability of all reporting changes.