At a Glance
- Tasks: Join a dynamic team to build and enhance customer data platforms using SQL and Python.
- Company: Be part of a leading telecoms company revolutionizing the industry with a flexible approach.
- Benefits: Enjoy fully remote work with occasional meet-ups, competitive salary, and a collaborative environment.
- Why this job: This role offers impactful work in product analytics and a chance to grow within a supportive team.
- Qualifications: 4+ years of experience in SQL, Python, DBT, and cloud technologies like Snowflake or BigQuery.
- Other info: The interview process includes discussions, technical exercises, and culture fit assessments.
The predicted salary is between 60000 - 67000 £ per year.
Role: Senior Product Analytics Engineer FULLY REMOTE (1x month in Uxbridge)
Salary: £60,000 – £67,000 (dependent on experience)
Insight into the Company:
This organisation is a large telecoms organisation that is looking to change the industry through their flexible approach! As an Analytics Engineer on their team, you will work to build the customer data platform.
The ideal candidate will be a team-player, working in a team of 10, working with and supporting different data workstreams. You will have strong communication skills to work within the team and also with stakeholders. The role will involve improving existing models to ensure they are efficient and scaled.
Role and Responsibilities:
You will ingest and transform data in snowflake using DBT
You will support the building of the data warehouse in Snowflake
You will work to sustain and implement existing ELT pipelines
Skills and Experience:
Essential to have 4+ years experience in:
SQL
Python
DBT
Cloud techs such as Snowflake, BigQuery or Databricks
Product Analytics
Experience working with data product teams
Desirable to have experience with:
CI/CD pipelines
Kafka; real-time streaming
Snowflake as a data warehouse
Interview Process:
~ There are 4 stages to the process:
# A 30 minute discussion about experience
# An hour take home exercise
# A technical interview with the Data Director and Analytics Engineer
# One hour culture fit interview
SQL Engineer - Remote employer: Harnham
Contact Detail:
Harnham Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Engineer - Remote
✨Tip Number 1
Familiarize yourself with the specific tools mentioned in the job description, like Snowflake and DBT. Having hands-on experience or projects that showcase your skills with these technologies can set you apart from other candidates.
✨Tip Number 2
Prepare for the technical interview by brushing up on your SQL and Python skills. Consider practicing common data transformation tasks and analytics problems to demonstrate your proficiency during the interview.
✨Tip Number 3
Since communication is key in this role, think of examples from your past experiences where you effectively collaborated with team members or stakeholders. Be ready to discuss how you can contribute to a positive team dynamic.
✨Tip Number 4
Research the company’s approach to product analytics and their vision for the future. Being able to articulate how your values align with theirs during the culture fit interview can significantly boost your chances of landing the job.
We think you need these skills to ace SQL Engineer - Remote
Some tips for your application 🫡
Understand the Role: Make sure to thoroughly read the job description for the Senior Product Analytics Engineer position. Highlight the key responsibilities and required skills, such as SQL, Python, and experience with Snowflake.
Tailor Your CV: Customize your CV to reflect your relevant experience in product analytics and data engineering. Emphasize your 4+ years of experience with SQL, DBT, and cloud technologies, ensuring that it aligns with the job requirements.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for analytics and your ability to work in a team. Mention specific projects where you improved data models or worked with stakeholders, demonstrating your communication skills.
Prepare for the Interview Stages: Familiarize yourself with the interview process outlined in the job description. Prepare for each stage by practicing common interview questions related to your experience and technical skills, and be ready to discuss your approach to data challenges.
How to prepare for a job interview at Harnham
✨Showcase Your Technical Skills
Make sure to highlight your experience with SQL, Python, and DBT during the interview. Be prepared to discuss specific projects where you utilized these skills, especially in relation to data ingestion and transformation.
✨Prepare for the Take-Home Exercise
The take-home exercise is a crucial part of the interview process. Practice similar exercises beforehand, focusing on building efficient ELT pipelines and working with Snowflake. This will help you feel more confident and perform better.
✨Communicate Effectively
Strong communication skills are essential for this role. During the interviews, be clear and concise when explaining your thought process and how you collaborate with team members and stakeholders.
✨Understand the Company Culture
Research the company's values and culture before the culture fit interview. Be ready to discuss how your personal values align with theirs and provide examples of how you've contributed to a positive team environment in the past.