BI Report Developer - Sage / SQL / Power BI
BI Report Developer - Sage / SQL / Power BI

BI Report Developer - Sage / SQL / Power BI

Full-Time No home office possible
Go Premium
T

At a Glance

  • Tasks: Lead data analysis and reporting for a tech transformation in manufacturing.
  • Company: Established manufacturing organisation driving digital growth.
  • Benefits: Competitive day rate, hybrid work model, and opportunity for professional development.
  • Why this job: Be at the forefront of data innovation and make a real impact.
  • Qualifications: Experience with BI tools, SQL, and advanced Excel skills required.
  • Other info: Dynamic role with excellent career growth potential.

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

12 month day rate contract, OUTSIDE IR35.

Role Overview

This new BI Report Developer position will be a key part of the organisation's technology transformation programme. The role will drive the evolution of data analysis and reporting capabilities, supporting business growth and digital transformation across manufacturing, supply chain, and customer engagement.

Key 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 Finances 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.

Preferred/Ideal Experience & Skills

  • 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

£350-400 per day

OUTSIDE IR35

BI Report Developer - Sage / SQL / Power BI employer: Tecnitex Industrial Ltda.

Join a highly successful manufacturing organisation in Maldon, Essex, as a BI Report Developer and be part of an exciting technology transformation programme. With a strong focus on employee growth and development, the company fosters a collaborative work culture that values innovation and data-driven decision-making. Enjoy the flexibility of a hybrid work model after initial on-site engagement, alongside competitive day rates and opportunities to enhance your skills in a dynamic environment.
T

Contact Detail:

Tecnitex Industrial Ltda. Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land BI Report Developer - Sage / SQL / Power BI

✨Tip Number 1

Network like a pro! Reach out to your connections in the industry, attend meetups, and engage on platforms like LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your best BI reports and dashboards. This is your chance to demonstrate your expertise in Sage, SQL, and Power BI, making it easier for potential employers to see what you can bring to the table.

✨Tip Number 3

Prepare for interviews by brushing up on common BI scenarios and technical questions. Practice explaining your past projects and how you've tackled challenges in data analysis and reporting. Confidence is key!

✨Tip Number 4

Don't forget to apply through our website! We’ve got loads of opportunities that might be perfect for you. Plus, applying directly shows your enthusiasm and commitment to joining our team.

We think you need these skills to ace BI Report Developer - Sage / SQL / Power BI

Sage X3
SQL
Power BI
Microsoft Excel
Power Query
VBA/macros
Data Warehousing
Business Intelligence tooling
DAX calculations
Data validation
Reconciliation
Variance analysis
Dashboard design
Stakeholder communication
Data quality

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the BI Report Developer role. Highlight your experience with Sage, SQL, and Power BI, and don’t forget to showcase any relevant projects that demonstrate your skills in data analysis and reporting.

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this role. Mention specific experiences that align with the job description, like leading workshops or building dashboards, to show us you understand what we need.

Showcase Your Technical Skills: Since this role requires strong technical skills, make sure to list your proficiency in SQL, Excel, and BI tools clearly. If you’ve worked on complex queries or built intuitive dashboards, let us know! We love seeing real examples of your work.

Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!

How to prepare for a job interview at Tecnitex Industrial Ltda.

✨Know Your Tools Inside Out

Make sure you’re well-versed in Sage X3, SQL, and Power BI. Brush up on your advanced Excel skills too! Be ready to discuss specific projects where you've used these tools effectively, as this will show your practical experience.

✨Prepare for Technical Questions

Expect questions about writing SQL scripts and building dashboards. Practice explaining complex concepts like DAX calculations and data validation processes clearly. This will demonstrate your technical expertise and communication skills.

✨Showcase Your Problem-Solving Skills

Think of examples where you've tackled challenges in data analysis or reporting. Be prepared to discuss how you approached these issues and the impact of your solutions on the business. This will highlight your analytical mindset.

✨Engage with Stakeholders

Since the role involves collaboration, be ready to talk about your experience working with different teams. Share how you’ve gathered requirements and communicated findings to stakeholders, showcasing your interpersonal skills and ability to build relationships.

BI Report Developer - Sage / SQL / Power BI
Tecnitex Industrial Ltda.
Go Premium

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

T
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>