Data Warehouse & BI Engineer

Compunnel, Inc.; Charlotte, Northern (NC, KY); Hybrid; USD 95,000 - 140,000; Full time

Job summary

Compunnel, Inc. is seeking a Data Warehouse & BI Engineer to lead design, development, and delivery of data warehouse, reporting, and analytics solutions.

The role spans requirements, architecture, development, testing, deployment, and ongoing support to ensure scalable, reliable outcomes. The ideal candidate will have 5+ years in DW/BI with Microsoft BI technologies (SQL Server, SSRS, SSIS, SSAS) and strong T-SQL skills, plus experience delivering ETL and Power BI solutions within an SDLC

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.

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.

Skills

Data warehousing

Analytical thinking

Problem solving

Education

Bachelor's degree in IT/CS/Engineering

Tools

SQL Server

SSRS

SSIS

SSAS

Power BI

T-SQL

GitLab

TFS

Oracle

OSIPL/ MES data models

Job description

The 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.