At a Glance
- Tasks: Lead data analysis and reporting, creating dashboards and SQL scripts for business growth.
- Company: Established manufacturing organisation driving technology transformation.
- Benefits: Competitive day rate, hybrid work model, and opportunity for professional growth.
- Why this job: Join a tech transformation journey and make a real impact in data-driven decision making.
- Qualifications: Experience with BI tools, SQL, and advanced Excel skills required.
- Other info: Collaborative environment with a focus on data quality and continuous improvement.
A BI Report Developer is required by a highly successful and well-established manufacturing organisation for a 12-month day rate contract, OUTSIDE IR35.
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.
- 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 in Maldon, Essex. 12-month contract, £350-400 per day, OUTSIDE IR35.
BI Report Developer - Sage / SQL / Power BI in London employer: Tecnitex Industrial Ltda.
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 in London
✨Tip Number 1
Get your networking game on! Reach out to folks in the industry, especially those who work with BI tools like Power BI and Sage. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills in a practical way! Create a portfolio of dashboards or reports you've built using SQL and Power BI. This not only demonstrates your expertise but also gives you something tangible to discuss during interviews.
✨Tip Number 3
Prepare for those interviews by brushing up on common BI scenarios. Think about how you would handle data validation or create a dashboard for a specific business need. We want you to be ready to impress with real-world examples!
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace BI Report Developer - Sage / SQL / Power BI in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Sage, SQL, and Power BI. We want to see how your skills match the job description, so don’t be shy about showcasing relevant projects or achievements!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re excited about this role and how you can contribute to our technology transformation programme. Keep it engaging and personal!
Showcase Your Technical Skills: Since this role involves a lot of technical work, make sure to include specific examples of your SQL scripting, dashboard creation, and Excel prowess. We love seeing real-world applications of your skills!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity. Don’t miss out!
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 SQL skills, especially complex joins and window functions, as these will likely come up in technical discussions. Familiarity with data validation and reconciliation processes will also show that you understand the importance of data quality.
✨Prepare for Scenario-Based Questions
Expect to be asked about how you would handle specific reporting requirements or challenges. Think of examples from your past experience where you led discovery workshops or built dashboards. Be ready to explain your thought process and the impact of your work on business growth and digital transformation.
✨Showcase Your Communication Skills
Since this role involves collaboration with various stakeholders, practice articulating your ideas clearly. Prepare to discuss how you’ve engaged with finance, operations, and sales teams in the past. Highlight your ability to document processes and communicate complex data concepts in an understandable way.
✨Demonstrate a Commitment to Continuous Improvement
Talk about how you stay updated with BI trends and tools. Share any experiences where you implemented improvements in data analysis or reporting capabilities. This shows that you’re not just about getting the job done but are also invested in enhancing processes and outcomes.