Specialist data Analyst
Canadian National Railway
Montréal, QC
ABOUT IT AT CN

At CN Rail, we work together to move our company—and our country—forward. We invest more than $100 million every year on projects and infrastructure. We harness the power of information to guide our decisions, and the Enterprise Architecture team is a critical part of the engine that keeps us in motion.

CN’s Enterprise Architecture Team is transforming our organization and is focused on building the future of rail technology. We are looking for the brightest, collaborative and most innovative minds in the industry to help us achieve our goals. If you are passionate about Artificial Intelligence, Deep Learning, Industrial Internet of Things, big data platforms and enjoy solving complex problems, CN is looking for you.

Want to know more about the Enterprise Architecture team, and the meaningful work we do in Information & Technology?

ABOUT THE ROLE

As part of the Enterprise Architecture organization, the Specialist, Data Quality will be responsible for translating business strategy into a fit for purpose business and technology architecture that ensures stable, reliable, resilient and efficient service delivery that meet customer needs and enable innovation. Further, he/she will use and drive best-in-class Enterprise Architecture principles including a common service-oriented architecture, consistent technical frameworks and guidance, and a loosely coupled agile architecture across the organization.

The discipline of data quality management ensures that data is "fit for purpose" in the context of existing business operations, analytics and digital business scenarios. The purpose of this role is to be responsible for the implementation of data quality at CN in the context of a project or support to a business area.

RESPONSIBILITIES

Data Quality Management at CN involves the tasks for data discovery, data improvement and data quality monitoring using the best tools in the market. In this role your will execute the following activities:

Profile data sets making use of data visualization, quality and SQL tools
Identify and document data quality issues
Prepare a data quality assessment with recommendations for high quality data
Work together with data governance to elaborate a data readiness assessment
Work together with information architects to elaborate source-target data mappings and data migration strategies
Work together with solution architects to analyze and document data flows and integration specifications
Design of data quality rules using as inputs data defects, business rules and data governance policies
Maintain the enterprise data quality rules catalogue
Work together with business leads/users to identify and validate data quality requirements are complete, consistent and achievable; and ensure decisions are documented
Work together with data governance to define the enforcement of data quality rules within the organization
Work together with internal and external software delivery teams to implement and deploy DQR
Design of data quality metrics and scorecards
Design and build data quality monitoring dashboards
Participate in data defects root-cause analysis with business users and data governance
Coordinate with the project team and members of other data practices (IA, DG, BI) to clarify the tasks, scope and deliverables

REQUIREMENTS

Bachelor's degree in computer science, information systems or a related study (such as library science), or equivalent related project experience
3-5 years understanding, designing and implementing data quality standards that enable well-integrated transactional, collaborative and analytical systems
Experience with various data profiling and data quality assessment techniques
Experience with various aspects of Information Management at the enterprise level (data governance, data quality, master data management, information life cycle, etc.)
5-7 of Experience with business intelligence, data warehousing, relational database and other data structures
Experience with TOAD or similar database management tool
Experience with Qlik View or similar data visualization tool
Experience with Informatica Data Quality Analyst or similar data profiling tool

CN is an employment equity employer and we encourage all qualified candidates to apply. We thank all applicants for their interest, however, only candidates under consideration will be contacted. Please monitor your email on a regular basis, as communication is primarily made through email.