Business Intelligence Architect & Analytics

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.

We recognize that candidates may use AI tools to assist with formatting, proofreading, and organizing application materials. However, all materials submitted must accurately reflect your qualifications and experience. Candidates are expected to generate their own substantive responses to application questions/prompts, interview questions, and other assessments without the use of generative AI tools or other external assistance unless they have received permission from the company.

Business Intelligence Architect & Analytics

GENERAL

SUMMARY

Intermediate-level technical resource responsible for developing, administering, optimizing, and supporting enterprise business intelligence and analytics solutions, with primary emphasis on Microsoft Power BI and Fabric. The role independently delivers moderately complex reports and semantic models, applies established architecture and governance standards, and troubleshoots performance, refresh, security, and access issues.

In addition to report development, this position supports day-to-day Power BI and Fabric administration, including workspace and item access, deployment support, gateway and data source coordination, refresh monitoring, and governed self-service enablement. The role partners with business users and senior technical resources to improve adoption, reliability, performance, and data literacy while escalating high-risk tenant, capacity, security, or architecture decisions when appropriate. Assistance and leadership on project management is required, and team management responsibilities are possible moving forward.

PRINCIPAL

DUTIES & RESPONSIBILITIES

• Design, develop, test, deploy, and maintain moderately complex Power BI reports, dashboards, semantic models, measures, and KPIs using governed enterprise data sources and dimensional modeling standards.
• Optimize Power BI model and report performance by analyzing model size, DAX and visual behavior, relationships, cardinality, query patterns, refresh performance, and source-system response times.
• Evaluate and recommend Import, DirectQuery, composite, or hybrid approaches based on performance, data volume, freshness, security, source-system capacity, and operational support requirements; document material trade-offs and escalate architecture exceptions.
• Configure and support incremental refresh and partitioning strategies, including parameters, query folding validation, refresh windows, change-detection options, and hybrid real-time requirements where applicable.
• Design and maintain aggregation strategies, including manual or automatic aggregations where appropriate, to improve query performance while validating that detail-level accuracy and security behavior are preserved.
• Preparing Power BI semantic models for integration with CoPilot AI Agents.
• Administer Power BI and Fabric access within assigned scope, including workspace roles, app audiences, item permissions, semantic model Build access, sharing, row-level and object-level security coordination, gateway/data source permissions, and least-privilege access reviews.
• Monitor and troubleshoot semantic model refreshes, gateways, credentials, deployment issues, usage, and performance; resolve intermediate incidents independently and escalate tenant, capacity, network, identity, or source-platform issues with clear diagnostic evidence.
• Apply development lifecycle and governance practices, including source control where available, workspace and deployment-pipeline conventions, peer review, testing, release documentation, change management, endorsement, and promotion of certified or governed data assets.
• Enable self-service analytics by training business users, preparing support documentation, advising on approved datasets and models, and promoting effective visualization, accessibility, and data interpretation practices.
• Validate and reconcile report outputs; document lineage, business definitions, dependencies, refresh schedules, security design, support procedures, and known limitations to improve operational continuity and audit readiness.
• In accordance with the NIST CSF and Hallmark Standards, ensure adherence to policies and processes to remain in compliance for maintenance, security continuous monitoring and recovery areas including Asset Management, Change Management, Incident Management, Problem Management, Vulnerability & Patch Management, Data Security, Disaster Recovery and Business Continuity.

JOB SPECIFICATIONS:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field preferred OR a Bachelor’s degree in a non-technical field with relevant experience in the specifications provided below.
• 3-5 years of experience delivering business intelligence or analytics solutions, including at least 2 years of hands-on Power BI development and service administration responsibilities.
• Advanced proficiency with Power BI Desktop and the Power BI/Fabric service, including semantic modeling, Power Query, DAX, report design, publishing, refresh configuration, and troubleshooting.
• Demonstrated ability to improve Power BI performance using star-schema principles, model simplification, efficient DAX, appropriate relationships and cardinality, reduced visual/query load, and available diagnostic tools such as Performance Analyzer, refresh history, or capacity metrics.
• Working knowledge of Import, DirectQuery, composite, hybrid, and Direct Lake concepts, with the ability to explain selection criteria and operational trade-offs involving performance, freshness, scale, security, and source-system impact.
• Hands-on experience configuring or supporting incremental refresh, including parameters, filter logic, query folding, partition behavior, refresh policy settings, and post-deployment validation.
• Working knowledge of Power BI aggregation concepts, including aggregation tables, storage-mode relationships, query routing considerations, and validation of performance improvement.
• Full working understanding of permissions management across Fabric and Power BI, including tenant, capacity, workspace, app, item, semantic model, gateway, and data source permission scopes; workspace roles; Build permission; sharing; service principals; security groups; row-level security; object-level security; and least-privilege practices. Ability to administer permissions independently within assigned authority and escalate privileged or tenant-wide changes.
• Experience leveraging CoPilot AI to assist Power BI Development required. Experience prepping CoPilot agents to interact with Power BI Semantic models a large plus.
• Experience monitoring and supporting scheduled and on-demand refreshes, gateway connectivity, data source credentials, deployment pipelines, endorsement, lineage, and workspace lifecycle processes.
• Working knowledge of data warehousing and dimensional modeling concepts, SQL, source-to-report lineage, data quality validation, and enterprise data governance. Familiarity with Microsoft Fabric Lakehouse or Warehouse concepts is strongly preferred.
• Ability to document solutions and operating procedures, perform peer reviews, support release and change-management activities, and communicate technical trade-offs clearly to business and technical stakeholders.
• Strong analytical, troubleshooting, customer service, organization, and prioritization skills, with the ability to manage multiple assignments and operate independently on moderately complex work.

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:

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 .

No phone calls please.

Search Firm Representatives - Please Read Carefully:

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.