Sr. Analytics Engineer

About the position

Smartsheet is hiring a Senior Analytics Engineer to lead the way in data-driven decision-making. You will be responsible for the creation and maintenance of a governed, reliable, and scalable analytics system, transforming raw data into usable datasets for DS/ML, analytics, and reporting. A key aspect of this role is leading the architecture and implementation of efficient data transformation systems within Snowflake, fostering data democratization and impacting business outcomes. Working closely with BI analysts and Data scientists, you will ensure data accessibility and drive activation on critical customer-facing platforms.

Responsibilities

• Leading 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).
• Collaborating 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).

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.

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)
• Smartsheet provides a competitive base salary range for roles that may be hired in different geographic areas we are licensed to operate our business from.