Apply on Employer Site

Northern Trust · 2 weeks ago

Third Party Risk Management - Data Reporting Consultant

Chicago, IL

Full-time

Hybrid

Mid, Senior Level

$74K/yr - $126K/yr

4+ years exp

Northern Trust is a globally recognized financial institution that has been in operation since 1889. The role involves leading Third-Party Risk governance, ensuring adherence to policies, and providing actionable support while also managing data reporting and analytics requirements.

BankingFinanceFinancial ServicesWealth Management

H1B Sponsor Likely

Responsibilities

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

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

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

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

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

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

Qualification

ETL workflowsData ModelingTransactional SQLPower BIBusiness Requirements GatheringRisk ManagementData Quality AssuranceCross-functional Leadership

Required