Smartsheet is looking for a Data Analytics Engineer to be responsible for the structure, design, and operations of the Plan Insights team enrichment tables, to ensure data accessibility and efficiency for stakeholders across Smartsheet. 

The Data Analytics Engineer will implement an efficient/scalable system of schemas and tables to optimize transforming data from its raw form in Snowflake, into clean and documented datasets for use by analytics stakeholders. Working with the BI team, the engineer will ensure the team has the required data in the proper format to be ingested into a variety of customer data platforms.

In 2005, Smartsheet was founded on the idea that teams and millions of people worldwide deserve a better way to deliver their very best work. Today, we deliver a leading cloud-based platform for work execution, empowering organizations to plan, capture, track, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

This full-time position reports to the BI Operations Manager and is based in Smartsheet’s corporate offices in Bellevue, WA, or you may work remotely from anywhere in the US where Smartsheet is a registered employer.

Our team focuses on distributed decision making that rewards ownership, transparency, and collaboration. Learn more about our platform here: Smartsheet Overview Video

You Will:

  • Develop enriched tables in Snowflake to streamline operations, inform strategic priorities, and develop product insights
  • Keep a close eye on usage of the self-service products and engage in activities (socialization, documentation, etc.) designed to increase usage
  • Create and contribute to data frameworks that improve logging data, while working with data infrastructure engineers to identify and resolve issues
  • Provide proper data accessibility and guidelines to analyst teams outside of BI
  • Collaborate with BI team members in the creation of enrichments and data products
  • Create and implement data testing plans, encompassing data validation, data quality assessment, and regression testing, to identify anomalies, inconsistencies, or errors in produced datasets.
  • 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).

You Have:

  • 5-8 years of experience in Advanced SQL knowledge and working with Cloud columnar databases (Google BigQuery, Amazon Redshift, Snowflake)
  • Familiarity with processes supporting data transformation, data structures, metadata, dependency and workload management (data pipeline orchestration, airflow, dbt core, gitlab scheduler, prefect)
  • Experience with building and maintaining semantic layers and self-service technologies for non-technical end-user use
  • Familiarity with self-serve product analytics tools (Segment, Amplitude, Mixpanel,etc) 
  • Production experience working with dbt and designing and implementing Data Warehouse solutions
  • Familiarity with AWS solutions such as S3, EC2, VPC [[not super necessary]]
  • Knowledge of standard code management solutions (Gitlab)

Perks & Benefits:

  • HSA, 100% employer-paid premiums, or buy-up medical/vision and dental coverage options for full-time employees
  • Equity - Restricted Stock Units (RSUs) for eligible roles
  • Lucrative Employee Stock Purchase Program (15% discount)
  • 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 Incidental Sick Leave
  • 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 LinkedIn Learning 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 reasonable range of compensation for roles that may be hired in different geographic areas we are licensed to operate our business from. Actual compensation is determined by several factors including, but not limited to, level of professional, educational experience, skills, and specific candidate location. In addition, this role will be eligible for a market competitive bonus and RSU stock grant upon accepted offer. California & New York: $118,800-$172,800 All other US States: $110,000-$160,000

Get to Know Us:

At Smartsheet, we’ve created a place where everyone is welcome — people from all over the world, all backgrounds, all ages, all colors, and all beliefs working side by side. Here, everyone can make a difference and empower others to do the same. You’re encouraged to apply even if your experience doesn’t precisely match our job description—if your career path has been nontraditional, that will set you apart. At Smartsheet, we empower everyone, everywhere to change the way the world works—join us

Equal Opportunity Employer:

Smartsheet is an Equal Opportunity Employer committed to fostering an inclusive environment with the best employees. We provide employment opportunities without regard to any legally protected status in accordance with applicable laws in the US, UK, Australia, Japan, Costa Rica, and Germany. If there are preparations we can make to help ensure you have a comfortable and positive interview experience, please let us know.

#BI-Remote

#LI-Remote

Apply for this Job

* Required
resume chosen  
Dropbox Google Drive
(File types: pdf, doc, docx, txt, rtf)
Cancel
cover_letter chosen  
Dropbox Google Drive
(File types: pdf, doc, docx, txt, rtf)
Cancel
Voluntary EEOC Demographics

At Smartsheet, we strive to build an inclusive environment that encourages, supports, and celebrates the diverse voices of our team members. Individuals seeking employment at Smartsheet are considered without regards to race, ethnicity, color, age, sex, religion, national origin, ancestry, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information, physical or mental disability, registered domestic partner status, caregiver status, marital status, veteran or military status, citizenship status, or any other legally protected category in the US, UK, and Australia.

Below is a set of voluntary demographic questions. If you choose to complete them, your responses will be used in aggregate to help us identify areas for improvement in our programs. Your responses, or your choice to not respond, will not be considered in the hiring process. Any information that you provide will be recorded and maintained confidentially.

For definitions of any of the following terms or to read more about your rights, please visit the EEOC website here. 

I identify my gender as: *




I identify as transgender: *



I identify my race / ethnicity as (select all that apply): *










My veteran status is: *



My disability status is: *



Our system has flagged this application as potentially being associated with bot traffic. Please turn off any VPNs, clear your browser cache and cookies, or try submitting your application in a different browser. If this issue persists, please reach out to our support team via our help center.
Please complete the reCAPTCHA above.