Data Engineer - SQL/ETL, Data Warehouse for Manufacturing

Luna Data Solutions, Inc.; Pittsburgh (Allegheny County); On-site; USD 100,000 - 140,000; Full time

Benefits offered by this job

Small team where you can make a big, |

Competitive compensation and benefits.

Job summary

Luna Data Solutions, Inc. in Butler, Indiana onsite is seeking a Data Engineer to design structured data models, develop SQL-driven data warehouses, and build scalable pipelines feeding analytics across multiple facilities.

You will collaborate with a data architect and technical partners to consolidate data from several divisions into a unified environment, delivering reliable and scalable data solutions in a hands-on role.

Qualifications

• 5–7 years of professional SQL experience in a SQL-heavy environment.
• 5–7 years in data analytics or a related discipline.
• Experience with Qlik and/or Power BI; knowledge of data warehouses.
• Experience building and maintaining ETL/ELT pipelines and data models.
• Experience in manufacturing or industrial environments is a plus.

Responsibilities

• Develop advanced SQL solutions including queries, procedures, views, and triggers.
• Design and maintain structured data models and warehouse environments used across facilities.
• Build, refine, and troubleshoot ETL/ELT pipelines for large-scale data ingestion.
• Ensure data accuracy, consistency, and reliability across systems.
• Monitor and optimize data workflows and query performance.
• Collaborate with architects, engineers, and operations teams to translate requirements.
• Document data flows, schemas, and definitions for long-term maintainability.
• Follow data governance, security, and compliance standards.
• Communicate technical concepts clearly to diverse audiences.
• Stay current with evolving data technologies.

Skills

SQL proficiency

Data analytics

Data modeling

ETL/ELT pipelines

Data governance & quality

Communication skills

Ownership of data solutions

Education

Bachelor’s degree in a relevant field

Tools

Qlik

Power BI

Microsoft SQL Server

SQL Server Management Studio

Job description

Luna Data Solutions, Inc. in Butler, Indiana onsite is seeking a Data Engineer to design structured data models, develop SQL-driven data warehouses, and build scalable pipelines feeding analytics across multiple facilities.

You will collaborate with a data architect and technical partners to consolidate data from several divisions into a unified environment, delivering reliable and scalable data solutions in a hands-on role.