Consultant

Quest Oracle Community; Bengaluru; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Northern Trust in Bengaluru is seeking a Consultant, Data Governance to drive data solutions and governance programs. You will gather requirements, analyze data sources, and deliver scalable BI artifacts in collaboration with Risk, Compliance, and IT teams.

The role emphasizes strong SQL/PLSQL skills, data warehousing concepts, and experience with Power BI within the Banking/Financial Services sector. This is a Bangalore office position offering a collaborative, inclusive culture.

Qualifications

• Master/Bachelor in CS/IT/Data Analytics from tier‑1 institution.
• 8–10 years experience as Data Engineer/DB Developer in Oracle/SQL Server.

Responsibilities

• Create BRD, HLD, process flows, cost and resource estimates.
• Translate business requirements to technical specs with stakeholders.
• Extract data, build processes and dashboards using SQL/PLSQL and Power BI.
• Develop solutions leveraging DW, BI, and governance, ensuring scalability and repeatability.
• Identify opportunities to enhance data value and track issues to resolution.
• Plan meetings with stakeholders and document discussions.

Skills

Data Engineering

SQL & PL/SQL

ETL Tools

Power BI

Data Warehousing

AML exposure

Banking & FS

Stakeholder Mgmt

Education

Master/Bachelor in CS/IT/Data Analytics

Tools

DataStage

Informatica PowerCenter

Power BI

Job description

About Northern Trust

As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world's most successful individuals, families, corporations and institutions.

Since 1889, we have aligned our efforts with our three guiding Principles That Endure: Service, Expertise, and Integrity. Together, they reflect the three cornerstones of business conduct which we strive to instill in our employees, whom we call partners, and to provide to our clients and the communities we serve worldwide.

With more than 135 years of financial experience and over 24,000 partners, we serve the world's most sophisticated clients using leading technology and exceptional service.

The Data & Analytics office (DAO) team drives the value creation through data solutions, advanced analytics and innovative technologies. The Data governance vertical within DAO 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.

Consultant, Data Governance is a key member of the Data Services team and will have responsibilities consist mainly of business process analysis, project management and reporting. Consultant will work under supervision and in a team environment performing requirements gathering, process analysis, documentation and reporting/ visualization.

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

Qualification

Master/ Bachelor Degree in Computer Science, Information Technology, Computer Applications, Data Analytics or a related field preferably from Tier 1 institution

Skills Required

For internal applications - 24 months as Associate Consultant

• 8-10 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
• Exposure to AML is preferred
• Experience in the Banking and Financial Services industry is preferred
• Strong communication, presentation and stakeholder management skills

Working with Us

As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to an inclusive workplace and assisting the communities we serve.

Philanthropy is deeply rooted in Northern Trust's history and is an essential element of our culture. Employees around the world give their time and talent to work for the greater good of their communities.

Reasonable Accommodation

Northern Trust is committed to working with and providing adjustments to individuals with health conditions and disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at [e-mail] , or alternatively you can discuss your individual requirements with the recruiter you are working with.

About Our Bangalore Office

The Northern Trust Bangalore office, established in 2005, is home to over 5,600 employees. In this stunning office space, we offer fantastic amenities which include our Arrival Hub - Jungle, the GameZone, and the Employee Experience Zone that appeal to both clients and employees. Learn more.