Business Intelligence Analyst
Amphenol Interconnect Products Corp. · Endicott, NY · 1 mo ago
On-siteAccountingFull-time
Key Responsibilities
- Reporting & Dashboard Development
- Create, 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.
- Aid in the creation of Key Performance Indicators (KPIs), 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.