Data Migration Analyst - Saputo - Dallas, TX

JOB SUMMARY:
As part of Master Data Management team, this position is a key contributor to enable the organization to leverage data as an enterprise asset. This position oversees the execution of data migration activities for specific data domain. Activities include gathering functional requirements, producing technical specification, and firming up test and deployment plans. The Junior Technical Analyst is responsible for building extracts, transforming and construction of master data, and creating load processes or programs. These migration activities require working across multiple business areas to understand data usage and implications on business modules and third party systems. In the Saputo environment this is across divisions located in four major regions; Canada, USA, Australia, and Argentina. In this position, it will be important that the Analyst establish key relationships with process leads, technical leads, data producers, and data owners. This includes driving communication and managing activities with business and technical teams leading to a successful migration while continuing to support operations and MDM maintenance activities.

JOB DESCRIPTION:
Responsible assisting with data migration and governance lifecycle activities for data objects while supporting MDM operation activities. Maintains specifications and relevant documentations related to extraction, enrichment, transformation, and data loads. Work closely with functional process leads and key users in defining specifications, developing transformation tools and resolving errors. Responsible for data domain build, conversion and error corrections processes during the ETL load processes.This process includes understanding legacy sources and business processes to enable transformation. During the transformation process, the Analyst must oversee extract, data review, mapping, cleansing and construction activities. This process also requires identification and reporting data quality issues, such as uniqueness, integrity, accuracy, consistency, and completeness in a cost-effective and timely fashion. Once information is ready for deployment, the Junior Technical Analyst will assist with the planning, staging, deployment and post go-live support. This includes Mock conversions and testing. A key responsibility is to ensure that there are good test scripts, test sign-offs, and back-out plans;

Responsible for conducting business and technical interviews leading to both business and technical decisions. Responsible for documents coming from these interviews such as workflow, functional and technical specifications, and solid repeatable test plans;

Responsible for following change control and project planning best practices to deliver on scope, budget, and schedule. Ability to plan their work in a structured way, report on progress metrics according to a defined framework and use provided management tools. Able to identify and raise issues where decisions may be made to influence scope delivery, stay on schedule and on budget;

Responsible for status reporting to IT and MDM teams;

Responsible for sharing information and knowledge with co-workers, technical teams, and business teams to influence growth and continuous improvement. Serve as level three support for the MDM and business operation teams. Travel up to 30 percent;

Willing to share new Ideas, which can benefit Saputo. Determine and seek out new knowledge, techniques, and processes that could influence current processes and future improvements. Maintain personal network of professionals; internal and external to Saputo.

Job Requirements

Bachelor’s or Master’s Degree in Information Systems or equivalent work experience;

Certifications and extra training is a plus;

Bilingual (Spanish, French, and English) is a plus;

Two plus year experience with data transformation and System integration showing advance knowledge of data exchange, validation, and loading techniques using tools such as iDocs, EDI, or other data exchange tools. This experience must have demonstrated a desire to use structure and reusable designs;

One plus years experienced data analysis, profiling, cleansing, and load reconciliation, which include conversions. A plus would be experience with data modeling, replication, web-services, and custom models. Experience operating in a complex, fast-paced, and knowledge sharing environment;

Have demonstrated Order to Cash, Plan to Produce, Procure to Pay, and financial knowledge;

Ability to understand and respect different cultural requirements;

A plus is experience serving on cross sectional teams showing positive results for your organization;

Migration tool experience such as in-house design processes or third party processes. Experience with FTP, SQL, programming languages, and MS office products. A plus would be experience using MS VBA or SAP Roadrunner, or Winshuttle;

Integration experience with an ERP system;

Experience with functional requirement gathering and documentation oriented towards implementing new systems and onboarding from other legacy systems;

Strong MS Office; Visio, and MS Project is desired; Experience using VBA is a plus;

Experience using multiple database adapters for databases such as DB2, MS Access, SQL, and Oracle. Knowledge of SAP data model is a plus;

Experience using FTP, EDI, Trusted Link, and connecting to AS2 servers is a plus;

Experience processing information into or from multiple formats such as ASCII, excel, comma delimited, or other flat file;

Experience with MDM tools or processes is a plus.

Exemption Type

Exempt

Saputo Cheese USA Inc. and Saputo Dairy Foods USA, LLC are equal opportunity employers. All qualified applicants will receive consideration for employment without regard to race, creed, color, national origin, ethnicity, ancestry, age, religion, disability, sex, pregnancy, sexual orientation, or veteran status. If you’d like more information on your EEO rights under law, please contact the Company Human Resources department or visit www.EEOC.gov .