About the position
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.
Minimum Requirements:
Education:
Degree in Computer Science, Software Engineering, or related field.
6 + years of experience in Business Intelligence (BI Development), Sage, TimeXtender.
Knowledge of mining / Engineering / Manufacturing.
Desired Skills:
- Knowledge of mining / Engineering / Manufacturing
- Sage
- TimeXtender
