Architect and maintain robust, modular data models in Snowflake using dbt, following industry-standard modeling methodologies (e.g., Kimball).
Write and tune advanced SQL to ensure optimal query performance, cost-efficiency, and resource management within the Snowflake environment.
Implement and manage automated testing, monitoring, and alerting frameworks to ensure data accuracy, freshness, and lineage.
Partner with business units to define KPIs, capture requirements, and translate business logic into technical data specifications.
Own the full data lifecycle from ingestion to production-grade data marts and strategic BI visualizations and dashboard building.
Apply software engineering best practices to data development, including version control (Git), CI/CD, and detailed technical documentation.
Continuous refactoring of legacy code and data structures to improve maintainability and scalability of the analytics stack.

Requirements

Mastery of complex SQL, including window functions, CTEs, and performance tuning for large-scale datasets.
Proven experience building production-grade dbt projects, including macros, seeds, and testing suites.
Strong understanding of Snowflake-specific features such as clustering, virtual warehouses, and zero-copy cloning.
Deep knowledge of dimensional modeling, fact/dimension design, and data warehousing principles.
Availability in US Eastern (EST) hours.
Ability to understand organizational drivers and communicate technical details effectively to non-technical stakeholders.
Strong problem-solving skills with the ability to identify root causes in data discrepancies or performance bottlenecks.

Benefits

Comprehensive health benefits - Medical, Vision, Dental
Flexible work schedule
Generous 401k matching up to 6%
20 days paid time off
15 sick days
12 company-paid holidays
Childcare expense reimbursement
Fitness and cell phone reimbursement
Birthday time off
Competitive salary - We publish salary ranges to promote transparency and ensure fair compensation. Final offers are based on skills, experience, and internal equity.
This role may require occasional domestic and international travel. All standard travel expenses will be covered in accordance with the company's travel reimbursement policy.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdbtdata modelingperformance tuningdata warehousingdimensional modelingversion controlCI/CDdata lifecycle managementautomated testing

Soft Skills

problem-solvingcommunicationcollaborationorganizational understanding