Data Engineer

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

A newly formed data engineering team is expanding, and we’re looking for a highly capable Data Engineer to help build the shared data environment supporting multiple manufacturing facilities. This role focuses on designing structured data models, developing SQL-driven data warehouses, and creating reliable pipelines that feed analytics and operational applications across several sites.

You’ll work closely with a data architect and other technical partners to consolidate data from multiple divisions into a unified environment. This is a hands-on engineering role ideal for someone who thrives in complex data ecosystems, values accuracy, and enjoys building foundational systems from the ground up.

Key Responsibilities

• Develop advanced SQL solutions including complex queries, stored procedures, views, and triggers.
• Design and maintain structured data models and warehouse environments used across multiple facilities.
• Build, refine, and troubleshoot ETL/ELT pipelines supporting large-scale data ingestion.
• Ensure data accuracy, consistency, and reliability across interconnected systems.
• Monitor and optimize data workflows and query performance.
• Collaborate with architects, engineers, and operational teams to translate requirements into scalable data solutions.
• Document data flows, schemas, and definitions for long-term maintainability.
• Follow data governance, security, and compliance standards.
• Manage assigned work independently and deliver on commitments.
• Communicate technical concepts clearly to both technical and non-technical audiences.
• Participate in ongoing learning to stay current with evolving data technologies.

Required Qualifications

• 5–7 years of professional SQL experience (this is a SQL-heavy environment).
• 5–7 years of experience in data analytics or a related discipline.
• Hands-on experience with Qlik and/or Power BI (Qlik is used more heavily across the group).
• Proven background in data engineering, analytics engineering, or similar roles.
• Strong SQL proficiency, including advanced queries, stored procedures, and triggers.
• Experience with relational databases and data modeling concepts.
• Experience building and maintaining ETL/ELT pipelines.
• Experience supporting BI, reporting, or analytics environments.
• Familiarity with data quality monitoring practices.
• Experience with cloud data platforms, data warehouses, or data lakes.
• Strong written and verbal communication skills.
• Demonstrated ownership of data solutions and deliverables.
• Bachelor’s degree in a relevant field, equivalent experience, or industry certifications.
• Proficiency with Microsoft SQL Server.
• Experience in manufacturing or industrial environments.

What We Offer

• Small team where you can make a big impact.
• Competitive compensation and benefits.

This is a full-time employment opportunity onsite in Butler, Indiana. Luna Data Solutions, Inc. (LDS) provides equal employment opportunities to all employees. All applicants will be considered for employment. LDS prohibits discrimination and harassment of any type regarding age, race, color, religion, sexual orientation, gender identity, sex, national origin, genetics, protected veteran status, and/or disability status. A 7-year background check and drug test are required for this role.