Senior Data Engineer/Analyst (Remote)
Deako is a leading provider of lighting control devices, dedicated to delivering exceptional value and quality to our customers. With a commitment to innovation and excellence, we have established ourselves as a trusted partner in the residential home building industry. Position Overview: We're looking for a hybrid Senior Data Engineer / Analyst to join our Operations and Analytics team, where we're building the data engine that drives decision-making across the business. This isn't just about reportswe're here to turn messy, siloed data into actionable and reliable insights. We partner closely with leaders across GTM, Finance, Supply Chain, and Product to make data a strategic asset that's trusted, accessible, and impactful.
What You'll Do
You'll own the full stackfrom ingesting raw data to delivering polished dashboards and analysis. That includes:
- 30% Design, build, and monitor ELT pipelines that land data from NetSuite, HubSpot, product logs, and other systems into Snowflake via dbt, Fivetran & Celigo.
- 25% Own our dbt project: create welltested, documented models that power selfservice reporting and satisfy dimensional/semantic layer needs.
- 20% Create exploratory analyses and stakeholderready dashboards in Hex (and occasionally Looker/Tableau/Power BI) that illuminate operational KPIs across revenue, supply chain, forecasting, and e-commerce.
- 15% Establish dataquality SLAs and alerting (Snowflake tasks, dbt tests, Monte Carlo/Great Expectations, etc.) to keep trust high.
- 10% Evangelize best practices: version control, CI/CD for analytics code, and analyticsengineering mindset across the company.
What We're Looking For
- 5+ years in data engineering/analytics, with at least 2 years owning a modern cloud warehouse (Snowflake/BigQuery/Redshift).
- Demonstrated experience with Fivetran or similar SaaS ELT tools; bonus points for Celigo flows.
- Strong command of SQL, Python (or dbt Jinja), and Git workflows.
- Deep hands-on experience with dbtyou know your staging, intermediate, and mart layers and insist on tests + docs.
- Comfort in a notebook-based exploration environment (Hex or similar); you can translate ambiguity into sharp narratives with Markdown and visualizations.
- Familiarity with business metrics, especially those tied to GTM operations, finance, and e-commerce.
- Proven ability to collaborate with non-technical stakeholders to clarify vague requests and deliver data products that drive action.
- Bonus: experience with orchestration tools (Airflow/Prefect), dbt Cloud, Monte Carlo/Great Expectations, or reverseETL (e.g., Hightouch, Census).
What Success Looks Like (612 Months In)
- Stakeholders trust the dataand data quality alerts catch issues before they do.
- Your dbt models and dashboards enable leaders to make decisions fastnot wade through stale reports.
- The executive dashboard pulls daily from Snowflake with Apply tot his job