BI Report Developer

Tech4 Ltd; Heybridge; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A well-established manufacturing organization in Essex is seeking a BI Report Developer to lead the design and implementation of robust dashboards and reports using Sage X3 and Power BI. The role requires strong SQL skills and advanced Excel capabilities. The position begins with on-site discovery workshops before transitioning to a hybrid work model, ensuring effective collaboration with stakeholders. This is a 12-month contract, outside IR35, offering a competitive daily rate.

Qualifications

• Hands-on experience with Data Warehouses and Business Intelligence tooling.
• Fluency in Sage X3, particularly in a manufacturing context.
• Proficient in SQL with advanced scripting skills.

Responsibilities

• Lead on-site discovery workshops to capture reporting requirements.
• Design and build dashboards, reports, and extracts using Sage and Power BI.
• Write SQL scripts for effective data handling and reporting.

Skills

Data Warehousing

Business Intelligence tooling

Sage X3 fluency

SQL scripting

Advanced Excel

DAX calculations

Communication skills

Tools

Sage SEI

Power BI

ZapBI

Job description

Overview

BI Report Developer - Sage / SQL / Power BI - is required by highly successful and well established manufacturing organisation.

12 month day rate contract, OUTSIDE IR35.

Responsibilities

• Lead on-site discovery workshops to accurately capture reporting requirements, translating them into technical specifications and success criteria.
• Design and build robust dashboards, reports, and live data extracts over Sage X3 and other databases, modelling best practices and governance using Sage Data & Analytics (ZapBI) and Power BI.
• Write performant Structured Query Language (SQL) scripts, including complex joins, window functions, and incremental loads.
• Apply advanced Microsoft Excel skills (Power Query, complex formulas, pivot tables, VBA/macros) to support ad hoc reporting and Finance's live data needs.
• Implement data validation, reconciliation, and variance analysis to build trust in reported figures.
• Create and maintain a calculation/measure dictionary with business definitions, DAX expressions, filters, and caveats.
• Optimise dataset performance (column cardinality, aggregations, incremental refresh, composite models).
• Build intuitive, role-based dashboards with strong UX; apply row and object-level security as needed.
• Collaborate with Finance, Operations, and Sales on data readiness (staging, transformations, ETL).
• Provide ongoing support: answer stakeholder questions about metrics, explain calculations and data lineage, and triage issues.
• Document data sources, refresh schedules, dependencies, and change history; contribute to BI standards and governance.
• Ensure data quality, Row-Level Security (RLS), performance, documentation, and stakeholder communication.

Qualifications / Ideal Experience

• Hands-on experience with Data Warehouses and Business Intelligence tooling.
• Fluency in Sage X3 within manufacturing and distribution organisations.
• Proficiency in Sage SEI or ZapBI (Sage Data & Analytics) and Power BI.
• Strong SQL skills, including advanced scripting and optimisation.
• Advanced Microsoft Excel capabilities, including Power Query, pivot tables, and VBA/macros.
• Experience in developing robust semantic models and authoring well-documented DAX calculations.
• Ability to implement and manage data validation, reconciliation, and variance analysis processes.
• Track record of building intuitive, secure, and role-based dashboards.
• Excellent communication skills for stakeholder engagement, requirements gathering, and ongoing support.
• Experience in documenting BI processes, data sources, and governance standards.
• Commitment to data quality, security, and continuous improvement.

Work Arrangement

Initially based 2 - 3 days on-site for discovery and stakeholder relationship building, transitioning to a hybrid model for remote development, delivery, and support.

Based Maldon, Essex

12 month contract

£(Apply online only) per day

OUTSIDE IR35