About the Opportunity
We are seeking an experienced Analytics Engineer to join our Product Analytics team. In this role, you’ll build analytics pipelines that help deliver actionable, automated user insights from product adoption data. You'll collaborate directly with product analysts, engineers, and business stakeholders to build robust data integrations, including Salesforce, Gainsight, JIRA and Github. Your work will be pivotal in empowering data-driven decisions across our organization, significantly impacting product strategy and customer engagement.
What to expect?
1. Analytics Pipelines & Data Modeling: Convert existing product analyst queries and reports into efficient and maintainable analytics pipelines primarily using dbt, and optimize data for self-service analytics in Tableau.
2. Owning Analytics Projects: Take ownership of medium-to-large analytics projects, from scoping through implementation.
3. Product Event Data: Transform and maintain scalable product adoption datasets, ensuring ease of downstream integration and rapid onboarding of new events or features.
4. Data Egestion: Develop and manage data pipelines for exporting curated datasets from Redshift to platforms like Salesforce and Gainsight using reverse ETL tools (e.g., Hightouch).
5. Data Ingestion: Own end-to-end responsibility for ingesting key productivity data from platforms such as GitHub and JIRA into the data warehouse, enabling accurate internal reporting and analysis.
6. Event Schema Management: Collaborate closely with Software Engineers and Product Analysts to define, manage, and approve event schemas in Segment, ensuring high-quality data.
What you need to be successful
Critical:
7. Analytics Engineering Experience: 5+ years of experience as an Analytics Engineer or similar role.
8. Data modeling and transformation: Expert in building scalable, maintainable analytics pipelines using dbt, SQL, and Jinja for effective data modeling and transformation.
9. Query performance optimization: Skilled at optimizing datasets for fast, efficient querying in enterprise-scale data warehouses such as AWS Redshift.
10. Reverse ETL and integrations: Practical knowledge of reverse ETL tools like Hightouch for delivering curated datasets to systems including Salesforce and Gainsight.
11. Event Data Management: Adept at working with product event data—defining schemas, validating inputs, and transforming raw events into structured analytics-ready formats.
12. Cross-functional collaboration: Confident when engaging with analysts, engineers, product managers, and business stakeholders to gather requirements and deliver actionable insights.
Desirable:
13. BI tooling and performance: Well-versed in BI platforms such as Tableau, with a focus on optimizing underlying data structures for dashboard performance.
14. Ingestion and orchestration tools: Skilled in using pipeline orchestration and data ingestion tools such as Airflow and Stitch, along with Python scripting for integrating diverse data sources.
15. Large-scale data processing: Proficient with distributed query engines like AWS Athena or SparkSQL for working with datasets at the scale of billions of rows.
16. Event streaming data: Experienced in working with live streamed event data, including transforming and modeling real-time inputs for analytics pipelines.
17. LLMs and unstructured data: Able to apply LLM APIs and vector databases to analyze unstructured inputs, including customer call transcripts.
18. Testing and containerization: Comfortable using Docker for local pipeline testing and writing comprehensive dbt tests for analytics workflows.
What's in it for you?
19. Join an ambitious tech company reshaping the way people build digital experiences
20. Full-time employees receive Stock Options for the opportunity to share in the success of our company
21. Fertility and family building benefits, including a lifetime reimbursable wallet to support your growing family.
22. We value Work-Life balance and You Time!A generous amount of paid time off, including vacation days, sick days, education days, compassion days for loss, and volunteer days
23. Use your personal annual education budget to improve your skills and grow in your career
24. Enjoy a full range of virtual and in-person events, including workshops, guest speakers, and fun team activities, supporting learning and networking exchange beyond the usual work duties
25. An annual wellbeing stipend to care for your physical, financial, or emotional health
26. A monthly communication phone/internet stipend and phone hardware upgrade reimbursement.
27. New hire office equipment stipend for hybrid or distributed employees. Get the gear you need to work at your best.
#LI-Hybrid #LI-AT1