Data Governance Analyst

Responsibilities

• Identify and register data elements, critical data elements (CDEs), and associated source/target systems
• Support the documentation and validation of Data Flow Diagrams and Data Lineage or Source-To-Target Mapping (STM)
• Define business and technical Data Quality rules for CDEs
• Execute data profiling, quality assessments, root cause analysis, investigation, and remediation
• Conduct various data testing including Quality Assurance Testing (QAT), Business Acceptance Testing (BAT), and Post Implementation Validation (PIV)
• Provide technical expertise in designing and implementing data pipelines
• Create dashboards to share data insights and build data features for governance, modeling, and reporting
• Maintain data-related documentation, including data lineage and ETL processes

Requirements

• University degree in a STEM discipline (Computer Science, Engineering, Mathematics), Economics, or Finance
• 2+ years of experience in cleaning, transforming, and visualizing data sets from various formats (e.g., XML, JSON, flat files)
• Advanced knowledge of SQL and hands-on programming experience
• Experience with visualization tools such as Power BI or Tableau
• Experience with statistical analysis and machine learning using R, Matlab, or Python
• Familiarity with data governance and management concepts (CDEs, Data Lineage, Metadata, etc.)
• Experience working with agile methodologies

Preferred Qualifications

• Familiarity with Collibra or similar data governance tools

About the Company

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families, and their communities achieve success through a broad range of advice, products, and services, including personal and commercial banking, wealth management, and capital markets.