About the Role
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. 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.
Responsibilities
- 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.
- 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.
- 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.
- 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.
Requirements
- 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.
- 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.
- Must be able to legally work in the United States; sponsorship is not provided.
- Requires access to controlled technology 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.
Skills
- Power BI
- Data analysis
- Reporting automation
- Business intelligence
- SQL
- Microsoft Excel
- PivotTables
- Formulas
- Data analysis tools
- Relational databases
- Analytical skills
- Problem-solving skills
- Organizational skills
- Communication skills
- Attention to detail
- Data accuracy
- ERP systems
- Power Query
- DAX
- Power Automate
- Data visualization tools
Location
- Endicott, NY
Work Type
- Full-time
Experience Level
- Early-career
- 0-3 years
Education Level
- Bachelor's degree in Business Analytics, Data Analytics, Information Systems, Computer Science, Finance, Accounting, Mathematics, Statistics, or a related field
About the Company
- 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.
Equal Opportunity
- 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.
