Business Intelligence Analyst - Finance

Crayola has inspired children to express their creativity since 1903. Crayolians take pride in fulfilling our mission of helping parents and educators raise creatively alive children around the world. Join our team and be part of an iconic brand that develops quality art products and experiences that are loved by families and preferred by teachers. Our company culture is mission focused, and encourages fun, collaboration, transparency, and helping others. Crayola believes our workforce benefits from a broad spectrum of diverse ideas and perspectives which enables us to understand our consumers better.

Business Intelligence Analyst (Finance)

Hybrid - onsite 3 days per week, Easton, PA

GENERAL SUMMARY:

The Business Intelligence Analyst is a key role in the Corporate Controllers organization responsible for delivering financial and business performance reporting across the global enterprise. The position designs, builds, and maintains reporting solutions using Microsoft Power BI and governed semantic models sourced from the Snowflake data warehouse. The position leverages modern tools to update legacy workflows and implement more efficient delivery of information. The position plays a key role in the implementation of Microsoft Copilot / AI within the Finance division.

PRINCIPAL DUTIES & RESPONSIBILITIES:

• Develop an end-to-end understanding of the Finance data and reporting landscape.
• Publish financial and operational reporting (monthly, quarterly, and ad hoc) using governed Power BI semantic models and certified datasets sourced from the Snowflake data warehouse and SAP, in coordination with Finance Division management. Validate and reconcile report outputs to ensure accuracy, completeness, and alignment with enterprise data sources and source-of-truth systems.
• Build and maintain Excel-based user applications that facilitate the financial forecasting and reporting cycles, as well as address Finance Division efficiency opportunities; apply VBA and Office Scripts selectively where cloud-native alternatives are not yet available.
• Partner with IT to define business requirements for new and enhanced Power BI semantic models (e.g., royalties, labor efficiency hours, COPA), participate in validation and parallel-run cycles, and build the downstream consumption layer on completed models.
• Develop and maintain financial process automated workflows using Power Automate (cloud and desktop) and Office Scripts - including refresh orchestration, file movement across SharePoint and OneDrive, and reduction of manual touchpoints; use VBA selectively as a bridge for legacy Excel workflows.
• Serve as a Finance Division super-user across the Microsoft Power Platform (Power BI, Power Query, Power Automate, Power Apps) from application source to data warehouse, to governed downstream models consumed via Power BI. Train and support end users in Power BI and Excel consumption and delivery, promoting self-service reporting on governed datasets and certified data sources.
• Apply Microsoft Copilot (Excel, Power BI, M365) to accelerate analysis, documentation, model interpretation, and prompt/code iteration; contribute use cases and feedback to the Finance AI adoption initiative.
• Support the organization's transition from local network-drive workflows to certified SharePoint and OneDrive cloud locations, improving accessibility, version control, and AI-readiness of Finance data assets.
• Create and maintain documentation, SOPs, and user guides for Finance data assets, semantic models, and reporting tools, ensuring audit-readiness and effective knowledge transfer.

JOB SPECIFICATIONS:

• Bachelor's degree in Finance, Accounting, Information Systems, Data Analytics, or related quantitative field. Coursework or certifications in data analytics, business intelligence, or information systems strongly preferred.
• 2 - 5 years of relevant experience in Finance, Accounting, FP&A, or Business Intelligence environments preferred.
• Strong proficiency in Microsoft Excel (advanced formulas, pivot tables, XLOOKUP, Power Query, Power Pivot/data model, VBA or Office Scripts).
• Demonstrated experience with Microsoft Power BI (report development, basic data modeling, and consuming published semantic models to build downstream models and visualizations).
• Familiarity with data modeling fundamentals, including normalization and dimensional (star schema) design.
• Working knowledge of Microsoft Copilot or generative AI prompt engineering for productivity and analytical use cases.
• Working knowledge of SharePoint Online and OneDrive for business file management, collaboration, and version control.
• Discipline in data validation, reconciliation, and quality control against source-of-truth systems.
• Strong written and verbal communication across multiple levels of the organization.
• Detail-oriented; strong analytical, problem-solving, and quality-control discipline.
• Ability to build durable partnerships across Finance, Accounting, and IT teams; comfort operating as a bridge between business and technical stakeholders.
• Ability to handle confidential financial and business information with sound judgment and discretion.
• Naturally curious and enthusiastic about modern technology and continuous learning - motivated to ask 'why' and 'what if,' challenge legacy workflows, and pursue better ways of working; collaborative team player.
• Power BI semantic model design and DAX fluency (composite models, measure/KPI design, tabular modeling).
• Power Automate flow design (cloud and desktop).
• Exposure to Microsoft Fabric concepts, including Lakehouse and OneLake fundamentals.
• SQL and Python for querying source data and performing data exploration or supplemental analytics (e.g., source table queries, pandas, Fabric notebooks).

PHYSICAL CONDITIONS:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is frequently required to sit, talk and hear. The employee is occasionally required to walk; use hands and fingers to operate, handle, or feel objects, tools, or controls; and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and the ability to adjust focus

DISCLAIMER: The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

WHY CRAYOLA?

• Kid Inspired Culture
• Free Admission to Crayola Experience for Employees
• Community Volunteerism Opportunities
• Annual Bonus Potential for all Full-Time Employees
• Company Matched 401k & Employee Value Sharing Plan
• Comprehensive Healthcare Benefits for Eligible Employees
• Education Assistance Program
• Wellness Programs
• Employee Resource Groups
• Generous Product Discounts Onsite & Online
• Company Sponsored Employee Events
• Discounts on a wide variety of products and services - automotive, electronics, fitness, travel and entertainment

Green is our favorite color! Crayola cares about the environment and responsibly makes the products you love. Learn more about Crayola's creative solutions for greener tomorrows: https://www.crayola.com/about-us/sustainability

Crayola is committed to providing competitive market compensation. Our pay ranges are established using reliable market data and consider factors such as job responsibilities, industry benchmarks, and geographic location.

Individual starting pay is determined by a candidate's skills, experience and qualifications. This role is eligible to participate in an annual incentive plan as per plan guidelines. For a full list of Crayola benefits, please visit https://www.crayola.com/company/employee-benefits.

No phone calls please.

Search Firm Representatives - Please Read Carefully:
Crayola LLC is not seeking assistance or accepting unsolicited resumes from search firms for this employment opportunity. Regardless of past practice, all resumes submitted by search firms to any employee at Crayola LLC via e-mail, the Internet, or directly to hiring managers at Crayola LLC in any form without valid written search agreement in place for that position will be deemed the sole property of Crayola LLC, and no fee will be paid in the event the candidate is hired by Crayola LLC as a result of the referral or through other means.

Search firms are essential to the recruitment and staffing efforts at Crayola LLC, and we value the partnerships we have built with our vendors. For this reason, Crayola LLC has established and regularly maintains a preferred vendor list. Please note that even preferred vendors need to have a written search agreement signed by Human Resources at Crayola LLC in place for the specific position in order for a fee to be paid for any candidate referrals.