Business System & Analytics Analyst
About The Position
The Business System & Analytics Analyst develops, maintains, and improves business intelligence solutions that support operational, financial, and supply chain decision-making. The role partners with stakeholders across departments to analyze business processes, troubleshoot data issues, develop dashboards and reports, automate reporting, create actionable metrics, and provide insights that support business performance. The analyst also supports the company’s ERP and inventory management systems and acts as a liaison between business users and technology solutions. Primary objectives include developing financial, operational, inventory, and customer service dashboards that give leadership real-time visibility into business performance. The analyst partners with Finance and Operations leadership to identify performance trends, develop forecasts, improve reporting processes, and support data-driven decisions. Travel to Canada and Mexico is required for less than 20% of the role.
Requirements
- At least 3 years of experience in business analytics, business intelligence, systems analysis, or a related field.
- Advanced Power BI experience, including DAX, data modeling, dashboard development, and report publishing.
- Strong SQL skills, including complex joins, data validation, and query optimization.
- Advanced Microsoft Excel skills, including Power Query, Pivot Tables, lookup functions, and data analysis tools.
- Experience with ERP systems such as CONTPAQ, Dynamics 365, SAP, Oracle, or similar.
- Strong analytical and problem-solving abilities.
- Ability to translate complex data into actionable business insights.
- Experience working with accounting, operations, inventory, and supply chain teams.
- Excellent communication and presentation skills.
- Ability to gather requirements and manage multiple priorities.
- Bilingual English/Spanish proficiency is required.
Nice To Haves
- Knowledge of accounting principles and financial reporting.
- Experience in manufacturing, chemical management, distribution, or supply chain.
- Experience with data warehousing or ETL processes.
Responsibilities
- Develop, maintain, and enhance Power BI dashboards and reports.
- Create and optimize SQL queries, datasets, and reporting tools.
- Design and implement key performance indicators and operational metrics.
- Automate recurring reports and business processes where possible.
- Create alerts and monitoring tools to identify business exceptions and trends.
- Validate and reconcile data to ensure reporting accuracy.
- Analyze operational, financial, inventory, and supply chain data to identify trends, risks, and opportunities.
- Investigate data discrepancies and conduct root cause analysis.
- Interpret data and present insights to business leaders.
- Support strategic decision-making through ad hoc analysis and reporting.
- Analyze current business processes and recommend improvements.
- Identify opportunities to streamline workflows and eliminate inefficiencies.
- Document business requirements and translate them into system and reporting solutions.
- Lead or support process improvement initiatives.
- Support and troubleshoot the CONTPAQ ERP and Flowtrac Inventory Management System.
- Assist with user training and documentation.
- Support system setup, testing, and implementation activities.
- Coordinate with vendors and internal stakeholders to resolve system issues.
- Partner with Finance and Operations leadership to identify trends, develop forecasts, and improve reporting processes.
- Travel to Canada and Mexico for less than 20% of the role.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
