Data Analyst

Amphenol Communications Solutions

Yocumtown (PA)

On-site

USD 75,000 - 120,000

Full time

3 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Amphenol Communications Solutions (ACS) is seeking a Data Analyst to map data flow, automate ingestion, and build reporting pipelines. The role focuses on translating stakeholder needs into automated, production-ready solutions using Python, SQL, and Excel, with an emphasis on scalable data pipelines and clean data practices.

The position is onsite in Valley Green, PA, offering opportunities to collaborate across global teams, develop dashboards, and enable data-driven decision making for

Qualifications

  • Strong Python proficiency with production-ready code.
  • Familiarity with JSON for data handling and CSS for dashboards.
  • 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 validating across sources.
  • Prior AI experience (Claude, Perplexity, Cursor) is a plus.

Responsibilities

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

Skills

Python
Advanced Excel
ETL pipelines
SQL
Communication

Tools

Docker
FastAPI
Django
openpyxl
Power Query

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.

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.

Position: Data Analyst
Location: Valley Green, PA
About The Role
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
  • 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/

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

Amphenol • Yocumtown (PA)

On-site
USD 70,000 - 110,000
Data Analyst
Data Analyst

Amphenol • Yocumtown (PA)

On-site
USD 70,000 - 100,000
Data Scientist
Data Scientist

Amphenol • Yocumtown (PA)

On-site
USD 90,000 - 140,000
Data Scientist
Data Scientist

Amphenol • Yocumtown (PA)

On-site
USD 90,000 - 150,000
Restaurant stipend
Manufacturing Operations Data Analyst
Manufacturing Operations Data Analyst

Amphenol Communications Solutions • Yocumtown (PA)

On-site
USD 85,000 - 110,000
Financial Analyst
Financial Analyst

Amphenol • Nashua (NH)

On-site
USD 70,000 - 90,000
Manufacturing Operations Data Analyst
Manufacturing Operations Data Analyst

Amphenol • Yocumtown (PA)

On-site
USD 70,000 - 90,000
Manufacturing Operations Data Analyst
Manufacturing Operations Data Analyst

Amphenol • Yocumtown (PA)

On-site
USD 70,000 - 95,000
AI Business Analyst
AI Business Analyst

Amphenol ICC • Yocumtown (PA)

On-site
USD 90,000 - 130,000
AI Business Analyst
AI Business Analyst

Amphenol TCS • Yocumtown (PA)

On-site
USD 90,000 - 120,000