Data Engineer

Piper Companies; Rockville (MD); Remote; USD 101,000 - 155,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401K

Paid time off

Sick leave

Holidays

Job summary

Zachary Piper Solutions in Rockville, MD seeks a Data Engineer to develop and maintain enterprise data solutions that support digital transformation, data integration, analytics, and governance.

You will work with AWS data services, ETL/ELT pipelines, Data Mesh architectures, and AI/ML-ready datasets across the organization, collaborating with architects, engineers, analysts, and business teams.

Qualifications

• Bachelor's degree in CS/SE or related field; 4+ years in data modeling, integration, and solution development.
• Strong Python, SQL, and/or C#/.NET skills for processing structured and unstructured data.
• Hands-on with AWS data services (S3, Glue, EMR, Redshift, Lake Formation, Kinesis, Lambda, IAM).
• Experience building ETL/ELT pipelines and integrating data from MES, ERP, PLM, SCADA/Historian, LIMS, QMS.
• Familiarity with DataOps, Git workflows, CI/CD, IaC, automated testing, and governance.

Responsibilities

• Develop and maintain ETL/ELT pipelines integrating MES, ERP, PLM, SCADA/Historian, and other systems.
• Design reusable, domain-oriented data products with data models, metadata, mappings, and governance.
• Collaborate with architects, engineers, analysts, and business teams to deliver secure, scalable data solutions.
• Manage full lifecycle of data platform development using Git, CI/CD, IaC, automated tests, and DataOps best practices.
• Support analytics and Digital Thread initiatives with AI/ML-ready datasets and RAG use cases.

Skills

Python

SQL

C#/.NET

Data Modeling

Data Integration

Problem Solving

Stakeholder Engagement

Education

Bachelor's Degree in Computer Science or Software Engineering

Tools

AWS S3

AWS Glue

AWS EMR

Redshift

Lake Formation

Kinesis

Lambda

IAM

Snowflake

Databricks

Kafka

Airflow

dbt

Fivetran

Power BI

Tableau

Looker

Job description

Zachary Piper Solutions is seeking a Data Engineer. This job is located in Rockville, MD and will be Remote. The Data Engineer will be responsible for developing and maintaining enterprise data solutions that support digital transformation, data integration, analytics, and governance initiatives across the organization. This is an exciting opportunity to work with AWS data services, ETL/ELT pipelines, Data Mesh architectures, AI/ML-ready datasets, and Digital Thread initiatives in Rockville, MD.

Responsibilities of the Data Engineer include:

• Develop and maintain ETL/ELT pipelines that integrate data from MES, ERP, PLM, SCADA/Historian, Quality, and other enterprise systems.
• Design reusable, domain-oriented data products while maintaining data models, metadata, mappings, and governance standards.
• Collaborate with architects, engineers, analysts, and business teams to deliver secure, scalable, and reliable data solutions.
• Manage the full lifecycle of data platform development utilizing Git, CI/CD, automated testing, Infrastructure-as-Code, and DataOps best practices.
• Support analytics, Digital Thread initiatives, and AI/ML-ready datasets for predictive analytics, anomaly detection, and RAG use cases.

Qualifications for the Data Engineer include:

• Bachelor's Degree in Computer Science, Software Engineering, or a related engineering discipline with 4+ years of experience in data modeling, data integration, and data solution development.
• Strong experience with Python, SQL, and/or C# .NET, including processing and analyzing structured and unstructured data.
• Hands-on experience with AWS data technologies including S3, Glue, EMR, Redshift, Lake Formation, Kinesis, Lambda, and IAM.
• Experience building ETL/ELT pipelines and integrating data from manufacturing systems such as MES, ERP, PLM, SCADA/Historian, LIMS, or QMS environments.
• Experience with DataOps practices, Git-based workflows, CI/CD pipelines, Infrastructure-as-Code, automated testing, and enterprise data governance.
• Experience supporting Data Mesh, Data Fabric, Digital Thread, data cataloging, lineage, metadata management, and domain-oriented data products.
• Knowledge of modern data platforms and tools including Snowflake, Databricks, Kafka, Airflow, dbt, Fivetran, Power BI, Tableau, Looker, and cloud-based data architectures.
• Strong communication, problem-solving, and stakeholder engagement skills; AWS Data Engineer/Data Analytics certifications, Siemens Teamcenter PLM, and AI/ML data readiness experience are highly preferred.

Compensation for the Data Engineer include:

• Salary Range: $101,400 - $154,650
• Comprehensive Benefits: Cigna Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law, and Holidays

This job opens for applications on 9/30/2026. Applications for this job will be accepted for at least 30 days from the posting date.

Data Engineer, ETL, ELT, Data Modeling, Data Integration, Data Pipelines, Data Solutions, Digital Thread, Data Mesh, Data Fabric, Data Governance, Data Lineage, Metadata Management, Data Catalog, AWS, AWS Glue, AWS S3, AWS EMR, Redshift, Lake Formation, Kinesis, Lambda, IAM, Python, SQL, C#, .NET, Git, CI/CD, DataOps, Infrastructure as Code, Terraform, CloudFormation, Airflow, dbt, Fivetran, Informatica, SSIS, Talend, Snowflake, Databricks, BigQuery, Kafka, Streaming Data, Manufacturing Systems, MES, ERP, PLM, SCADA, Historian, LIMS, QMS, Teamcenter, Siemens Teamcenter, Supply Chain Analytics, Manufacturing Analytics, OEE, Yield Analysis, Product Traceability, Data Architecture, Data Engineering, Data Cataloging, Collibra, Alation, Atlan, OpenMetadata, AI, Machine Learning, ML, AI Readiness, Feature Engineering, Dataset Versioning, RAG, Retrieval Augmented Generation, Predictive Analytics, Power BI, Tableau, Looker, Business Intelligence, Cloud Data Platforms, Analytics Engineering.