Data Engineer

Zachary Piper Solutions; Rockville (MD); On-site; USD 101,000 - 155,000; Full time

Benefits offered by this job

Salary Range: $101,400 - $154,650

Comprehensive Benefits

Job summary

Zachary Piper Solutions in Rockville, MD is seeking a Data Engineer to develop and maintain enterprise data solutions that support digital transformation, data integration, analytics, and governance initiatives. This role involves AWS data services, ETL/ELT pipelines, Data Mesh architectures, AI/ML-ready datasets, and Digital Thread initiatives in Rockville, MD.

Responsibilities include building and optimizing pipelines, designing data products with governance in mind, and collaborating with

Qualifications

• Bachelor's Degree in CS/Software Eng with 4+ years in data modeling and integration.
• Strong experience with Python, SQL, and/or C# .NET for processing data.
• Hands-on AWS data technologies: S3, Glue, EMR, Redshift, Lake Formation, Kinesis, Lambda, IAM.
• Experience building ETL/ELT pipelines from MES/ERP/PLM/SCADA/Hist/LIMS/QMS environments.
• DataOps, Git CI/CD, IaC, automated testing, and data governance experience.
• Experience with Data Mesh/Fabric, Digital Thread, data cataloging, lineage, metadata management.

Responsibilities

• Develop and maintain ETL/ELT pipelines that integrate data from MES, ERP, PLM, SCADA/Historian, Quality, and others.
• 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 data solutions.
• Manage the full lifecycle of data platform development utilizing Git, CI/CD, automated testing, IaC, and DataOps best practices.
• Support analytics, Digital Thread initiatives, and AI/ML-ready datasets for predictive analytics, anomaly detection, and RAG use cases.

Skills

Python

SQL

C# .NET

Data Modeling

ETL/ELT

Git CI/CD

Education

Bachelor's Degree in Computer Science, Software Engineering, or related engineering discipline

Tools

AWS

Snowflake

Databricks

Airflow

dbt

Fivetran

Power BI

Tableau

Looker

Kinesis

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.