Business Intelligence/Data Analyst

Overview

Manage & automate data pipelines, reporting and dashboards using SQL, Zoho and Python.

Key Responsibilities

• data governance
• sql development
• python automation
• zoho integration
• data quality
• stakeholder liaison

Tasks

-Champion best practices in data governance, security, and version control. -Design and maintain SQL queries that power core reports, dashboards, and automated workflows. -Deliver ad hoc data analysis and recommendations to support operational and strategic decision-making. -Collaborate with finance, product, and operations teams to ensure data models evolve with changing business needs. -Continuously refine SQL models to improve efficiency and accuracy of reporting. -Monitor system syncs and resolve discrepancies promptly. -Drive ongoing improvements in reporting efficiency, scalability, and transparency. -Use Python and APIs to automate data flows, refresh schedules, and exception alerts. -Ensure all reports and metrics are traceable back to trusted data sources. -Ensure data quality through proactive validation, reconciliation, and exception reporting. -Simplify and streamline manual processes using automated SQL scripts and data pipelines. -Document and maintain clear procedures for all data processes. -Develop and maintain interactive dashboards and reports in Zoho Analytics to track performance across sales, operations, and finance. -Build and maintain integrations between Zoho CRM, Zoho Analytics, and other data sources. -Act as the primary point of contact for all business data requirements, translating stakeholder needs into robust SQL and analytics solutions. -Own the structure, integrity, and reliability of data across Zoho CRM and Zoho Analytics. -Manage and document data logic, definitions, and relationships across key datasets.

Requirements

• sql
• python
• zoho crm
• data modelling
• problem solving
• communication

What You Bring

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

People Also Searched For

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 (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.

About The Green Energy Advice Bureau

-Founded with a vision to drive the transition towards sustainable energy solutions. -Supports organizations in navigating the complexities of energy efficiency and green technologies. -Works on a wide range of projects from residential to large-scale commercial energy solutions. -Specializes in advising businesses on optimizing energy usage and reducing carbon footprints. -Offers tailored consultancy services in sectors like energy, utilities, transport, and more. -Focused on delivering cost-effective, sustainable solutions for clients in diverse industries. -Known for its practical approach and clear, actionable recommendations for energy transformation.

Sector Specialisms