Hybrid Data Warehouse & BI Engineer for Manufacturing Ops

Iconma,-Llc.; Charlotte (NC); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health Benefits

Referral Program

Growth opportunities

Job summary

Iconma,-Llc. seeks a Data Warehouse & BI Engineer to design, develop, and deliver data warehouse, reporting, and analytics solutions for a manufacturing environment across Charlotte, NC and Corning, NY in a hybrid setup.

The role requires 5+ years in Data Warehouse/BI with Microsoft BI tools (SQL Server, SSRS, SSIS, SSAS), strong T-SQL, ETL, and Power BI expertise, and experience in SDLC and Agile teams.

Qualifications

• Bachelor’s degree in IT, CS, Engineering, or related field.
• 5+ years designing, developing, and supporting Data Warehouse and BI solutions.
• 5+ years with Microsoft BI: SQL Server, SSRS, SSIS, SSAS.
• Strong T-SQL development, stored procedures, tuning, and optimization.
• Experience Power BI or similar dashboard/reporting tools.
• Experience SDLC and Agile in software projects.
• Experience with MES, CAMSTAR, OSI PI knowledge of data models.

Responsibilities

• Lead end-to-end data warehouse, reporting, and analytics delivery.
• Translate requirements into scalable data solutions for operations.
• Develop and maintain T-SQL procedures, queries, and scripts.
• Design, build, and maintain ETL processes for data ingestion from MES/ERP.
• Collaborate with DBAs to optimize server health and query performance.
• Ensure code is version-controlled and SDLC compliant.

Skills

SQL development

ETL processes

Power BI

T-SQL

SSRS/SSIS/SSAS

Data warehousing

SDLC

Agile

Stakeholder management

Manufacturing data

Education

Bachelor’s degree in IT/CS/Engineering

Tools

Microsoft SQL Server

SSRS

SSIS

SSAS

Job description

Iconma,-Llc. seeks a Data Warehouse & BI Engineer to design, develop, and deliver data warehouse, reporting, and analytics solutions for a manufacturing environment across Charlotte, NC and Corning, NY in a hybrid setup.

The role requires 5+ years in Data Warehouse/BI with Microsoft BI tools (SQL Server, SSRS, SSIS, SSAS), strong T-SQL, ETL, and Power BI expertise, and experience in SDLC and Agile teams.