BI Developer (Power BI, Sage Integration) LW

About the position

Techstack: BI Development, PowerBI, Sage HR, TimeXtender (Nice to have), SSIS, TSQL, SQL,  SSRS, ETL, Integration knowledge, Data Analysis (Know how)



 



Business Intelligence & Reporting:

• Design, develop, and maintain Power BI dashboards and analytics solutions supporting HR, finance, and manufacturing use cases, including workforce analytics, headcount, turnover, payroll-related insights, and departmental reporting.


• Develop KPI-driven dashboards and enterprise reports to support management decision-making across finance, HR, and operations.


• Design and deliver SSRS reports, including Debtors Analysis, HR workforce reports, and Manufacturing Expense Control reports.

 



Data Integration & Warehousing:

• Develop and maintain robust SSIS packages to extract, transform, and load (ETL) data into Operational Data Stores (ODS) and Enterprise Data Warehouses.


• Integrate HR and payroll data from Sage (e.g. Sage 300 / Sage People) into enterprise BI and reporting solutions, ensuring data accuracy and consistency.


• Implement dimensional data models to support scalable and performant reporting solutions across HR, finance, and manufacturing domains.


• Utilise TimeXtender for data warehouse design, dimensional modelling, and deployment of database objects for enterprise reporting.

 



Database & SQL Development:

• Write and maintain optimised T-SQL queries, views, and stored procedures to support BI and reporting requirements.


• Develop and maintain Oracle PL/SQL procedures to feed reporting solutions with real-time financial, HR, and operational data.


• Integrate data from enterprise systems such as Sage HR/Payroll, Oracle Financials, Maximo, and manufacturing source systems.

 



Manufacturing & Operational Analytics:

• Develop reporting solutions for manufacturing expense control, enabling real-time tracking of budget, commitments, and actual costs.


• Deliver end-to-end BI solutions for shop-floor systems, including quality and defect reporting, such as coil-level pass/fail analytics from surface defect scanning systems.


• Support engineers, HR, finance, and operations teams with timely, reliable production, workforce, and quality insights.

 



Monthly salary + 15 days annual leave.


Minimum Requirements:

• Degree in Computer Science, Software Engineering, or related field.


• 4 + years of experience in Business Intelligence Development


• Knowledge of mining / Engineering / Manufacturing (beneficial)

Desired Skills:

• BI Development
• SQL
• SSRS
• Data Analysis