Data Warehouse & Integrations Architect

General Summary

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.

Principal Duties & 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
• Affiliate 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

Job Specifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or Business Administration, OR 5+ years of relevant professional experience
• 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
• Experience with Snowflake a strongly preferred
• Experience with MS Fabric Lakehouse a plus
• 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
• Familiarity with Lakehouse concepts and architectures is beneficial
• 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

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.

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

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.