Lead Business Analyst

We are seeking a Lead Business Analyst for Reporting and Analytics role in the Ameriprise Bank(BCS Analytics). This role will be responsible for developing Power Bi dashboards, develop complex SQL to extract metrics from multiple data sources and delivering actionable insights for strategic decision-making and act as the primary liaison between the Technology Organization, Businesses, and internal teams. Also, the candidate will be responsible for creating and maintain existing reporting structure and introduce automation where possible.

Key Responsibilities

Must be able to do end-to-end Design, Develop and implement sophisticated Power BI solutions which include ETL, Data models, interactive dashboards/visualizations/Reports that effectively communicate key performance indicators (KPIs) and insights.

Create Excel reports and provide automation where possible.

Advanced in Data aggregation techniques to consolidate and summarize data from multiple sources.

Able to work on all best practices related to Power BI service, including Data Modeling, dashboard/Report Design, writing complex DAX formulas, Power Query and access controls & have a general understanding of the AWS stack.

• Hands-on experience in SQL/PostgreSQL/AWS Datalake skills for data manipulation, ad-hoc Queries, and Star Schema design.
• Conduct in-depth data analysis to identify trends, patterns, and opportunities for process improvement or business growth.
• Optimize data models and queries for performance and efficiency, ensuring fast and accurate data retrieval.
• Able to collaborate with cross-functional teams.

Required Qualifications

• Bachelors degree in computer science, Data Analytics, or related field.
• Strong academic background with good analytical and problem-solving skills.
• 5-8 years of related experience in data management and reporting.
• Minimum 5 years of experience in Power BI/ Advance DAX functions and Dashboard designing.
• Minimum 5 years of strong experience of writing complex SQL queries.
• Experience developing Excel reports and automation of report distribution.
• Experience in documenting business and technical processes.
• Self-motivated, ability to work independently and in a team environment.
• High sense of urgency and ability to adapt to a changing environment.
• Strong oral and written communication skills.

Preferred Qualifications

Experience in Python or any other programming language will be a plus.

Knowledge of SAS and VBA will be a plus.

About Our Company

Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U.S. based financial planning company headquartered in Minneapolis with a global presence. The firms 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. Youll also have plenty of opportunities to make your mark at the office and a difference in your community. So if youre 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.

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, veteran status, marital status, family status or any other basis prohibited by law.

• Full-Time/Part-Time
• Full time
• Timings
• (2:00p-10:30p)
• India Business Unit
• AWMPO AWMP&S Presidents Office
• Job Family Group
• Business Support & Operations