Senior Analytics Engineer

Summary

Join Chili Piper, a fast-growing B2B SaaS startup, as a Senior Analytics Engineer. You will play a key role in driving data-driven decision-making by designing, implementing, and extending our data model. Collaborate with Data Engineers and business stakeholders to define solutions for operational efficiencies and analytic insights. This role balances impactful new development with addressing business user requests. You will work with various business functions and mentor colleagues. Chili Piper offers a fully remote global team environment with numerous benefits.

Requirements

• 5+ years in the Data space as an analyst, engineer, scientist, or equivalent
• 5+ years experience designing, implementing, operating, and extending commercial enterprise dimensional models
• 5+ years working with a large-scale (1B+ Rows) Data Warehouse, preferably in a cloud environment
• Demonstrated experience leading 4 or more analytics projects from beginning to operationalization
• Demonstrated experience designing and socializing Entity Relationship Diagrams and reference SQL scripts to scale data acumen and adoption
• Experience working with commercial data warehouses, ETL tools, and data visualization tools
• Extensive experience in 2 or more major data subject areas (marketing, sales, finance, product, people, etc.)
• Strong knowledge of common data integration patterns (CDC, ELT, etc.)
• You thrive in ambiguous situations and possess a proactive problem-solving attitude, taking ownership where required
• You can communicate effectively with both business stakeholders and technical peers

Responsibilities

• Collaborate with team members to collect business requirements, define successful analytics outcomes, and design data models which support those initiatives
• Develop an understanding of our data model and optimize our data models and pipelines for scale
• Design & build data models using SQL, dbt and Snowflake
• Create and maintain architecture and systems documentation
• Improve existing systems' performance, observability, reliability, and scalability
• Own one or more stakeholder relationship in Operations, Sales, Marketing, Product and Customer Success business functions
• Develop and maintain a scalable, robust and efficient data platform serving analytic and operational needs across the organization
• Work independently and share your knowledge across the business and mentor colleagues in areas of deep technical expertise

Preferred Qualifications

• Experience with batch / streaming services
• Fluent SQL Skills with an additional competency in any scripting language
• Strong perspective on analytics engineering development cycle (data modeling, version control, documentation + testing, best practices for codebase development)
• Knowledge in modern and classic Data Modeling - Kimball, Data Vault, OBT etc
• Experience with the modern data stack (Fivetran / Snowflake / dbt / Looker / Hightouch or equivalents)
• Experience with product / marketing analytics would be an asset

Benefits

• Unlimited vacation (and we do mean it, and we do take it!)
• Generous health, dental, and vision insurance
• Any equipment/software/tech that you need to do your job
• Annual professional development stipend of $2,000 USD
• Equity - all Pipers receive stock options
• Annual company retreat for a week of bonding and adventure (previous retreat locations include Paris, Morocco, Tulum, Iceland, Ibiza, and India!)
• Competitive pay based on market rate wherever you live
• Freedom and flexibility. We’re a 100% distributed team working from around the world, and we've been fully remote since 2016. Our team members can work from wherever they want in the world, as long as they show up on our weekly all hands meeting on Zoom