Analyst, Business Intelligence & Data

Voyant Beauty•Hodgkins, IL

About The Position

The Data Analytics & Business Intelligence Analyst designs, develops, and maintains enterprise reporting and analytics solutions that turn operational and business data into meaningful insights. The role connects business operations and technology by working with stakeholders to understand processes, reporting needs, and performance measures, then translating those requirements into analytics solutions. It uses Microsoft Power BI, SQL Server, and related technologies to create dashboards, reports, data models, and reporting tools for Manufacturing, Supply Chain, Quality, Inventory, Sales, Finance, and other functions. The Analyst also supports data governance, reporting standards, data quality, and the expansion of self-service analytics. The role requires a strong understanding of Voyant Beauty’s manufacturing and business processes, and the ability to work with stakeholders ranging from executive leadership to manufacturing and shop floor teams. Analytics may support operational measures such as Overall Equipment Effectiveness (OEE), production efficiency, inventory accuracy, fill rate and service levels, scrap and yield, quality performance, labor productivity, purchasing and supplier performance, forecast accuracy, and financial performance. The Analyst also stays current on business intelligence, analytics, data management, and Microsoft technologies.

Requirements

Bachelor’s degree in Information Systems, Data Analytics, Computer Science, Business Administration, Engineering, or a related field, or an equivalent combination of education and relevant experience.
4–6 years of experience in business intelligence, data analytics, reporting, or a related field.
4–6 years of hands-on Power BI development experience.
4–6 years of Microsoft SQL Server development experience.
4–6 years of experience working within a manufacturing environment.
4–6 years of experience supporting ERP systems such as Epicor, Oracle, JD Edwards, Microsoft Dynamics, or comparable enterprise platforms.
4–6 years of experience developing and supporting business reporting, dashboards, KPIs, and operational metrics.
High proficiency in Microsoft Power BI development, Power BI data modeling, DAX, Power Query, dashboard and data visualization design, Power BI performance optimization, and Power BI row-level security.
High proficiency in Microsoft SQL Server, SQL query development and optimization, SQL views and stored procedures, data transformation and validation, dimensional data modeling, data warehousing concepts, ETL processes, and relational databases.
High proficiency in manufacturing operations and processes, KPI and operational metrics development, business analysis, data governance and data quality, analytical and problem-solving skills, business process analysis, stakeholder management, written and verbal communication, and business acumen.

Nice To Haves

4–6 years of manufacturing experience supporting one or more of Production Planning, Inventory Management, Supply Chain, Quality Assurance, Procurement, or Warehouse Operations.
4–6 years of experience with Epicor Kinetic and/or JD Edwards World.
4–6 years of experience with Microsoft Fabric.
4–6 years of experience with Azure Data Services.
4–6 years of experience with SQL Server Reporting Services (SSRS).
4–6 years of experience working with data lakes and modern data platforms.
4–6 years of experience developing operational KPIs and performance measurement frameworks.
Medium proficiency in Microsoft Fabric and Azure Data Services.

Responsibilities

Design, develop, maintain, and enhance interactive Power BI dashboards, reports, and scorecards.
Gather reporting requirements from business stakeholders and translate them into analytics solutions and visualizations.
Develop reporting solutions that help leaders identify trends, monitor performance, and make data-driven decisions.
Establish and maintain business intelligence reporting standards and governance practices, and promote self-service analytics.
Design, develop, and maintain SQL views, stored procedures, queries, and related reporting logic.
Develop efficient data models and datasets optimized for Power BI and other reporting solutions.
Troubleshoot and optimize database performance for reporting workloads.
Transform, validate, and reconcile data to ensure reporting accuracy and consistency.
Work with ERP and application teams to understand system data structures, business rules, and data relationships.
Support dimensional modeling, relational database structures, data warehousing concepts, and ETL processes.
Identify and resolve data issues affecting reporting accuracy or performance.
Partner with business leaders and functional teams to understand operations, reporting requirements, and KPIs.
Analyze manufacturing, inventory, quality, production, procurement, supply chain, and other business data to identify trends, risks, and improvement opportunities.
Translate manufacturing and operational processes into KPIs, metrics, and analytics solutions.
Document business requirements, metric definitions, reporting logic, standards, data definitions, and data dictionaries.
Recommend process improvements based on data analysis and business trends; help departments establish performance measures and measurement frameworks.
Validate data and ensure conclusions are supported by accurate information before communicating findings.
Support enterprise data accuracy, validation, governance, security, and access requirements.
Train and support end users on Power BI dashboards, reports, and self-service analytics.
Respond to reporting questions, issues, and enhancement requests.
Participate in strategic analytics, data management, and digital transformation initiatives, collaborating to improve enterprise reporting reliability and usability.
Develop an understanding of Voyant Beauty’s manufacturing and business processes so analytics reflect operational realities.
Support analytics for OEE, production efficiency, inventory accuracy, fill rate and service levels, scrap and yield, quality performance, labor productivity, purchasing and supplier performance, forecast accuracy, and financial performance.
Stay current on business intelligence, analytics, data management, and Microsoft technologies.