Data Insights Analyst - SQL, Python & Dashboards

Amphenol Communications Solutions; Yocumtown (PA); On-site; USD 70,000 - 95,000; Full time

Job summary

Amphenol Communications Solutions is seeking a Data Analyst in Etters, PA to transform raw operational data into reliable reporting that drives decision-making. You will work with data scientists and software engineers to build dashboards, validate data, and ensure accuracy across systems.

The role requires 3+ years in analytics, a bachelor’s in a related field, and strong SQL/Python skills plus experience with Tableau, Looker or Power BI.

Qualifications

• Bachelor's degree in Data Science, Applied Mathematics, Statistics, Analytics, or a related field required. MS preferred.
• Comfort working with messy, real-world data, including cleaning, reconciling, and validating across multiple sources
• Strong communication skills, able to gather requirements from non-technical stakeholders and explain findings clearly to mixed audiences
• Experience mentoring or reviewing the work of others is a plus for more senior candidates

Responsibilities

• Collect, clean, and validate data from multiple engineering systems.
• Partner with engineering stakeholders to understand reporting needs and translate them into clear, actionable dashboards and reports.
• Build and maintain SQL queries and Python scripts to automate recurring data pulls and reduce manual reporting work.
• Conduct root-cause and trend analysis to surface issues and opportunities for improvement.
• Maintain documentation for data sources, definitions, and reporting logic so outputs are consistent and repeatable across the team.
• Perform data quality checks, flagging and resolving discrepancies before they reach stakeholders.
• For more senior candidates: lead requirements-gathering on complex initiatives and mentor junior analysts

Skills

SQL

Python

BI/Visualization tools

Education

Bachelor's degree in data analytics related field

Tools

Tableau

Looker

Power BI

Job description

Amphenol Communications Solutions is seeking a Data Analyst in Etters, PA to transform raw operational data into reliable reporting that drives decision-making. You will work with data scientists and software engineers to build dashboards, validate data, and ensure accuracy across systems.

The role requires 3+ years in analytics, a bachelor’s in a related field, and strong SQL/Python skills plus experience with Tableau, Looker or Power BI.