At a Glance
- Tasks: Join our Data Engineering team to shape data and analytics for investment strategies.
- Company: Columbia Threadneedle Investments, a global leader in financial services.
- Benefits: Full-time role with competitive salary, career growth, and flexible working options.
- Other info: Collaborative culture with opportunities to work across global teams.
- Why this job: Make a real impact by translating complex data into actionable insights.
- Qualifications: Experience in data analytics and strong skills in Python, R, and SQL.
The predicted salary is between 63000 - 77000 £ per year.
About Columbia Threadneedle Investments
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 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.
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
- Prior 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.
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.
Full‑Time/Part‑Time
Full time Worker Sub Type Permanent Job Family Group Investment 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. We appreciate that work‑life balance is an important factor for many when considering their next move so please discuss any flexible working requirements directly with your recruiter.
Columbia Threadneedle Investments is an equal opportunity employer. We consider all qualified applicants without regard to racial or ethnic background, religion or belief, sex or gender, nationality, genetic information, age, sexual orientation, gender identity, disability, marital status, pregnancy or maternity 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 aid your participation in the application or interview process, speak to your recruiter to discuss how we can support you.
Data, Analytics & Reporting Analyst - Data Engineering Team employer: Columbia-Threadneedle-Investments
Columbia Threadneedle Investments is an exceptional employer, offering a dynamic work environment in Edinburgh where collaboration and professional growth are at the forefront. With a strong commitment to inclusivity and employee development, you will have access to diverse career opportunities and the chance to work alongside a global team of experts in the investment sector. The company values work-life balance and provides flexibility, ensuring that you can thrive both personally and professionally while contributing to meaningful client solutions.
Contact Details:
Columbia-Threadneedle-Investments Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Data, Analytics & Reporting Analyst - Data Engineering Team
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Columbia-Threadneedle-Investments!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data, Analytics & Reporting Analyst - Data Engineering Team at Columbia-Threadneedle-Investments.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Columbia-Threadneedle-Investments.
✨Apply Directly through Our Website
When you find a suitable opening like Data, Analytics & Reporting Analyst - Data Engineering Team at Columbia-Threadneedle-Investments, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data, Analytics & Reporting Analyst - Data Engineering Team
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Columbia-Threadneedle-Investments, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Columbia-Threadneedle-Investments. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Columbia-Threadneedle-Investments
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Columbia-Threadneedle-Investments!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
