Key Skills

Job Description

About the Company Tavant is a global AI-powered digital engineering and technology solutions company, founded in 2000 and headquartered in Silicon Valley. We help enterprises accelerate digital transformation through expertise in AI, data, cloud, digital engineering and enterprise platforms. With a strong presence across North America, Europe, India and other global locations, Tavant delivers innovative, industry-focused solutions for financial services, manufacturing, media and entertainment, digital commerce and other sectors. Join us to work with modern technologies, solve meaningful business challenges and build scalable, future-ready solutions. About the Role A technically strong data professional who can independently design, develop, and optimize scalable data solutions while collaborating with business and engineering stakeholders. Responsibilities Design, develop, and optimize data pipelines using Snowflake, dbt, SQL, and Python. Analyzing large datasets to identify trends, patterns, and actionable insights Build and maintain scalable ELT/ETL workflows. Develop complex SQL queries and optimize Snowflake performance. Design dimensional data models and data warehouse architectures. Implement data quality checks, validation frameworks, and monitoring processes. Contribute to data architecture and system design discussions. Collaborate with cross-functional teams to deliver reliable analytics solutions. Required Skills Advanced SQL: Complex queries, CTEs, window functions, performance tuning dbt (Data Build Tool): Models, macros, testing, incremental transformations Snowflake: Data warehousing, optimization, data transformations Python: Data processing, scripting, and automation Data Modeling: Star schema, snowflake schema, dimensional modeling Data Warehousing: ETL/ELT, warehouse design, optimization Data Architecture & System Design Data Quality & Validation

Core Responsibilities

Design, develop, and optimize scalable data pipelines and ELT/ETL workflows using Snowflake, dbt, SQL, and Python. Build data models and warehouse architectures, improve data quality and performance, analyze datasets for actionable insights, and collaborate with stakeholders on reliable analytics solutions.

Requirements

The role requires advanced SQL, dbt, Snowflake, and Python skills, along with experience in dimensional data modeling and data warehouse design. Candidates should also be able to contribute to data architecture and system design and implement data quality, validation, and monitoring processes.