Data Warehouse & Integrations Architect

Crayola is an iconic company that develops art products and experiences for children, families, and educators. The Data Warehouse & Integrations Architect supports the development, execution, maintenance, and modernization of enterprise data warehouse and integration solutions, including data ingestion, transformation, validation, and pipeline operations. The role collaborates with senior engineers and leadership to ensure reliable, scalable, and well-documented global data delivery.

Responsibilities

• Develop and maintain ELT pipelines using established frameworks to support ingestion, transformation, and loading of enterprise data
• Execute data integration processes across platforms, including API-based, file-based, and system-to-system data movement patterns
• Support the ongoing operation of the global data warehouse environment by monitoring data pipelines, identifying failures, and resolving routine issues
• Perform data validation and reconciliation activities to ensure data accuracy, completeness, and consistency across staging, warehouse, and downstream systems
• Assist in implementing transformation logic aligned with defined dimensional models, schemas, and enterprise data structures
• Contribute to documentation of data pipelines, integration flows, and transformation logic to support knowledge transfer and operational resiliency
• Participate in testing activities including unit testing, regression validation, and support for release and deployment processes
• Support modernization and migration efforts by assisting in transitioning legacy integration processes to standardized ELT and cloud-based frameworks
• Collaborate with senior engineers and leadership to apply established standards related to metadata, naming conventions, error handling, and data quality controls
• Escalate issues related to data integrity, system dependencies, or performance that impact global data availability or reliability

Preferred

• Experience with Snowflake a strongly preferred
• Experience with **MS Fabric Lakehouse** a plus
• Familiarity with **Lakehouse** concepts and architectures is beneficial
• Snowflake
• MS Fabric Lakehouse
• Lakehouse Concepts
• Lakehouse Architecture

Benefits

• 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
• Hybrid work arrangement in Easton, PA
• This role is eligible to participate in an annual incentive plan as per plan guidelines

Company

• Children's art supplies, toys, and creative resources
• Easton, Pennsylvania, USA
• http://www.crayola.com/
• Founded in 1903
• 1001-5000 employees

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or Business Administration, **OR** 5+ years of relevant professional experience relevant to the requirements below
• Minimum 3 years of experience in data engineering, ETL/ELT development, or data warehousing
• Experience with integration platforms and tooling, including **API integrations**, platform integrations, and tools such as **Informatica ICDM** or comparable solutions
• Understanding of source systems and enterprise applications, including but not limited to **SAP**, and the associated extraction and integration considerations
• Comprehensive working knowledge of BI and analytics delivery tools; **Power BI** experience is required
• Strong business partnership, communication, facilitation, and presentation skills, with the ability to translate technical topics into user-friendly language
• Strong analytical, problem-solving, organizational, and prioritization skills, with the ability to lead multiple simultaneous efforts in a high-pressure environment
• Strong customer service orientation and the ability to collaborate effectively with internal and external stakeholders
• Proficiency with Microsoft Office Suite
• Must have excellent problem solving and analytical skills
• High initiative and ability to prioritize in a high-pressure environment
• Must be able to work on simultaneous projects
• Experience with Snowflake a strongly preferred
• Experience with **MS Fabric Lakehouse** a plus
• Familiarity with **Lakehouse** concepts and architectures is beneficial
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or Business Administration, **OR** 5+ years of relevant professional experience relevant to the requirements below.

Required skills

• API Integrations, Data Engineering, Data Warehousing, ETL/ELT Development, Informatica ICDM, Lakehouse Architecture, MS Fabric Lakehouse, Microsoft Office Suite, Power BI, SAP, Snowflake

Preferred skills

• Experience with **MS Fabric Lakehouse** a plus, Experience with Snowflake a strongly preferred

Experience

• 3+ years