We are seeking a Sr. 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
- Bachelor’s degree in computer science, Data Analytics, or related field.
- Strong academic background with good analytical and problem-solving skills.
- 3-6 years of related experience in data management and reporting.
- Minimum 3 years of experience in Power BI/ Advance DAX functions and Dashboard designing.
- Minimum 3 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 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.
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 President's Office
Job Family Group
Business Support & Operations
Top Skills
What We Do
Ameriprise Financial has helped millions of clients feel confident about their financial futures for more than 125 years. Our network of approximately 10,000 financial advisors* delivers personalized financial advice to help clients reach their goals.
We believe that with the right advisor, the right advice, and the right firm, life can be brilliant.
Ameriprise has corporate locations throughout the U.S. and across the globe, and advisor offices in all 50 states.
Learn how you can build your career at Ameriprise Financial.
*Ameriprise Financial Q2 2020 Statistical Supplement
All content on this page is provided for informational purposes only and should not be used as the sole basis for investment decisions. Ameriprise Financial cannot guarantee future financial results. Investment products are not federally or FDIC insured, are not deposits or obligations of, or guaranteed by, any financial institution, and involve investment risks including possible loss of the entire amount invested.
By clicking on a hyperlink, you may be directed to a non-Ameriprise website. Be aware that the linked site will be subject to rules, regulation, and privacy and security provisions that are separate, and may differ, from Ameriprise Financial.
Investment advisory products and services are made available through Ameriprise Financial Services, LLC., a registered investment adviser.