• Design, build, and maintain dimensional data models in Snowflake that serve as the foundation for analytics and reporting across the company • Develop and optimize dbt models to transform raw data from systems like Salesforce, HubSpot, Recurly, and other business platforms into clean, reliable datasets • Create and maintain data documentation in Select Star and other catalog tools to ensure discoverability and understanding of our data assets • Partner with data analysts and business teams to understand their analytical needs and translate them into scalable data solutions • Implement data quality checks and monitoring to ensure accuracy and reliability of analytics datasets • Optimize SQL queries and data pipelines for performance and cost efficiency • Support strategic analytics initiatives including customer journey analysis, revenue analytics, and product usage metrics • Contribute to data governance practices including data quality standards, PII handling, and metadata management • Mentor junior team members and promote best practices in data modeling and analytics engineering