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.
Minimum Requirements:
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.
Desired Skills:
- Power BI (Desktop and Service)
- DAX and Power Query (M)
- SQL Server