We are seeking a Sr. Business Analyst for Reporting and Analytics role in the Advisor Business Development Group (ABDG). The role will be primarily focused on the transition from excel reports to Power BI and automate the current reports using Python or Data Lake. Role will also require understanding the data, providing ad-hoc analysis and work on regular reports.
Key Responsibilities
- Supports/ owns the execution of risk and/or valuation models including the management of inputs, processing, and outputs (results) based on risk and reporting requirements. Requests technical environments and monitors processing logs. Maintains documentation for risk processes at the Ameriprise product/LOB level.
- Prepares spreadsheets and other related reports based on model results (output) and internal client requirements. Manage various inputs and generate extracts for the corporate model.
- Supports input, spreadsheet, and model validation control activities. Supports the testing of model and process changes as needed by corporate model and actuarial teams.
- Collaborate with different teams in completing the task and understand the need arises.
- Should have a good command of verbal and written communication and keen to learn new technologies.
- Should be able to proceed with self-learning opportunities related to systems/tools used by the team with minimal guidance.
- Should be able to work effectively and make sure the results are accurate and thoroughly reviewed before sharing it with business partners.
- Should be able to maintain the documentation and make sure quality is maintained throughout.
- Execute and understand the software applications or programs used to assist in the execution of risk and/or valuation models using one of several programming languages or software development frameworks such as VBA (used with Excel/Access), SQL, R studio, Python, or other.
- Has some knowledge of basic finance structures and terminologies.
Required Qualifications
- Bachelor’s degree in Finance, Data Analytics, MIS, or related field.
- Strong academic background with good analytical and problem-solving skills.
- 4-6 years of related experience in data management and reporting.
- Minimum 2 years of experience in VBA (used with Excel/Access), SQL, R studio, Python.
- Advanced skills in writing complex queries, developing 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
- 1-2 years’ experience in Python or any other programming language will be plus.
- Knowledge of using Prophet is 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
Read Full Description