Sr. Associate – BI & Data Analytics

Posted 3 Hours Ago
Be an Early Applicant
Pune, Maharashtra, IND
Hybrid
Senior level
Artificial Intelligence • Cloud • Fintech • Information Technology • Analytics • Financial Services • Cybersecurity
Dynamic careers. Brighter futures. Achieve greater.
The Role
Design, develop, and maintain Power BI dashboards and enterprise reports; build and optimize data models, DAX calculations, and Power Query transformations; develop and support ETL processes (SSIS) and reporting (SSRS, SSAS); write and tune SQL and Azure SQL objects; collaborate in Agile teams using Azure DevOps and support testing, deployment, and production data quality.
Summary Generated by Built In

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.


We are seeking a highly motivated Sr. Associate – BI & Data Analytics Developer to support the design, development, and maintenance of enterprise reporting and analytics solutions. The ideal candidate will have hands-on experience with Power BI, Microsoft SQL technologies, ETL processes, and Azure SQL, along with a strong understanding of Agile development practices. This role will work closely with business stakeholders, data engineers, and application teams to deliver scalable dashboards, reports, and data solutions that enable data-driven decision-making.

Key Responsibilities

Power BI Development

  • Design, develop, and maintain interactive Power BI dashboards and reports.
  • Create and optimize data models using best practices for performance and scalability.
  • Develop calculations and measures using DAX (Data Analysis Expressions).
  • Utilize Power Query for data transformation, cleansing, and integration.
  • Implement Row-Level Security (RLS) and data governance requirements.
  • Collaborate with business users to gather reporting requirements and translate them into actionable insights.

Data Integration & ETL

  • Develop and support ETL processes using SSIS (SQL Server Integration Services).
  • Extract, transform, and load data from multiple sources into reporting repositories and Azure SQL environments.
  • Monitor ETL jobs and troubleshoot data quality and performance issues.
  • Ensure data accuracy, integrity, and consistency across systems.

Reporting & Analytics

  • Develop and maintain enterprise reports using SSRS (SQL Server Reporting Services).
  • Support multidimensional and tabular data models using SSAS (SQL Server Analysis Services).
  • Create automated reporting solutions and improve existing reporting frameworks.
  • Perform data analysis and validate business requirements through data insights.

Database & Cloud Technologies

  • Develop and optimize SQL queries, stored procedures, views, and database objects.
  • Support data solutions built on Azure SQL Database.
  • Participate in database performance tuning and data optimization initiatives.
  • Assist in the implementation of cloud-based analytics and reporting solutions.

Agile Delivery & Collaboration

  • Participate in Agile ceremonies including sprint planning, stand-ups, retrospectives, and reviews.
  • Utilize Azure DevOps (ADO) for work item tracking, backlog management, documentation, and deployment activities.
  • Collaborate with development, infrastructure, and business teams to ensure timely delivery of solutions.
  • Support testing, UAT, deployment, and production support activities.

Required Qualifications

Education

  • Bachelor’s degree in Computer Science, Information Technology, Data Analytics, Engineering, or related field.

Experience

  • 3-5 years of experience in Business Intelligence, Reporting, or Data Analytics development.

Technical Skills

  • Strong hands-on experience with:
    • Power BI
      • DAX
      • Power Query
      • Data Modeling
      • Row-Level Security (RLS)
      • Dashboard & Report Development
    • SSIS
    • SSRS
    • SSAS
    • ETL Development
    • Microsoft SQL Server
    • Azure SQL Database
    • Azure DevOps (ADO)
  • Good understanding of relational database concepts and data warehousing principles.
  • Experience writing complex SQL queries and optimization techniques.

Good to have Skills

  • Understanding of IT Service Management (ITSM) concepts and processes.
  • Exposure to ServiceNow platform, reporting, or integrations.
  • Knowledge of data governance, data quality, and security best practices.
  • Familiarity with cloud analytics and Azure data services.

Key Competencies

  • Strong analytical and problem-solving skills.
  • Excellent communication and stakeholder management skills.
  • Ability to work independently and within cross-functional teams.
  • Attention to detail and commitment to delivering high-quality solutions.
  • Continuous learning mindset with a passion for data and analytics.

Success Measures

  • Timely delivery of dashboards and reporting solutions.
  • High data accuracy and reporting quality.
  • Effective stakeholder satisfaction and adoption of BI solutions.
  • Continuous improvement in reporting automation and analytics capabilities.
  • Adherence to Agile delivery practices and development 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, Information Technology, Data Analytics, Engineering, or related field
  • 3-5 years of experience in Business Intelligence, Reporting, or Data Analytics development
  • Power BI development including dashboard/report development, data modeling, RLS
  • DAX (Data Analysis Expressions) for calculations and measures
  • Power Query for data transformation and integration
  • SSIS for ETL development and support
  • SSRS for enterprise reporting
  • SSAS for multidimensional and tabular model support
  • Strong experience with Microsoft SQL Server and Azure SQL Database, including complex SQL queries, stored procedures, views, and performance tuning
  • Experience with Azure DevOps (ADO) for work item tracking, deployments, and Agile practices
  • Good understanding of relational database concepts and data warehousing principles
  • Experience ensuring data accuracy, integrity, and troubleshooting ETL/data quality issues
  • Understanding of IT Service Management (ITSM) concepts and ServiceNow exposure
  • Familiarity with cloud analytics and Azure data services
  • Knowledge of data governance, data quality, and security best practices

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

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, IL
24,000 Employees
Year Founded: 1889

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

Gallery

Similar Jobs

ZS Logo ZS

Technology Leader - Supply Chain and Manufacturing

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
3 Locations
15000 Employees

ZS Logo ZS

Finance Associate - Accounts Payable

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
Pune, Maharashtra, IND
15000 Employees
Hybrid
Mumbai, Maharashtra, IND
289097 Employees
Hybrid
Mumbai, Maharashtra, IND
289097 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account