Business Intelligence Analyst

Amphenol and its Affiliated Companies•Endicott, NY

5d•$55,000 - $70,000•Onsite

About The Position

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.

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
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.

Nice To Haves

Experience in a manufacturing environment preferred but not required
Exposure to ERP systems, Power Query, DAX, Power Automate, or data visualization tools preferred

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