Business Intelligence/Data Analyst

The Green Energy Advice Bureau; Sunderland; On-site; GBP 40,000 - 45,000; Full time

Job summary

A leading energy consultancy in Sunderland is seeking a Data Analyst to own the design and automation of data reporting processes across the business. The ideal candidate will have expert-level SQL skills, experience with Zoho CRM and Zoho Analytics, and a working knowledge of Python. This role is pivotal for maintaining data integrity and generating insightful reports to support data-driven decisions. The position offers a competitive salary and a generous holiday package.

Benefits

Generous holiday package

Self-development fund for professional growth

Fun summer and Christmas events

Qualifications

• Strong command of SQL for data extraction and reporting.
• Familiarity with Zoho CRM and Zoho Analytics is desired.
• Experience using Python for automation and integration.

Responsibilities

• Own the structure and reliability of data across Zoho platforms.
• Design and maintain SQL queries for core reports.
• Develop and maintain dashboards and reports in Zoho Analytics.
• Automate data flows and build integrations between systems.
• Drive improvements in reporting efficiency and governance.

Skills

Expert-level SQL

Experience with Zoho CRM

Experience with Zoho Analytics

Working knowledge of Python

Strong data modelling skills

Attention to detail

Problem-solving skills

Clear communication

Tools

Zoho CRM

Zoho Analytics

SQL

Python

Excel / Power Query

Jira

Microsoft 365 Suite

APIs / ETL tools

Job description

£40,000 - £45,000 depending on experience

Location: Sunderland

Updated: October 14, 2025

Reports to: Head of Product & Delivery

Purpose of the Role

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.

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.

Key Responsibilities

• Data Ownership & Management
  • Own the structure, integrity, and reliability of data across Zoho CRM and Zoho Analytics.
  • Design and maintain SQL queries that power core reports, dashboards, and automated workflows.
  • Ensure data quality through proactive validation, reconciliation, and exception reporting.
  • Act as the primary point of contact for all business data requirements, translating stakeholder needs into robust SQL and analytics solutions.
  • Manage and document data logic, definitions, and relationships across key datasets.
• Reporting & Insight Generation
  • Develop and maintain interactive dashboards and reports in Zoho Analytics to track performance across sales, operations, and finance.
  • 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.
  • Ensure all reports and metrics are traceable back to trusted data sources.
• Automation & Integration
  • Use Python and APIs to automate data flows, refresh schedules, and exception alerts.
  • Build and maintain integrations between Zoho CRM, Zoho Analytics, and other data sources.
  • Simplify and streamline manual processes using automated SQL scripts and data pipelines.
  • Monitor system syncs and resolve discrepancies promptly.
• Continuous Improvement & Governance
  • Drive ongoing improvements in reporting efficiency, scalability, and transparency.
  • Document and maintain clear procedures for all data processes.
  • Collaborate with finance, product, and operations teams to ensure data models evolve with changing business needs.
  • Champion best practices in data governance, security, and version control.

Core Skills & Competencies

• Expert-level SQL for data extraction, transformation, validation, and reporting.
• Experience with Zoho CRM and Zoho Analytics (or equivalent other relational databases/CRMs).
• Strong data modelling and analytical skills.
• Working knowledge of Python for automation, integration, and ETL tasks.
• Attention to detail, accuracy, and process documentation.
• Problem‑solving and ability to identify trends, exceptions, and anomalies.
• Clear communication with both technical and non-technical stakeholders.
• Understanding of finance or commercial data (e.g., commissions, invoicing) advantageous.

Tools & Platforms

Zoho CRM, Zoho Analytics, SQL, Python, Excel / Power Query, Jira, Microsoft 365 Suite, APIs / ETL tools.

Benefits & Perks

• Generous holiday package: Take advantage of 23 days of holiday (including 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.
• 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.