Sr. Programmer Analyst, Easton, PA

GENERAL SUMMARY:

The Sr. Programmer Analysts will support Business Process Automation by coding new applications, integrating systems together or making beneficial adjustments to existing software programs to maximize their effectiveness. The primary function is to support efficient workflow and production by writing new applications, integrations and SQL code that creates and/or troubleshoots proper workflow sequencing within the manufacturing production life cycle. Also, serves as a technical advisor and project manager to other members of the organization on projects as needed. Possess an in-depth knowledge of a manufacturing environment and a sound understanding of business practices. Develops and executes detailed project plans.

PRINCIPAL DUTIES & RESPONSIBILITIES:

Sr. Programmer Systems Analyst will perform all the activities that support the development and maintenance of new applications and;

• Ability to extract manufacturing PLC data from SQL databases (SQL stored procedures) and display data on management front-end web-based dashboards, or business intelligence/analytic tools (such as PowerBI).
• Code programs, create code libraries, and run tests to determine software defects.
• Develop and maintain in-house developed applications.
• Write APIs between existing and new applications, both on-prem and SaaS based.
• Troubleshoot technical issues and identify modifications needed in existing applications to meet changing user requirements.
• Work as a Project Manager to evaluate business needs, create a plan on how best to meet.
  those needs and communicate a time frame for correction of issues and/or implementation of new processes.
• Troubleshoot technical issues and identify modifications needed in existing applications to meet changing user requirements.
• Arranges project requirements in programming sequence by analyzing requirements, preparing a workflow chart and diagram using knowledge of computer capabilities, subject matter, programming language, and logic.
• Enhance existing custom application performance by optimizing the SQL statements/procedures within the database which the application is built on.
• Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies.
• Identifies, develops and maintains the procedures that aid in system recovery in case of disaster.
• Works with IS Operations to ensure that systems are transferred to a production status once the new system has been implemented or an older system has been upgraded.
• Serve as back up to System Analyst and supports production operations by resolving incidents within their SLA.
• Performs other functions as assigned.
• Maintains computer systems and programming guidelines by writing and updating policies and procedures.
• In accordance with the NIST CSF and Hallmark Standards, ensure adherence to policies and processes to remain in compliance for maintenance, security continuous monitoring and recovery areas including Asset Management, Change Management, Incident Management, Problem Management, Vulnerability & Patch Management, Data Security, Disaster Recovery and Business Continuity.

JOB SPECIFICATIONS:

• Bachelor's degree in computer science from an accredited college or university program with 8+ years' manufacturing system experience in large systems design and implementation using relational database technology, advanced programming tools as well as experience in working with application users and technical staff in a team environment. Experience in developing Client/Server, and Web-Based applications.

OR

Associate's degree in Computer Science with 12+ years' manufacturing system experience in large systems design and implementation using relational database technology, advanced programming tools as well as experience in working with application users and technical staff in a team environment. Experience in developing Client/Server, and Web-Based applications.

• Strong knowledge of SQL. With the ability to write new, and troubleshoot, existing stored procedures.
• Ability to successfully develop in HTML, CSS, Javascript, .NET and front-end business intelligent/analytic tools.
• Ability to develop APIs using open restAPI scripting.
• Strong knowledge of web-based architectures, relational databases, database architecture and data loading and extraction practices.
• Strong organizational skills, the ability to perform under pressure and manage multiple priorities with competing demands for resources.
• Strong analytical, data processing and problem-solving skills.
• Proficiency in process formulation and improvement.
• Familiar with a variety of the IS field's best practices, concepts and procedures.
• Excellent interpersonal and communication skills (written, verbal and presentation).
• Knowledge of applications related to the manufacturing environment (Rockwell, Johnson Controls, Allen Bradley, etc. a plus).
• Some travel maybe required.

SCHEDULE:

Crayola is currently operating in a Hybrid work environment for its office employees. This requires non-manufacturing employees to work a mandatory 2days/week in the office during core work hours (Monday - Friday 8A-5P). The work location for this position is: Easton, PA 18044. This schedule could change in the future depending on internal and external factors.

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. Occasionally, the employee must be comfortable working in manufacturing areas where assembly lines, large machinery and loud noises are present.

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.