Job Description

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, and departmental reporting.



Develop KPI-driven dashboards and enterprise reports to support management decision-making.



Design and deliver SSRS reports , including Debtors Analysis 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 .



Implement dimensional data models to support scalable and performant reporting solutions.



Utilize TimeXtender for data warehouse design, dimensional modeling, and deployment of database objects for enterprise reporting.

Database & SQL Development:

Write and maintain optimized 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 and operational data.



Integrate data from enterprise systems such as 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 and operations teams with timely, reliable production and quality insights.

Required Technical Skills:

Power BI (Desktop and Service).



DAX and Power Query (M).



SQL Server (T-SQL, performance tuning).



SSIS and SSRS



Oracle PL/SQL



TimeXtender (Data Warehousing & Dimensional Modeling).



Data Warehousing concepts (ODS, Star/Snowflake schemas).

Education:

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



6 + years of experience in Business Intelligence (BI Development).



Knowledge of mining / Engineering / Manufacturing.

Advantageous Skills:

Manufacturing and quality analytics (OEE, cost control, defect analysis).



Budgeting and financial analytics.



Azure data platforms or cloud-based BI solutions.



Power BI governance and deployment best practices.



Between 3 - 5 Years