Data Analyst

Amphenol Aerospace; Yocumtown (PA); On-site; USD 70,000 - 110,000; Full time

Job summary

Amphenol Corporation seeks a Data Analyst to modernize Excel-based workflows into scalable data pipelines. The role is onsite in Valley Green, PA or Nashua, NH, collaborating with cross-functional teams to gather requirements and deliver reliable data outputs.

The position emphasizes Python and SQL automation, ETL design, and dashboard development. Candidates should have 3+ years of experience, strong communication, and the ability to handle messy data.

Qualifications

• 3+ years of experience as a Data Analyst, Analytics Engineer, or similar role.
• Strong Python proficiency and experience with data manipulation libraries.
• Advanced Excel skills including complex formulas, pivot tables, VBA/Power Query.
• Experience designing, building, and documenting data pipelines or ETL workflows from scratch.
• Comfort working with messy, real-world data and explaining decisions clearly to non-technical stakeholders.

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.
• Automate data ingestion, cleaning, transformation, and delivery across multiple sources.
• Build validation checks to ensure automated output matches or improves manual processes.
• Develop reports, dashboards, or templates for non-technical stakeholders to consume outputs.
• Document the new workflow clearly and enable handoff to the broader team.

Skills

Python proficiency

Strong communication skills

Analytical thinking

Problem solving

Ability to work with messy data

Tools

Python (pandas, numpy)

SQL

Docker

OpenPyXL

FastAPI

Django

ETL scripting

JSON handling

CSS for dashboards

Job description

Amphenol Communications Solutions (ACS), a division of Amphenol Corporation, is a world leader in interconnect solutions for Communications, Mobile, RF, Optics, and Commercial electronics markets. Amphenol Corporation is one of the world’s largest designers and manufacturers of electrical, electronic and fiber optic connectors and interconnect systems, antennas, sensors and sensor-based products and coaxial and high-speed specialty cable. ACS has an expansive global presence in research and development, manufacturing, and sales. We design and manufacture a wide range of innovative connectors as well as cable assemblies for diverse applications including server, storage, data center, mobile, RF, networking, industrial, business equipment, and automotive.

Position: Data Analyst

Location: Valley Green, PA

Amphenol High Speed Products Group is the market leader for high speed, high bandwidth electrical connectors for the Telecom/Datacom market (Mobile Networks, Storage, Servers, Routers, Switches, etc.). Our products help to enable the electronics revolution and remain a key enabler for all the major Tier 1 OEMs globally. Our global headquarters are located in Wallingford, CT and we have design, sales and manufacturing locations globally.

We are currently seeking a detail-oriented and technically skilled Data Analyst to join our High Speed Backplane team that supports the High Speed Products Group. The position will be located onsite in one of either our Valley Green, PA or Nashua, NH offices.

About the Role

The Data Analyst must have programming proficiency and will lead the modernization of manual, Excel-based workflows into scalable, automated data pipelines — starting with a critical existing process and expanding across multiple business processes over time. You will work closely with cross-functional stakeholders to gather requirements, design solutions, and deliver reliable data outputs that drive informed decision-making.

RESPONSIBILITIES:

What you'll do:

• 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

QUALIFICATIONS:

A good candidate should have 3+ years of experience as a Data Analyst, Analytics Engineer, or similar role, with a proven track record of automating manual data processes.

• Strong Python proficiency (pandas, numpy, docker, openpyxl, fastAPI, Django, ETL scripting) — comfortable writing production-ready code, not just exploratory analysis
• Familiarity working with JSON for data handling & CSS for styling dashboards or visualizations
• Advanced Excel skills, including complex formulas, pivot tables, and VBA/Power Query, to fully understand and rebuild existing processes
• Experience designing, building, and documenting data pipelines or ETL workflows from scratch
• Comfort working with messy, real-world data — cleaning, reconciling, and validating across multiple sources
• Strong communication skills — able to gather requirements from non-technical stakeholders and explain technical decisions clearly to mixed audiences
• Prior AI experience a plus, especially with Claude, Perplexity, or Cursor

Amphenol Corporation is proud of our reputation as an excellent employer. Our focus is to provide the highest level of support and responsiveness to both our employees and our customers, the world's largest technology companies. Amphenol Corporation offers the opportunity for career growth within a global organization. We believe that Amphenol Corporation is unique in that every employee, regardless of his or her position, has the ability to positively impact the business.

Amphenol is an “Equal Opportunity Employer” - Minority/Female/Disabled/Veteran/Sexual Orientation/Gender Identity/National Origin. For additional company information please visit our website at https://www.amphenol-cs.com/.