All Manitoba Liquor & Lotteries employees may apply. Manitoba Liquor and Lotteries is committed to Diversity, Equity and Inclusion. We strive to hire a workforce that reflects the community we serve. Employment equity will be considered therefore applicants who identify as women, Indigenous people, members of racialized groups, and persons with a disability are encouraged to apply.

If you require an accommodation at any time during the recruitment process, please let us know how we can meet your needs.

Job Purpose

The Data Quality Analyst is responsible to ensure the data loaded into the enterprise data warehouse is complete, reliable and accurate and will meet the informational requirements of the organization. The incumbent works closely with the Business and with development teams to understand the relationships between business process management, data acquisition and data use. The incumbent understands data quality concepts, designs and constructs effective data validation processes to identify data quality problems, and is able to suggest solutions to solve data quality problems. The incumbent mentors and coaches others on their role in data quality, and advocates the role and importance of data quality in the organization.

Job Responsibilities

• Identify, assess, fix, document and communicate potential quality issues in the way data is collected, stored, processed or used.
• Review and validate data loaded into the data warehouse for accuracy, proactively identifying any data quality issues.
• Recommend, design, implement and monitor data quality standards and procedures for use in the data production process.
• Work with Business users to resolve data quality problems, using techniques such as root cause analysis.
• Explain assumptions and methodologies and simplify complex concepts for non-technical users.
• Exhibit and establish a culture of quality solution design and development.
• Recommend maintenance enhancements to data acquisition processes to improve accuracy of data warehouse data.
• Make recommendations to operational support for enhancements to systems of record to improve accuracy of operational data.
• Review referential integrity of data warehouse data.
• Review historical integrity of data warehouse data.
• Manage the data warehouse data dictionary and Metadata.
• Perform data profiling to determine if data can be used for other purposes.
• Develop and report on appropriate data quality metrics.
• Create and execute data validation plans, scripts, cases and scenarios that will ensure the veracity of the data in the data warehouse.
• Prepare estimates of time and resources required to perform data validation on development projects.
• Accurately report progress and status on assigned projects.
• Produce reports and documentation for data validation efforts, results, activities, logging and tracking.
• Maintain test defect logs and manage defects until resolved.
• Maintain awareness of current and developing trends in Data Quality Management including best practices, tools and techniques.
• Research and evaluate data quality tools and frameworks to justify recommendations and to support technology solution purchasing efforts.
• Establish the practices and standards used in the Data Quality practice.
• Ensure and maintain an enterprise view of Data Quality.
• Other duties as assigned.

Primary Qualifications

• Completion of a recognized degree or diploma program in an IT related discipline, or an equivalent combination of education, certification, and experience.
• A minimum of six years of experience in software development or quality assurance in heavy data environments.
• Demonstrated knowledge of data modeling, database design, OLTP, OLAP, and Big Data environments, structured and unstructured data processing, ETL processes and business intelligence tools and concepts.
• Advanced SQL skills required.
• Ability to work with a high degree of accuracy and attention to detail.
• Strong critical thinking, communication and interpersonal skills.
• Post-secondary education in business, commerce or a related discipline is an asset.
• Experience working in an agile development environment is an asset.
• Knowledge of TQM, QA practices, Six Sigma and process improvement as it relates to data quality are assets.
• Upgrading is required to keep up-to-date on new technology and changes in information technology.
• The core competencies for this position include achieving quality results, adaptability/managing change, communication, customer service, decision making and problem solving, integrity and building trust, teamwork and cooperation and valuing diversity. These competencies are deemed important for the success of the position and organization.

Secondary Qualifications

• Previous experience in the gaming, retail and/or distribution industries, ERP systems, financial or human resources functions are assets.
• Previous experience with Cognos BI tools and Teradata are assets.
• Bilingual French/English language skills are an asset.

***Testing may form part of the screening/selection process. Employment Equity will be a factor in the recruitment process. Circumstances may arise where the bulletin may need to be withdrawn or the number of positions may need to be increased depending on the Collective Agreement.

We thank all interested applicants, however, only those selected for interviews will be contacted.

A Great Place to Work! Enjoy fantastic benefits with our Total Rewards package

Work/Life Balance and Wellness

• Discretionary Time: Up to 10 paid discretionary leave days per year, depending on bargaining unit. Employees can carry forward discretionary leave days each year for a total of up to 50 days.
• Hybrid Work Model for Eligible Positions: Remote/Office work for eligible positions.
• Flex Time: Flexible shifts and work hours for eligible positions.
• Maternity and Parental Leave: Top-up of E.I. maternity leave benefits to 93% of employee’s basic earnings for 17 weeks.
• Fitness Allowance Reimbursement, depending on bargaining unit: Up to $250 per year that can be used to cover gym memberships, fitness equipment, and more.
• Computer Purchase /Fitness Purchase Program: Interest free loans for employees purchasing computer equipment to increase computer literacy, learning, and professional growth, or to purchase fitness equipment for personal health and wellness.
• Diversity and Inclusion: Our Diversity, Equity and Inclusion Committee is made up of employees from across the organization who are passionate about bringing diversity and inclusion to life.
• The Together Project: At Liquor & Lotteries, Caring is part of our corporate culture - we care for each other, our partners, and our community The Together Project represents the charitable efforts of the corporation and its employees working together to enrich the lives of Manitobans. Employee charitable activities are eligible for reward benefits.

Vacation

• Accrue up to 10 paid vacation days per year during the first 2 years of employment.
• Accrue 15 paid vacation days per year after 3 years of employment.
• Accrue 20 paid vacation days per year after 5 years of employment.
• Accrue 25 paid vacation days per year after 9 years of employment.
• Accrue 30 paid vacation days per year after 19 years of employment.

Retirement Savings Plan

• Defined Benefit Pension Plan: Guaranteed lifelong monthly payment at retirement provides great security for employee’s long-term strategy.
• Voluntary Group Registered Retirement Savings Plan

Health Insurance and Benefits

• Customize your Plan: Choose from a variety of options to best fit your needs. Includes coverage for prescription drugs, vision, dental, ambulance, extended health options and more for you and your eligible dependents. Health Spending Account: Depending on the option you choose, you may receive up to $1,750 towards eligible medical or dental expenses.

Flex Credit: Depending on the bargaining unit and status, you may be provided with a Flex Credit amount to purchase some or all of Group Life Insurance, Accidental Death and Disablement Insurance & Dependent Life Insurance.

World-wide Travel Health Benefits

Employee & Family Assistance Program (EFAP): Free professional wellness support for employees and their immediate family member

Training and Development

• Educational Assistance: Tuition reimbursement for eligible employees.
• Training: Variety of courses and programs to support skill and professional development.
• Career progression: Internal job posting system that provides opportunities for a variety of career paths.
• Apprenticeship and skilled trade training: Programs offered in partnership with educational institutions such as RRC Polytech, the University of Winnipeg, and the University of Manitoba.

Discounts and Rewards

• Employee Rewards & Recognition Program: Points-based program recognizing employees for earned and nominated achievements such as long-service, going above and beyond, and community volunteer work.
• Discounts: Employees receive exclusive discounts from a variety of retailers, entertainment venues, and service providers.