At a Glance
- Tasks: Join a dynamic team to optimize product operations and manage critical data assets.
- Company: Work with an innovative client focused on enhancing their product team.
- Benefits: Enjoy remote work flexibility and the chance to collaborate globally.
- Why this job: Make a real impact by bridging business challenges with technical solutions in a supportive environment.
- Qualifications: 3+ years of experience with advanced SQL and cloud data warehouses required.
- Other info: Lead complex analytics projects and establish best practices in a collaborative setting.
The predicted salary is between 48000 - 72000 £ per year.
We\’re working with a client who is looking for innovation within their product team. My client is looking for a Senior Analytics Engineer who will play a pivotal role in scaling and optimizing the Product Operations (Prod Ops). This role is responsible for building and maintaining high-value data assets, defining and implementing analytics development strategies, and ensuring consistent operational excellence within a remote, global environment.
THE ROLE AND RESPONSIBILITIES
-
Partner with technical and non-technical stakeholders to bridge the gap between business challenges and technical solutions.
-
Own and maintain core Product Operations data assets that serve as the Source of Truth for critical business questions.
-
Develop scalable data models to facilitate efficient and high-performance analysis of HubSpot\’s products and operations.
-
Curate, organize, and document data and reporting environments across Looker, dbt, and Amplitude.
-
Collaborate with Business Intelligence (BI) and Data Engineering teams to enhance data accessibility and infrastructure.
-
Define and promote best practices for SQL query optimization, data modeling, and analytics development within Snowflake SQL, dbt, LookML, and Git.
-
Establish team-wide coding standards, documentation processes, and development best practices, including code reviews and testing frameworks.
-
Lead requirement gathering with stakeholders and guide projects through their entire lifecycle, ensuring clear roadmaps and alignment across teams.
-
Deep understanding of analysts\’ workflows involving both structured and unstructured datasets.
-
Exceptional ability to document technical designs, ensuring clarity and usability across teams.
-
3+ years of hands-on experience with advanced SQL, cloud data warehouses (e.g., Snowflake, Redshift, BigQuery), and relational databases.
-
Proficiency in GitHub Enterprise for code management, peer reviews, version control, and conflict resolution.
YOUR EXPERIENCE AND QUALIFICATIONS
-
Proven experience leading the technical execution of high-complexity analytics projects using advanced SQL techniques (e.g., CTEs, nested queries).
-
Strong understanding of complex datasets, software development lifecycle (SDLC), and best practices in data engineering.
-
Experience building and optimizing data pipelines, architectures, and entity relationships using tools like Lucidchart.
-
Familiarity with multi-step ETL/ELT processes, job scheduling systems, and the ability to reverse-engineer/refactor existing technical projects.
-
Conceptual knowledge of Looker (LookML, Looks, Dashboards) or other BI tools like Tableau, Qlik, or Power BI.
Please click on the link and apply to the role!
Analytics Engineer (Contract) employer: Harnham
Contact Detail:
Harnham Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Analytics Engineer (Contract)
✨Tip Number 1
Make sure to familiarize yourself with the specific tools mentioned in the job description, such as Looker, dbt, and Snowflake. Having hands-on experience or even personal projects showcasing your skills with these tools can set you apart from other candidates.
✨Tip Number 2
Highlight your experience in bridging the gap between technical and non-technical stakeholders. Prepare examples of past projects where you successfully communicated complex data insights to non-technical teams, as this is a key aspect of the role.
✨Tip Number 3
Demonstrate your understanding of best practices in SQL query optimization and data modeling. Consider preparing a brief presentation or document that outlines your approach to optimizing queries and how it has positively impacted previous projects.
✨Tip Number 4
Showcase your ability to document technical designs clearly. Bring examples of documentation you've created in the past, as clarity and usability are crucial for collaboration across teams in this role.
We think you need these skills to ace Analytics Engineer (Contract)
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and requirements of the Senior Analytics Engineer position. Familiarize yourself with key terms like SQL, data modeling, and analytics development strategies.
Tailor Your CV: Customize your CV to highlight relevant experience in analytics projects, particularly those involving advanced SQL and cloud data warehouses. Emphasize your ability to bridge technical and non-technical stakeholders.
Craft a Strong Cover Letter: Write a cover letter that showcases your passion for data engineering and analytics. Mention specific projects where you've successfully implemented best practices in SQL query optimization or data pipeline architecture.
Showcase Technical Skills: In your application, clearly outline your technical skills, especially your experience with tools like Snowflake, dbt, and GitHub. Provide examples of how you've used these tools to solve complex business challenges.
How to prepare for a job interview at Harnham
✨Understand the Role and Responsibilities
Make sure you have a clear understanding of the role's responsibilities, especially around building and maintaining data assets. Be prepared to discuss how your previous experiences align with these tasks.
✨Showcase Your Technical Skills
Be ready to demonstrate your proficiency in advanced SQL and cloud data warehouses. Prepare examples of past projects where you've successfully implemented complex analytics solutions.
✨Prepare for Collaboration Questions
Since this role involves partnering with both technical and non-technical stakeholders, think of examples that showcase your ability to bridge gaps between business challenges and technical solutions.
✨Discuss Best Practices
Familiarize yourself with best practices in SQL query optimization and data modeling. Be prepared to discuss how you have defined and promoted these practices in your previous roles.