Third Party Risk Management - Data Reporting Consultant

Northern Trust•Tempe, AZ

42d

About The Position

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

Requirements

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.

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

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume