Data Engineer: Cloud Pipelines & AI-Ready Data

Amphenol Communications Solutions; Nashua (NH); On-site; USD 95,000 - 140,000; Full time

Job summary

Amphenol Communications Solutions in Nashua, NH seeks a Data Engineer to design and maintain scalable data pipelines, data lakehouse structures, and curated datasets for analytics, automation, and AI readiness. You will turn fragmented source-system data into reliable, governed assets and work with IS Lead, Data Analyst, and external partners.

The role focuses on source-system onboarding, data quality, orchestration, and production reliability, enabling dashboards and AI-enabled workflows across

Qualifications

• BS in Computer Science, Information Systems, Data Engineering, Data Analytics, Engineering, or related field.
• 3-7+ years of experience in data engineering, analytics engineering, ETL/ELT development, data integration, or cloud data platform implementation.
• Strong SQL skills and experience building data models, transformations, joins, validations, and production-ready datasets.
• Experience with Python, PySpark, notebooks, or comparable data engineering tools strongly preferred.
• Experience with modern cloud data platforms such as Microsoft Fabric, Azure Data Lake, Azure Data Factory, Synapse, Databricks, Snowflake, or comparable platforms.
• Familiarity with lakehouse architecture, medallion data structures, semantic models, data quality controls, pipeline orchestration, and data governance concepts.
• Experience integrating data from ERP, MES, PLM, QMS, manufacturing, engineering, or operational systems strongly preferred.
• Experience with APIs, file ingestion, database extraction, scheduled refreshes, and on-prem-to-cloud data movement preferred.
• Familiarity with Power BI, semantic models, DAX, or business intelligence consumption patterns preferred.
• Experience with Git, DevOps practices, deployment management, testing, monitoring, and documentation preferred.
• Strong analytical, troubleshooting, communication, and problem-solving skills.
• Ability to work with business stakeholders, technical teams, and external partners to translate source-system data into reliable business-ready assets.
• Travel required as needed to support global sites and data integration activities.

Responsibilities

• Design, build, test, and maintain scalable data pipelines from priority source systems into the CBS cloud/lakehouse environment.
• Integrate data from enterprise and functional systems including ERP, MES, PLM, QMS, SI/test data, SharePoint/file repositories, Azure SQL, and other business platforms.
• Implement ETL/ELT patterns, data transformations, and medallion architecture layers including raw, cleaned, curated, and business-ready datasets.
• Develop data quality checks, validation logic, reconciliation methods, exception handling, and monitoring to ensure trusted and reliable data products.
• Support secure on-prem-to-cloud data integration patterns including database/API connectivity, file-based ingestion, scheduled refreshes, and batch or event-based processing.
• Partner with the IS Lead to develop data models, semantic layers, standardized KPIs, and reusable data assets that support dashboards, analytics, automation, and AI use cases.
• Partner with the Data Analyst and Business Analyst to understand reporting requirements, business definitions, and functional data needs.
• Support the AI Solutions & Automation team by preparing AI-ready datasets, defining data access patterns, and ensuring data products are governed, reliable, and reusable.
• Build and maintain orchestration, scheduling, logging, alerting, and pipeline documentation to support production operations and sustainment.
• Collaborate with corporate IT, security teams, and data owners to implement access controls, data lineage, naming standards, environment controls, and data governance requirements.
• Support implementation partners and vendors during architecture, pipeline build, source-system integration, testing, documentation, and handoff activities.
• Troubleshoot data issues, performance problems, refresh failures, and source-system changes that affect downstream analytics or automation capabilities.
• Contribute to continuous improvement of data engineering standards, development practices, documentation, and reusable pipeline patterns.
• Travel as required to support global operations and source-system discovery or deployment activities.
• Perform other duties and responsibilities as required to support the growth and success of the business.

Skills

Strong SQL skills

Data analysis

Troubleshooting

Communication

Problem-solving

Collaboration

Education

BS in Computer Science, Information Systems, Data Engineering, Data Analytics, Engineering, or related field

Tools

Python

PySpark

Notebooks

Microsoft Fabric

Azure Data Lake

Azure Data Factory

Synapse

Databricks

Snowflake

Power BI

Git

DevOps tools

Job description

Amphenol Communications Solutions in Nashua, NH seeks a Data Engineer to design and maintain scalable data pipelines, data lakehouse structures, and curated datasets for analytics, automation, and AI readiness. You will turn fragmented source-system data into reliable, governed assets and work with IS Lead, Data Analyst, and external partners.

The role focuses on source-system onboarding, data quality, orchestration, and production reliability, enabling dashboards and AI-enabled workflows across