Position Summary
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.
Recommended Responsibilities
Business Intelligence & Reporting
- 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
Data Analysis
- 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
Business Process Improvement
- 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
Systems Support
- 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
Recommended Qualifications
Technical Skills
- 3+ years of experience in business analytics, business intelligence, systems analysis, or related field
- Advanced Power BI experience including:
- DAX
- Data modeling
- Dashboard development
- Report publishing
- Strong SQL skills including:
- Complex joins
- Data validation
- Query optimization
- Advanced Microsoft Excel skills including:
- Power Query
- Pivot Tables
- Lookup functions
- Data analysis tools
- Experience with ERP systems such as CONTPAQ, Dynamics 365, SAP, Oracle, or similar
Business Skills
- 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
Preferred
- Knowledge of accounting principles and financial reporting
- Manufacturing, chemical management, distribution, or supply chain experience
- Experience with data warehousing or ETL processes
- Bilingual English/Spanish (required)
- Travel required to CAN and Mexico < 20%
Primary Objectives:
- 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.
EEO Statement:
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 applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
Chemico expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Chemico employees to perform their expected job duties is not tolerated.
Other Duties:
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.