Job SummaryThe Data Warehouse & BI Engineer supports Client manufacturing environment by leading the design, development, and delivery of data warehouse, reporting, and analytics solutions that drive operational visibility and business decision-making. This hands-on role spans the full solution lifecycle - requirements gathering, architecture, design, development, testing, deployment, and ongoing support - ensuring scalable, reliable, and high-value outcomes.
Key Responsibilities- Lead end-to-end delivery of data warehouse, reporting, and analytics solutions.
- Design, develop, and maintain high-quality data warehouse and BI solutions supporting manufacturing and enterprise priorities.
- Partner with business stakeholders and technology teams to define solution approaches and deliver impactful reporting capabilities.
- Develop and maintain T-SQL procedures, functions, queries, and scripts for data integration and analytics.
- Design, build, and support ETL processes for intake and transformation of manufacturing and enterprise data.
- Research, analyze, and troubleshoot data issues, stored procedures, and associated SSRS or Power BI reports.
- Collaborate with DBAs to assess server health, database performance, and query optimization; recommend and implement improvements.
- Develop and support data migration procedures and scripts for projects and operations.
- Contribute to evolving data warehouse architecture aligned with best practices.
- Ensure code is version-controlled and developed in accordance with SDLC standards.
- Support operationally critical work and global project timelines, including flexible hours when required.
Required Qualifications- Bachelor's degree in Information Technology, Computer Science, Engineering, or related field.
- 5+ years of experience designing, developing, and supporting Data Warehouse and BI solutions.
- 5+ years of experience with Microsoft BI technologies (SQL Server, SSRS, SSIS, SSAS).
- Strong T-SQL development skills including stored procedures, functions, performance tuning, and query optimization.
- Experience developing ETL and reporting solutions, including Power BI or similar tools.
- Experience working within an SDLC process.
- Strong analytical, problem-solving, and troubleshooting skills.
- Ability to work effectively with technical and non-technical stakeholders in fast-paced environments.
Preferred Qualifications- Experience using Agile project methodologies.
- Experience supporting manufacturing or factory floor systems.
- Familiarity with Camstar or other Manufacturing Execution Systems (MES).
- Experience with MES, CMMS, SPC, OSI PI, and related data models.
- Knowledge of industry best practices in data warehousing and BI architecture.
- Experience with relational databases in SQL Server and Oracle.
- Experience using TFS, GitLab, or similar source control platforms.
- Understanding of cubes, OLTP, and OLAP systems.
- Experience supporting analytics/reporting solutions in regulated or operationally sensitive environments.
Certifications (if any)- None required; certifications in BI, SQL, or Agile methodologies are a plus.
