Snowflake DBT Lead - ITIL

We are seeking a highly skilled and experienced Technical Lead to join our Data Operations team. The ideal candidate will possess strong technical knowledge, excellent leadership abilities, and a solid understanding of ITIL best practices. This role is critical in ensuring the smooth operation and optimization of our data infrastructure, including Snowflake, Airflow, and DBT.Prioritize and triage incidents based on severity and impact, ensuring timely resolution and minimal/no disruption to operations.Lead the response to data incidents, including system outages, performance degradation, or data integrity issues.
Assign tasks and responsibilities to team members based on their skills, workload, and shift priorities.
Communicate effectively with stakeholders, including senior management, business users, and other teams, to provide updates on incident status and resolution efforts.SQL Proficiency Write, execute, and troubleshoot SQL queries to extract, transform, and load data within Snowflake.
Snowflake AdministrationUnderstand user management, security policies, and warehousing concepts like materialized views and clustering keys.
Snowflake Monitoring Identify and troubleshoot performance issues within the Snowflake platform.
Troubleshooting andAnalysis Analyze error messages, logs, and query execution plans to diagnose and resolve Snowflake-related issuesWorkflow Orchestration Manage and optimize workflow orchestration using tools like Airflow.
Scripting Write scripts (Python or bash) to automate tasks within Airflow workflows.
Data Lineage Track data flow through the platform using data lineage concepts.
Troubleshooting & Analysis Diagnose and resolve issues with Airflow workflows by analyzing logs and job execution data.SQL Modeling Apply data modeling concepts and best practices for building dimensional models.
DBT Models Develop and maintain DBT models to automate data transformation tasks within Snowflake.
Testing and Documentation Write unit tests for DBT models and document data pipelines.
Troubleshooting & Analysis Troubleshoot DBT models by analyzing error messages and test results.Develop, implement, and maintain service delivery processes in accordance with ITIL best practices.
Understand the ITIL culture and know how to raise a Change request, problem ticket, etc.Bachelors degree in Computer Science Information Technology or a related fieldMinimum of 5 years to a maximum of 10 years of experience in data operations or a related technical field.Proven experience in incident management, particularly within a data-centric environment.Snowflake Proficiency in SQL, Snowflake administration, and performance monitoring.
Airflow Knowledge of workflow orchestration, scripting, data lineage, and troubleshooting.
DBT Experience with SQL modeling, DBT model development, testing, documentation, and troubleshooting.General Strong analytical skills, technical troubleshooting, and data analysis capabilities.Solid understanding of ITIL best practices.
Experience in raising and managing Change requests, Problem tickets, and other ITIL processes.Excellent communication skills, with the ability to engage effectively with all levels of the organization.
Strong leadership and team management skills.
Ability to work in a fast-paced, dynamic environment and manage multiple priorities simultaneously