BI Report Developer
<p><b>Salary: £30,000 - 55,000 per year</b></p>
<b>Requirements:</b>
<ul><li>Hands-on experience with Data Warehouses and Business Intelligence tooling</li><li>Fluency in Sage X3 within manufacturing and distribution organizations</li><li>Proficiency in Sage SEI or ZapBI (Sage Data & Analytics) and Power BI</li><li>Strong SQL skills, including advanced scripting and optimization</li><li>Advanced Microsoft Excel capabilities, including Power Query, pivot tables, and VBA/macros</li><li>Experience in developing robust semantic models and authoring well-documented DAX calculations</li><li>Ability to implement and manage data validation, reconciliation, and variance analysis processes</li><li>Track record of building intuitive, secure, and role-based dashboards</li><li>Excellent communication skills for stakeholder engagement, requirements gathering, and ongoing support</li><li>Experience in documenting BI processes, data sources, and governance standards</li><li>Commitment to data quality, security, and continuous improvement</li></ul>
<b>Responsibilities:</b>
<ul><li>Lead on-site discovery workshops to accurately capture reporting requirements, translating them into technical specifications and success criteria</li><li>Design and build robust dashboards, reports, and live data extracts over Sage X3 and other databases, modeling best practices and governance using Sage Data & Analytics (ZapBI) and Power BI</li><li>Write performant Structured Query Language (SQL) scripts, including complex joins, window functions, and incremental loads</li><li>Apply advanced Microsoft Excel skills (Power Query, complex formulas, pivot tables, VBA/macros) to support ad hoc reporting and Finances live data needs</li><li>Implement data validation, reconciliation, and variance analysis to build trust in reported figures</li><li>Create and maintain a calculation/measure dictionary with business definitions, DAX expressions, filters, and caveats</li><li>Optimize dataset performance (column cardinality, aggregations, incremental refresh, composite models)</li><li>Build intuitive, role-based dashboards with strong UX; apply row and object-level security as needed</li><li>Collaborate with Finance, Operations, and Sales on data readiness (staging, transformations, ETL)</li><li>Provide ongoing support: answer stakeholder questions about metrics, explain calculations and data lineage, and triage issues</li><li>Document data sources, refresh schedules, dependencies, and change history; contribute to BI standards and governance</li><li>Ensure data quality, Row-Level Security (RLS), performance, documentation, and stakeholder communication</li></ul>
<b>Technologies:</b>
<ul><li>Business Intelligence</li><li>DAX</li><li>ETL</li><li>Excel</li><li>Support</li><li>Power BI</li><li>Power Query</li><li>SQL</li><li>Sage</li><li>Security</li><li>VBA</li><li>UX UI Design</li></ul>
<p><b>More:</b></p>
<p>We are a highly successful and well-established manufacturing organization located in Maldon, Essex. This new BI Report Developer position is part of our technology transformation programme, where youll play a crucial role in evolving our data analysis and reporting capabilities. We offer a 12-month day rate contract, initially requiring 2 - 3 days on-site for discovery and stakeholder relationship building, transitioning to a hybrid model for remote development, delivery, and support. This position is outside IR35.</p>
<p>last updated 8 week of 2026</p>
<b>Requirements:</b>
<ul><li>Hands-on experience with Data Warehouses and Business Intelligence tooling</li><li>Fluency in Sage X3 within manufacturing and distribution organizations</li><li>Proficiency in Sage SEI or ZapBI (Sage Data & Analytics) and Power BI</li><li>Strong SQL skills, including advanced scripting and optimization</li><li>Advanced Microsoft Excel capabilities, including Power Query, pivot tables, and VBA/macros</li><li>Experience in developing robust semantic models and authoring well-documented DAX calculations</li><li>Ability to implement and manage data validation, reconciliation, and variance analysis processes</li><li>Track record of building intuitive, secure, and role-based dashboards</li><li>Excellent communication skills for stakeholder engagement, requirements gathering, and ongoing support</li><li>Experience in documenting BI processes, data sources, and governance standards</li><li>Commitment to data quality, security, and continuous improvement</li></ul>
<b>Responsibilities:</b>
<ul><li>Lead on-site discovery workshops to accurately capture reporting requirements, translating them into technical specifications and success criteria</li><li>Design and build robust dashboards, reports, and live data extracts over Sage X3 and other databases, modeling best practices and governance using Sage Data & Analytics (ZapBI) and Power BI</li><li>Write performant Structured Query Language (SQL) scripts, including complex joins, window functions, and incremental loads</li><li>Apply advanced Microsoft Excel skills (Power Query, complex formulas, pivot tables, VBA/macros) to support ad hoc reporting and Finances live data needs</li><li>Implement data validation, reconciliation, and variance analysis to build trust in reported figures</li><li>Create and maintain a calculation/measure dictionary with business definitions, DAX expressions, filters, and caveats</li><li>Optimize dataset performance (column cardinality, aggregations, incremental refresh, composite models)</li><li>Build intuitive, role-based dashboards with strong UX; apply row and object-level security as needed</li><li>Collaborate with Finance, Operations, and Sales on data readiness (staging, transformations, ETL)</li><li>Provide ongoing support: answer stakeholder questions about metrics, explain calculations and data lineage, and triage issues</li><li>Document data sources, refresh schedules, dependencies, and change history; contribute to BI standards and governance</li><li>Ensure data quality, Row-Level Security (RLS), performance, documentation, and stakeholder communication</li></ul>
<b>Technologies:</b>
<ul><li>Business Intelligence</li><li>DAX</li><li>ETL</li><li>Excel</li><li>Support</li><li>Power BI</li><li>Power Query</li><li>SQL</li><li>Sage</li><li>Security</li><li>VBA</li><li>UX UI Design</li></ul>
<p><b>More:</b></p>
<p>We are a highly successful and well-established manufacturing organization located in Maldon, Essex. This new BI Report Developer position is part of our technology transformation programme, where youll play a crucial role in evolving our data analysis and reporting capabilities. We offer a 12-month day rate contract, initially requiring 2 - 3 days on-site for discovery and stakeholder relationship building, transitioning to a hybrid model for remote development, delivery, and support. This position is outside IR35.</p>
<p>last updated 8 week of 2026</p>