BI Developer
Core
Design, develop, and support data warehouse and BI solutions for manufacturing and enterprise data.
Role type
Senior BI Developer (Data Warehouse & ETL)
Builds
Data warehouse, ETL processes, and end-user reporting solutions (Power BI, SSRS)
Domain
Manufacturing / Materials Science / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
T-SQL, SQL Server, SSRS, SSIS, SSAS, ETL, Data Warehouse design, Stored procedures, Query optimization, Power BI, Source control (GitLab/TFS), OLAP cubes, OLTP/OLAP concepts
Preferred skills
Agile delivery, Manufacturing Execution Systems (MES), CMMS, SPC, OSI PI, Oracle, Manufacturing/factory-floor systems
Technologies
SQL Server, SSRS, SSIS, SSAS, Power BI, Oracle, GitLab, TFS, CMMS, MES, SPC, OSI PI
Responsibilities
Lead end-to-end delivery of data warehouse and BI solutions from requirements to support; Develop and maintain T-SQL stored procedures, functions, and queries; Design, build, and support ETL processes for manufacturing and enterprise data; Investigate and resolve data issues in reports and procedures; Partner with DBA team to improve server health and query performance; Develop and support data migration scripts; Maintain data warehouse code in version control; Provide flexible coverage for global support hours
Seniority
Senior, hands-on IC