Lead, Business Intelligence & Analytics - PowerBI
ntrs
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
Northern Trust in Pune, India seeks a Lead - Business Intelligence & Analytics to drive end-to-end BI design, development, and delivery across enterprise reporting and data integration. This role bridges business stakeholders and technical teams to translate complex requirements into dashboards and data solutions.
You will lead Power BI development, build scalable data models, manage ETL using SSIS/SSRS/SSAS, and guide Agile delivery with Azure DevOps, while mentoring cross-functional teams to
Qualifications
- Experience delivering enterprise BI reporting and analytics solutions.
- Strong hands-on expertise in Power BI, SSIS/SSRS/SSAS, ETL, and cloud data platforms.
- Ability to translate business requirements into actionable dashboards, KPIs, and data models.
Responsibilities
- Lead design, development, and delivery of enterprise BI reporting and analytics solutions.
- Build scalable Power BI dashboards and semantic data models with DAX.
- Oversee data integration via SSIS and manage data warehousing aspects.
Skills
Tools
Job description
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 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Lead cross-functional initiatives without direct management responsibility.
- Influence teams and stakeholders to achieve
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
