At a Glance
- Tasks: Transform CRM data into actionable insights and build AI-assisted analytics workflows.
- Company: Dynamic London-based company focused on innovative data solutions.
- Benefits: Hybrid work model, competitive salary, and opportunities for professional growth.
- Other info: Mentorship opportunities and a collaborative team environment await you.
- Why this job: Lead the future of data analytics and make a real impact with AI.
- Qualifications: Strong SQL skills, experience with cloud data warehouses, and a passion for data innovation.
The predicted salary is between 60000 - 75000 £ per year.
My client is looking for a Data Analytics Specialist to work hybrid from their office in London. You will own how my client turns CRM data into something clients can act on. Day to day, that means working across client CRM and campaign datasets, building the models and pipelines that aggregate behavioural and campaign data, and answering the questions the account and strategy teams cannot get from a dashboard alone. You will use AI to move faster; drafting and checking SQL, summarising large datasets, and surfacing patterns, while setting the rules for doing all of that safely with client data.
This is a role that sets the standard rather than follows one. You will bring modern practice into how they work: a warehouse-first approach, version-controlled and tested transformations, and AI-assisted workflows the rest of the team can pick up and trust. Where AI speeds the work up, you decide where it helps and where it must not go near client PII, and you make those guardrails real rather than theoretical.
Success in the first 6 months looks like reporting the teams trust, at least 2 AI-assisted analytics workflows other people actually adopt, and a clear, documented data governance standard across client workspaces.
Key Responsibilities- Build and own data models that aggregate CRM, campaign, and behavioural data across multiple clients into something analysts and strategists can query.
- Turn messy client data into reliable, documented, version-controlled transformations; treat pipelines as code, with tests.
- Answer the analytical questions a dashboard cannot: cohort behaviour, lifecycle value, and what actually moved a campaign metric.
- Set how my client uses AI in data work; where large language models speed up SQL, summarisation, and pattern-finding, and where they must not touch client PII.
- Validate AI-generated queries and analysis before anyone acts on them; no AI output ships unchecked.
- Define and enforce data quality and governance standards across client workspaces.
- Build repeatable, AI-assisted analytics workflows the wider team can use, not one-off scripts only you understand.
- Partner with strategy and account teams to turn findings into campaign and lifecycle decisions.
- Mentor analysts and raise the data literacy of the teams around you.
- Track modern tooling and AI capabilities, and bring the useful parts in rather than chasing every new release.
- Strong SQL and hands-on experience modelling data in a cloud warehouse such as BigQuery or Snowflake.
- Comfortable with a transformation framework such as dbt, and with treating analytics as version-controlled, tested code.
- Fluent in Python for analysis and automation.
- Deep understanding of CRM and campaign data: segmentation, lifecycle metrics, and event data from platforms like Braze.
- Practical, safe use of AI tools for data work; prompt hygiene, validating output, and clear rules for handling client PII.
- A leader and an innovator who sets the approach and brings others with them.
- Clear communicator who can explain a finding to a strategist or a client without the jargon.
- Bonus: experience with BI tools such as Looker, Tableau, or Metabase, and with reverse ETL.
- Bonus: experience building or evaluating AI-assisted internal tooling.
Data Analytics Specialist in City of London employer: MarkIT Placements
Join a forward-thinking company that values innovation and collaboration, where as a Data Analytics Specialist, you will play a pivotal role in transforming CRM data into actionable insights. With a hybrid work model based in London, you'll benefit from a supportive work culture that encourages professional growth, mentorship opportunities, and the chance to lead AI-assisted analytics workflows that enhance team efficiency. This is not just a job; it's a chance to set new standards in data governance and analytics while working alongside passionate professionals in a dynamic environment.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analytics Specialist in City of London
✨Tip Number 1
Network like a pro! Reach out to people in the industry on LinkedIn or at events. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data models and analytics projects. This gives potential employers a taste of what you can do beyond just a CV.
✨Tip Number 3
Prepare for interviews by practising common data-related questions. Think about how you’d explain complex concepts simply, as if you were talking to a client or a strategist.
✨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 are proactive!
We think you need these skills to ace Data Analytics Specialist in City of London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the Data Analytics Specialist role. Highlight your SQL skills, experience with cloud warehouses like BigQuery or Snowflake, and any AI tools you've used. We want to see how your background aligns with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data analytics and how you can bring modern practices to our team. Don't forget to mention specific projects where you've turned messy data into actionable insights.
Showcase Your Projects:If you've worked on relevant projects, make sure to include them in your application. Whether it's building data models or creating AI-assisted workflows, we want to see examples of your work that demonstrate your skills and innovation in data analytics.
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it shows you're keen on joining our team at StudySmarter!
How to prepare for a job interview at MarkIT Placements
✨Know Your Data Inside Out
Before the interview, dive deep into your understanding of CRM and campaign data. Be ready to discuss how you've modelled data in cloud warehouses like BigQuery or Snowflake. Prepare examples of how you've transformed messy data into reliable insights, as this will show your practical experience.
✨Showcase Your SQL Skills
Since SQL is a key part of the role, brush up on your SQL knowledge and be prepared to demonstrate your skills. You might be asked to write queries on the spot, so practice common scenarios you might encounter in data analytics. Highlight any AI-assisted workflows you've created using SQL.
✨Communicate Clearly and Confidently
This role requires clear communication, especially when explaining complex findings. Practice articulating your past projects without jargon, focusing on how your insights led to actionable decisions. Think about how you can convey technical concepts to non-technical stakeholders.
✨Be Ready to Discuss AI Ethics
Given the emphasis on safe AI use, prepare to discuss your approach to handling client PII and validating AI-generated outputs. Share your thoughts on setting guardrails for AI in data work and how you've implemented data governance standards in previous roles.
