Lead Cortex Developer

Key responsibilities

Lead the design, development, and implementation of data engineering solutions using Snowflake.
Develop and optimize data pipelines, transformations, and workflows using dbt, Apache Airflow, PySpark, and SQL.
Build and maintain solutions leveraging Snowflake Cortex AI capabilities for AI-driven data processing and analytics.
Develop complex SQL queries, stored procedures, views, and performance-optimized data models.
Design scalable ETL/ELT pipelines to ingest, transform, and process structured and semi-structured data.
Implement data orchestration, scheduling, monitoring, and error-handling mechanisms using Apache Airflow.
Develop modular, reusable, and maintainable data transformation models using dbt.
Optimize Snowflake queries, warehouse utilization, and overall data processing performance.
Lead technical discussions, conduct code reviews, and establish development best practices.
Collaborate with cross-functional teams to translate business requirements into technical solutions.
Ensure data quality, security, governance, and reliability across data pipelines.
Mentor junior developers and provide technical guidance to the development team.

Mandatory technical skills

Snowflake: Strong hands-on experience in data warehousing, data modeling, query optimization, and Snowflake architecture.
dbt: Experience developing data transformation models, reusable SQL logic, testing, and dependency management.
Apache Airflow: Experience building, scheduling, monitoring, and troubleshooting data pipeline workflows.
PySpark: Strong experience in distributed data processing, transformations, and large-scale data engineering.
SQL: Excellent proficiency in complex queries, joins, CTEs, window functions, query tuning, and data analysis.
Snowflake Cortex: Experience with Cortex AI capabilities is highly desirable for developing AI-enabled data solutions.

Required experience

Strong hands-on experience in Snowflake-based data engineering.
Proven experience designing and implementing scalable data pipelines.
Experience leading technical development and mentoring team members.
Strong analytical, communication, and troubleshooting skills.
Ability to work independently and deliver solutions in a fast-paced environment.