Develop a deep understanding of our data tech stack, key data sources, and business domain to become a go-to resource for data questions across the organization
Own and evolve our dbt project — improving model structure, documentation, testing coverage, and overall warehouse architecture
Write performant, scalable SQL that integrates complex data from multiple sources into reliable tables and views that power critical business decisions
Monitor and optimize Snowflake costs through query optimization, warehouse tuning, clustering strategies, and proactive recommendations
Partner with analysts, data scientists, and business stakeholders to translate business requirements into well-modeled, reusable data assets
Establish and enforce best practices for data modeling, code review, testing, and documentation across the BI team
Identify and resolve data quality issues, building robust testing frameworks to ensure data accuracy and consistency
Contribute to the roadmap for our data platform, evaluating new tools and technologies as the business scales

8+ years of experience in data analytics, analytics engineering, or data engineering
Expert-level SQL skills with proven ability to model complex, high-volume datasets in a cloud data warehouse (Snowflake strongly preferred)
Hands-on experience with dbt (Core or Cloud), including advanced features such as macros, tests, snapshots, and incremental models
Familiarity with data visualization and BI tools such as Sigma, Tableau, or Power BI
Experience with Python for data transformation, scripting, or pipeline work is a plus
Background in financial data, pipeline modeling, or SaaS/fintech analytics strongly preferred
Strong analytical thinking and attention to detail — you can trace a data problem from a dashboard all the way back to source systems
Excellent communication skills with the ability to explain technical concepts to non-technical stakeholders and translate business needs into data solutions
Comfortable working autonomously in a fast-paced, remote-first environment while collaborating closely with cross-functional teams
US-based; ability to work from our New York office is a plus.

Octus

Open Positions (1)