Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support the risk management team by extracting and compiling data for reports.
- Company: Join a dynamic team focused on risk management and data analytics.
- Benefits: Gain hands-on experience with SQL, Google Sheets, and BigQuery in a supportive environment.
- Why this job: Perfect for early-career data enthusiasts wanting to grow their skills and make an impact.
- Qualifications: Basic SQL knowledge, proficiency in Google Sheets, and a keen eye for detail required.
- Other info: This is a 3-month role based in London, ideal for students or recent graduates.
We are looking for a motivated Junior Data Analyst to support our risk management team by extracting and compiling data for monthly risk reports. This is an excellent opportunity for someone early in their data career who wants to develop their skills in SQL, Google Sheets, and working with large datasets like those in BigQuery, while gaining exposure to risk management practices.
Key Responsibilities:
- Assist in extracting data from the central Risk system using SQL queries.
- Compile and organize data manually into monthly risk management reports using Google Sheets.
- Work closely with senior team members to ensure data accuracy and consistency.
- Learn to handle large datasets using BigQuery under guidance.
- Maintain strong attention to detail in all data-related tasks.
- Support ongoing efforts to improve reporting processes within the team.
Must-Have Qualifications:
- Basic experience with SQL and comfort writing simple queries.
- Proficiency in Google Sheets including functions and data organization.
- Willingness to learn and develop skills in BigQuery or similar data platforms.
- Strong attention to detail and a methodical approach to work.
- Good communication skills and ability to collaborate effectively in a team.
- Some familiarity or interest in risk management or financial services.
- Exposure to or interest in data visualization tools such as Google Data Studio, Tableau, or Power BI.
- Experience or coursework involving data analysis or reporting.
Data Analytics Specialist employer: Emagine Consulting
Contact Detail:
Emagine Consulting Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analytics Specialist
✨Tip Number 1
Familiarise yourself with SQL and Google Sheets before applying. Brush up on your skills by completing online tutorials or courses, as this will not only boost your confidence but also show us your commitment to the role.
✨Tip Number 2
Network with professionals in the data analytics field, especially those who work in risk management. Engaging with them on platforms like LinkedIn can provide you with insights into the industry and potentially lead to referrals.
✨Tip Number 3
Demonstrate your attention to detail by preparing a small project or case study that showcases your ability to compile and analyse data. This practical example can be a great conversation starter during interviews.
✨Tip Number 4
Stay updated on the latest trends in data analytics and risk management. Being knowledgeable about current tools and practices will help you stand out and show us that you're genuinely interested in the field.
We think you need these skills to ace Data Analytics Specialist
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL and Google Sheets. Include any coursework or projects that demonstrate your data analysis skills, especially those related to risk management or financial services.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and how it aligns with your career goals. Mention your willingness to learn BigQuery and your interest in improving reporting processes, as these are key aspects of the job.
Showcase Attention to Detail: Provide examples in your application that demonstrate your strong attention to detail. This could be through previous work experiences or academic projects where accuracy was crucial.
Highlight Team Collaboration: Mention any experiences where you successfully collaborated with others, as good communication skills and teamwork are essential for this role. This could include group projects or team-based activities.
How to prepare for a job interview at Emagine Consulting
✨Showcase Your SQL Skills
Be prepared to discuss your experience with SQL, even if it's basic. You might be asked to explain how you would write a simple query or solve a data-related problem. Brush up on your SQL knowledge and think of examples where you've used it.
✨Demonstrate Google Sheets Proficiency
Since the role involves compiling data in Google Sheets, make sure you can confidently talk about functions and data organisation techniques. Consider preparing a small example or two that showcases your skills, such as using pivot tables or conditional formatting.
✨Express Your Willingness to Learn
The company values candidates who are eager to develop their skills, especially in BigQuery. Be ready to discuss how you approach learning new tools and technologies, and share any relevant experiences where you've successfully picked up new skills.
✨Highlight Attention to Detail
Attention to detail is crucial for this role. Prepare to give examples of how you've ensured accuracy in your previous work or projects. This could include double-checking data entries or implementing processes to maintain data integrity.
