Experience Inc. Jobs

Job Information

Smartsheet Inc. Data Analytics Engineer in Clyde Hill, Washington

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: 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 devel