Business Intelligence Architect & Analytics

Crayola Corporate•Forks Township, PA

20h

About The Position

Crayola is hiring an intermediate-level technical resource to develop, administer, optimize, and support enterprise business intelligence and analytics solutions, with a primary focus 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. The position also supports day-to-day Power BI and Fabric administration, including access management, deployment support, gateway and data source coordination, refresh monitoring, and governed self-service analytics. It partners with business users and senior technical resources to improve adoption, reliability, performance, and data literacy, escalating high-risk tenant, capacity, security, or architecture decisions when appropriate. Project-management assistance and leadership are required; team-management responsibilities may arise in the future. The role must follow applicable NIST CSF and Hallmark Standards policies and processes for security, continuous monitoring, and recovery, including asset, change, incident, problem, vulnerability and patch, and data security management, as well as disaster recovery and business continuity. The position has physical demands that include frequent sitting, talking, and hearing; occasional walking, handling or operating objects, tools, or controls, reaching, and lifting or moving up to 25 pounds. Reasonable accommodations may be made. Crayola describes its culture as mission-focused and centered on fun, collaboration, transparency, and helping others. The company states that it values diverse ideas and perspectives. Compensation is market-based, determined individually according to skills, experience, and qualifications; the role is eligible for an annual incentive plan under its guidelines.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field preferred; alternatively, a bachelor’s degree in a non-technical field with relevant experience.
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.
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 diagnostic tools such as Performance Analyzer, refresh history, or capacity metrics.
Working knowledge of Import, DirectQuery, composite, hybrid, and Direct Lake concepts and 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, and performance validation.
Full working understanding of permissions management across Fabric and Power BI, including tenant, capacity, workspace, app, item, semantic model, gateway, and data source scopes; workspace roles; Build permission; sharing; service principals; security groups; row-level and 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.
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, SQL, source-to-report lineage, data quality validation, and enterprise data governance.
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, including the ability to manage multiple assignments and work independently on moderately complex tasks.
Ability to meet the described physical demands, with reasonable accommodations available for individuals with disabilities.

Nice To Haves

Experience preparing CoPilot agents to interact with Power BI semantic models is a strong plus.
Familiarity with Microsoft Fabric Lakehouse or Warehouse concepts is strongly preferred.
A bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field is preferred.

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 support requirements; document 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 applicable hybrid real-time requirements.
Design and maintain manual or automatic aggregation strategies where appropriate, validating detail-level accuracy and security behavior.
Prepare 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 and data source permissions, and least-privilege reviews.
Monitor and troubleshoot semantic model refreshes, gateways, credentials, deployments, usage, and performance; independently resolve intermediate incidents and escalate tenant, capacity, network, identity, or source-platform issues with diagnostic evidence.
Apply development lifecycle and governance practices, including available source control, 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.
Validate and reconcile report outputs and document lineage, business definitions, dependencies, refresh schedules, security design, support procedures, and known limitations.
Assist with and provide leadership on project management; team-management responsibilities may be added in the future.
Follow NIST CSF and Hallmark Standards policies and processes for maintenance, security monitoring, recovery, and related compliance areas.

Benefits

Free admission to Crayola Experience for employees.
Community volunteerism opportunities.
Annual bonus potential for full-time employees; the role is eligible for an annual incentive plan under plan guidelines.
Company-matched 401(k) and Employee Value Sharing Plan.
Comprehensive healthcare benefits for eligible employees.
Education Assistance Program.
Wellness programs.
Employee Resource Groups.
Product discounts onsite and online.
Company-sponsored employee events.
Discounts on a wide variety of products and services, including automotive, electronics, fitness, travel, and entertainment.