More jobs:
Data Warehouse & BI Engineer
Job in
Charlotte, Mecklenburg County, North Carolina, 28245, USA
Listed on 2026-09-07
Listing for:
Compunnel, Inc.
Full Time
position Listed on 2026-09-07
Job specializations:
-
IT/Tech
Data Engineering, Data Warehousing
Job Description & How to Apply Below
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.
- 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.
- 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, Git Lab, or similar source control platforms.
- Understanding of cubes, OLTP, and OLAP systems.
- Experience supporting analytics/reporting solutions in regulated or operationally sensitive environments.
- None required; certifications in BI, SQL, or Agile methodologies are a plus.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×