Associate Principal, Technical Data Analysis

Request Technology - Chicago, IL

Full-time - Senior

Chicago, IL

Administrative and Support Services

About the position

The Associate Principal, Technical Data Analysis role is a pivotal position that serves as a bridge between business and technical teams. The primary focus is on supporting and implementing data quality, metadata management, data lineage, data mapping, and data governance within a financial context. The ideal candidate will leverage their expertise in SQL and the Collibra Platform to ensure the integrity and quality of data across various sources.

Responsibilities

• Work closely with Data Domain Owners and SMEs to identify Critical Data Elements (CDEs) and define data elements for the Business Glossary.
• Identify data sources and build out the business glossary in collaboration with data owners/stewards, and review definitions of business terms vs technical terms with data modelers.
• 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 to understand application system/technical design and create data flow diagrams/data mappings.
• Work on metadata management by ingesting metadata using metadata bridges/connectors and creating custom source to target mappings and custom metadata assets.
• Develop Metadata, Data Lineage, and Data Quality Solutions for multiple data sources across On-Prem and Cloud environments, including Kafka, Protocol Buffers, REDIS, APIs, Databases, Flat Files, JSON, ETL/BI Tools, and other Data Platform technologies.
• Design, Build, and Execute Data Quality Rules over the identified CDEs according to business needs to ensure clean and healthy data.
• Manage Data Quality Exceptions and assist the team in root cause analysis.
• Implement data governance policies, procedures, controls, and standards.
• 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.

Requirements

• Bachelor's or master's degree in data analytics, computer science, or a related field.
• 7+ years of experience in data governance disciplines including metadata management, data quality analysis, data quality remediation, data profiling, and data lineage.
• DAMA certification preferred.
• Experience with Data Governance tools such as Collibra, IBM Infosphere Information Server Suite, or Informatica.
• Proficient with SQL and strong data analysis capabilities.
• Proficient with Microsoft Office desktop tools (Word, Excel, etc.).
• Experience with Databases (e.g., 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 or Cognos.
• Prior development/coding experience is preferred.
• Experience working on Protobuf, APIs, Kafka as Data Sources is preferred.
• Experience with tools like draw.io for creating architecture or data flow diagrams.

Nice-to-haves

• DAMA certification
• Experience with Business Intelligence/Reporting tools such as Tableau/Cognos
• Prior development/coding experience
• Experience working on Protobuf, APIs, Kafka as Data Sources