Spectrum Search · 2 hours ago
Analytics Engineer
United States
Full-time
Remote
Mid, Senior Level
4+ years expSpectrum Search is partnering with a high-growth client in the Web3 and digital finance education sector, which is poised for significant expansion. The Analytics Engineer will play a crucial role in managing the company's data infrastructure and delivering insights to drive strategic decisions across the business.
Staffing & Recruiting
Responsibilities
Own the design and optimisation of a Snowflake data warehouse
Implement a structured Bronze → Silver → Gold architecture
Write advanced SQL to clean, transform, and aggregate data
Manage performance tuning and cost optimisation in Snowflake
Enforce governance, security, and access best practices
Set up and maintain pipelines using tools like Fivetran, Airbyte, or similar
Integrate data from marketing (Meta, Google, TikTok), CRM (e.g. HubSpot), payments (e.g. Stripe), and analytics tools
Monitor and troubleshoot data consistency and pipeline issues
Adapt to API changes and schema evolution
Build dimensional models including fact and dimension tables
Create scalable models for marketing, finance, and sales metrics
Work closely with stakeholders to translate business needs into data structures
Ensure consistency of core business metrics across the organisation
Develop dashboards using tools like Sigma, Tableau, Power BI, or Looker
Build real-time and executive dashboards across marketing, sales, and customer analytics
Maintain KPI definitions and perform ad hoc analysis as needed
Automate reporting and data sync workflows
Set up data quality checks and monitoring
Maintain documentation of pipelines, models, and metrics
Qualification
Required
4–6+ years in a role such as Analytics Engineer, BI Developer, or Data Engineer
Extensive hands-on experience with Snowflake
Built and maintained production-grade Snowflake environments
Designed high-performance schemas and queries
Advanced SQL capabilities (e.g. CTEs, window functions, joins)
Experience building ETL/ELT pipelines with modern tools
Expertise in data modeling (star schemas, fact/dimension design)
Familiarity with BI tools for dashboard development
Strong understanding of business metrics (CAC, LTV, ROAS, MRR, churn)
Excellent communication and stakeholder collaboration skills
Preferred
Hands-on with HubSpot or similar CRM systems
Scripting experience (Python or JavaScript)
Familiar with APIs, JSON handling, and version control (Git)
Knowledge of dbt (data build tool)
Experience in marketing analytics and attribution modeling
Benefits
100% remote working across a globally distributed team
High-impact role across marketing, sales, and finance analytics
Significant growth potential and career development
Dynamic, innovative, and collaborative team culture
Company
Spectrum Search
We help the world’s most ambitious Web3 companies hire the talent they need to scale. Fast.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase