Automation-Focused Data Analyst — Python & ETL

Amphenol Corporation; Yocumtown (PA); On-site; USD 75,000 - 110,000; Full time

Job summary

Amphenol Communications Solutions seeks a Data Analyst to modernize Excel-based workflows into scalable automated pipelines. The role is onsite in Valley Green, PA or Nashua, NH, with opportunities to expand across business processes.

You will work with cross-functional stakeholders to gather requirements, design solutions, and deliver reliable data outputs that drive informed decision-making. The role emphasizes Python/SQL automation, data ingestion, validation, and reporting, requiring strong

Qualifications

• 3+ years as Data Analyst or Analytics Engineer with automation track record.
• Experience building data pipelines and ETL workflows.
• Ability to translate requirements for non-technical stakeholders.

Responsibilities

• Document and map the current data flow, including inputs, transformations, manual steps, and outputs.
• Collaborate with stakeholders to understand their process requirements and translate them into automated solutions.
• Redesign and implement processes for automation using Python and SQL, eliminating fragile spreadsheet logic and replacing manual work with version-controlled, production-ready scripts.
• Automate data ingestion, cleaning, transformation, and delivery across multiple sources.
• Build validation checks to ensure the automated output matches and improves on the manual process.
• Develop reports, dashboards, or templates so non-technical stakeholders can consume outputs without touching raw data.
• Document the new workflow clearly and enable handoff to the broader team.

Skills

Python

SQL

Excel

Data visualization

Communication

AI experience

Tools

pandas

numpy

docker

openpyxl

fastAPI

Django

Power Query

VBA

ETL scripting

Job description

Amphenol Communications Solutions seeks a Data Analyst to modernize Excel-based workflows into scalable automated pipelines. The role is onsite in Valley Green, PA or Nashua, NH, with opportunities to expand across business processes.

You will work with cross-functional stakeholders to gather requirements, design solutions, and deliver reliable data outputs that drive informed decision-making. The role emphasizes Python/SQL automation, data ingestion, validation, and reporting, requiring strong