BI Systems Analyst

Industry: Manufacturing
Department: Finance / Information Technology
Employment Type: Full-Time, Onsite

Location: Branford, CT.

Salary Range: $80,000-$90,000/year

Work schedule:

* Monday-Thursday: Arrive in office between 6-9am. Mandatory 9 hour work day.
* Fridays: 6-1, or 9-4. 

* Every other Friday off.

Our client, an established manufacturing company, is seeking a Business Intelligence (BI) Systems Analyst to support business intelligence, data analytics, ERP administration, and reporting automation across the organization.

This position plays a key role in transforming complex business and operational data into meaningful, actionable insights that support strategic decision-making and operational efficiency.

The ideal candidate will have a strong background in SQL, Oracle databases, Power BI, and ERP systems, along with experience working in a manufacturing environment. This individual will collaborate with Finance, IT, Operations, and other departments to improve data accessibility, automate reporting, optimize business processes, and support ongoing systems initiatives.

Business Intelligence & Data Analytics

• Develop, maintain, and automate dashboards, reports, and data visualizations using Power BI and other business intelligence tools.
• Translate business requirements into meaningful KPIs, operational metrics, and actionable reporting solutions.
• Utilize SQL and Oracle databases to extract, analyze, validate, and organize business data.
• Partner with cross-functional teams to identify opportunities for process improvements through data analysis.
• Support real-time reporting and maintain digital dashboards and associated workstations.
• Present findings, reports, and recommendations to departmental leadership.

ERP Systems & Data Management

• Support ERP system administration, configuration, customization, and ongoing optimization.
• Serve as an ERP super-user, assisting departments with system functionality, troubleshooting, and process improvements.
• Plan and execute data cleansing, validation, and migration projects.
• Support third-party software integrations and system enhancements.
• Maintain accurate systems documentation, reporting procedures, and data management processes.
• Identify and recommend technology solutions that improve business efficiency and data accessibility.

Technical Support & Cross-Functional Collaboration

• Collaborate with Finance, IT, Operations, and other business functions to support reporting and systems initiatives.
• Provide technical expertise and analytical support for departmental projects.
• Train employees on ERP functionality, reporting tools, and accessing business information.
• Coordinate with external IT managed services providers to assist with general IT maintenance, troubleshooting, and end-user support.
• Work closely with international colleagues, including teams based in the United Kingdom.
• Ensure systems and processes comply with applicable regulatory requirements and cybersecurity standards.
• Manage multiple projects while meeting established deadlines.

Required

• Bachelor's degree in Management Information Systems (MIS), Computer Science, Business Administration, Information Technology, or a related field.
• Minimum of 3 years of experience in a Business Intelligence Analyst, Systems Analyst, ERP Analyst, or similar position.
• Minimum of 3 years of experience working within a manufacturing environment.
• Strong proficiency in SQL, including querying and analyzing data.
• Experience working with Oracle databases.
• Hands-on experience developing dashboards and reports using Microsoft Power BI.
• Experience supporting ERP systems, including administration, configuration, reporting, or troubleshooting.
• Strong analytical, critical-thinking, and problem-solving abilities.
• Excellent organizational and time-management skills with the ability to manage multiple priorities independently.
• Strong written and verbal communication skills with the ability to explain technical information to nontechnical stakeholders.
• Ability to collaborate effectively with cross-functional teams.

Preferred

• Experience with IFS ERP software.
• Experience with data migration, data cleansing, and system integrations.
• Familiarity with manufacturing operations, production reporting, inventory management, or supply chain analytics.
• Experience developing automated reporting solutions and real-time operational dashboards.
• Experience supporting international business operations.

• Work Environment: Professional office environment.
• Travel: Occasional travel may be required.
• Collaboration: Regular interaction with internal departments, international colleagues, and external IT service providers.

This position offers the opportunity to combine business intelligence, ERP systems, and data analytics within a manufacturing organization. The successful candidate will have a direct impact on reporting automation, data-driven decision-making, operational improvements, and systems optimization.