Data Warehouse Developer

Responsibilities

• Design and implement scalable, high-performance data models such as Star Schema, Snowflake Schema, or Data Vault 2.0
• Architect end-to-end ELT pipelines from raw ingestion zones to analytics-ready data marts
• Develop and maintain automated data ingestion pipelines using Snowpipe, Streams, and Tasks
• Optimize query performance using Query Profile and manage Virtual Warehouse configurations to control costs
• Implement robust security frameworks utilizing Snowflake's Role-Based Access Control (RBAC) and data masking policies
• Manage semi-structured data formats including JSON, Parquet, and XML using Snowflake’s VARIANT type

Requirements

• 5+ years of experience in Data Warehousing, Data Engineering, or Business Intelligence roles
• Minimum of 3 years of hands-on experience specifically designing and developing in Snowflake
• Advanced SQL skills, including window functions, complex joins, and analytical queries
• Proficiency in Python (preferred for Snowpark integration)
• Experience with modern data stack tools such as dbt, Fivetran, Matillion, or Airflow
• Experience with cloud storage environments, specifically AWS S3

Preferred Qualifications

• Snowflake Certification (SnowPro Core or SnowPro Advanced Developer/Architect)
• Experience setting up secure Data Sharing and utilizing the Snowflake Marketplace
• Familiarity with CI/CD deployment pipelines for data infrastructure (e.g., GitHub Actions, GitLab CI, or schemachange)

About the Company

Photon is a global leader in digital transformation, helping businesses navigate complex technological landscapes through innovative data and engineering solutions.