Reference #: DATAW003612Description

Data Warehouse / Business Intelligence Architect, Full-TimeGENERAL SUMMARY:Senior technical resource responsible for the overall architecture of the BI environment.  Role includes designing the technical architecture and defining of best practices of the data warehouse environment as well as defining the data architecture of the BI reporting tool.  This role is responsible for leading development projects from inception through delivery.PRINCIPAL DUTIES RESPONSIBILITIES: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.Perform basic Snowflake DBA functionality (Create tables, indexes, stored procedures)Experience in Informatica ICDMPower BI experience a plusLakeHouse experience a plusLeads the activities of the data warehouse team members in the configuration and auditing of the data warehouse to ensure quality control of data including balancing with Corporate financial results.Serves as the project lead for BI initiatives and can execute all tasks involved including the creation of BI reports/dashboards.Work closely with business partners to define key business drivers.Work closely with senior management and technical design teams in prioritizing new BI requirements.Define Metadata standards for the data warehouse.Understanding of source systems, particularly SAP to facilitate extraction of data.Design and direct the information access and delivery effort for the data warehouse.Involved in the selection of technical solutions for business needsJOB 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 experienceExperience in leading multiple successful enterprise data warehousing efforts.Expertise in data warehousing technologies (e.g. ETL, ODS, DBMS (Database Management Systems), BI)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 business and communication skills.Ability to present ideas in user-friendly language.Maintain a high level of customer service to both internal and external clients.Must exhibit a proficiency in using 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.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.WHY CRAYOLA?Kid Inspired CultureFree Admission to Crayola Experience for EmployeesCommunity Volunteerism OpportunitiesAnnual Bonus Potential for all Full-Time EmployeesCompany Matched 401k Employee Value Sharing PlanComprehensive Healthcare Benefits for Eligible EmployeesEducation Assistance ProgramWellness ProgramsEmployee Resource GroupsGenerous Product Discounts Onsite OnlineCompany Sponsored Employee EventsDiscounts on a wide variety of products and services - automotive, electronics, fitness, travel and entertainmentDiversity Inclusion at CrayolaWe will cultivate diversity and create a culture of inclusion for our collective brands - one that grows through sustained action, demonstrates care for every life experience, inspires new products and content, and builds a sense of belonging in which every employee is able to be their very best. Learn more about Crayola's Diversity and Inclusion strategy: https://www.crayola.com/about-us/diversity-and-inclusion.aspxGreen 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.aspxWe 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

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Crayola is an equal opportunity employer. All qualified applicants will be considered for employment without regard to race, religious creed, color, sex, pregnancy, sexual orientation, gender identity, genetics, age, national origin, ancestry, physical or mental disabilities, use of a guide or support animal for a disability, a relationship to a person with a disability, veteran status, having a GED (rather than a high school diploma), or any other legally-protected status.