We are hiring a Senior Reporting Data Analyst to improve, implement, update and support Columbia Threadneedle Investments 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, as well as a passion for analytic problem solving, strategic uses of data, customer service, continuous quality improvement, and creativity.
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 with business and technology partners to develop, test, and implement technology solutions for projects and business as usual (BAU) technology changes.
Review and approve technology design, testing, and implementations
Assist in resolving problems related to business or technology systems
Actively exploring data for specific use cases
Documenting calculations, code and adhering to data management principles and files
Actively facilitating discussions and meeting to identify data needs for reporting platforms
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.
Robust understanding of data structure and relational databases
Support business in resolving problems related to data
Bachelors degree or 5-7 years of relevant work experience
Knowledge of investment products and securities
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, and crafting implementation plans.
Experience in business process analysis and improvement
Good communication skills
Intermediate to sophisticated skills in Microsoft Access and Excel development using Visual Basic for Applications
Tableau, reporting or other visualization tool experience.
SharePoint development experience.
Knowledge of Columbia Threadneedle Investments systems or data.
Data governance experience.
Data warehouse experience.
Knowledge of AWS
About Our Company
Millions of people around the world rely on Columbia Threadneedle Investments to manage their money. We're intentionally built to help our clients succeed, backed by a global team of 2,000 people including more than 450 investment professionals sharing global perspectives across all major asset classes and markets. At Columbia Threadneedle, you'll find the promise we make to our clients is the same one we make to our employees: Your success is our priority. In addition to our competitive total rewards package, employees stay with us because of our culture and commitment to their development. And, backed by the strength of our parent company, Ameriprise Financial, we are committed to providing you with the tools, resources, recognition and rewards to help you shape the career you want.
Ameriprise Financial is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, national origin, genetic information, age, sexual orientation, citizenship, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.