Description
sql automation
data pipelines
zoho integration
dashboard development
data governance
data quality
To own the design, accuracy, and automation of data and reporting processes across the business.
The role is central to maintaining reliable datasets, developing insightful reports and dashboards, and ensuring the organisation can make confident, data-driven decisions.
- Collaborate with finance, product, and operations teams to ensure data models evolve with changing business needs.
- Simplify and streamline manual processes using automated SQL scripts and data pipelines.
- Manage and document data logic, definitions, and relationships across key datasets.
- Champion best practices in data governance, security, and version control.
- Drive ongoing improvements in reporting efficiency, scalability, and transparency.
- Build and maintain integrations between Zoho CRM, Zoho Analytics, and other data sources.
- Design and maintain SQL queries that power core reports, dashboards, and automated workflows.
- Develop and maintain interactive dashboards and reports in Zoho Analytics to track performance across sales, operations, and finance.
- Document and maintain clear procedures for all data processes.
- Use Python and APIs to automate data flows, refresh schedules, and exception alerts.
- Own the structure, integrity, and reliability of data across Zoho CRM and Zoho Analytics.
- Ensure data quality through proactive validation, reconciliation, and exception reporting.
- Monitor system syncs and resolve discrepancies promptly.
- Continuously refine SQL models to improve efficiency and accuracy of reporting.
- Deliver ad hoc data analysis and recommendations to support operational and strategic decision-making.
- Act as the primary point of contact for all business data requirements, translating stakeholder needs into robust SQL and analytics solutions.
- Ensure all reports and metrics are traceable back to trusted data sources.
Requirements
sql
python
zoho crm
zoho analytics
power query
problem solving
A strong command of SQL, familiarity with Zoho CRM and Zoho Analytics or other relational databases/CRMs, and working knowledge of Python is desired to deliver high-quality analytics, automation, and continuous improvement.
*MUST BE BASED IN THE NORTH EAST OF ENGLAND TO BE CONSIDERED*
Zoho CRM, Zoho Analytics, SQL, Python, Excel / Power Query, Jira, Microsoft 365 Suite, APIs / ETL tools.
Business Intelligence/Data Analyst
- Problem-solving and ability to identify trends, exceptions, and anomalies.
- Experience with Zoho CRM and Zoho Analytics (or equivalent other relational databases/CRMs).
- Clear communication with both technical and non-technical stakeholders.
- Expert-level SQL for data extraction, transformation, validation, and reporting.
- Attention to detail, accuracy, and process documentation.
- Working knowledge of Python for automation, integration, and ETL tasks.
- Strong data modelling and analytical skills.
- Understanding of finance or commercial data (e.g., commissions, invoicing) advantageous.
Benefits
- Culture perks and self-development fund: At GEAB, we foster a vibrant work culture. Our jam-packed culture calendar brings exciting events like monthly office themes and food trucks to keep the energy high. Plus, we invest in your personal and professional growth with our Better Yourself development fund.
- Fun and celebrations: We know how to have a good time! Enjoy summer and Christmas events where you can connect with colleagues, unwind, and create lasting memories.
- Generous holiday package: Take advantage of 23 days of holiday (plus bank holidays) to recharge and rejuvenate. We even offer extra time off during the festive season with performance and role-dependent opportunities for time off in December. Maximise your time away while enjoying a non-absence day off bonus which increases your holiday allowance.
Training + Development
Information not given or found
