Data Governance Analyst

Job Description

Data Governance Analyst - Contract to hire (US Cit or Green Card only)

Location: Mid-town, NYC

Right to hire “Data Governance Analyst” consultant.

hybrid role – 3 days in the NY office and 2 days remote

3-7 years of total professional experience with at least 3 years in data-related roles

Essential Job Function:

• Provide guidance and assistance to Data Stewards and technology subject matter experts (SMEs) with metadata management related activities (e.g., developing a business glossary, managing business glossary terms, lineage, and data classification), and with ensuring that metadata about key data is governed appropriately.

• Facilitate data access and data protection requirements in support of Least Privileged Access and Zero Trust as enterprise standard practices.

• Collaborate with Data Stewards and technology SMEs to measure and monitor data quality in an efficient, meaningful, and scalable manner.

• Coordinate root cause analyses and the resolution of data problems.

• Administer data governance related tools.

• Work with other technical teams to operationalize new data governance capabilities (e.g., Snowflake Object Tagging).

• Assist the Data Governance Officer with maintaining the Data Governance Framework (i.e. the listing of the Bank’s most significant data sets, each of which is assigned to a data steward and a data owner).

• Assist the Data Governance Officer in facilitating Data Steward Forum meetings & events.

• Contribute ideas to and the writing of Data Governance standards, processes, and procedures.

Other Duties:

• Provide training on supported capabilities.

• Collaborate with other Data Management Office staff as needed to advance the maturity of the bank's overall data management practices.

Technical skills:

• Expertise in applying critical thinking skills to distill clarity from incomplete or conflicting information (e.g. root cause analysis, process auditing).

• Proficiency with writing SQL queries for data analysis purposes in different databases (e.g. ANSI SQL, Microsoft SQL Server (MSSQL, T-SQL), Oracle (PL SQL), Postgres (PostgreSQL)).

• Strong understanding of database design and data structures (e.g., normalization, Metamodel, Conceptual Data Model (CDM), Logical Data Model (LDM), and Physical Data Model (PDM)).

• Experience in using Microsoft Visio or similar tools for creating process flow documentation.

• Experience with Microsoft PowerPoint or other storytelling tools to create succinct and compelling presentations.

• Experience in using Microsoft Excel for analysis and reporting, including formulas, Pivot tables, and charts.

• Demonstrated experience with visualization and/or reporting tools (e.g., Qlik Sense, Qlikview, Tableau, Crystal Reports, SAP Web Intelligence (WebI))

• Familiarity with Data Governance Tools (e.g., Alation, Atlan, Collibra, Informatica)

• Familiarity with data modeling tools (e.g. Idera ER/Studio, SAP PowerDesigner, erwin)

• Familiarity with Agile (e.g., scrum, Kanban) approach

Non-technical skills:

• Demonstrated strength in translating technical complexity to a business audience and vice versa

• High attention to detail and self-driven pursuit of accuracy

• Ability to proactively solve problems and seek to own the resolution of issues throughout their lifecycle

• Proven ability to manage assigned tasks and deliverables to a successful conclusion in a timely manner

• Familiarity with Privacy laws and regulations (e.g. CCPA, GDPR)

People Skills:

• Excellent interpersonal skills and the ability to successfully interact with a variety of stakeholders, from senior management to hands-on specialists.

• A patient & adaptable approach to training colleagues of varying experience levels.

Hybrid remote