Role Overview
We are seeking a highly skilled Senior Data Engineer / Snowflake Lead with 4+ years of experience in designing, building, and modernizing enterprise data platforms. The ideal candidate will have strong expertise in Snowflake, Python, PySpark, Snowpark, SQL, and dbt, with hands-on experience migrating legacy data warehouse technologies to modern cloud-based data platforms.
This role will focus on migrating SSIS/SSAS/MDX-based solutions to Snowflake Native Architecture while enabling AI-ready analytics and scalable data engineering solutions.
Key Responsibilities
- Design, develop, and maintain scalable, high-performance data pipelines using Snowflake, Python, PySpark, and Snowpark.
- Lead migration of legacy data platforms (SSIS, SSAS, MDX Cubes) to Snowflake Native Architecture.
- Develop optimized ELT pipelines using DBT and Snowflake best practices.
- Build and maintain semantic data models to support enterprise reporting, analytics, and AI/ML use cases.
- Optimize Snowflake performance, SQL queries, compute resources, and data models.
- Collaborate with business stakeholders, architects, product teams, and data scientists to translate business requirements into scalable technical solutions.
- Ensure data quality, governance, security, and operational excellence across data platforms.
- Mentor junior engineers and drive engineering best practices within the team.
Must-Have Skills
- 4+ years of experience in Data Engineering.
- Strong hands-on experience with Snowflake.
- Expertise in SnowSQL, Snowpark, Python, PySpark, and SQL.
- Strong experience with DBT for modern ELT development.
- Experience designing and optimizing enterprise-scale data pipelines.
- Experience with Data Lakes, Lakehouse Architecture, and Cloud Data Warehouses.
- Strong knowledge of Snowflake performance tuning and query optimization.
- Excellent stakeholder management and communication skills.
- Experience leading technical initiatives and mentoring engineering teams.
Migration Experience (Highly Preferred)
Candidates with experience in the following areas will be highly preferred:
- Migration of SSIS packages to Snowflake.
- Strong experience with SSAS multidimensional modeling.
- Expertise in MDX query development.
- Experience migrating SSAS Cubes to modern cloud platforms.
- Understanding of legacy Microsoft BI technologies and transformation to Snowflake Native solutions.
Preferred Skills
- Experience with AWS, Azure, or GCP.
- Experience supporting AI/ML pipelines.
- Knowledge of Tableau, Power BI, or Looker.
- Experience with Apache Airflow.
- Knowledge of Databricks.
- Exposure to Teradata migration projects.
- Snowflake SnowPro Core Certification (Mandatory).
- SnowPro Advanced Certification (Preferred).
Why Join EXL
- Work on enterprise-scale cloud transformation initiatives.
- Drive the modernization of legacy BI platforms into Snowflake Native Architecture.
- Collaborate with high-performing analytics and engineering teams.
- Build scalable AI-ready data platforms using modern cloud technologies.
