Senior Data Engineer - Snowflake

expertise including complex analytical queries, window functions, stored procedures, and schema design Proficiency in Spark/Py Spark and Python for data processing, transformation, and automation. Solid understanding of data modeling, schema design, partitioning strategies, and file formats (Parquet, ORC, Avro). Experience with batch and streaming data pipelines, ETL/ELT frameworks, and orchestration tools. Experience with Snowflake Snow Convert AI for automated code conversion and migration of legacy SQL, stored procedures, ETL scripts, and database objects from platforms such as Teradata, Oracle, Hive, or Spark to Snowflake-compatible SQL. Familiarity with multi-layer data architectures (Bronze/Silver/Gold medallion pattern) Experience with Snowflake core capabilities including Snowflake Procedures, UDFs, Streams, Tasks, Dynamic Tables, and Snowpipe for continuous data ingestion. Hands-on experience with Snowflake performance optimization — clustering keys, materialized views, query profiling, resource monitors, and warehouse sizing strategies. Working knowledge of Snowflake security and governance features — Role-Based Access Control (RBAC), data masking, row access policies, and tagging. Experience with Snowflake's data sharing and collaboration features including Secure Data Sharing, Snowflake Marketplace, and cross-region replication. Familiarity with Snowflake Cortex for AI/ML functions and Snowpark for building data pipelines in Python, Java, or Scala natively within Snowflake. Knowledge of data warehousing concepts, dimensional modeling, and slowly changing dimensions. Strong SDLC practices including Git version control, branching strategies, code reviews, and release management processes Experience with monitoring, logging, alerting, and observability frameworks for data pipelines. Strong troubleshooting, debugging, and production support capabilities. Highly experienced in the use of AI / LLMs to accelerate data engineering work (e.g., Snowflake Co Co, Kiro, Git Hub Copilot, Cursor, or similar Gen AI-assisted development tools). Excellent communication, problem-solving, and stakeholder management skills. Snowflake Snow Pro Core Certification required — advanced certifications a plus. Good To Have Skills Experience with Snowflake capabilities (Procedures, UDFs, Streams, Tasks, Cortex) and dbt for data transformation SQL expertise across legacy platforms such as Hive or Impala alongside Snowflake Experience with Snowpark or Snowflake migration tooling Familiarity with migration accelerators and remediation workflows Disciplined approach to data validation, reconciliation, and defect triage across source and target systems during migration Experience with cloud data platforms such as AWS (S3, Glue, Redshift, EMR, Lambda) and their integration with Snowflake Experience with CI/CD pipelines for data engineering (e.g., Jenkins, Git Hub Actions, Git Lab CI) Strong environment and dependency troubleshooting skills Experience with data pipelines and orchestration in hybrid or multi-cloud environments Terraform or Infrastructure as Code (Ia C) experience Familiarity with Kafka, Iceberg, Delta Lake, or other modern streaming/lakehouse technologies Understanding of data governance, data cataloging, and metadata management practices If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us! Thank you for your interest in Quantiphi! We are a team that dreams together and collaborates to ensure success. We are currently looking for exceptional individuals who can join us and contribute to a fun, diverse and hybrid work culture. As a part of the Quantiphi family, you will get ample opportunities to learn, grow and interact with colleagues from varied experience and backgrounds around the globe. If this excites you, explore our current openings and apply to any job roles that suit and interest you. Quantiphi is an award-winning AI-first digital engineering company driven by the desire to reimagine and realize transformational opportunities at the heart of business. We solve the toughest and most complex business problems with the latest and cutting-edge technologies and to make this happen, we have a vibrant, diverse and talented set of professionals we proudly refer to as the Quantiphi family. Our culture is built on transparency, diversity, integrity, learning and growth. We are committed to provide our teams with an environment that helps them to learn, grow and flourish in their professional as well as personal lives.