Third Party Risk Management - Data Reporting Consultant at Northern Trust

Chicago, Illinois, United States

Apply Now

Not SpecifiedCompensation

Mid-level (3 to 4 years), Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Financial ServicesIndustries

Requirements

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
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, including 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, including liaising (as needed) with Legal Entity Outsourcing Managers
Assists in the support of local regulatory and audit engagements pertaining to Third Party Risk, including 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