Northern Trust - Risk Analytics/Data Service Engineer (2-5 yrs)

Note : If shortlisted, you will be invited for initial rounds on 1st March'25 (Saturday) in Bengaluru

About Company :

For more than a century, Northern Trust has worked hard building our legacy of outstanding service, expertise and integrity. From a Chicago-based bank founded in 1889, we now have more than 20 international locations and 16,500 employees globally. We serve the world's most-sophisticated clients - from sovereign wealth funds and the wealthiest individuals and families, to the most-successful hedge funds and corporate brands.

We burnished our reputation as a global leader delivering innovative investment management, asset and fund administration, fiduciary and banking solutions enabled by sophisticated, leading technology. And through it all, we continually laid a solid, forward-looking foundation on which future generations can continue growing and achieving greater.

Job Summary :

The Risk Analytics and Data Services (RADS) team drives value creation through data solutions, advanced analytics and innovative technologies. The Risk Data Management vertical within RADS focuses on data delivery solutions supporting regulatory disclosures across corporate functions, including but not limited to Treasury, Controllers, Credit Risk and Compliance. Interaction with internal and external auditors is required to substantiate the completeness and accuracy of the data deliverables.

The Risk Data Management team is responsible for ensuring the end to end sourcing, integration, application delivery and data integrity for financial, non-financial and compliance data consumers.

Job Duties :

- Identify and remediate critical enterprise data issues across multiple product offerings by performing complex data profiling, data/business analysis and conducting data mapping as part of root cause/impact analysis

- Provides analytical or risk measurement support to help meet both internal corporate and regulatory requirements

- Design, develop, and maintain interactive Power BI / Incorta dashboards.

- Work with SQL to extract, transform, and analyze large datasets.

- Utilize Python for data manipulation, attribute derivations, automation, and advanced analytics.

- Optimize and maintain data models, DAX calculations, and ETL pipelines.

- Supports development of comprehensive documentation and testing of risk management framework

- Ensure reporting, escalation, and remediation of issues, deficiencies, or regulatory matters to committees and appropriate business management

- Collaborate with business and technology teams to ensure requirements are captured adequately and solutions implemented accurately satisfying business needs

- Primarily involved in creating complex data sets using SQL, data profiling, analyzing and interpreting data that help provide insight to drive business decisions

- Perform data analysis to support business decision making process using any Data visualization tools.

Skills & Experience Required :

- 2-5 Years of relevant experience

- Technical skills / systems knowledge - SQL, PowerBI development & Analytics, tableau, Advanced Excel is mandatory

- Proficiency in SQL for data extraction, transformation, and performance tuning.

- Strong programming skills in Python for data processing and automation.

- Solid understanding of DAX, and ETL processes.

- Ability to analyze large datasets and present actionable insights.

- Strong problem-solving skills

- Experience in Risk Management (Credit Risk, Market Risk, Operational, Risk, Regulatory Compliance, Counterparty Data) in a Banking/Financial Services industry demonstrated through a combination of education or work experience

- Fundamental knowledge of the US Regulatory reporting framework

- Excellent communication and interpersonal skills, specifically the ability to articulate complex data challenges and solutions to internal/external stakeholders

- Expertise in MS Office (Word, PowerPoint, Excel)

- Also open to candidates who can relocate to Pune where we have similar roles open