Analyst, Data

Borden Ladner Gervais LLP (BLG)•Vancouver, BC

About The Position

The Analyst, Data Management will report to the Senior Manager, Data Management and will contribute to the development and execution of plans, policies, and practices that control, protect, deliver and enhance the value of BLG’s data and information assets. This role will be responsible for assisting in the implementation of enterprise data strategy, initiation and successful execution of strategic data management projects and continuous improvement initiatives.

Requirements

Experience implementing best practices, adoption methodologies and standards with regards to Data Analytics, Data Governance, Data Structure, Data Architecture, and Data Security.
Knowledgeable in data profiling, root cause analysis, and quality improvement.
Well versed in the following data domains: Master/Reference Data, Operational Data, Analytical Data, Unstructured Data, and Metadata.
Solid understanding of transactional and information systems, data warehouses, data marts, MDM methodologies and life cycles.
Hands-on experience with data analysis, quality, cleaning and extraction / validation tools.
Strong proficiency with SQL-based languages.
Ability to write and troubleshoot complex SQL queries.
Hands-on experience with implementation of a data catalog/dictionary.
Minimum 2 years of experience in Data Management design principles, concepts and implementing data-centric solutions.
Minimum 2 years of experience with BI methodology and technologies.
Ability to translate user requirements into technical specifications and systems.
Understanding the IT architecture discipline, processes, concepts, and best practices.

Nice To Haves

Knowledge of Microsoft Fabric, Python notebooks, Data Pipeline, Data Factory is an asset.
Knowledge of DAMA framework is an asset.
Knowledge of Reporting tools like SSRS, Power BI is an asset.
Knowledge of Informatica suite of tools is an asset.

Responsibilities

Maintaining data definitions, establishing data quality standards, monitoring compliance to those standards, improving data quality, and assisting in the development of master/reference data and business intelligence/analytical solutions.
Assisting in the implementation of a data warehouse platform using Microsoft Fabric, with a focus on centralization and the protection of sensitive data through creation of appropriate organization policies, standards, principles, governance metrics, processes, related tools and data architecture.
Working with diverse stakeholders/data owners to understand current and future data needs and assisting with the development of roadmaps (tactical and strategic).
Assisting with implementing a data management and governance framework aligned with BLG’s business objectives.
Assisting with the implementation of data catalog solution, to hold firm-wide technical metadata and data glossary.
Assisting with historical data quality/cleanup initiatives and developing rules to validate the data across different enterprise systems.
Working with sponsors and stakeholders to implement processes, policies, firm-wide business data definitions, data quality rules, domains, validation and resolution policies and methods that will support a successful data management program.
Implementing master/reference data management standards, enforcing data governance procedures and ensuring data integrity across multiple platforms to ensure proper use of data.
Establishing monitoring and reporting processes to ensure high standards of data quality and conformance with data policies, procedures and standards.
Developing indicators of performance, quality metrics and ensuring compliance with data related policies, standards, roles and responsibilities.
Developing & maintaining an inventory of the enterprise data sources, including authoritative systems and owners.
Providing recommendations on the development of data management policies, procedures and standards to ensure best practices of data management.
Assisting with the formulation of new guidance and standards.
Analyzing business processes and identifying data and information requirements (i.e. what information the business process requires, produces, collects and stores; who needs access to it; for what purpose and for how long).
Recommending improvements in business processes as appropriate.
Ensuring compliance with roles and responsibilities related to data governance and ensuring clear data ownership and stewardship of the BLGs data assets.
Participating in Data Governance Council meetings, comprising of Data Owners, communicating decisions, plans, goals and strategies related to enterprise data.
Coordinating with data stewards and data owners across the enterprise to address data quality issues.
Collaborating with centralized analytics team to deliver business intelligence solutions.
Maintaining best practice guidelines and standards for data, metadata, data modeling, and management.
Investigating tools and technologies to assist with data management and dissemination, such as data warehouse and analytics tools, data integration tools, data quality and profiling tools, outlining risks, costs, benefits, and capabilities.
Responsible for maintaining and enhancing the data quality scorecards.