Reporting Data Analyst

Reporting Data Analyst is required to improve, implement, update and support CTI enterprise data, including securities, accounts, positions, analytics, transactions/trades, and related parties used across reporting teams! This role requires understanding of investment management data, the ability to learn data structure, act as domain specialist on data, and collaboration with business, technology, data owners and stewards on defining and using data to best meet business needs. The ideal candidate has balanced skills of business and technical knowledge

Key Responsibilities

Collaborate with internal and external teams to assemble requirements for reporting needs, help with data-driven decision making, strive to get data from authoritative sources to reporting via enterprise data hub, data warehouses and data marts.

Generate and present Decision Analysis Recommendations (DARs) for business and technology partners decision-making. Work on SQL to identify the data files with the help of UDF Table file (provided by Backend time).

Documenting report specifications, data sources, and assumptions to maintain a clear record of the reporting process.

Prepare the Data Specification document for new function development and enhancement in existing functions. (which includes calculations for the functions).

Work with business and technology partners to develop, test, and implement technology solutions for projects and business as usual (BAU) technology changes. See opportunities for automation to more efficiently provide repeatable data extract ions to reduce manual effort and rework and decrease operational risk.

Partner with Data Management team and Technology to build foundational solutions to reporting problems that ensure accuracy, ease of use and query performance.

Required Qualifications

Knowledge of investment products and securities.

Understanding of SQL and data sets Ability to write SQL queries and understand data retrieval, formatting, and integration. Ability to understand Database architecture concepts.

Ability to integrate data from multiple systems for consolidated reporting.

Experience as key contributor in larger projects and leading smaller projects, including writing requirements, developing and carrying out test cases.

Experience in business process analysis and improvement.

PowerBI / Tableau Reporting Or Other Visualization Tool Experience.

Excellent Communication skills both written/Oral

Solid analytical, quantitative and problem-solving skills, with the ability to interpret data, reach conclusions and take action.

Ability to communicate technology related information clearly to different audiences and clearly detail implementation processes.

Strong relationship within the department and across business functions.

Bachelor's degree or equivalent work experience.

1+ years experience in the financial services industry

Strong leadership competencies and execution skills by way of cross-collaboration and workflow facilitation with multiple internal business partners.

Must be highly responsive and proactive in a fast-paced changing environment.

Preferred Qualifications

Knowledge of Asset management Investments systems or data.

Intermediate to sophisticated skills in Microsoft Access and Excel development using Visual Basic for Applications.

Knowledge of AWS and SharePoint development experience.

Data governance experience.

Data warehouse experience.

Knowledge of Columbia Threadneedle Investment systems or data.

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