Job Purpose

The Data Analyst will be a key member of the Azelis Information Technology team reporting directly to Director of ERP. This position will collaborate with colleagues in standardizing and normalizing master data across the organization in preparation for the implementation of a single, global ERP solution. The position is also expected to contribute to the organization's business intelligence capabilities by performing system analysis, design, and programming. Specifically, she/he will be charged with determining how our data systems will provide the information required to make effective management decisions and creating advanced queries and reports using Microsoft SQL and related technologies.

Principle Accountabilities/Responsibilities/Tasks

• Design, create, maintain, deploy, and manage SSIS packages for internal business teams and our customers.
• Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Develop reports using Microsoft Reporting Services (SSRS) from a variety of data sources
• Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.
• Formulate and document ETL process design based on business requirements and system specification including source to target mapping and transformations.
• In collaboration with subject matter experts and data stewards, define and implement data standards, policies, controls, and programs to ensure that enterprise master data is accurate, standardized, complete, secure, and reliable.
• Work closely with business and IT stakeholders to standardize enterprise master data (e.g, customers, suppliers, products, etc.) across all systems in preparation for migration to new, global ERP and CRM solution(s).
• Identify areas for data quality improvements and help to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design enhancements.
• Work with members of the IT team in the development, implementation, and operation of business intelligence and reporting solutions that support business requirements, follow agreed standards, and maximize the quality and reliability of the reported information.
• Monitor nightly automated processes to ensure the timely and accurate delivery of automated reports.
• Work with business and IT colleagues in the development of basic queries and reports (using Microsoft SQL)
• Produce and maintain high quality documentation that supports the needs of other project functions such as: architecture, analysis & data modeling, testing, and support.

Required Skills / Qualifications

• Must be able to perform duties with low supervision.
• Minimum of 3 years experience
• Must possess a strong attention to detail.
• Ability to manage multiple priorities, and assess and adjust quickly to changing priorities.
• Advanced proficiency with Microsoft Excel is a must.
• Experience working with relational databases.
• Proficient in Microsoft tools: SQL Server 2012 and higher, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and T-SQL;
• Intermediate experience in other areas of SQL Server development technology including stored procedures, functions and triggers.
• Experience in data cleansing, data management, and data migration activities is strongly preferred.
• Fluency in English (written and oral) required. Must be able to discuss both functional and technical concepts with team members, business colleagues, and external stakeholders.
• Bachelor's degree in Computer Sciences or related field is preferable. Equivalent combination of experience, education and training will be considered.
• Knowledge of D365 is a plus