Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse financial data, build dashboards, and automate reporting processes.
- Company: Join a dynamic team focused on delivering insights to clients in the UK.
- Benefits: Enjoy flexible working options and opportunities for professional growth.
- Why this job: Make an impact by transforming data into actionable insights in a collaborative environment.
- Qualifications: 4+ years in data analysis, strong SQL and Python skills, and a quantitative degree.
- Other info: Experience with AWS and CRM databases is a plus.
The predicted salary is between 36000 - 60000 £ per year.
We are seeking a highly skilled Data Analyst to join our team, working with clients in the UK. The ideal candidate will have a strong background in data analysis, visualization, and programming, with a focus on financial and investment data.
General Responsibilities:
- Collaborate with our Advisory Team business partners to understand key business objectives and define analytical frameworks and approaches to support them.
- Build advanced scripts in SQL and Python by connecting to a series of databases in the lake.
- Build advanced dashboards in PowerBI and Tableau by connecting data from D365, Datalake and Excel files.
- Iterate on existing data assets and provide quick turnarounds to ad-hoc insight requests from key Advisory Team stakeholders.
- Deliver and manage the lifecycle of a data project by working closely with both technical and non-technical across organizations and regions.
- Provide solutions to automate manual data reporting across teams who may be leveraging 3rd party data in Excel and execute.
- Document end-to-end data reporting processes managed within Advisory Team.
Key Requirements:
- Minimum 4 years’ experience in a data analyst/science role within the investment and finance industry.
- Bachelor’s and/or Masters in a highly quantitative degree discipline (e.g. Mathematics, Statistics, Finance, Computer Science or Economics) are highly desired.
- Advanced SQL, Python and Excel (VBA Macros is desirable).
- Strong proficiency in building dashboards in both PowerBI and Tableau.
- Experience in using AWS Athena and HIVE/Presto.
- Experience working within an agile framework and comfortable using project management tooling like JIRA.
- Proven experience presenting complex data finding and concepts to business stakeholders of varying levels of data literacy.
- Experience using statistical techniques and modelling is highly desirable.
- Previous exposure to working with CRM Databases, specifically D365 is highly desirable.
[20899] - Data Analyst - CONTRACT employer: Ciandt
Contact Detail:
Ciandt Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land [20899] - Data Analyst - CONTRACT
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as SQL, Python, PowerBI, and Tableau. Consider taking online courses or tutorials to sharpen your skills in these areas, as practical knowledge will set you apart during interviews.
✨Tip Number 2
Network with professionals in the finance and investment sectors, especially those who work with data analysis. Attend industry meetups or webinars to connect with potential colleagues and learn more about the challenges they face, which can help you tailor your approach when discussing your experience.
✨Tip Number 3
Prepare to discuss your previous projects in detail, particularly those that involved data visualisation and automation. Be ready to explain your thought process, the tools you used, and how your contributions led to successful outcomes, as this will demonstrate your hands-on experience.
✨Tip Number 4
Research StudySmarter and our approach to data analysis within the advisory context. Understanding our company culture and values will help you align your responses during interviews, showing that you're not just a fit for the role but also for our team.
We think you need these skills to ace [20899] - Data Analyst - CONTRACT
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data analysis, particularly within the investment and finance industry. Emphasise your skills in SQL, Python, and dashboard creation using PowerBI and Tableau.
Craft a Compelling Cover Letter: In your cover letter, explain why you are interested in this Data Analyst position and how your background aligns with the company's needs. Mention specific projects or experiences that demonstrate your ability to deliver insights and collaborate with teams.
Showcase Technical Skills: Clearly outline your technical skills in SQL, Python, and Excel, as well as your experience with AWS Athena and HIVE/Presto. Provide examples of how you've used these tools to solve problems or improve processes in previous roles.
Highlight Communication Skills: Since the role involves presenting complex data findings to stakeholders, include examples of how you've effectively communicated data insights in the past. This could be through presentations, reports, or collaborative projects.
How to prepare for a job interview at Ciandt
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, Python, and Excel in detail. Bring examples of scripts or dashboards you've built, especially those related to financial data, as this will demonstrate your hands-on expertise.
✨Understand the Business Context
Research the company and its Advisory Team's objectives. Be ready to explain how your analytical frameworks can support their goals, showing that you can bridge the gap between technical analysis and business needs.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills in real-world scenarios. Think about past projects where you had to iterate on data assets or automate reporting processes, and be ready to share these experiences.
✨Communicate Complex Ideas Simply
Practice explaining complex data findings in a straightforward manner. Since you'll be presenting to stakeholders with varying levels of data literacy, being able to simplify your insights is crucial.
