Data Infrastructure Engineer (Analytics Team)
Bellevue, WA, USA
Applications have closed
Smartsheet
Smartsheet enables teams to manage projects, automate processes & scale programs in one powerful platform. Maintain visibility & keep distributed teams connected.Smartsheet's mission is to empower everyone, everywhere to drive meaningful change. Smartsheet is looking for a Data Infrastructure Engineer to be responsible for the structure, design, and operations of the BI Snowflake enrichment code base, to ensure data accessibility and efficiency for stakeholders across Smartsheet. The Data Infrastructure Engineer will implement an efficient/scalable system of schemas and enrichments to optimize transforming data from its raw form in Snowflake, into clean and documented datasets for use by analytics stakeholders and end-users in front-end data products. Working with the BI team, the engineer will ensure the team has the required data to best automate the creation of enrichments and tools/data products.
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.
You will report to our BI Operations Manager located in our Bellevue, WA office, or you may work remotely from anywhere in the US where Smartsheet is a registered employer.
You Will:
- Turn existing manual or fragile ad hoc processes into repeatable automated jobs
- Own and maintain infrastructure for an analytics database
- Handle processes that ingest, move, and transform data
- Design and implement code testing and merging procedures
- Coordinate multiple systems for our code base and database (dbt, aws, snowflake, GitLab, etc)
- Establish rules/processes to ensure proper access levels
- Ensure all legal/privacy/SOX requirements are met in Snowflake enrichments
- Provide proper data accessibility and guidelines to analyst teams outside of BI
- Transform raw company data and 3rd party data into enrichment tables
- Collaborate with BI team members in the creation of enrichments and data products
You Have:
- 3-5 years of experience in Advanced SQL knowledge and working with Cloud columnar databases (Google BigQuery, Amazon Redshift, Snowflake)
- Data engineering experience in building, working & maintaining data pipelines & ETL processes on data environments
- Production experience working with dbt and designing and implementing Data Warehouse solutions
- Familiarity with processes supporting data transformation, data structures, metadata, dependency and workload management (data pipeline orchestration, airflow, gitlab scheduler, prefect)
- Familiarity with AWS solutions such as S3, EC2, VPC
- 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) with all offers
- 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
- 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, primary care membership, local retail discounts, and your own personal Smartsheet account
- Teleworking options from any registered location in the U.S. (role specific)
- 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
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: 97,200 to 140,400 | All other US States: 90,000 to 130,000
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, 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.
At Smartsheet, we strive to build an inclusive environment that encourages, supports, and celebrates the diverse voices of our team members who also represent the diverse needs of our customers. We’re looking for people who are driven, authentic, supportive, effective, and honest. 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 welcome diverse perspectives and people who aren’t afraid to be innovative—join us!
#BI-Remote
#LI-Remote
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Airflow AWS BigQuery Data pipelines Data warehouse EC2 Engineering ETL GitLab Pipelines Privacy Redshift Snowflake SQL Testing
Perks/benefits: 401(k) matching Career development Competitive pay Equity Flex hours Health care Home office stipend Insurance Medical leave Parental leave Salary bonus
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open MLOps Engineer jobs
- Open Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Sr. Data Scientist jobs
- Open Business Data Analyst jobs
- Open Senior Data Architect jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Junior Data Engineer jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Java-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs