Data Engineer jobs

Snowflake Developer - ll

PhotonUnited StatesFull-time

$37k/yr listed by the employer

Key facts

Experience
4+ years
Degree
Bachelor's degree

Looks real. 1 thing to check before you apply.

On Photon’s own careers site (Oracle Recruiting), checked open today.

  • To check: Posted by the employer 2 months agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • Checked: On the company's own careers siteOracle Recruiting board
  • Checked: Checked open todayOracle Recruiting board
  • Checked: Pay listedJob posting
  • Checked: No reposts foundOracle Recruiting board
  • Trust score 95 / 100 · Strong
See all 6 checksShow fewer
How we check

What you’ll do

  • Design, develop, and maintain Snowflake data warehouse solutions, data models, schemas, and database objects.
  • Build and optimize ETL/ELT pipelines and data integrations from on-premises and cloud sources.
  • Develop data transformations using SQL, Snowflake Stored Procedures, and Snowpark; automate workflows and orchestration.
  • Tune Snowflake performance and monitor, troubleshoot, and resolve data issues, including production root cause analysis.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Licenses and certifications

  • Snowflake certification (preferred)

Experience

  • 4 to 8 years of experience
  • Hands-on experience with Snowflake Data Cloud
  • Experience designing and implementing data warehouse solutions
  • Experience building ETL/ELT pipelines and using data ingestion and transformation frameworks
  • Experience handling structured and semi-structured data, including JSON, XML, Parquet, and Avro
  • Experience with at least one of AWS, Azure, or Google Cloud Platform
  • Experience with Python or Java for data processing and automation
  • Experience with at least one of Informatica, Matillion, Talend, Azure Data Factory, Airflow, or dbt
  • 4+ years of experience in Data Engineering (preferred)
  • 2+ years of hands-on Snowflake development experience (preferred)
  • Experience working in Agile/Scrum environments (preferred)
  • Experience with Databricks (preferred)
  • Machine learning data preparation workloads (preferred)

Education

  • Bachelor's degree in Computer Science, Information Technology, or a related field (preferred)

Skills

  • Expertise in Snowflake architecture, virtual warehouses, databases, schemas, and stages
  • Experience with Snowpipe, Streams and Tasks, Time Travel, Zero Copy Cloning, Secure Data Sharing, Materialized Views, and Snowpark
  • Strong proficiency in SQL and query optimization
  • Knowledge of star schema, snowflake schema, dimension modeling, and fact tables
  • Familiarity with Snowpark development using Python or Java
  • Knowledge of CI/CD practices and DevOps methodologies (preferred)
  • Apache Spark (preferred)
  • Kafka or event streaming (preferred)
  • Data lake architecture (preferred)
  • Terraform or Infrastructure as Code (preferred)

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Benefits

Health insurance
Medical benefits
Dental & vision
Dental and vision benefits
Retirement plan
401(k) retirement plan
Paid time off
Paid time off and paid holidays
Bonus
Variable pay/incentives

Full job description

From Photon’s careers site

a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }

Job Summary

We are seeking a skilled Snowflake Developer - II to join our Data Engineering team. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining data solutions on the Snowflake Cloud Data Platform. The role involves building scalable data pipelines, data warehouses, ETL/ELT processes, and ensuring efficient data integration from multiple sources.

Show full descriptionShow less

The candidate should have strong expertise in Snowflake, SQL, data modeling, cloud technologies, and modern data engineering practices. This role requires close collaboration with business stakeholders, data architects, analysts, and engineering teams to deliver high-quality, data-driven solutions.

Snowflake Developer - Data engineering, analysis, data warehouses, data lakes. Specialist understanding and experience of methodologies like data warehousing, data visualization, and data integration. Strong Understanding and proven experience with relational database technologies (Oracle SQL & PL/SQL or similar RDBMS), preferably Snowflake or other Cloud Data warehousing services. Outstanding SQL skills and experience performing deep data analysis on multiple database platforms.

Key Responsibilities

  • Design, develop, and maintain scalable data warehouse solutions using Snowflake.
  • Build and optimize ETL/ELT pipelines for loading and transforming large datasets.
  • Develop and maintain data models, schemas, and database objects.
  • Implement data integration processes from multiple on-premises and cloud sources.
  • Optimize Snowflake performance through query tuning, clustering, partitioning, and warehouse management.
  • Develop data transformation logic using SQL, Snowflake Stored Procedures, and Snowpark.
  • Collaborate with Data Engineers, Analysts, and Business Teams to understand data requirements.
  • Monitor, troubleshoot, and resolve data-related issues.
  • Ensure data quality, governance, security, and compliance standards are maintained.
  • Support production deployments and perform root cause analysis for data issues.
  • Automate data workflows and orchestration processes.
  • Contribute to data architecture and best practice initiatives.

Required Skills & Qualifications Snowflake

  • Strong hands-on experience with Snowflake Data Cloud.
  • Expertise in Snowflake Architecture, Virtual Warehouses, Databases, Schemas, and Stages.
  • Experience with Snowflake Features such as:
  • Snowpipe
  • Streams & Tasks
  • Time Travel
  • Zero Copy Cloning
  • Secure Data Sharing
  • Materialized Views
  • Snowpark

SQL & Data Warehousing

  • Strong proficiency in SQL and query optimization.
  • Experience designing and implementing Data Warehouse solutions.
  • Strong knowledge of Data Modeling concepts:
  • Star Schema
  • Snowflake Schema
  • Dimension Modeling
  • Fact Tables

ETL/ELT Development

  • Experience building ETL/ELT pipelines.
  • Hands-on experience with data ingestion and transformation frameworks.
  • Experience handling structured and semi-structured data (JSON, XML, Parquet, Avro).

Cloud Platforms

  • Experience working with one or more cloud platforms:
  • AWS
  • Azure
  • Google Cloud Platform (GCP)

Programming

  • Experience with Python or Java for data processing and automation.
  • Familiarity with Snowpark development using Python or Java.

Data Integration Tools

Experience with one or more of the following:

  • Informatica
  • Matillion
  • Talend
  • Azure Data Factory (ADF)
  • Airflow
  • dbt

Preferred Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 4+ years of experience in Data Engineering.
  • 2+ years of hands-on Snowflake development experience.
  • Experience working in Agile/Scrum environments.
  • Knowledge of CI/CD practices and DevOps methodologies.

Nice to Have

  • Snowflake Certification.
  • Experience with Databricks.
  • Apache Spark.
  • Kafka/Event Streaming.
  • Data Lake Architecture.
  • Terraform or Infrastructure as Code (IaC).
  • Machine Learning data preparation workloads.

Key Competencies

  • Strong Analytical and Problem-Solving Skills
  • Data Modeling Expertise
  • Database Performance Tuning
  • Stakeholder Communication
  • Attention to Detail
  • Collaboration and Teamwork
  • Agile Mindset

Experience:

4 to 8 Years

Employment Type:

Full-Time

Mandatory Skills:

  • Snowflake
  • SQL
  • Data Warehousing
  • ETL/ELT Development
  • Cloud Platform (AWS/Azure/GCP)
  • Data Modeling
  • Performance Optimization

Good to Have:

  • Python
  • Snowpark
  • dbt
  • Airflow
  • Databricks
  • CI/CD Pipeline Experience

Compensation, Benefits and Duration

Minimum Compensation: USD 37,000

Maximum Compensation: USD 132,000

Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.

Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.

This position is not available for independent contractors

No applications will be considered if received more than 120 days after the date of this post

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

ETL Developer

GRVTY · McLean, VA

$150k–$250k/yr

StrongChecked open todayPosted 12 days ago

Senior Data Engineer

Vericast · Remote · US only

$130k–$150k/yrFull-time

StrongChecked open todayPosted 2 days ago

Senior Data Engineer

AIR Communities · Denver, CO

$125k–$145k/yrFull-timeOn-site

StrongChecked open todayPosted 3 days ago

Lead Data Engineer

AIR Communities · Denver, CO

$135k–$160k/yrFull-timeOn-site

StrongChecked open todayPosted 3 days ago

Sr. Data Engineer

NBCUniversal · New York, NY

$115k–$145k/yrFull-timeHybrid

StrongChecked open todayPosted 3 days ago

Senior Data Engineers

Movement Labs · Remote · US only

$120k–$150k/yrFull-time

StrongChecked open todayPosted 8 days ago

See more like this