Data Analyst with SQL and Governance

To perform this job successfully, an individual must be able to perform each primary duty satisfactorily.

• Work closely with Data Domain Owners and SMEs to identify CDE s (Critical Data Elements), define data elements for the Business Glossary and define business rules.
• Identify data sources and build out business glossary collaborating with data owners/stewards, collaborate with data modelers to review definitions of business terms vs technical terms.
• Ability to communicate effectively with Business and Technical SMEs, Architects, Analysts, Developers and other IT and business teams.
• Create, develop, configure and execute end to end business and technical data lineage across disparate sources working with business and technical SMEs/developers understanding the applications system/technical design and create data flow diagrams/data mappings.
• Experience working on metadata management ingesting metadata using metadata bridges/connectors, creating and ingesting custom source to target mappings, custom metadata assets.
• Develop Metadata, Data Lineage and Data Quality Solutions for multiple data sources across On Prem and Cloud environments including but not limited to Kafka, Protocol Buffers, REDIS, APIs, Databases, Flat Files, JSON, ETL/BI Tools and other Data Platform technologies etc.
• Design, Build and Execute Data Quality Rules over the CDEs identified according to the business needs to ensure clean and healthy data.
• Manage Data Quality Exceptions and help the team to find out the root cause analysis.
• Implement data governance policies, procedures, controls, and standards.
• Hands on experience working on data quality and data governance technology and tools.
• Utilize data profiling and data quality tools to analyze and determine causes of data quality issues.
• Design and implement Data Quality Dashboards for monitoring and reporting.
• Perform other duties as assigned.

Supervisory Responsibilities:

None

Qualifications:

The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the primary functions.

• Ability to work independently and as part of a team to successfully execute projects.
• Ability to multitask and meet aggressive deadlines efficiently and effectively.
• Experience with Data Governance tools such as Collibra, IBM Infosphere Information Server Suite or Informatica.
• Proficient with SQL.
• Strong data analysis capabilities.
• Proficient with Microsoft Office desktop tools (Word, Excel, etc.)
• Experience with Databases (i.e. Oracle, SQL Server, DB2, Amazon Redshift, NoSQL, Object-based) and ETL tools.
• Previous experience in designing and building data capabilities like data quality, metadata, data lineage, data catalog and data dictionary.
• Experience with Business Intelligence/ Reporting tools such as Tableau / Cognos.
• Strong written and oral communication skills with ability to work with users, peers and management.
• Capital market or banking domain experience is preferred.
• Prior development / coding experience is preferred.
• Experience working on Protobuf, APIs, Kafka as Data Sources is preferred.
• Experience working with draw.io or other tools creating architecture or data flow diagrams.

Technical Skills:

• Structured Query Language (SQL)
• Data Governance Tools example Collibra, IBM ISEE, Informatica etc.

Education and/or Experience:

• Bachelor s or master s degree in data analytics, computer science or related field.
• 7 years of experience in data governance disciplines: metadata management; data quality analysis; data quality remediation; data profiling and data lineage.

Certificates or Licenses:

• DAMA certification preferred.