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!