Data Warehouse BI Architect

at  Crayola LLC

GENERAL 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.

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

• 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 ICDM
• Power BI experience a plus
• LakeHouse experience a plus
• Leads 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 needs