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.
Our Candidate Privacy Notice describes how Smartsheet may process your personal data, including the use of a third party provider for application submissions.