Business Analyst-Process Trainee IND

This position will be responsible for ensuring adherence to Business T change control policies – documenting SQL changes request, testing code changes and ensuring code change documentation before final signoff. Facilitates validation of monthly data refreshes in testing environment. Managing ETFs data loading and validation, performing analysis and reporting, and resolving questions for our business partners. Helps team to resolve problems or issues through methods of trouble shooting, as well as separate analysis. Provides management with recommended actions to resolve issues and/or create value for the business.

Responsibilities

• Ensuring adherence all Business T change control policies.
• Conduct end-to-end testing on SQL, to ensure that business and functional requirements are being met.
• Design and execute test scripts based upon test strategy/plans to identify defects prior to production.
• Construct test scenarios, cases, and scripts, ensuring that requirement coverage is adequate and business requirements, functional specifications and designs are linked to test artifacts.
• Work with team in SQL database, loading/updating data, validating procedures, and reviewing results.
• Ensure maintenance of necessary process documentation, data definitions, data sources and assists with testing.
• Build and review systematic data checks to ensure data integrity.
• Applies advanced analytical skills to understand system limitations and optimize solutions.
• Ability to prioritize work based on leadership and business needs
• Helps team to perform reporting and analysis to validate data, and answer business requests.

Required Qualifications

• Master’s degree in computer science, MIS, Finance or related field.
• 1-3 years of relevant experience in data management for a global financial services / asset management firm
• Proficient in writing SQL queries and manipulating data in databases.
• Experience in using Excel to analyze and manipulate data.
• Knowledge of manual testing tools/frameworks.
• Ability to work independently and as part of a team.
• Ability to communicate effectively on recommendations and analysis results and establish and maintain strong relationships across the organization.
• Ability to prioritize work based on leadership and business needs.

Preferred Qualifications

• Experience with Microsoft SQL Server Integration Services (SSIS).
• VBA for both MS Access and Excel
• SharePoint
• Python

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

(2:00p-10:30p)

AWMPO AWMP&S President's Office

Business Support & Operations