Data Warehouse & BI Engineer — Flexible Hours

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

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