Data & Automation Specialist

Data & Automation Specialist

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.

Data & Automation Partner (AI, Power Platform & Reporting Solutions)

Role Summary

The Metrics & Reporting Team is seeking a highly motivated and innovative Data & Automation Partner to support the next phase of its reporting transformation journey. This role will be responsible for designing and implementing scalable technology solutions that automate data sourcing, streamline governance processes, enable self-service reporting, and accelerate adoption of AI-enabled capabilities across the organization.

The successful candidate will combine expertise in Power Platform, data integration, automation, analytics, and emerging AI technologies to help transform the Metrics & Reporting function from a reporting organization into a strategic insights and decision support capability. This role directly supports the team's objectives to increase automation, establish scalable reporting solutions, enhance governance workflows, and leverage AI to improve operational efficiency and reporting effectiveness.

Key Responsibilities

AI and Automation Solutions

• Identify opportunities to automate manual reporting, governance, and operational processes.
• Design and implement AI-enabled solutions to improve reporting quality, insights generation, metric analysis, and workflow effectiveness.
• Leverage Microsoft Copilot and emerging AI capabilities to enhance productivity and reporting outcomes.
• Partner with business stakeholders to translate reporting challenges into scalable technology solutions.

Power Platform Development

• Design, build, and maintain Power Apps to support metric intake, governance workflows, approvals, tracking, and reporting processes.
• Develop Power Automate workflows to automate data collection, validations, notifications, approvals, and reporting activities.
• Create user-friendly solutions that improve stakeholder experience and reduce operational overhead.

Data Integration and Engineering

• Develop and maintain automated integrations with authoritative enterprise data sources.
• Build scalable data pipelines and automated refresh processes to support management reporting and dashboards.
• Collaborate with Data & Technology teams to establish sustainable data sourcing models and reduce manual intervention.
• Support data quality, lineage, controls, and governance requirements across reporting solutions.

Reporting and Analytics Enablement

• Support development of enterprise reporting solutions using Power BI and related technologies.
• Design scalable data models and reporting architectures that support future growth.
• Enable self-service reporting capabilities for metric owners and stakeholders.
• Drive continuous improvement of reporting processes, operating models, and technology platforms.

Governance and Risk Management

• Ensure solutions align with enterprise governance, risk, compliance, and control requirements.
• Embed appropriate controls, auditability, and traceability into automation and reporting processes.
• Support implementation of standardized reporting frameworks, governance workflows, and metric lifecycle management.

Stakeholder Engagement

• Partner with risk, governance, operations, technology, and business teams to understand requirements and define solutions.
• Translate complex technical concepts into practical business outcomes.
• Provide technical consultation and thought leadership on automation, data integration, reporting technologies, and AI opportunities.

Required Qualifications

Education

• Bachelor's Degree in Information Technology, Computer Science, Data Analytics, Business Technology, Engineering, or related discipline.
• Relevant Microsoft certifications preferred.

Experience

• 10+ years of experience in data analytics, reporting technology, application development, automation, or business intelligence.
• Demonstrated experience building enterprise solutions using Microsoft Power Platform.
• Experience designing and implementing reporting and automation solutions within complex organizations.
• Experience working with cross-functional business and technology teams.

Technical Skills

Required

• Microsoft Power Apps
• Power Automate
• Power BI
• SharePoint
• SQL
• Data Integration and ETL concepts
• Data modelling and reporting architecture
• Microsoft Office 365 ecosystem
• Workflow automation and process digitization

Preferred

• Microsoft Fabric
• Azure Data Services
• Databricks
• Snowflake
• Python
• AI and Machine Learning concepts
• Microsoft Copilot Studio
• API integrations and enterprise connectivity solutions

Leadership Competencies

The successful candidate will demonstrate:

• Strong problem-solving and analytical skills
• Continuous improvement mindset
• Ability to influence without direct authority
• Strong stakeholder management capabilities
• Innovation and technology curiosity
• Ability to balance strategic thinking with hands-on delivery
• Excellent communication and presentation skills
• Ability to operate effectively in a fast-paced and evolving environment

Eligibility for Internal Partners

Sr Consultant/Associate Specialist or 2 years qualifies for a Specialist

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 MyHRHelp@ntrs.com, 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.

Experience Level

Mid Level