Sr. Manager, Data Warehouse, Business Intelligence

Sr. Manager, Data Warehouse, Business Intelligence & AI

GENERAL SUMMARY:

The technical Senior Manager, Data Warehouse, Business Intelligence, and AI is a strategic leadership role responsible for architecting, implementing, and optimizing enterprise-wide data platforms. This role drives the integration of data warehouse systems, business intelligence tools, and AI/ML capabilities to support advanced analytics, operational efficiency, and business innovation. The manager will lead cross-functional teams, collaborate with business stakeholders, and ensure alignment with compliance, governance, and security standards. This role is responsible for leading development projects from inception through delivery.

PRINCIPAL DUTIES & RESPONSIBILITIES:

Data Warehouse Architecture & Engineering

• • Define the overall data warehouse architecture (e.g., ETL (Extraction, Transformation, and Load) process, ODS (Operational Data Store) , EDW (Enterprise Data Warehouse), and Data Marts)
  • Define best practices and ensure data standardization among all data warehouse architecture including but not limited to load strategies, package scripts, schemas, dimensions, fact tables, etc.
  • Lead the development and optimization of data pipelines using tools like Azure Data Factory, and Informatica.
  • Oversee database administration tasks including schema design, indexing, and performance tuning (Snowflake, SQL Server)

Business Intelligence Strategy

• • Design and deliver BI dashboards and semantic models using Power BI and MS Fabric.
  • Establish metadata standards and ensure data consistency across reporting platforms.
  • Collaborate with business units to define KPIs and enable self-service analytics.

AI/ML Enablement

• • Lead AI/ML initiatives including model development, deployment, and MLOps using frameworks like PyTorch, TensorFlow, and Azure AI Foundry
  • Integrate predictive analytics and GenAI capabilities into business workflows (e.g., Power BI Copilot, OpenAI models).
  • Drive innovation through use cases in retail analytics, customer insights, and operational forecasting.

Governance & Compliance

• • Ensure adherence to NIST CSF and Hallmark standards for data security, incident management, and disaster recovery.
  • Implement data governance frameworks including cataloging, quality, and master data management.

Team Leadership & Collaboration

• • Manage and mentor a team of data engineers, BI developers, and data scientists.
  • Partner with PMs, BAs, and business leaders to align technical solutions with strategic goals.
  • Lead vendor engagements and oversee technology cost management.

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 (Masters preferred) in computer science, information systems field with 7+ years of Business Intelligence work experience and 10+ years overall IT experience
• Experience in leading multiple successful enterprise data warehousing efforts.
• Expertise in data warehousing technologies (e.g. ETL, ODS, DBMS (Database Management Systems), BI) and familiarity with AI/ML frameworks
• Strong data modeling skills (normalized and multidimensional).
• Understanding of business data and its various sources including but not limited to SAP.
• Understanding of database technologies and data warehouse methodologies.
• Strong communication, leadership, and stakeholder management skills.
• Must have excellent problem solving and analytical skills.

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 colorCrayola 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

We offer competitive salary, outstanding benefits and the potential for advancement through the use of creative abilities. 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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.
For further information, please review the Know Your Rights notice from the Department of Labor.

---