Data Integration Specialist, Full-Time, Forks, PA

GENERAL SUMMARY:

This position is a technical role that has the responsibility for designing and developing data integration solutions in support of our data warehouse environment and inter-system interfaces. The individual will collaborate with cross-functional teams to understand data requirements and implement data integration solution to best satisfy the requirements.

PRINCIPAL DUTIES & RESPONSIBILITIES

• Develop and maintain ETL (Extract, Transform, Load) processes to ensure seamless data integration from various sources into our data warehouse using Informatica IDMC
• Ensure data quality and accuracy by implementing validation checks and error handling mechanisms.
• Understand and perform basic DBA functions in Snowflake and MS SQLServer
• Strong familiarity with SAP and SAP data in a manufacturing setting.
• Design and develop the ETL process, including data analysis and testing.
• Design and develop the information access and delivery effort for the data warehouse.
• Participate in the design and development of the data warehouse, as well as creation of user and SOP documentation.
• Monitor system performance, implement changes to optimize performance.
• Experience with IDMC Catalog and Data Governance a plus.

JOB SPECIFICATIONS:

• Bachelor's degree in computer science, information systems field with 5+ years of work experience.
• Strong technical skills with Informatica ICDM including but not limited to
• Flat file Source and Target transformations, Expression transformations, Lookup transformations, Filter transformations, Joiner transformations, Router transformations.
• Intelligent Structure Model
• Java transformations
• Source Control experience
• MS PowerShell scripting
• SQL Server, Oracle, Snowflake database connections
• Cloud Application Integration
• Cloud B2B
• Cloud Mass Ingestion
• SAP HANA connector
• Google Analytics connector
• REST V2/V3 connector
• Understand and perform basic Snowflake DBA functionality including but not limited to
• Stored Procedures,
• JavaScript
• User Defined Functions
• Stages
• Data Pipelines
• Strong data modeling skills (normalized and multidimensional).
• Understanding of business data and its various sources including but not limited to SAP, both ECC and S4/Hana
• 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:

This position requires the candidate to be on-site in the Forks offices a minimum of 2 days per week.

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

Diversity & Inclusion at Crayola
We 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.aspx

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

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.