Hybrid: We have a balanced hybrid working model to ensure you get the flexibility you need, and the successful candidate will spend their time between working in the office and working from home.
Job title: Associate Consultant
Location: Bangalore/ Pune (Hybrid model, 2 days per week in office)
Experience: 5-8 years of relevant experience
Role/Department:
The Risk Analytics and Data Services (RADS) team drives the value creation through data solutions, advanced analytics and innovative technologies. The Risk Data Analytics vertical within RADS focuses on building and delivering robust data, BI and automation products and solutions through innovative tools and technology and diverse talent across Risk and Compliance.
Associate Consultant, Risk Data Analytics is a key member of the Risk Analytics and Data Services team and will have responsibilities consist mainly of business process analysis, project management and reporting. Associate Consultant will work under supervision and in a team environment performing requirements gathering, process analysis, documentation and reporting/ visualization.
The key responsibilities of the role include:
Major Duties
Create Detailed Business Requirement documents (BRD), High level design (HLD) documents, process flows, cost and resource estimates, project planning and implementation artifacts that support regulatory and audit requirements
Understand the business process, analyse the multiple data sources/systems, translate business requirements into technical specifications and subsequently work with technical developers / business stakeholders
Extract necessary data from systems, build processes and develop visualization dashboards and address any ad-hoc queries using SQL, PL/SQL and Power BI
Develop solutions that a) leverage/extend existing Data Warehouse & Business Intelligence and analytics infrastructure, b) are integrated with data governance and enterprise solutions, c) are scalable, repeatable and effective and d) follow agreed upon governance and technology policies
Identify opportunities for enhancing value proposition along with data chain and ensure issues are identified, tracked, reported on and resolved in a timely manner
Plan/Setup meetings with key stakeholders (Business, Risk, Compliance, IT), manage the meetings through a structured agenda and document discussions
Understand Data and Analytics projects both from a business & technical aspects and support the data analytics need of the department; participate in special projects as needed and perform other duties in line with priority
Skills
5-8 years of experience as a Data Engineer/Database Developer in RDBMS like Oracle, SQL Server with data architecture/modelling skills
Experience in database development in SQL & PL/SQL is mandatory and conceptual understanding of data modelling and data warehousing is a must
Knowledge of any ETL tool such as DataStage or Informatica Power Center, BDM will be beneficial
Intermediate working knowledge of any data visualization tool (such as Power BI) will be advantageous
Experience in the Banking and Financial Services industry is preferred
Strong communication, presentation and stakeholder management skills coupled with strong analytical and problem solving skills
Qualifications:
Master/Bachelor Degree in Computer Science, Information Technology, Computer Applications, Data Analytics or a related field preferably from Tier 1 institution
Keyskills: sql java customer relations sap power bi etl tool sql server data modeling data services
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 worlds most-sophisticated clients from...