Automation-Driven Data Analyst (Python & ETL)

Amphenol Corporation; Nashua (NH); On-site; USD 85,000 - 105,000; Full time

Job summary

Amphenol Corporation’s ACS division in Nashua, NH seeks a Data Analyst to modernize Excel workflows into scalable data pipelines using Python and SQL. You will work with cross-functional teams to gather requirements, design solutions, and deliver reliable outputs that drive informed decisions.

Responsibilities include mapping data flows, building production-ready scripts, automating ingestion and validation, and creating dashboards so non-technical stakeholders can access insights.

Qualifications

• 3+ years of experience as a Data Analyst, Analytics Engineer, or similar role.
• Proven track record of automating manual data processes.
• Strong Python proficiency with production-ready code.

Responsibilities

• Document and map the current data flow, including inputs, transformations, manual steps, and outputs.
• Collaborate with stakeholders to understand process requirements and translate them into automated solutions.
• Redesign and implement automation using Python and SQL, replacing fragile spreadsheet logic with production-ready scripts.
• Automate data ingestion, cleaning, transformation, and delivery across multiple sources.
• Build validation checks to ensure automated outputs match or improve the manual process.
• Develop reports, dashboards, or templates for non-technical stakeholders.

Skills

Python proficiency

Communication skills

Advanced Excel

Tools

Pandas

NumPy

Docker

OpenPyXL

FastAPI

Django

Job description

Amphenol Corporation’s ACS division in Nashua, NH seeks a Data Analyst to modernize Excel workflows into scalable data pipelines using Python and SQL. You will work with cross-functional teams to gather requirements, design solutions, and deliver reliable outputs that drive informed decisions.

Responsibilities include mapping data flows, building production-ready scripts, automating ingestion and validation, and creating dashboards so non-technical stakeholders can access insights.