Data, Analytics & Reporting Analyst - Data Engineering Team

Columbia Threadneedle Investments; Boston (MA); Hybrid; USD 140,000 - 170,000; Full time

Job summary

Columbia Threadneedle Investments is seeking a Data Engineer to shape data, analytics and reporting for investment oversight, research and portfolio construction. You will translate business needs into high-quality data solutions, quantitative models and actionable reporting while partnering with analysts and investment teams.

This role offers ownership and cross-functional influence in a global enterprise.

Qualifications

• 3-7 years of experience in data analytics, quantitative development or reporting within investment management or financial services.
• Bachelor's or Master's degree in a quantitative field.
• Proficiency in Python, R and SQL with experience using database platforms.
• Strong communication skills and ability to collaborate across functions and locations.
• Ability to manage multiple priorities and deliver high-quality work.

Responsibilities

• Understand analytical needs and translate them into data solutions, models and reporting.
• Participate in research discussions and project planning for investment oversight and portfolio construction.
• Source, validate and maintain investment data across platforms.
• Build and enhance quantitative models and analytical tools.
• Automate recurring analytical and reporting workflows for performance and risk metrics.
• Design dashboards and data visualisations for investment professionals.
• Apply model governance with documentation and validation protocols.
• Collaborate with IT and risk teams across multiple offices.

Skills

Python

R

SQL

communication

prioritization

Education

Bachelor's or Master's in mathematics, statistics, computer science, data science or related quantitative field

Tools

AWS

Azure

BI tools

Job description

About Our Company

Working at Columbia Threadneedle Investments you'll find growth and career opportunities across all of our businesses.

About Our Company

Working at Columbia Threadneedle Investments you'll find growth and career opportunities across all of our businesses.
We're intentionally built to help you succeed. Our reach is expansive with a Columbia Threadneedle Investments global team of 2,300 people working together. Our capability is diverse with more than 550 investment professionals sharing global perspectives across all major asset classes and markets. Our clients have access to a broad array of investment strategies, and we have the capability to create bespoke solutions matched to clients' specific requirements. Our unwavering focus on our clients and strong financial foundation connects each of our enterprise businesses - Ameriprise Financial, Columbia Threadneedle Investments and RiverSource Insurance and Annuities.

Job Description

Join our Data Engineering team and help shape the data, analytics and reporting capabilities that support investment oversight, research, portfolio construction and manager selection.
You will partner with Coverage Analysts, Investment Strategy & Research and Multi-Manager Solutions professionals to translate complex business needs into high-quality data solutions, quantitative models and actionable reporting. This hands-on role offers meaningful ownership, cross-functional influence and the opportunity to strengthen data quality, automate critical workflows and introduce innovative analytical capabilities.
You will contribute directly to how our investment teams generate insights and make informed decisions while continuing to grow your technical and investment expertise.

Responsibilities

• Partner closely with Coverage Analysts, Investment Strategy & Research and Multi-Manager Solutions professionals to understand analytical needs and translate them into effective data solutions, models and reporting.
• Participate in research discussions and project planning, aligning data and analytical capabilities with investment oversight, research, portfolio construction and manager selection priorities.
• Source, validate and maintain investment data across platforms and databases, ensuring quality, consistency, accessibility and reliable data feeds for investment teams and broader stakeholders.
• Build, maintain and enhance quantitative models, analytical tools and performance attribution systems, including solutions that support backtesting, scenario analysis and factor-based research.
• Automate recurring analytical and reporting workflows to improve efficiency, accuracy and timely delivery of performance reports, risk metrics and strategy dashboards.
• Design and maintain dashboards and data visualisations that give investment professionals ready access to decision-useful information.
• Apply sound model governance practices, including clear documentation, version control and validation protocols.
• Drive process improvement by evaluating new technologies and methodologies, including artificial intelligence and machine learning, and support product development and market research through data analysis and quantitative modelling.
• Collaborate with Enterprise Technology, Information Technology and Investment Risk Management teams on technology enhancements, platform development and analytical needs, while coordinating effectively with colleagues across Boston, New York, London and India.

Required Qualifications

• 3-7 years of experience in data analytics, quantitative development or reporting within investment management or financial services, with strong knowledge of investment data, portfolio analytics, performance attribution and risk.
• Bachelor's or Master's degree in mathematics, statistics, computer science, data science or a related quantitative field.
• Advanced proficiency in Python, R and Structured Query Language (SQL), together with experience using database platforms.
• Strong communication skills, with the ability to explain complex concepts clearly to technical and non-technical audiences and collaborate across functions and locations.
• Proven ability to manage multiple priorities, deliver high-quality work to deadlines and demonstrate initiative, intellectual curiosity and a practical problem‑solving mindset.

Preferred Qualifications

• Professional certification such as Chartered Financial Analyst (CFA) or Financial Risk Manager (FRM) is preferred.
• Experience with cloud platforms such as Amazon Web Services or Microsoft Azure, big data technologies or business intelligence tools is preferred.
• Experience with investment data platforms such as Bloomberg, FactSet, Morningstar, eVestment or Aladdin is preferred.
• Background in investment consulting, multi-manager investing or investment operations is preferred.

U.S. Work Authorization & Sponsorship

Applicants must have a valid work authorization that does not now, or in the future, require visa sponsorship for employment in the United States (e.g., H-1B, F-1 CPT, F-1 OPT, TN).

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 four (4) days per week, with flexibility to work from home one (1) day 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.

Base Pay Salary

The estimated base salary for this role is $140,000 - $170,000 per year. We have a pay-for-performance compensation philosophy. Your initial total compensation may vary based on job-related knowledge, skills, experience, and geographical work location. In addition, most of our roles are eligible for variable pay in the form of bonus, commissions, and/or long-term incentives depending on the role. We also have a competitive and comprehensive benefits program that supports all aspects of your health and well-being, including but not limited to vacation time, sick time, 401(k), and health, dental and life insurances.

Full-Time/Part-Time

Full time
Exempt/Non-exempt
Exempt
Job Family Group
Investment Management
Line of Business
AMINV US Asset Management
Columbia Threadneedle is a people business, and we recognise that our success is due to our talented people, who bring diversity of thought, complementary skills and capabilities. We are committed to fostering an inclusive and performance-based culture where everyone can belong, grow, contribute and realise their potential.

Columbia Threadneedle is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, military status, veteran status, genetic information, citizenship, disability status, marital status, 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.