Smartsheet19 дней назад
Sr. Analytics Engineer - Data Warehouse (Hybrid, Bangalore)
Bangalore
Обязанности
- 01Leading the implementation of efficient and scalable systems that optimize data transformations from our data lake in Snowflake into clean, documented data products
- 02Contribute to the design standards and architectural principle standards, designs and processes
- 03Build and maintain a governed, robust, reliable, and scalable analytics system (DW/DV)
- 04Collaborating with BI analysts and data scientists to provide proper data accessibility guidelines
- 05Foster data democratization via activation of data on critical platforms like Smartsheet platform, Amplitude, Thoughtspot, Gainsight
- 06Create and contribute to frameworks that improve data quality and observability to identify and resolve issues faster
- 07Create and implement data testing plans, encompassing data validation, data quality assessment, and regression testing, to identify anomalies, inconsistencies, or errors in produced datasets
- 08Mentor and guide teams and help drive high standards across the team by conducting design reviews and engineering ideation forums
- 09Collaborate with cross-functional teams to assess data privacy needs and define data masking strategies aligned with industry compliance standards (e.g., GDPR, HIPAA, CCPA)
Требования
- 016+ years of experience in advanced data modeling using Data Vault (DV 2.0), dbt, and Snowflake
- 02Proven experience in building analytics systems with data transformation, dependency, and workload management (Data Vault, AutomateDV, dbt core, Airflow, Snowflake, GitLab, SQL)
- 03Proven experience with building and maintaining business analytics layers and semantic layers to enable self-service for non-technical end-users
- 04Strong production experience supporting and maintaining analytics/data warehouse solutions with mission-critical datasets
- 05Familiarity with data governance principles for maintaining datasets to enable a single source of truth
- 06Familiarity with self-serve product analytics tools (Amplitude, Thoughtspot, Tableau, Gainsight, etc.)
- 07Knowledge of code management and CI/CD practices (GitLab, Airflow, Snowflake, Terraform)
- 08Familiarity with AWS solutions such as S3, EC2, VPC
Условия
- 01Full-time position based in Smartsheet’s corporate offices in Bengaluru, India (Hybrid)
- 02Reports to the Director of Analytics Engineering