BI Systems Analyst

Silicon Valley Recruiting•Branford, CT

1d•Onsite

About The Position

The Business Intelligence (BI) Systems Analyst supports business intelligence, data analytics, ERP administration, and reporting automation across an established manufacturing company. The role transforms complex business and operational data into actionable insights that support strategic decision-making and operational efficiency. The analyst works with Finance, IT, Operations, and other departments to improve data accessibility, automate reporting, optimize business processes, and support systems initiatives. The position is onsite in Branford, Connecticut, in a professional office environment. The work schedule is Monday through Thursday, with arrival between 6 a.m. and 9 a.m. and a mandatory nine-hour workday. On Fridays, the schedule is either 6 a.m.–1 p.m. or 9 a.m.–4 p.m., with every other Friday off. Occasional travel may be required. The role regularly interacts with internal departments, international colleagues, including teams in the United Kingdom, and external IT service providers.

Requirements

Bachelor's degree in Management Information Systems (MIS), Computer Science, Business Administration, Information Technology, or a related field.
At least 3 years of experience in a Business Intelligence Analyst, Systems Analyst, ERP Analyst, or similar position.
At least 3 years of experience working in 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.
Strong organizational and time-management skills, with the ability to manage multiple priorities independently.
Strong written and verbal communication skills, including the ability to explain technical information to nontechnical stakeholders.
Ability to collaborate effectively with cross-functional teams.

Nice To Haves

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.

Responsibilities

Develop, maintain, and automate dashboards, reports, and data visualizations using Power BI and other business intelligence tools.
Translate business requirements into KPIs, operational metrics, and actionable reporting solutions.
Use SQL and Oracle databases to extract, analyze, validate, and organize business data.
Work with cross-functional teams to identify process improvements through data analysis.
Support real-time reporting and maintain digital dashboards and associated workstations.
Present findings, reports, and recommendations to departmental leadership.
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 systems documentation, reporting procedures, and data management processes.
Identify and recommend technology solutions that improve business efficiency and data accessibility.
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 on general IT maintenance, troubleshooting, and end-user support.
Ensure systems and processes comply with applicable regulatory requirements and cybersecurity standards.
Manage multiple projects while meeting established deadlines.