Sr Business Analyst-Practice Source

56672 Ameriprise India LLP; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Ameriprise India LLP is seeking a Senior Business Analyst to drive reporting, analytics, and operational insights. You will partner with business stakeholders to gather requirements, analyze data, and deliver actionable dashboards and reports that enhance decision-making across leadership and advisory teams.

The role emphasizes data quality, process improvement, and cross-functional collaboration, with opportunities to leverage Power BI, SQL, and Salesforce CRM in a fast-paced financial services

Qualifications

• Bachelor’s degree in BE/BTech, Information Systems, CS, or related field.
• 5-8 years of experience in BI, analytics, or reporting.
• Strong requirements gathering and process mapping skills.
• Advanced SQL for data extraction and analysis.
• Excel with complex formulas, pivots and data cleaning.
• Power BI dashboards, storytelling with data, and dashboards for leaders.
• Experience with Salesforce CRM and data visualization tools.

Responsibilities

• Develop and maintain dashboards and reports using Power BI.
• Translate business needs into analytical solutions and insights.
• Write and optimize SQL queries across multiple sources.
• Ensure data quality, governance, and reporting consistency.
• Collaborate with stakeholders to drive performance and KPIs.
• Automate reporting processes and support data-driven decisions.

Skills

Requirements gathering

Process mapping

SQL

Data analysis

Power BI

Excel advanced

Communication

Stakeholder management

Dashboard design

Salesforce CRM

Education

BE/BTech or related field

Tools

Power BI

SQL

Power Apps

Power Automate

Salesforce CRM

SharePoint

Data lakes

AWS Athena

Job description

About Our Company

Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 20 years. We are part of Ameriprise Financial Inc., a US financial planning company headquartered in Minneapolis with a global presence and diversified financial services leader with more than $1.5 trillion in assets under management, administration and advisement as of year-end 2024. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection. Be part of an inclusive, collaborative culture that rewards you for your contributions, and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So, if you're talented, driven and want to work for a strong, ethical company that cares, take the next step and create a career at Ameriprise India LLP.

Job Description

Provide reporting and analytics support for advisor practices by managing regular reports, dashboards, scorecards, and data distribution. Collect, clean, reconcile, and validate data from approved sources such as CRM, pipeline, activity, and prospect tracking systems. Generate weekly, monthly, and ad hoc reports, identify data quality issues and trends, and ensure reporting accuracy. Customize reports for advisors, teams, and leadership, create professional communications, maintain reporting templates and documentation, support automation and process improvements, and collaborate with leadership to enhance KPIs and reporting processes as business needs evolve.

Job Description

We are looking for a detail-oriented and analytical Senior Business Analyst to support business reporting, operational effectiveness, and strategic decision-making. The ideal candidate will work closely with business stakeholders to gather requirements, analyze data, maintain reporting processes, and deliver actionable insights that drive business outcomes. This role requires strong analytical, communication, problem-solving, and stakeholder management skills, along with the ability to manage multiple priorities while ensuring accuracy, consistency, and continuous process improvement.

Key Responsibilities

• Partner with stakeholders to gather, analyze, and document business requirements.


• Translate business needs into actionable insights and business solutions.


• Perform ad hoc analysis and develop reports, dashboards, and presentations for leadership.


• Analyze business processes and identify opportunities for process improvements and efficiencies.


• Maintain reporting documentation, SOPs, business rules, and data-source references.


• Ensure reporting outputs remain aligned with leadership directives and stakeholders.


• Validate data accuracy, reconcile discrepancies, and proactively resolve reporting issues.


• Support recurring reporting cycles while maintaining consistency and quality.


• Communicate findings, recommendations, and updates to business stakeholders.


• Identify opportunities to improve reporting processes, data quality, and operational performance.

Required Qualifications

• Bachelor's degree in Engineering (BE/BTech), Information Systems, Computer Science, or a related field.


• 5-8 years of experience in Business Analysis, Reporting, Analytics.


• Strong business analysis skills, including requirements gathering and process mapping.


• Advanced SQL skills for data extraction, validation, and analysis.


• Good understanding of data modelling concepts to support reporting, analytics, and business data interpretation.


• Advanced Microsoft Excel skills, including complex formulas, data cleaning, lookups, conditional formatting, and pivot tables.


• Strong PowerPoint skills, including executive presentations, charts, and data storytelling.


• Experience with reporting and visualization tools such as Power BI.


• Working knowledge of Salesforce CRM (end-user perspective) with experience in navigating dashboards, generating reports, managing records, and supporting business processes.


• Strong analytical and problem-solving skills with high attention to detail.


• Ability to validate data, reconcile reports, and ensure reporting accuracy.


• Excellent verbal and written communication skills.


• Ability to work independently, manage multiple priorities, and collaborate effectively across teams.

Preferred Qualifications

• Experience with KPI reporting and business performance dashboards.


• Exposure to process improvement and operational excellence initiatives.


• Experience working with large and complex datasets.


• Ability to provide data-driven recommendations to business leaders.


• Working knowledge of AWS Athena for querying and analyzing data from cloud-based data sources.

Key Responsibilities

• Develop and maintain interactive dashboards and reports using Power BI (DAX, Power Query, data modeling).


• Design and build Power Apps solutions and automate workflows using Power Automate to improve operational efficiency.


• Perform data analysis, identify trends, anomalies, and provide actionable insights to stakeholders.


• Gather business requirements and translate them into technical reporting and workflow solutions.


• Write and optimize SQL queries to extract, transform, and validate data from multiple sources.


• Ensure data quality, governance, and consistency across reporting outputs.


• Automate and streamline manual reporting processes and improve existing reporting frameworks.


• Collaborate with business teams to deliver scalable reporting and analytics solutions.


• Maintain historical data and support data integration with tools like SharePoint and data lakes.

Required Qualifications

• 2–3 years of experience in reporting, data analysis, or BI development.


• Strong hands-on experience with: Power BI (Dashboard development, DAX, Power Query).


• Power Apps / Power Platform tools.


• Proficiency in SQL for data extraction and transformation.


• Strong analytical and problem-solving skills with ability to interpret complex datasets.


• Good understanding of data modeling, data validation, and reporting best practices.


• Effective communication and stakeholder management skills.

Preferred Qualifications

• Certification in Power BI (PL-300) or Power Platform.


• Experience working with data lakes / large datasets / cloud data sources.


• Knowledge of Power Automate and workflow automation.


• Familiarity with SharePoint integration and data governance practices.


• Exposure to building enterprise-level reporting or operational dashboards.


• Experience in financial services / insurance domain (nice to have given your setup).


• Good-to-Have Competencies Ability to convert business problems into analytical solutions.


• Self-driven learning mindset (important given evolving Power Platform use in your team).


• Strong attention to detail and data accuracy.

In-Office Collaboration

We are a client-centric, relationship-based business. Working together, in-person, is foundational to how we achieve results. By fostering a culture of face-to-face collaboration, idea sharing, productivity and personal connection, we deliver for our stakeholders — clients, advisors, employees and shareholders. Our employees work in the office at least three (3) days per week, with flexibility to work from home two (2) days per week. Some roles may require additional in-office time or different in-office expectations, and specific requirements will be discussed during the hiring process.

Full-Time/Part-Time

Full time Timings (8:00p-4:30a) India Business Unit AWMPO AWMP&S President's Office Job Family Group Business Support & Operations

Equal Opportunity Employer

Ameriprise India LLP is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, genetic information, age, sexual orientation, gender identity, disability, military status, veteran status, marital status, pregnancy, family status or any other basis prohibited by law. We are committed to fostering an inclusive and accessible recruitment process for individuals with disabilities. If you require a reasonable accommodation to participate in the application or interview process, speak to your recruiter to discuss how we can support you.

About Ameriprise Financial

Since 1894, Ameriprise Financial has helped people feel more confident about their financial future. Guided by strong values and a deep commitment to clients, we've remained a trusted leader in financial planning and advice for more than 130 years. Through our businesses, Ameriprise Financial, Columbia Threadneedle Investments and RiverSource Insurance & Annuities, we deliver advice, investment and protection solutions designed for long-term success. While each business brings distinct capabilities and expertise, all are united by our unwavering focus on clients and a strong financial foundation. For you, that means the opportunity to build a meaningful career in a high-performing, collaborative culture where your expertise can grow, your contributions are valued and your work can make a real impact. As a global financial services company with three complementary businesses, the breadth of our capabilities sets us apart. It also creates unique opportunities for employees to learn, collaborate and grow their careers: Ameriprise Financial: Financial planning, advice and wealth management. Columbia Threadneedle Investments: Global asset management serving individual, institutional and corporate clients. RiverSource Insurance & Annuities: Products and solutions designed to help clients protect and grow their wealth.