BI Developer (Power BI, SQL & Data Integration) LW

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, 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