Business System & Analytics Analyst

The Business Systems & Analytics Analyst is responsible for developing, maintaining, and improving business intelligence solutions that support operational, financial, and supply chain decision-making. This role partners with stakeholders across all departments to analyze business processes, troubleshoot data issues, develop dashboards and reports, automate reporting processes, create actionable metrics, and provide insights that drive business performance. The analyst also supports the company's ERP and inventory management systems while serving as a liaison between business users and technology solutions.

• Develop, maintain, and enhance Power BI dashboards and reports
• Create and optimize SQL queries, datasets, and reporting tools
• Design and implement key performance indicators (KPIs) and operational metrics
• Automate recurring reports and business processes where possible
• Create proactive alerts and monitoring tools to identify business exceptions and trends
• Ensure reporting accuracy through data validation and reconciliation

• Analyze operational, financial, inventory, and supply chain data to identify trends, risks, and opportunities
• Investigate data discrepancies and perform root cause analysis
• Interpret data and present meaningful 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 implementation of process improvement initiatives

• Support and troubleshoot 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

• 3+ years of experience in business analytics, business intelligence, systems analysis, or related field
• Advanced Power BI experience including:
• DAX
• Data modeling
• Report publishing
• Strong SQL skills including:
• Data validation
• Query optimization
• Advanced Microsoft Excel skills including:
• Power Query
• Lookup functions
• 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

• Knowledge of accounting principles and financial reporting
• Manufacturing, chemical management, distribution, or supply chain experience
• Experience with data warehousing or ETL processes
• Travel required to CAN and Mexico < 20%

• Develop financial, operational, inventory, and customer service dashboards that provide leadership with real-time visibility into business performance.
• Partner with Finance and Operations leadership to identify performance trends, develop forecasts, improve reporting processes, and support data-driven decision making.

Chemico provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. Chemico complies with…