At a Glance
- Tasks: Design and implement data solutions for personalised customer experiences while ensuring data quality.
- Company: Join a forward-thinking company in the heart of London with a hybrid work culture.
- Benefits: Enjoy competitive pay, flexible working, and opportunities for professional growth.
- Why this job: Make an impact by transforming raw data into actionable insights and empowering analytics.
- Qualifications: Strong SQL skills and experience with dbt, data warehousing, and BI tools required.
- Other info: Collaborative environment with a focus on innovation and career advancement.
The predicted salary is between 36000 - 60000 £ per year.
We are looking for a Data Engineer who will design and implement customer data solutions that enable personalised experiences while ensuring privacy, quality, and accessibility of customer information across all touchpoints.
Length: 12 months
Location: London, UK
Environment: Hybrid - 2-3 days in the office
Key responsibilities:
- Develop and maintain dbt models that transform raw data into trusted datasets for analytics and business intelligence
- Implement data quality tests and monitoring to ensure accuracy and reliability
- Optimise query performance using effective data modelling and materialisation strategies
- Establish and maintain documentation and data dictionaries for analytical models, KPI definitions and metrics frameworks
- Conduct exploratory data analysis to identify trends, patterns, and anomalies in business performance
- Build interactive dashboards and reports that empower self-service analytics
- Design visualizations that clearly communicate complex data stories to both technical and non-technical audiences
What is required to be successful in this role:
- Strong SQL skills with experience in complex data transformations, CTEs and window functions
- Expertise with dbt and modern analytics engineering tools
- Solid understanding of dimensional modelling and data warehousing concepts
- Experience with Git-based workflows for version control and collaboration for analytics
- Knowledge of data testing frameworks and quality assurance practices
- Experience with Snowflake, Databricks, or similar data platforms
- Proficiency in Looker or similar BI tools (Tableau, Power BI)
Data Analytics Engineer in City of London employer: Morson Edge (Technology)
Contact Detail:
Morson Edge (Technology) Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analytics Engineer in City of London
✨Tip Number 1
Network like a pro! Reach out to folks in the data analytics space on LinkedIn or at local meetups. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your dbt models, dashboards, and any cool projects you've worked on. This gives potential employers a taste of what you can do beyond just your CV.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and data modelling concepts. Be ready to discuss how you've tackled data quality issues or optimised query performance in past roles.
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are genuinely interested in joining us at StudySmarter. Plus, it makes tracking your application super easy!
We think you need these skills to ace Data Analytics Engineer in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the role of Data Analytics Engineer. Highlight your SQL skills, experience with dbt, and any relevant projects that showcase your ability to transform raw data into trusted datasets.
Craft a Compelling Cover Letter: Use your cover letter to tell us why you're passionate about data analytics and how your background aligns with our mission. Share specific examples of how you've implemented data quality tests or built interactive dashboards in the past.
Showcase Your Technical Skills: Don’t shy away from listing your technical proficiencies! Mention your experience with Git workflows, Snowflake, and any BI tools like Looker or Tableau. We want to see how you can hit the ground running!
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates!
How to prepare for a job interview at Morson Edge (Technology)
✨Master Your SQL Skills
Make sure you brush up on your SQL skills before the interview. Be ready to discuss complex data transformations, CTEs, and window functions. Practising some real-world scenarios can help you articulate your thought process during the interview.
✨Showcase Your dbt Expertise
Since dbt is a key part of the role, be prepared to talk about your experience with it. Bring examples of dbt models you've developed and how they transformed raw data into trusted datasets. This will demonstrate your hands-on experience and understanding of modern analytics engineering tools.
✨Understand Data Quality Assurance
Familiarise yourself with data quality tests and monitoring practices. Be ready to discuss how you ensure accuracy and reliability in your work. Sharing specific examples of how you've implemented these practices in past projects will show your commitment to data integrity.
✨Communicate Complex Data Stories
Prepare to explain how you design visualisations that cater to both technical and non-technical audiences. Think of examples where your dashboards or reports empowered self-service analytics. This will highlight your ability to make data accessible and actionable for everyone.