Business Intelligence Analyst

AGS Company Automotive Solutions•Muskegon Heights, MI

2d•$85,000 - $95,000

About The Position

The Business Intelligence Analyst plays a critical role in supporting Sales, Supply Chain, and Product Development by transforming data into actionable insights that drive strategic decision-making and operational performance. This position partners across departments to develop data-driven strategies, analyze complex datasets, improve business processes, and design tools that enhance visibility and efficiency. Reporting directly to the Director of Business Intelligence, the BI Analyst will collaborate with cross-functional teams to promote data literacy, provide training, and empower stakeholders to leverage analytics in their daily decision-making. This role is responsible for translating data into meaningful visualizations and interactive reporting solutions that enable exploration, scenario analysis, and informed business choices. The ideal candidate is a self-starter with strong analytical and problem-solving skills. They bring experience in statistical analysis, data profiling, and machine learning, along with hands-on expertise in techniques such as linear regression, logistic regression, and model validation. A strong ability to communicate insights clearly and effectively to both technical and non-technical audiences is essentialAt AGS, our values of Give, Respect, Act, Innovate, and Lead shape how we work together and deliver excellence in the automotive industry.

Requirements

Bachelor’s degree in Data Analytics, Information Systems, Business, Finance, or related field
3 + years of experience in business intelligence and analytics
Advanced proficiency in SQL (query development, joins, aggregations, performance tuning)
Experience building dashboards in Spotfire, Power BI, Tableau, or similar platforms
Advanced Excel skills (pivot tables, Power Query, complex formulas)
Strong understanding of relational databases and data modeling concepts
Experience working with ERP systems
Ability to interpret operational and financial metrics
Strong analytical thinking and problem-solving skills
High attention to detail and data accuracy

Nice To Haves

Experience in manufacturing, automotive, or distribution environments
Experience working with data warehouse or ETL processes
Knowledge of inventory, supply chain, and margin analytics
Experience supporting executive-level reporting
Familiarity with continuous improvement methodologies

Responsibilities

Develop, implement, and maintain scalable data models to support operational, financial, and strategic reporting
Design and optimize data collection systems and processes to improve statistical efficiency and data quality
Create and maintain structured datasets from ERP and related systems
Build and optimize SQL queries, stored procedures, and views
Develop validation checks to ensure data accuracy, consistency, and reliability
Assist in establishing data governance policies and procedures for data collection, processing, and analysis
Identify and evaluate internal and external data sources to enhance reporting capabilities
Support development and enhancement of centralized data warehouse structures
Design, create, and maintain rich interactive dashboards, visual reports, and scorecards using BI tools
Transform complex analytical results into clear, actionable reporting for stakeholders
Define and document KPI logic, metric definitions, and reporting standards
Implement automated reporting solutions to reduce manual processes
Ensure a single source of truth through strong data quality and reconciliation practices
Continuously refine dashboards for usability, performance, and executive visibility
Analyze complex datasets to identify operational and market trends
Perform comparative analysis, benchmarking, and trend analysis
Use statistical methods to interpret data patterns and support diagnostic and predictive insights
Partner closely with management and operational teams to gather business requirements
Translate business needs into technical specifications and scalable BI solutions
Evaluate performance against key performance indicators and highlight risks and opportunities
Bring data together to communicate clear themes, insights, and strategic implications
Support forecasting, budgeting, margin analysis, and performance improvement initiatives
Communicate complex analytical findings clearly and effectively to leadership and stakeholders
Monitor data environment performance and reporting reliability
Validate and reconcile data sources to ensure confidence in decision-making
Foster positive working relationships with data suppliers and cross-functional teams
Maintain documentation for reporting standards, business definitions, and governance practices
Ensure confidentiality and compliance with company data policies
Stay current on emerging BI technologies, data tools, and analytics best practices
Recommend improvements to reporting systems, automation processes, and data architecture
Identify opportunities to streamline analytics workflows and improve reporting efficiency
Support cross-functional integration of BI solutions into daily business operations
Share knowledge generously and support development of others
Promote a culture of open communication, continuous learning, and shared responsibility for quality
Participate in team building, training, and company-wide initiatives to strengthen engagement and performance
Model AGS values in day-to-day interactions and decision-making
Contribute to a workplace where people feel valued, supported, and empowered to succeed.

Benefits

Medical, dental, and vision insurance
Short-Term Disability (STD) and Long-Term Disability (LTD) coverage
Life insurance
AFLAC supplemental insurance options
Fitness membership benefit to support an active, healthy lifestyle
Employee Assistance Program (EAP) offering confidential support and resources
Ongoing educational and professional development opportunities
Proud partner of Cornerstone University’s Soar Program, providing access to learning, leadership development, and career growth pathways
A people-centered, values-driven culture rooted in respect, collaboration, and trust
Supportive leadership that believes in growth, feedback, and doing the right thing
A workplace where your voice matters and your contributions are recognized