Analyst, Business Intelligence & Data

Voyant Beauty believes our people are more than just employees; they’re the driving force behind everything we achieve. Our culture fosters teamwork, respect, and camaraderie, ensuring that every individual’s contribution is valued and celebrated. We invest in their growth, providing opportunities for development and advancement within our dynamic team.

Voyant Beauty is a company that specializes in the development and manufacturing, of beauty, personal and home care products. We work with various brands, retailers, and businesses to create customer formulations and products tailored to their needs. This can include skincare, haircare, bath and body products, fragrances, and more. Essentially, Voyant Beauty serves as a one-stop-shop for companies looking to bring their beauty and personal care product ideas to life.

Safety is a core value at Voyant Beauty. We prioritize the well-being of our team members, ensuring a safe and secure environment where everyone can thrive and excel.

If you’re seeking to be part of a team where your talents are valued, your safety is paramount, and your efforts contribute to meaningful change, then Voyant Beauty is the place for you. Come join us and be a part of our journey.

A Brief Overview

The Data Analytics & Business Intelligence Analyst is responsible for designing, developing, and maintaining enterprise reporting and analytics solutions that transform operational and business data into meaningful insights. This position serves as a key connection between business operations and technology, partnering with stakeholders to understand business processes, reporting requirements, and performance measures and translating those needs into effective analytics solutions. The role will utilize Microsoft Power BI, SQL Server, and related technologies to develop dashboards, reports, data models, and reporting tools that support decision-making across Manufacturing, Supply Chain, Quality, Inventory, Sales, Finance, and other functional areas. The Analyst will also support data governance, reporting standards, data quality, and the continued expansion of self-service analytics across the organization.

What you will do

• Design, develop, maintain, and enhance interactive Power BI dashboards, reports, and scorecards. Partner with business stakeholders to gather reporting requirements and translate business needs into actionable analytics solutions. Develop meaningful visualizations that provide insight into operational, manufacturing, and financial performance. Create reporting solutions that enable leaders to identify trends, monitor performance, and support data-driven decision-making. Establish and maintain reporting standards and governance practices within the business intelligence environment. Promote and support adoption of self-service analytics capabilities throughout the organization. Ensure reporting solutions are intuitive, accurate, scalable, and aligned with business requirements.
• Design, develop, and maintain SQL views, stored procedures, queries, and related logic to support reporting and analytics requirements. Develop efficient data models and datasets optimized for Power BI and other reporting solutions. Troubleshoot and optimize database performance associated with reporting workloads. Perform data transformation, validation, and reconciliation to ensure reporting accuracy and consistency. Partner 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-related issues impacting reporting accuracy or performance.
• Partner with business leaders and functional teams to understand operational processes, reporting requirements, and key performance indicators. 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 meaningful KPIs, metrics, and analytics solutions. Document business requirements, metric definitions, reporting logic, and reporting standards. Recommend process improvements based on data analysis and identified business trends. Assist departments in establishing meaningful performance measures and measurement frameworks. Challenge assumptions, validate data, and ensure conclusions are supported by accurate information before communicating findings.
• Support enterprise data accuracy, validation, and reporting governance initiatives. Develop and maintain reporting documentation, business definitions, data dictionaries, and supporting reference materials. Ensure reporting and analytics solutions comply with company data governance, security, and access requirements. Train and support end users on Power BI dashboards, reports, and self-service analytics capabilities. Provide ongoing support for reporting-related questions, issues, and enhancement requests. Participate in strategic analytics, data management, and digital transformation initiatives. Collaborate with business and technology teams to continuously improve the reliability and usability of enterprise reporting.
• Develop a strong understanding of Voyant Beauty’s manufacturing and business processes to ensure analytics solutions reflect operational realities.
• Work effectively with stakeholders ranging from executive leadership to manufacturing and shop floor teams.
• Support analytics related to key operational measures including: Overall Equipment Effectiveness (OEE)z, Production Efficiency, Inventory Accuracy, Fill Rate and Service Levels, Scrap and Yield, Quality Performance, Labor Productivity, Purchasing and Supplier Performance, Forecast Accuracy, & Financial Performance
• Stay current on emerging business intelligence, analytics, data management, and Microsoft technologies.

Education Qualifications

• Bachelor's Degree in Information Systems, Data Analytics, Computer Science, Business Administration, Engineering, or a related field (Required) or
• An equivalent combination of education and relevant experience may be considered. (Required)

Experience Qualifications

• 4-6 years of experience in business intelligence, data analytics, reporting, or a related field. (Required)
• 4-6 years of hands-on Power BI development experience. (Required)
• 4-6 years of Microsoft SQL Server development experience. (Required)
• 4-6 years working within a manufacturing environment. (Required)
• 4-6 years supporting ERP systems such as Epicor, Oracle, JD Edwards, Microsoft Dynamics, or comparable enterprise platforms. (Required)
• 4-6 years developing and supporting business reporting, dashboards, KPIs, and operational metrics. (Required)
• 4-6 years Manufacturing experience supporting one or more of the following functional areas: Production Planning, Inventory Management, Supply Chain, Quality Assurance, Procurement, & Warehouse Operations (Preferred)
• 4-6 years with Epicor Kinetic and/or JD Edwards World. (Preferred)
• 4-6 years with Microsoft Fabric. (Preferred)
• 4-6 years Azure Data Services. (Preferred)
• 4-6 years SQL Server Reporting Services (SSRS). (Preferred)
• 4-6 years working with data lakes and modern data platforms. (Preferred)
• 4-6 years developing operational KPIs and performance measurement frameworks. (Preferred)

Skills and Abilities

• Microsoft Power BI Development (High proficiency)
• Power BI Data Modeling (High proficiency)
• DAX Calculations (High proficiency)
• Power Query (High proficiency)
• Dashboard and Data Visualization Design (High proficiency)
• Power BI Performance Optimization (High proficiency)
• Power BI Row-Level Security (High proficiency)
• Microsoft SQL Server (High proficiency)
• SQL Query Development and Optimization (High proficiency)
• SQL Views and Stored Procedures (High proficiency)
• Data Transformation and Validation (High proficiency)
• Dimensional Data Modeling (High proficiency)
• Data Warehousing Concepts (High proficiency)
• ETL Processes (High proficiency)
• Relational Databases (High proficiency)
• Manufacturing Operations and Processes (High proficiency)
• KPI and Operational Metrics Development (High proficiency)
• Business Analysis (High proficiency)
• Data Governance and Data Quality (High proficiency)
• Analytical and Problem-Solving Skills (High proficiency)
• Business Process Analysis (High proficiency)
• Stakeholder Management (High proficiency)
• Written and Verbal Communication (High proficiency)
• Business Acumen (High proficiency)
• Microsoft Fabric (Medium proficiency)
• Azure Data Services (Medium proficiency)

To Staffing and Recruiting Agencies: Our company does not accept unsolicited curriculum vitae’s or applications from agencies. We are not responsible for any fees related to unsolicited curriculum vitae’s or applications and explicitly reserve its right to contact candidates presented in such unsolicited curriculum vitae’s or application.

Our company provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, religion, sex, color, national origin, sexual orientation, age, disability or veteran status. Voyant Beauty will consider requests for accommodations due to a disability impacting a qualified employee's ability to perform the essential functions of their position consistent with applicable laws. In addition to federal law requirements, Voyant Beauty complies with applicable provincial and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.