Business Intelligence (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.
Position Overview
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.
Key Responsibilities
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.
Qualifications & Experience
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.
Additional Information
- Work Environment: Professional office environment.
- Travel: Occasional travel may be required.
- Collaboration: Regular interaction with internal departments, international colleagues, and external IT service providers.
Why Consider This Opportunity?
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.