Consultant, Data Governance (Two Positions)

About Northern Trust:

Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.

Northern Trust is proud to provide innovative financial services and guidance to the world’s most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.

General Position Description:
• This position supports the Data Governance function to build a quality framework of critical data to improve, monitor and thereby leverage common tools and governance across a variety of data sources.
 
Minimum Requirements:
• A Graduate/Post Graduate from a Computer Science, Management Information Systems or a related field with more than 5 Years of Data Quality/Governance experience 
• Must be flexible to work in shifts and/or on a rotational basis

Desired Competencies:
• Ability to communicate effectively with senior business stakeholders. Has done similar work in enterprise data governance groups implementing change and DG best practices. 
• Worked and understands and can measure various dimensions of Data Quality (using tools and without)
• Self-driven and a quick learner of different tools, technologies, concepts and frameworks and is comfortable in driving it independently with little to no direction
• Worked and understands Meta Data concepts as well as Lineage concepts
• Worked and understands Business Glossaries and related topics
• Ability to communicate effectively with senior business stakeholders. Has done similar work in enterprise data governance groups implementing change and 
DG best practices. 
• Has experience with Master Data, Data Domains. Can clearly articulate what is master data and what is the mastering process. Ideally should have worked on data governance of customer and product data and should be able to talk about challenges on data definitions, taxonomy, and data quality
• Experience implementing data governance standards in particular metadata and data quality. Can clearly articulate how they have made data quality controls effective.
• Has worked with complex databases and applications – legacy and newer technologies
• Has worked on big strategic data governance projects
• Comes with a financial domain understanding
• Can rationalize multiple meanings for the same data definitions
• Can solicit  input from business teams and Data Stewards to standardize business glossary terms
• Can manage work-streams and defined pieces of work
• Utilize tools (Collibra)  to analyze, query and manipulate data according to defined business rules and procedures. Collibra work experience is a must
• Proficient in SQL and Regex.  Experience with Programming basics in Java, COBOL, BIG Data (Hadoop) will be an advantage.
• Proficient in reporting tools like Power BI and Tableau
• Any experience on the IBM Info Sphere Information Analyzer tool will be a plus 
• Understanding of Data Models, Schemas, DDLs
• Experience in  Data Warehouse projects is a plus
• Exposure to File Transmissions
• Trouble Shooting on the Data Gaps      
• Excel: importing and manipulating data 
• Usage of Excel advance features

Key Responsibilities:
• Work on Data Quality projects and deliver results while being strategic
• Work with Master Data, Data Domains. Can clearly articulate what is master data and what is the mastering process. Ideally should have worked on data governance of customer and product data and should be able to talk about challenges on data definitions, taxonomy, and data quality
• Implementing data governance standards in particular metadata and data quality. Can clearly articulate how they have made data quality controls effective.
• Work with complex databases and applications – legacy and newer technologies
• Reviews, analyzes, and ensures the quality of data in database systems and provides support from a quality perspective.  Must be able to understand business rules, work with varying data formats, and develop metrics and audit procedures to monitor data quality.
• Formulate business rules for data
• Write and present - both for a business and technical audience
• Translate business concepts and concerns into logical statements and code
• Understand, query and manipulate varying data and file formats.  Identify, compare, and resolve data quality problems.  Measure and audit large volumes of varying data for quality issues.  Works with multiple groups, including overseas groups, to resolve issues.
• Documents data process flows and transformation rules
• Follow defined audit procedures, and produce required metrics according to defined procedures.
• Correct data quality errors, either with system tools or working with the DQ or LOB teams.
• May update/maintain database with reviewed and corrected data.
• Review data and record layouts prior to submitting to development or DQ  teams and does final check when data is loaded. May approve release of data into production.
• Prepare reports and track trends.
• Interpret, evaluate and resolve or escalate phone/e-mail inquiries pertaining to user requests.
• Provide training to other Data Quality Analysts.

Working with Us:

As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas.

Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose.

We’d love to learn more about how your interests and experience could be a fit with one of the world’s most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater

Reasonable accommodation

Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com.

We hope you’re excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people.

Apply today and talk to us about your flexible working requirements and together we can achieve greater.