Team Lead- Vermilion Reporting Analyst
- Hiring from
- India
- Work type
- Hybrid
- Posted
- Sep 28, 2026
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
Serve as a conduit to the organization's data, working closely with stakeholders to provide data solutions that help the business make strategic decisions. Based on the business needs and requirement, perform complex analysis to determine an overall data solution. Participate in data profiling, analysis, design documentation and communication with business partners. Perform testing and issue resolution, working closely with the development teams.Responsible for system administration, business production support, design and build of new templates and functionalities on systems supported within the team. Solve organizational information problems and needs through identification and analysis of requirements, creation of project and process specifications, design and development of the output.Key Responsibilities
Gather business information and incorporate information into project plans with project manager or leadWork on process improvements and complex projects in identifying business and system requirements, creating project and process specifications for new and/or enhanced systems and drive quantifiable results through facilitating interaction with the business unit. Analyzing the work request to provide high level of time estimation. Assist BA in preparation of BRD and URD, create Design Doc and Data spec, Report development and perform Smoke testing on the developed reports.
Perform and/or support system administration tasks including but not limited to:
- Change Management - Maintenance and Monitoring of the applications - Install and upgrading of software - Back-ups and archives - Configuration and troubleshooting - Maintain documentations (new user’s guide, policy and procedure documents, disaster recovery plans, administrative procedures, user access) - Help and educate users - Base-lining and application capacity monitoring.
Assist with gathering requirements across business partners and develop test execution plans. Support small to medium scale projects. Also, provide support on VRS development and SQL development tasks to the business unit. Create and test applications, as well as trouble-shoot and resolve routine and medium to less-complex problems for the business unit as it relates to business requirements and technology.
Attend / conduct team meetings, leader's regular meetings, trainings, coaching, leading initiatives for the business and other admin responsibilities associated to the team and function. oversight the work of developers and guide them. Support and solve a variety of complex system and system-related problems for the business unit and liaise with technology peers, as it relates to business requirements, technology, in addition to design, development or implement systems.
Develop expertise in all systems, processes and data relating to the assigned business or project. Leverage domain expertise and analyst practice expertise to provide the most effective solutions to the business partners in the most efficient means possible. Educate business partners on systems capabilities and the feasibility of developing specific solutions.
Leverage technical knowledge and business acumen to manage effective working relationships with technology teams and business partners. Work effectively in a team environment to ensure that solution delivery is on-time, within cost estimates and meets business needs. Negotiate technical and non-technical solutions that both satisfy the business users and conform to the technical architecture.
Actively contribute to the continuous improvement of data analysis best practices, using innovative ideas to increase effectiveness of the overall analyst organization. Provide subject matter expertise in areas including strategy/approach, domain/data knowledge, use cases and other areas of expertise based on established data analysis tools and techniques.
Partner with data governance and analytical domain owners, ensuring attribute logic/design is appropriately logged and reviewed as required. Document metadata, including business and technical details, for each attribute being created or updated.
Strive for quality data by documenting data quality issues found during profiling and analysis activities. Partner with the development team for resolution on quality issues, including root cause analysis when required.
Required Qualifications
Bachelors degree in Computer Science or similar field; or equivalent work experience.
7-10 years of relevant experience required.
4+ years of demonstrated development experience on Vermilion Reporting Suite (VRS)
6+ years of demonstrated experience in business and functional requirements elicitation, translation and documentation.
Strong analytic skills including ability to identify patterns, potential issues and then translate those into functional and test requirements.
Solid understanding of business functional areas and business management issues as well as the IT organizations systems and capabilities.
Knowledge of and ability to effectively use the appropriate modeling methodologies and tool-sets, requirements management methodologies and tool-sets, requirements visualization methods and tool-sets, and artifact version tools.
In depth knowledge of business operations and processes with the ability to articulate these processes to others.
Experience with analysis planning, requirements elicitation, Report Development on VRS, test planning, creating test cases and test data, executing test scripts, implementation planning, and implementation execution.
Preferred Qualifications
Expert level understanding of industry concepts, terminology and related data in the financial industry.
Experience of reports development from end to end on Vermilion (VRS).
Experience in dimensional (star schema) data modeling, reporting (Power BI/Quick Sight preferred) and metadata management.
Big data or cloud data integration and analytics experience (AWS preferred).
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
Timings
India Business Unit
Job Family Group
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.
Who We Are
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.
Our Business and our Brands
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.
Explore opportunities within each business and region below.
Common Questions
Can I check the status of my application?
Yes, you can check the status of your submitted application. To do so, you will need to log into the Candidate Homepage with your username and password.
What information is required to apply for a job?
Requirements vary by position, state and/or region. Be prepared to provide work history, resume, and contact information at a minimum.