Data Engineer — AI-Ready Analytics & Lakehouse

Amphenol ICC; Nashua (NH); On-site; USD 90,000 - 130,000; Full time

Job summary

Amphenol ICC is seeking a Data Engineer in Nashua, NH to design, build, and maintain scalable data pipelines and curated data products for analytics and AI readiness. You will integrate data from ERP, MES, PLM, QMS, and other systems, implement ETL/ELT patterns, and develop data quality checks and governance.

You will collaborate with IS, Data Analysts, and partners to define data models, KPIs, and reusable assets for dashboards and automation.

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

SQL

Python

PySpark

Data modeling

ETL/ELT

Data governance

Data quality

Troubleshooting

Communication

Collaboration

Education

Bachelor's degree in CS/IS/Data Engineering/Analytics

Tools

Git

Azure Data Factory

Azure Data Lake

Databricks

Power BI

Job description

Amphenol ICC is seeking a Data Engineer in Nashua, NH to design, build, and maintain scalable data pipelines and curated data products for analytics and AI readiness. You will integrate data from ERP, MES, PLM, QMS, and other systems, implement ETL/ELT patterns, and develop data quality checks and governance.

You will collaborate with IS, Data Analysts, and partners to define data models, KPIs, and reusable assets for dashboards and automation.