Business System & Analytics Analyst

The Chemico Group; Southfield (MI); On-site; USD 70,000 - 110,000; Full time

Job summary

The Chemico Group is seeking a Business Systems & Analytics Analyst to develop, maintain, and improve BI solutions that support operational, financial, and supply chain decision-making. You will partner with stakeholders across departments to analyze processes, troubleshoot data issues, develop dashboards, automate reporting, and provide actionable metrics.

This role also supports CONTPAQ ERP and Flowtrac Inventory Management, translating requirements into robust reporting solutions and

Qualifications

• 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.

Responsibilities

• Develop, maintain, and enhance Power BI dashboards and reports.
• Create and optimize SQL queries, datasets, and reporting tools.
• Design and implement KPIs and operational metrics.
• Automate recurring reports and business processes where possible.
• Create proactive alerts and monitoring tools to identify 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 insights to business leaders.
• Support strategic decision-making through ad hoc analysis and reporting.
• Analyze current business processes and translate requirements into system/reporting solutions.
• Lead or support implementation of process improvement initiatives.
• Support and troubleshoot CONTPAQ ERP and Flowtrac Inventory Management System.

Skills

Power BI

SQL

Excel

Data analysis

DAX

Data modeling

Reporting

Tools

CONTPAQ ERP

Dynamics 365

SAP

Oracle

Job description

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
• 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

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
• 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.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.