Data Analyst

Glen Mills, Pennsylvania
Information Technology
07-07-2019
Glen Mills, PA
60,000.00 
55,000.00 
Full Time
First Shift

Join our winning team!

Rapidly growing Golden Malted® is hiring an experienced Data Analyst at our state of the art Glen Mills, PA facility. This is a full-time exempt position. Benefits include PTO, medical, dental, life and 401k plan.

We are the largest supplier of waffle mix in the United States for the best hotels, universities, restaurants and theme parks. Golden Malted® Waffles are also enjoyed throughout the world. Our waffles are distributed to several countries including Australia, Canada, England, Germany, Greece, New Zealand, South Africa and Sweden.

The Data Analyst monitors the error logs, backup & restore processes, user administration, and report subscriptions. Identifies performance bottlenecks and works with other IT staff members as well as external vendors to resolve issued and implement solutions. Designs script and program to perform specific database functions and to analyze and maintain data. The Data Analyst also maintains the Business Intelligence (BI) infrastructure.      

Essential Functions:

  • Provide backup in monitoring the production ETL, CRM and ERP systems. 
  • Participate in the creation of standards and architecture design of the databases. 
  • Administer incomplete/duplicate/errored CRM invoices, returns and payments for both New Carbon and Heartland companies. 
  • Design, develop and deploy queries, stored procedures, data validation and SSRS reports based on defined business requirements. 
  • Maintain equipment statement and usage details of AT&T and Verizon in database. 
  • Design and test ETL process for data integration. 
  • Support any weekend maintenance and support activities. 
  • Perform other work-related duties as assigned.   

Requirements:

Experience/Education

  • Bachelor’s degree or equivalent combination of education and experience. 
  • Degree in Information Technology or Computer Science preferred. 
  • 2 years’ experience in the relational database systems (i.e., SQL Server, Oracle, DB2). 
  • 2 years’ experience in the underlying operating system (i.e. Microsoft Windows, LINUX). 
  • 1 year experience in ETL concepts, process and tools. 

Skills

  • Working knowledge of relational database concepts and operation (SQL Server preferred). 
  • Working knowledge of RDBMS queries and demonstrated skills in basic to intermediate SQL. 
  • Exposure to performance tuning of SQL Queries. 
  • Exposure to CRM and ERP systems such as Microsoft Dynamics CRM and GP preferred. 
  • Experience in report writing tools such as SSRS, Crystal Reports, and Management Reporter. 
  • Strong written and verbal communication skills.  
  • Excellent organizational skills. 
  • Ability to work in a team environment consisting of technology and business Professionals. 
  • Ability to handle confidential, proprietary and security system issues. 
  • Ability to define problems collects data, establish facts and draw valid conclusions. 

Ability to pass a pre-employment drug screen.

Golden Malted® is the world’s largest supplier of waffle mix and irons. We offer a complete suite of products with our waffle program including customer-friendly batter and syrup dispensers, syrups, fruit toppings, and a variety of waffle and pancake mixes. Our waffles are distributed in over 60 countries throughout the world. Golden Malted is on the cutting edge of technology having recently launched a proprietary sales force automation application and a new online portal designed for customers to easily manage their accounts and make purchases.  

Golden Malted® will continue to recruit the best talent and provide an environment in which our employees can succeed.