IT Systems Analyst

Open Date: 3/1/2017 Close Date: 3/10/2017

Organization: Information Technology

Location: Ogden, Utah

An Opening Exists For: IT Systems Analyst

This Position Reports Directly To: Director of IT

HR Contact: Ryan Vaughn

Hiring Manager: Todd Christensen

The IT Systems Analyst proactively participates in designing, developing and evolving high quality, extensible Business Intelligence (BI) solutions and interpretation of results using a variety of techniques ranging from simple data aggregation to complex data mining. This individual will be responsible for creating complex reporting and analytics processes to support Honeyville’s analytical needs interfacing with both internal and external clients. In addition, they will perform all aspects of analysis and report development ranging from requirement gathering to creating advanced dashboards while demonstrating the ability to deliver results in a dynamic environment. Experience with E-Commerce and web development also a plus. This position reports directly to the Director of IT.

Core Responsibilities:

• Develops and implements complex reporting and analytical processes regarding MAS100 and other inter-related back-office systems such as Accellos Warehouse Management Systems (WMS), EDI by using a variety of techniques ranging from simple data aggregation to complex data mining.
• Works with clients, project and business leaders to identify analytical requirements to deliver high quality BI solutions and analyses and takes ownership for data quality, report quality and customer satisfaction.
• Performs unit and user acceptance testing of reporting modules, analyzes test results, and corrects problems.
• Participate in first level of production support activities and resolves escalated support issues.
• Generates new code and corrects, converts, and/or modifies existing code to meet specifications.
• Communicates regular progress reports and provides input to regarding annual goals and training plans.
• Actively supports colleagues by sharing information about the department, business unit and organization.
• Maintains knowledge of current Business Intelligence industry trends and organizations by attending appropriate training seminars on business unit, computer applications, and additional knowledge-based opportunities as necessary.
• Contributes to standards, process creation, process automation, process improvement projects through data analytics, and statistical analysis.
• Performs other related duties as assigned per the IT Director.

Qualifications:

• 5+ years’ experience with a relational database and BI report development preferably with Sage100, EDI standards, WMS, Magento, SQL Server, MS Access, Crystal Reports, and SSRS.
• Expert in designing and developing Data Source Views, Dimensions, Hierarchies, Cubes and Reports.
• Clear and concise understanding of data movement (ETL), Business Intelligence and industry trends.
• Create ETL processes and development of charts and reports for reporting initiatives.
• Understanding of Business Intelligence Industry and trends
• Must be a team player with effective interpersonal, written and verbal communication skills to interact professionally with internal and external parties.
• Understanding of query driven applications and reporting, and logical and physical data models.
• Ability to work independently or in a team environment
• Strong creative thinking, problem solving and analytical skills.
• High commitment to excellent service levels and satisfaction with partners.
• Strong organizational skills with the ability to multi-task are necessary.
• Detail-oriented outlook coupled with ability to manage time effectively, plan ahead and meet deadlines.
• Good business writing and presentation skills.

Education Requirements:

• 3 years’ experience with data warehousing and SQL preferred.
• 3+ years’ experience with SQL Server, Sage MAS100, EDI import/exports, and other BI tools or statistical programming experience highly preferred.
• Strong understanding of data movement (ETL), Business Intelligence and industry trends.

At Honeyville, Inc., career development is a shared responsibility in which all employees are encouraged to develop, improve, and enhance their skills and professional growth to support our business objectives.

rev. date- 3/1/2017

Job Type: Full-time

Required education:

• Master’s

Required experience:

• SQL Server: 3 years
• relational database: 5 years
• warehousing: 3 years