Senior Analytics Engineer

Summary

Join Smartsheet as a Senior Analytics Engineer and lead the development and maintenance of a scalable analytics system. You will transform raw data into usable datasets for various teams, architect efficient data transformation systems within Snowflake, and collaborate with BI analysts and data scientists. This role involves fostering data democratization, ensuring data accessibility, and driving business outcomes. The position reports to the Director of Analytics Engineering and offers remote work options within the US. You will be responsible for data quality, observability, and compliance. Smartsheet offers a competitive salary and a comprehensive benefits package.

Requirements

• 10+ years of experience in advanced data modeling using Data Vault (DV 2.0), dbt, and Snowflake
• Proven experience in building analytics systems with data transformation, dependency, and workload management (Data Vault, AutomateDV, dbt core, Airflow, Snowflake, GitLab, SQL)
• Proven experience with building and maintaining business analytics layers and semantic layers to enable self-service for non-technical end-users
• Strong production experience supporting and maintaining analytics/data warehouse solutions with mission-critical datasets
• Familiarity with data governance principles for maintaining datasets to enable a single source of truth
• Familiarity with self-serve product analytics tools (Amplitude, Thoughtspot, Tableau, Gainsight, etc.)
• Knowledge of code management and CI/CD practices (GitLab, Airflow, Snowflake, Terraform)
• Familiarity with AWS solutions such as S3, EC2, VPC

Responsibilities

• Lead the implementation of efficient and scalable systems that optimize data transformations from our data lake in Snowflake into clean, documented data products
• Contribute to the design standards and architectural principle standards, designs and processes
• Build and maintain a governed, robust, reliable, and scalable analytics system (DW/DV)
• Collaborate with BI analysts and data scientists to provide proper data accessibility guidelines
• Foster data democratization via activation of data on critical platforms like Smartsheet platform, Amplitude, Thoughtspot, Gainsight
• Create and contribute to frameworks that improve data quality and observability to identify and resolve issues faster
• Create and implement data testing plans, encompassing data validation, data quality assessment, and regression testing, to identify anomalies, inconsistencies, or errors in produced datasets
• Mentor and guide teams and help drive high standards across the team by conducting design reviews and engineering ideation forums
• Collaborate with cross-functional teams to assess data privacy needs and define data masking strategies aligned with industry compliance standards (e.g., GDPR, HIPAA, CCPA)

Benefits

• HSA, 100% employer-paid premiums, or Buy-up medical/vision and dental coverage options for full-time employees
• 401k Match to help you save for your future (50% of your contribution up to the first 6% of your eligible pay)
• Monthly stipend to support your work and productivity
• Flexible Time Away Program, plus Sick Time Off
• US employees are automatically covered under Smartsheet-sponsored life insurance, short-term, and long-term disability plans
• US employees receive 12 paid holidays per year
• Up to 24 weeks of Parental Leave
• Personal paid Volunteer Day to support our community
• Opportunities for professional growth and development including access to Udemy online courses
• Company Funded Perks, including a counseling membership, local retail discounts, and your own personal Smartsheet account
• Teleworking options from any registered location in the U.S. (role specific)