Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support data needs, build SQL queries, and collaborate with teams to deliver CRM audiences.
- Company: Join a dynamic ISIT team in a forward-thinking company.
- Benefits: Flexible work schedule with 2 days onsite and opportunities for growth.
- Why this job: Gain hands-on experience in data analysis and work with cutting-edge tools.
- Qualifications: Experience with SQL, Salesforce Marketing Cloud, and advanced Excel skills.
- Other info: Perfect for detail-oriented individuals who thrive in collaborative environments.
The predicted salary is between 28000 - 35000 £ per year.
Job Location: Rickmansworth
Duration: 12 months
Office Requirement: 2 days onsite per week (Wednesday is mandatory)
Description: We are seeking a Data Support Analyst to work within our ISIT team supporting the data requirements of our business departments. You will work closely with our business teams to understand their requirements and work with our remote technical teams to build and validate SQL queries to deliver the correct CRM audiences from within Salesforce Marketing Cloud. Reporting to our Data Lead, you will also ensure that the current technical architecture is fully understood and documented.
Skills:
- SQL
- Salesforce Marketing Cloud
- Advanced Excel Experience
- Any previous role involving analysis and segmentation of large data sets
- Preparation and validation of SQL data extract scripts
- Use of Excel pivot tables
- Demonstrable use of AI to improve functional delivery
Soft Skills:
- Attention to detail
- Communication – able to communicate technical issues with non-technical business staff, or business requirements to technical teams
- Effective working with remote teams or alone
Junior Data Analyst employer: Lorien
Contact Detail:
Lorien Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Junior Data Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those who work at companies you're interested in. A friendly chat can open doors and give you insights that job descriptions just can't.
✨Tip Number 2
Prepare for interviews by practising common questions related to data analysis and SQL. We recommend doing mock interviews with friends or using online platforms to get comfortable with your responses.
✨Tip Number 3
Showcase your skills! Create a portfolio of projects that highlight your experience with SQL, Excel, and any data analysis you've done. This will give you an edge and demonstrate your capabilities beyond just words.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take that extra step to connect with us directly.
We think you need these skills to ace Junior Data Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL, Salesforce Marketing Cloud, and Excel. We want to see how your skills match the job description, so don’t be shy about showcasing relevant projects or roles you've had!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re excited about the Junior Data Analyst role and how your background makes you a great fit. We love seeing genuine enthusiasm for the position.
Showcase Your Analytical Skills: In your application, give examples of how you've worked with large data sets and any experience you have with data analysis. We’re looking for someone who can demonstrate their analytical prowess, so don’t hold back!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy – just follow the prompts!
How to prepare for a job interview at Lorien
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss how you've used SQL in previous roles, especially in relation to data extraction and validation. Practising writing queries can also help you feel more confident.
✨Familiarise Yourself with Salesforce Marketing Cloud
Since this role involves working with Salesforce Marketing Cloud, it’s a good idea to get a basic understanding of its functionalities. If you can, try to explore its features or even take a quick online course. This will show your enthusiasm and readiness to dive into the role.
✨Showcase Your Excel Skills
Be ready to talk about your experience with Excel, particularly with pivot tables. You might even want to prepare a few examples of how you've used Excel to analyse large datasets. This will demonstrate your analytical capabilities and attention to detail.
✨Communicate Clearly and Effectively
Since the role requires liaising between technical and non-technical teams, practice explaining complex concepts in simple terms. Think of examples where you've successfully communicated technical issues to non-technical staff, as this will highlight your soft skills.