Data Governance Analyst

Job Description Summary

The Data Governance Analyst will support and participate in data governance efforts across the Business Unit areas to ensure that enterprise data used for reporting, modeling, key business decisions and executing RJF end-to-end business processes is ‘fit for purpose’. This position will report to the Director of Data Governance Adoption in the Chief Administration Office and support RJF as it builds its capabilities for enterprise data governance and data management.

The Data Governance Analyst is responsible for supporting enterprise efforts underway to identify and document all business and technical metadata required for sourced data in various Enterprise use cases outlined above. In addition, the Data Governance Analyst will support the documentation of end-to-end data lineage requirements for use cases, tracing data flows from source to final consumption. Additionally, the role involves performing reverse analysis of existing use cases, mapping consumption points back to their originating sources.

Responsibilities include identifying data issues and gaps, providing actionable recommendations, and collaborating closely with Technology teams and subject matter experts across Regulatory Reporting, Compliance, Risk, and Operations to promote and advance data governance adoption.

• Fully understand various data and reporting flows across the Regulatory Reporting areas to identify data sourcing and full lineage to consumption.
• Support the identification and documentation efforts for all Enterprise data sets and use cases.
• Analyze and document end-to-end use case data flows from target to source into a Business Glossary document, identifying and documenting the data lineage and transformations, and data quality rules that are required, as well as improvement opportunities throughout the data flow.
• Use Ab Initio tool to load data catalogs, required business terms / definitions, link business to technical data elements, categorizing criticality of each data element, and working with IT to complete the data lineage from data sources to reports.
• Correspond and execute deliverables aligned with principles, policies, frameworks and procedures laid at the firm or business unit or function levels as per the guidance from the Chief Administrative Officer heading up the Business Controls & Risk function.
• Collaborate with appropriate business stakeholders/remediation owners to implement data quality controls, help remediate data gap issues and improve processes to prevent future data concerns.
• Track, resolve and elevate issues for own projects while keeping relevant stakeholders informed.
• Maintain project deliverables including reporting and tracking status using PowerPoint, Excel, SharePoint, and Teams Planner.
• Create effective presentations to be used with business audiences of various levels.
• Support day-to-day activities that align to data governance and management activities, various end-to-end data efforts, and optimize metrics and progress reporting processes.
• Monitor and support governance of data management processes.
• Identify opportunities to improve governance processes, efficiency, and execution rigor.
• Facilitate discussions with cross-functional stakeholders to evaluate data use cases, risks, and compliance requirements.

• Foundational data quality principles and how they contribute to ‘fit for purpose’ data.
• Data development lifecycle – requirements, source analysis, data design, ETL development, test & validation, deployment, monitoring & operations, governance & stewardship.
• Concepts, principles and practices of internal controls and data management and governance.
• Principles of banking, finance and securities industry operations, and familiarity with accounting and finance related topics.
• General familiarity with risk and control framework of Category IV financial institution.
• Concepts of business analytics and familiarity with business intelligence tools such as Python, Tableau, Qlik, MS Power BI, MS Teams, SharePoint, etc.
• Experience in using data gap remediation and data quality monitoring tools (particularly Microsoft Dev Ops (TFS),…