Responsibilities- Own the design, development, and maintenance of data models within Snowflake that serve as the foundation for business metrics, reporting, and analytics across the organization
- Partner closely with business stakeholders to translate operational definitions and KPIs into reliable, well-documented data structures
- Build and maintain dbt models that power our core metrics layer, ensuring accuracy, consistency, and reusability across teams
- Manage and evolve our Snowflake data warehouse, including schema design, performance optimization, and data organization best practices
- Collaborate with analytics and BI teams to ensure the data layer supports self-serve reporting and business review cadences
- Contribute to data modeling standards and best practices that allow the team to scale with confidence
- Participate in strategic discussions around data architecture and help evaluate trade-offs across build vs. buy decisions
Requirements - 5+ years of experience in a data engineering or analytics engineering role
- Strong proficiency in SQL and hands-on experience with Snowflake, including warehouse management, query optimization, and data modeling patterns
- Experience with dbt (Core or Cloud) for building and maintaining modular, tested transformation pipelines
- Demonstrated ability to work closely with business stakeholders to define and implement metrics and data definitions - not just build pipelines
- Solid understanding of dimensional modeling, data vault, or other warehouse modeling approaches
- Experience with workflow orchestration tools such as Airflow, Dagster, or Prefect - you'll be creating and improving the DAGs that drive our Snowflake pipelines end to end.
- Hands-on experience with AWS data services - S3, MWAA, and CloudWatch - supporting production data pipelines in a cloud-native environment.
- Ability to work through ambiguity and exercise good judgment when translating loosely defined business requirements into structured data models
- Bachelor's degree in Computer Science, Engineering, Math, or a related field, or equivalent practical experience
The base salary range for this role varies by location and is aligned to market benchmarks.
- Candidates located in higher-cost labor markets, including California, Washington, New York, New Jersey, Connecticut, Massachusetts, and Washington, DC represent the middle to high end of the range, while candidates located in all other U.S. locations represent the low to middle end of the range.
- Final compensation is determined based on location, experience, skills, and internal equity.
This role is eligible for a
10% target annual bonus, resulting in the following
base salary and
Total Target Compensation (TTC) ranges:
- Base Salary: $160,000 - $174,000
- TTC: $176,000 - $191,400
*Total Target Compensation (TTC): Total Cash Compensation (including base pay, variable pay, commission, bonuses, etc.) Additionally, stock options, paid benefits, and employee perks are part of your total rewards.
Working at Cleerly takes HEART. Discover our Core Values:- H: Humility- be a servant leader
- E: Excellence- deliver world-changing results
- A: Accountability- do what you say; expect the same from others
- R: Remarkable- inspire & innovate with impact
- T: Teamwork- together we win
Don't meet 100 percent of the qualifications? Apply anyway and help us diversify our candidate pool and workforce. We value experience, whether gained formally or informally on the job or through other experiences. Job duties, activities and responsibilities are subject to change by our company.
