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 – Lead, Business Intelligence & Analytics
Job Summary
We are seeking a highly skilled and results-driven Lead – Business Intelligence & Analytics to lead the design, development, and delivery of enterprise reporting, analytics, and data integration solutions. This role will serve as a bridge between business stakeholders and technical teams, translating complex business requirements into actionable dashboards, reports, and data solutions.
The ideal candidate will possess strong hands-on expertise in Power BI, SSIS, SSRS, SSAS, ETL, Azure SQL, and Azure DevOps (ADO), combined with leadership skills such as stakeholder management, problem-solving, influencing without authority, and driving execution across cross-functional teams. The role requires ownership of end-to-end BI solution delivery, ensuring data-driven insights support strategic business decisions.
Key Responsibilities
Business Engagement & Solution Design
- Partner with business stakeholders to understand strategic objectives, operational challenges, and reporting requirements.
- Translate business needs into meaningful dashboards, KPIs, scorecards, and self-service analytics solutions.
- Conduct workshops and requirements gathering sessions to define reporting and data visualization needs.
- Recommend analytics solutions and reporting strategies aligned with business priorities.
- Drive adoption of reporting and analytics capabilities across business functions.
Power BI Development & Data Visualization
- Lead the design, development, and deployment of enterprise-grade Power BI dashboards and reports.
- Build scalable semantic models and data models using Power BI best practices.
- Develop advanced calculations, KPIs, and business metrics using DAX.
- Utilize Power Query for data transformation, cleansing, and preparation.
- Implement and manage Row-Level Security (RLS) and data access controls.
- Optimize dashboard performance, usability, and user experience.
- Establish visualization standards and reporting governance practices.
Data Integration & Engineering
- Design, develop, and support complex ETL solutions using SSIS.
- Integrate data from multiple enterprise applications, databases, and cloud platforms.
- Ensure data quality, consistency, and reliability across reporting platforms.
- Troubleshoot and resolve ETL, data integration, and reporting issues.
- Support data warehousing and analytics initiatives.
Reporting & Analytics Platforms
- Develop and maintain enterprise reports using SSRS.
- Design and support multidimensional and tabular models using SSAS.
- Create automated reporting frameworks to reduce manual effort.
- Manage data refresh schedules, report subscriptions, and operational support.
Database & Cloud Technologies
- Design and optimize SQL queries, stored procedures, views, and database objects.
- Develop solutions leveraging Azure SQL Database.
- Monitor and improve reporting and database performance.
- Support cloud migration and modernization initiatives related to analytics platforms.
Agile Delivery & DevOps
- Lead Agile delivery activities including sprint planning, backlog refinement, reviews, and retrospectives.
- Utilize Azure DevOps (ADO) for sprint management, user stories, testing, release management, and documentation.
- Ensure delivery milestones are achieved while maintaining quality standards.
- Drive continuous improvement through automation and Agile best practices.
Leadership Responsibilities
Stakeholder Management
- Build strong relationships with business leaders, product owners, and technology teams.
- Clearly communicate project status, risks, dependencies, and recommendations.
- Influence decision-making through data-driven insights and business understanding.
- Manage competing priorities and stakeholder expectations effectively.
Problem Solving & Incident Resolution
- Act as the escalation point for complex reporting, analytics, and data issues.
- Lead root cause analysis and resolution of data quality, performance, and reporting challenges.
- Identify opportunities for process improvement and automation.
- Drive proactive resolution of recurring issues.
Execution Without Authority
- Lead cross-functional initiatives without direct management responsibility.
- Influence teams and stakeholders to achieve common objectives.
- Facilitate collaboration across business, application, infrastructure, and data teams.
- Drive accountability, ownership, and timely delivery of commitments.
Team Leadership & Mentoring
- Provide technical guidance and mentorship to BI developers and analysts.
- Establish development standards, coding practices, and quality controls.
- Conduct peer reviews and ensure adherence to architectural standards.
- Foster a culture of continuous learning, innovation, and operational excellence.
Required Qualifications
Education
- Bachelor's degree in Computer Science, Information Technology, Engineering, Data Analytics, or related discipline.
Experience
- 6–10 years of experience in Business Intelligence, Data Analytics, Reporting, or Data Engineering roles.
- 2+ years of experience leading BI initiatives, projects, or technical teams.
Required Technical Skills
Business Intelligence & Analytics
- Power BI
- DAX
- Power Query
- Data Modeling
- Row-Level Security (RLS)
- Dashboard & Report Development
- Performance Optimization
- SSIS
- SSRS
- SSAS
- ETL Design & Development
- Data Warehousing Concepts
Database & Cloud
- Microsoft SQL Server
- Azure SQL Database
- Database Performance Tuning
- Data Integration & Transformation
Delivery & DevOps
- Agile/Scrum Methodology
- Azure DevOps (ADO)
- CI/CD and Release Management concepts
Preferred Qualifications
- Knowledge of ServiceNow platform and reporting capabilities.
- Understanding of ITSM processes including Incident, Problem, Change, and Service Request Management.
- Experience integrating ServiceNow data into analytics and reporting solutions.
- Exposure to Azure Data Factory, Databricks, Synapse Analytics, or modern cloud data platforms.
- Knowledge of data governance, data security, and compliance standards.
Key Competencies
Leadership
- Stakeholder Management
- Influencing Without Authority
- Strategic Thinking
- Executive Communication
- Team Coaching & Mentoring
Functional
- Business Requirement Translation
- Data Storytelling & Visualization
- Problem Management & Root Cause Analysis
- Solution Architecture Thinking
- Process Improvement & Automation
Behavioral
- Ownership & Accountability
- Customer Focus
- Collaboration & Teamwork
- Continuous Learning
- Results Orientation
Success Measures
- Successful delivery of business-critical dashboards and analytics solutions.
- High stakeholder satisfaction and adoption of BI capabilities.
- Reduced reporting turnaround time through automation and self-service analytics.
- Improved data quality, accuracy, and governance.
- Effective leadership of cross-functional initiatives through influence and collaboration.
- Consistent delivery of projects within agreed timelines and quality standards.
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 [email protected], or alternatively you can discuss your individual requirements with the recruiter you are working with.
About Our Pune Office
The Northern Trust Pune office, established in 2016, is now home to over 3,000 employees. The office handles various functions, including Operations for Asset Servicing and Wealth Management, as well as delivering critical technology solutions that support business operations across the globe.
Our Pune team takes our commitment to service to heart. In 2024, they volunteered more than 10,000+ hours into the communities where they live and work. Learn more.
Skills Required
- Bachelor's degree in Computer Science, IT, Engineering, Data Analytics, or related discipline
- 6-10 years experience in Business Intelligence, Data Analytics, Reporting, or Data Engineering
- 2+ years leading BI initiatives, projects, or technical teams
- Power BI (dashboard/report development, data modeling, performance optimization)
- DAX (advanced calculations and KPIs)
- Power Query (data transformation and preparation)
- Row-Level Security (RLS) implementation and data access controls
- SSIS for ETL design and development
- SSRS for enterprise reporting
- SSAS (multidimensional and tabular model design/support)
- ETL design & Data Warehousing concepts
- Microsoft SQL Server and Azure SQL Database (queries, stored procedures, performance tuning)
- Azure DevOps (ADO) for sprint management, CI/CD, release management
- Agile/Scrum methodology experience (sprint planning, backlog refinement, retrospectives)
- Stakeholder management, data storytelling, and ability to translate business requirements into BI solutions
- ServiceNow platform and reporting capabilities
- Understanding of ITSM processes (Incident, Problem, Change, Service Request Management)
- Experience integrating ServiceNow data into analytics solutions
- Exposure to Azure Data Factory, Databricks, Synapse Analytics or modern cloud data platforms
- Knowledge of data governance, data security, and compliance standards
Northern Trust Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Northern Trust and has not been reviewed or approved by Northern Trust.
-
Retirement Support — A 401(k) with company match alongside an employer‑funded defined‑benefit pension is highlighted in employer‑verified materials and filings, setting the retirement package apart from many private employers.
-
Leave & Time Off Breadth — PTO is portrayed as solid overall, and two paid volunteer days per year are clearly documented across corporate materials.
-
Parental & Family Support — Company sources and postings reference paid parental and caregiver leave and recent enhancements to parental benefits, indicating meaningful family support within the package.
Northern Trust Insights
What We Do
As a global leader in innovative wealth management, asset servicing and investment solutions, Northern Trust (Nasdaq: NTRS) is proud to guide the world’s most successful individuals, families and institutions by remaining true to our enduring principles of service, expertise and integrity. A globally recognized Fortune 500 Company in continuous operation since 1889, we’ve built a legacy of empowering clients to reach their goals with confidence. Since our roots as a trust bank, we’ve grown to a global presence with more than 24,000 employees in more than 20 countries and across six core business units: Wealth Management Asset Management Asset Servicing Technology Corporate Functions Enterprise Operations Join a Team That’s Achieving Greater At Northern Trust, we refer to our employees as partners – with good reason. We understand that relationships are the key to our success. Here you’ll join a diverse and inclusive team of innovators with the drive to challenge the way things have always been done. Instead of choosing between a dynamic career and work-life balance, enjoy working with a team that supports your goals in the office and at home. We’ll help you get where you want to go without sacrificing what matters most to you. Delivering value and adhering to our enduring principles What are enduring principles? Since our founding, they have guided our strategy and success. Thanks to the dedication of our partners, Northern Trust continues to thrive by adhering to three enduring principles: service, expertise and integrity . What does this mean? Service Northern Trust has a relentless drive to provide exceptional service to our clients, our partners and our communities. We set new standards and go above and beyond in our commitment to delivering greater results. Expertise Expertise is at the core of who we are. We focus sharply on what we do well. From expanding our capabilities, to hiring talented professionals to developing innovative solutions, our expertise is why we continue to be a trusted advisor for generations of families and institutions. Integrity Operating with uncompromising ethics is central to Northern Trust’s heritage. As a result, our clients, partners and communities know they can rely on us. For more than 130 years, our integrity has been our guide – and that will never change.
Why Work With Us
At Northern Trust, we go further because we go together. We embrace flexibility, encourage balance, and prioritize inclusion at all levels, working together to keep you connected. We are committed to our employees—all 24,000 of them. Whether this is a first step or a bold new leap in your career, we’re here to help you move forward.
Gallery
