Analyst, Data Quality

at  SYSCO FOOD SERVICES

ANALYST, DATA QUALITY

Reports To
Manager, Data Governance
Location
Remote
Type
Full time, Salary
Closing Date
April 25th, 2024
Salary Range/
Hourly Rate
$53,363 -$110,652

QUALIFICATIONS/SKILLS/JOB REQUIREMENTS (ABOUT YOU):

• A minimum of three (3+) years of job-related experience in Data Governance/Master Data Management is required.
• Minimum two (2+) years job related experience in Business Analysis.
• Professional experience working with Tableau is required.
• Experience with data governance design, documentation, and implementation.
• Experience working with designing data relationship diagrams and business data or process models.
• Work experience on Data Governance projects is an asset.
• Experience with working with Metadata management in a structured platform such as Alation or unstructured as SharePoint
• Post Secondary Degree or Diploma in Finance, Business or Technology
• Understand concepts of relational database, experience with extracting data from various sources and perform analytical tasks.
• Understanding of VBA (or other coding tool) and experience with DB2 system and Microsoft SQL Server is an asset.
• Exposure to Informatica Data quality (or any other data quality tool) is an asset.
• Must be extremely detail and deadline oriented, a fast learner, and be able to multitask.
• Advanced proficiency in Tableau, Microsoft Office tools such as Word, Excel, and Outlook as well as Cognos Impromptu and Powerplay (SPAR), AS400, and Internet applications.
• Knowledge of best practices metadata and data quality initiatives, policy, and techniques.
• Proven ability to work with large amounts of data and perform data cleansing
  Internal candidates apply via the Career Centre on your HR Portal / ADP Workforce Now.
  External candidates submit cover letter & resume via www.sysco.ca/careers

ROLE:

The purpose of this role is to analyze, cleanse and standardize existing data across our Canadian Operating companies and tie in data from various IT systems within our organization. The incumbent will also work with BT to model, test and implement new software systems and existing software enhancements to help with the standardizing efforts and train all field users. In addition, the role will work with cross functional teams to gather business metadata and data quality metrics requirements and lead the small business projects.

ROLE RESPONSIBILITIES:

• Work with our various data query tools and databases to extract data and perform analysis to understand current data set up and develop strategies to standardize.
• Understand the data and make recommendations throughout project design and implementation to ensure data integrity.
• Closely work with internal business customers and BT to design, test and implement the data solution to meet various project demands and then train the end users.
• Review data and work with subject matter experts within the company as well as our Vendor community to determine proper master data set up.
• Develop, maintain, and automate data reports using reporting tool (such as IBM Cognos, SQL, Tableau, and Excel & Visual Basic).
• Perform data cleansing on large datasets with focus on data quality.
• Work with IT to create Master Data Management environment and populate with standardized data.
• Work with Operating Companies across Canada to implement new master data within Operating Company environments and assess overall progress via reporting
• Develop automated reports and Excel Macro tools for end users.
• Develop KPIs for data quality and conduct data governance maturity assessments.
• Work with various subject matter experts to gather business metadata and data quality metrics requirements.
• Understand the data and make recommendations throughout project design and implementation to ensure data integrity.
• Assist in designing and developing data quality dashboards in both Tableau and Excel
• Help maintain business glossary in Alation
• Complies with Sysco’s Food Safety Policy and procedures to ensure food safety, quality and legality requirements are met.
• Is willing to work safely with minimal environmental impact and understands the importance of reporting all hazards, incidents, and environmental spills immediately to their Supervisor.
• Understands that they play an integral role in their own safety and that of their colleagues and is willing to speak out when hazards are present.
• Perform other duties as assigned.