- Company Name
- Decentralized Masters
- Job Title
- Analytics Engineer
- Job Description
-
Job Title: Analytics Engineer
Role Summary:
Design and operate end‑to‑end data pipelines and a Snowflake warehouse to deliver timely, high‑quality data for executive dashboards and business insights across marketing, sales, and finance functions.
Expectations:
- Own the Snowflake architecture, data models, and governance.
- Deliver reliable, optimized data extracts from CRM, advertising, and payment platforms.
- Present clear, actionable metrics to leadership with minimal manual intervention.
Key Responsibilities:
- • Architect, maintain, and scale Snowflake environment (schemas, warehouses, roles).
- • Implement Bronze‑Silver‑Gold data layering and enforce data governance/security.
- • Build and optimize advanced SQL queries for data transformation and aggregation.
- • Configure and monitor ETL/ELT tools (Fivetran, Airbyte, Stitch) to ingest HubSpot, Meta, Google, TikTok, Stripe, and analytics sources.
- • Design dimensional models (star schemas, fact/dimension tables) and standard business metrics (CAC, LTV, ROAS, MRR, ARR, churn).
- • Develop and maintain dashboards in Sigma, Tableau, Power BI, Looker, or similar for marketing, sales funnel, customer analytics, and revenue KPIs.
- • Implement automation, data quality checks, alerts, and versioned documentation for all pipelines and models.
- • Collaborate with stakeholders, translate business requirements into scalable data structures, and communicate insights to non‑technical audiences.
Required Skills:
- 4‑6+ years in Analytics Engineering/ Data Engineering/ BI Development.
- Expert‑level proficiency with Snowflake (architecture, warehouse sizing, query tuning).
- Advanced SQL: complex joins, CTEs, window functions, optimization.
- ETL/ELT pipeline experience (Fivetran, Airbyte, Stitch).
- Dimensional data modeling (star schema, fact & dimension tables).
- BI dashboarding (Sigma, Tableau, Power BI, Looker).
- Strong business acumen: marketing metrics (CAC, LTV, ROAS), SaaS metrics (MRR, ARR, churn).
- Excellent written & verbal communication; ability to explain technical concepts to non‑technical stakeholders.
Preferred Skills:
- HubSpot or equivalent CRM data experience.
- Scripting in Python or JavaScript for automation.
- Workflow automation tools familiarity.
- API integration knowledge.
Required Education & Certifications:
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field (or equivalent professional experience).
- Industry certifications in Snowflake, SQL, or Data Engineering are a plus.