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.
- Utilize 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 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:
- Degree in Computer Science, Software Engineering, or related field.
- 6 + years of experience in Business Intelligence (Power BI), Sage, TimeXtender
- Knowledge of mining / Engineering / Manufacturing
Desired Skills:
- Power BI
- Integration
- SQL
- Python