CAREERS

Wealth Management - Data Quality Analyst – Chicago

📁
Operations/Securities
📅
85477 Requisition #

Wealth Management - Data Quality Analyst - Chicago

 

Job Summary

Essential responsibilities of the Data Quality Analyst will be to drive and/or support the development of the Data Quality program operating model as the team continues to operationalize and mature the various parts of our framework: Detect, analyze, remediate, and communicate. Some efforts in this area will include: Data quality tool implementation, dashboard development, data quality rules design and development, and issue triage/remediation.

 

Key Responsibilities

  •  
  • Synthesizes business requirements for the development and maintenance of data quality rules for proactive measurement of Wealth Management data. Continuous keeping of rules and data relevant and fit for purpose based on current business practice needs.
  • Builds data quality monitoring and measurement examining completeness, validity, uniqueness, reasonability, consistency, accuracy, etc. as it moves from source to various Wealth Management applications and reporting.
  • Collaborates with database developers to implement effective automation processes by developing queries in an SQL platform so data can be mined for quality control and accuracy.
  • Performs impact & root cause analysis, providing long-term strategic solution recommendations to stakeholders.
  • Determines business impact level for data quality issues.
  • Collaborates with Wealth Management Data Operations team to:
    1. Research and determine scope and complexity of data quality issues to identify steps for correction.
    2. Develop process improvements to improve overall data quality.
    3. Develop and execute data cleanup measures.
  • Supports data product development in any data discovery preload efforts for journey and non-journey related efforts.
  • Maintains a record of original data and corrected data and incorporates this into data quality dashboards.
  • Supports and/or builds scorecards for data quality dashboards using Power BI.
  • Analyzes data quality rule exceptions (failures), draw conclusions based on findings, and clearly summarize complex results in order to facilitate the appropriate next steps.
  •  

Required Qualifications and Skills

  • A bachelor's degree in computer science or a related discipline, or equivalent relevant work experience
  • 1 - 5 years’ experience in data quality analysis environments/projects
  • Experience with root cause analysis
  • Excellent problem-solving skills
  • Excellent SQL skills
  • Outstanding written and oral communication skills

 

Beneficial Experience

  • Data quality rule design (pseudo rules), rule building, rule monitoring, and dashboard design
  • Data profiling/ data discovery
  • Relational databases
  • Conceptual & logical data modeling
  • Source to target mapping
  • Agile principles
  • Software: Oracle’s Enterprise Data Quality (EDQ), Microsoft’s Power BI

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions

Similar Listings

United States, Illinois, Chicago

📁 Operations/Securities

Requisition #: 85372

United States, Illinois, Chicago

📁 Operations/Securities

Requisition #: 19136

United States, Illinois, Chicago

📁 Operations/Securities

Requisition #: 85262

Reasonable Accommodation
Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please email our HR Service Center or call 1-800-807-0302 (North America), +630-276-5353 (Asia Pacific), 1800-425-0333 (India), +44(0)207 982 4357 (Europe, Middle East and Africa) and let us know the nature of your request and your contact information.

Equal Employment Opportunity Statements
  • APAC/India EEO Statement
    • APAC/INDIA EEO STATEMENT

      It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

  • Canada EEO Statement
    • Canada EEO STATEMENT

      Northern Trust is an Equal Opportunity Employer. Hiring and other employment decisions at Northern Trust are made without regard to race, colour, religion, sex, ancestry, national origin, ethnic origin, age, disability, citizenship, veteran status, sexual orientation, record of offences, marital status, family status, or any other characteristic protected by federal, provincial, or local law, regulation, or ordinance.

  • EMEA EEO Statement
    • EMEA EEO STATEMENT

      It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

  • USA EEO Statement
    • USA EEO STATEMENT

      It is the policy of The Northern Trust Company to afford equal opportunity in all phases of employment without regard to an individual's age, race, color, religion, creed, gender, national origin, citizenship status, marital status, pregnancy, sexual orientation, gender identity, gender expression, genetic tests and information, physical or mental disability, protected veteran status or any other legally protected status. EEO poster (U.S.)EEO is Law Poster Supplement