Amphenol IPC (AIPC) is the global leader in power distribution interconnect solutions for IT & Data Communications equipment, electric mobility, and industrial power conversion. We are driven by innovative, empowered, and creative teamwork, and build solutions that solve business challenges. Headquartered in Endicott, NY, and with operations in China and Mexico, AIPC is a division of Amphenol Corporation, a Fortune 500 company with over 90 years of experience in enabling the ongoing electronics revolution.
The Business Intelligence Analyst is responsible for developing, maintaining, and automating business reporting and analytics solutions that support decision-making across the organization. This role serves as the primary resource for Power BI development, data analysis, reporting automation, and business intelligence initiatives within the organization.
The position partners closely with Finance, Accounting, Operations, and Information Technology to transform data into meaningful insights, improve reporting efficiency, and support data-driven decision-making. This role is designed for an early-career professional with strong technical aptitude and analytical skills who is eager to develop expertise in business intelligence and enterprise reporting.
Key Responsibilities
Reporting & Dashboard Development
- Develop, maintain, and enhance Power BI dashboards, reports, and visualizations that support Finance and business operations
- Create recurring financial, operational, and management reports for internal stakeholders
- Translate business requirements into meaningful reporting solutions and visualizations
- Ensure accuracy, consistency, and reliability of data presented in reports and dashboards
- Maintain documentation for reporting processes, calculations, and data sources
Data Analysis & Business Intelligence
- Analyze business and financial data to identify trends, patterns, and opportunities for improvement
- Support development and maintenance of data models, relationships, and calculations within Power BI
- Assist with KPI development, performance metrics, and business scorecards
- Validate data integrity and investigate reporting discrepancies
- Support ad hoc reporting and analytical requests from Finance leadership and business partners
Data Automation & Systems Support
- Develop and maintain SQL queries, data extracts, and automated reporting solutions
- Identify opportunities to reduce manual reporting efforts through automation and process improvements
- Support integration of ERP, financial, and operational data into reporting platforms
- Assist with testing and implementation of reporting enhancements and system changes
- Troubleshoot reporting issues and support users of business intelligence tools
Collaboration & Continuous Improvement
- Partner with Finance, Accounting, Operations, and IT teams to understand reporting requirements
- Provide training and support to end users on reporting tools and dashboards
- Recommend improvements to reporting processes, data quality, and analytics capabilities
- Stay current on emerging technologies and best practices related to business intelligence and data analytics
- Contribute to continuous improvement initiatives across Finance and business operations
Qualifications
- Bachelor's degree in Business Analytics, Data Analytics, Information Systems, Computer Science, Finance, Accounting, Mathematics, Statistics, or a related field
- 0–3 years of experience in business intelligence, analytics, reporting, finance, accounting, or a related field
- Proficiency in Microsoft Excel, including PivotTables, formulas, and data analysis tools
- Working knowledge of Power BI or other business intelligence/reporting platforms
- Basic understanding of SQL and relational databases
- Strong analytical, problem-solving, and organizational skills
- Ability to communicate technical information effectively to non-technical audiences
- Demonstrated attention to detail and commitment to data accuracy
- Experience in a manufacturing environment preferred but not required
- Exposure to ERP systems, Power Query, DAX, Power Automate, or data visualization tools preferred
Physical Demands (with or without reasonable accommodations)
The physical demands described below are representative of those required to successfully perform the essential functions of this position.
- Ability to remain in a stationary position for extended periods of time, with the ability to occasionally move throughout the work environment.
- Ability to occasionally bend, push, and pull as required to perform job-related tasks.
- Ability to adapt to changes in work processes, priorities, and environment.
- Ability to apply mental processes to understand, interpret, and follow verbal and written instructions, and to perform job-related tasks accurately and efficiently.
The candidate must be able to legally work in the United States; we are unable to provide sponsorship. This position requires access to controlled technology that is subject to US export controls. Qualified candidates must be a US person (including US Citizen, lawful permanent resident, or protected individual as defined by 8 U.S.C. 1324b(a)(3)) or eligible to obtain required authorization(s) from the U.S. Government.
Amphenol is a proud Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, marital status, sex, sexual orientation, gender identity or expression, national origin, age, protected veteran status, or disability status.
