Associate Specialist, Data Analytics

085 Northern Operating Srvs Pvt Ltd; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Northern Trust, Bangalore, is seeking an Associate Specialist in Data Analytics to manage enterprise datasets for regulatory reporting and related transformation initiatives. The role collaborates with Enterprise Architecture, Resolution Planning, Technology, and Business teams to ensure accurate data and timely insights.

The candidate will apply advanced Excel, Access, SQL, and Power Platform tools to automate processes, develop dashboards, and support governance workflows within a global team.

Qualifications

• Bachelor's degree in a related field.
• 10+ years IT experience with 5–6 years in data analytics, reporting, governance and stakeholder management.
• Strong analytical, communication and problem-solving skills.

Responsibilities

• Maintain Service Catalog data and support regulatory reporting requirements.
• Develop Power BI dashboards and reports for operations and governance metrics.
• Perform data validation, reconciliation, and root-cause analysis of data issues.
• Collaborate with Enterprise Architecture, Data Governance and cross-functional teams.
• Automate manual processes using Power Platform and SQL tooling.

Skills

Excel VBA

MS Access

SQL

Power BI

Power Apps

Power Automate

SharePoint

Data analysis

Data validation

Reporting

Documentation

Education

Bachelor's Degree in Computer Science / Information Systems

Tools

Azure DevOps

Python

Data Governance tools

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.

Job Description

The Associate Specialist, Data Analytics is a key role responsible for managing an enterprise dataset used for regulatory reporting (Resolution Plan). This dataset (called the Service Catalog) will also be used for other transformation initiatives within Enterprise Architecture world through data management, regulatory reporting, process governance, business analysis, and technology enablement activities. The role partners with stakeholders across Enterprise Architecture, Resolution Planning, Technology, and Business teams to maintain critical business and technology data, drive process improvements, support governance workflows, and deliver reporting and analytics solutions. The successful candidate will combine strong analytical, technical, and stakeholder management skills to support regulatory compliance, operational excellence, and enterprise governance objectives.

Responsibilities

• Service Catalog Operations & Regulatory Support: Support the annual and quarterly Service Catalog Mapping and Attestation exercises across Personnel, Systems, Vendors, Real Estate, Intellectual Property, and other critical service components.
• Perform data collection, validation, reconciliation, and quality assurance activities across multiple enterprise data sources.
• Coordinate with business stakeholders to resolve mapping discrepancies, data quality issues, and reporting exceptions.
• Maintain Service Catalog metadata and ensure alignment with Resolution Planning and regulatory reporting requirements.
• Prepare data extracts, reports, exhibits, and management information supporting Resolution Planning submissions and regulatory inquiries.
• Support data ingestion activities and maintain integrity of the Service Catalog repository.
• Participate in stakeholder outreach, training sessions, office hours, and governance meetings related to Service Catalog processes.
• Analytics, Reporting & Automation: Leverage Microsoft Access, Excel, VBA, Power Query, SQL, and Power Platform tools to automate manual processes (current state solution – we have plans to modernize this in 2027).
• Develop Power BI dashboards and reports to provide operational insights and performance metrics.
• Perform root cause analysis on data issues and recommend process improvements.
• Support data governance initiatives through monitoring, validation, and reporting activities.
• Collaborate with Enterprise Architecture, Resolution Office, Data Governance, Technology, HR, Vendor Management, and business teams.
• Assist in documenting business processes, operating procedures, and governance frameworks.

Required Qualifications

Education: Bachelor's Degree in Computer Science, Information Systems, Data Analytics, Business Administration, Engineering, or related field.

Experience: 10+ years of IT experience; 5 to 6 years of experience in: Data Analytics, Business Analysis, Reporting & Dashboard Development, Data Governance, Regulatory Reporting, Process Improvement, Stakeholder Management, Technical Skills.

Technical Skills Required / Current State

• Advanced Microsoft Excel (incl. VBA), Microsoft Access and SQL skills
• Power BI, Power Apps / Power Automate, SharePoint
• Data Analysis & Reporting
• Data Validation & Reconciliation
• Business Process Documentation

Preferred / Future State

• Azure DevOps
• Python API Integration
• Data Governance tools

Soft Skills

• Excellent analytical and problem-solving abilities
• Strong communication and presentation skills
• Ability to work with senior stakeholders
• Strong organizational and multitasking skills
• Self motivated with a continuous improvement mindset
• Working knowledge of full stack technology solutions with a focus on data is a plus
• Seasoned multi-disciplinary expert with technical and business knowledge and functional expertise
• Eager to learn and explore in area of AI tools like copilot is a plus as team has various AI initiative planned for coming year.
• Ability to work independently and collaboratively across global teams

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.

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.

Reasonable Accommodation

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.

APAC/INDIA EEO STATEMENT

It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

Canada EEO STATEMENT

Northern Trust is an Equal Opportunity Employer. Hiring and other employment decisions at Northern Trust are made without regard to race, colour, religion, sex, ancestry, national origin, ethnic origin, age, disability, citizenship, veteran status, sexual orientation, record of offences, marital status, family status, or any other characteristic protected by federal, provincial, or local law, regulation, or ordinance.

EMEA EEO STATEMENT

It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

USA EEO STATEMENT

It is the policy of The Northern Trust Company to afford equal opportunity in all phases of employment without regard to an individual's age, race, color, religion, creed, gender, national origin, citizenship status, marital status, pregnancy, sexual orientation, gender identity, gender expression, genetic tests and information, physical or mental disability, protected veteran status or any other legally protected status.