Third Party Risk Management - Data Reporting Consultant

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.

Leads in the Third-Party Risk governance framework in the 1st Line of Defence, with oversight and reporting to enterprise leadership on related risk and control profile, issues / incidents and any relevant emerging risks

Works with Vendor Managers to ensure that Third Party Risk policies and guidelines are adhered to, and provide actionable support and guidance to the Business

Escalates any concerning trends to Senior Management. This may include (but not limited to) oversight and monitoring of emerging risks, weaknesses in controls and material change programs, deterioration in service / performance standards, and provide guidance on mitigating actions

Assists in review of internal and external Third-Party Risk related events and issues, to ensure that the root cause is adequately identified and remediation actions are fit for purpose

Works to ensure appropriate oversight / governance of intra-group arrangements is in place, and changes to business models are accurately reflected in applicable group documentation. This may include liaising (as needed) with Legal Entity Outsourcing Managers

Assists in the support of local regulatory and audit engagements pertaining to Third Party Risk; this includes supporting remediation activities

Supports Third Party Risk awareness and risk management culture in order to ensure that the material risks are both evident and effectively managed

Exercises judgment based on the analysis of multiple sources of information

Able to lead cross functional or complex projects with manageable risks and resource requirements

Acts as a subject matter expert for all team members, substitutes for manager when required

Working with Data Architects from specific source data stewards

Other areas to include:

ETL (Extract, Transform, Load)

· Design and implement ETL workflows using tools such as SSIS, Power Query, or cloud-based integration platforms.

· Ensure data quality and integrity during extraction and transformation processes.

· Optimize ETL pipelines for performance and scalability across large datasets.

Data Modeling

· Develop and maintain logical and physical data models to support reporting and analytics.

· Implement dimensional modeling techniques for star and snowflake schemas.

· Collaborate with stakeholders to align data models with business requirements and governance standards.

Transactional SQL

· Write and optimize complex SQL queries for transactional systems and reporting needs.

· Create stored procedures, views, and functions to support data operations.

· Troubleshoot and tune SQL queries for performance in high-volume environments.

Power BI

· Connect to diverse data sources and build interactive dashboards and reports in Power BI Desktop and Service.

· Implement row-level security and manage workspaces for secure data sharing.

· Configure scheduled refresh and optimize datasets for performance.

Collecting Business Requirements

· Engage with business stakeholders to gather and document reporting and analytics requirements.

· Translate business needs into technical specifications for data models and reports.

· Validate requirements through iterative feedback and prototype development.

Salary Range:

$74,200 - 126,200 USD

Salary range is a good faith estimate of base pay. Northern Trust provides a comprehensive benefits package including retirement benefits (401k and pension), health and welfare benefits (medical, dental, vision, spending accounts and disability), paid time off, parental and caregiver leave, life & accident insurance, and other voluntary and well-being benefits. Northern Trust also provides a discretionary bonus program that may include an equity component.

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.