Associate Principal, Data Governance
Chicago - 125 S Franklin
What You'll Do:
Must have a holistic perspective on the entire data governance process from both a business and technical perspective. Act as a liaison and translation layer between business and technical teams and operate at system- and detailed technical level for analysis purposes. Implement and support Metadata Management, Data Lineage, Data Quality and other essential Data Governance functions.
Primary Duties and Responsibilities:
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.
Who We Are
The Options Clearing Corporation (OCC) is the world's largest equity derivatives clearing organization. Founded in 1973, OCC is dedicated to promoting stability and market integrity by delivering clearing and settlement services for options, futures and securities lending transactions. As a Systemically Important Financial Market Utility (SIFMU), OCC operates under the jurisdiction of the U.S. Securities and Exchange Commission (SEC), the U.S. Commodity Futures Trading Commission (CFTC), and the Board of Governors of the Federal Reserve System. OCC has more than 100 clearing members and provides central counterparty (CCP) clearing and settlement services to 19 exchanges and trading platforms. More information about OCC is available at www.theocc.com.
What We Offer
A highly collaborative and supportive environment developed to encourage work-life balance and employee wellness. Some of these components include:
A hybrid work environment, up to 2 days per week of remote work
Tuition Reimbursement to support your continued education
Student Loan Repayment Assistance
Technology Stipend allowing you to use the device of your choice to connect to our network while working remotely
Generous PTO and Parental leave
Competitive health benefits including medical, dental and vision
Step 1
When you find a position you're interested in, click the 'Apply' button. Please complete the application and attach your resume.
Step 2
You will receive an email notification to confirm that we've received your application.
Step 3
If you are called in for an interview, a representative from OCC will contact you to set up a date, time, and location.
For more information about OCC, please click here.
OCC is an Equal Opportunity Employer
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Architecture Banking Business Intelligence Computer Science Data analysis Data Analytics Data governance Data quality DB2 ETL Excel Informatica JSON Kafka NoSQL Oracle Redshift SQL Tableau
Perks/benefits: Health care Home office stipend Medical leave Parental leave Wellness
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.