Photon Logo

Photon

Snowflake Developer - ll - Dallas, TX

Posted 24 Days Ago
In-Office or Remote
Hiring Remotely in United States
37K-132K Annually
Mid level
In-Office or Remote
Hiring Remotely in United States
37K-132K Annually
Mid level
Develop and maintain scalable Snowflake data warehouses, ETL/ELT pipelines, data models, and integrations across cloud and on-premises sources. Optimize queries, clustering, partitioning, and warehouse performance; implement transformations using SQL, stored procedures, and Snowpark. Monitor data quality, governance, security, deployments, and production issues. Collaborate with engineers, architects, analysts, and business stakeholders while automating workflows and contributing to data architecture and best practices.
The summary above was generated by AI

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.

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

Similar Jobs

15 Minutes Ago
Remote or Hybrid
OH, USA
Senior level
Senior level
Financial Services
Leads software engineering and AI/ML solution delivery using Java and Python. Designs, builds, operates, and troubleshoots secure, scalable production systems; advances AI-assisted engineering practices; integrates LLM, RAG, and NLP capabilities; develops CI/CD and cloud-native automation; improves observability, reliability, and incident remediation; partners on technical roadmaps; and mentors engineers and AI practitioners.
Top Skills: Ai/MlAWSCi/CdCloud-Native ArchitecturesContainerizationEvent-Driven ArchitectureGenerative AiInfrastructure As CodeJavaLangchainLanggraphLlmsMicroservicesNlpObservabilityPythonRetrieval-Augmented Generation (Rag)
An Hour Ago
Remote or Hybrid
97K-164K Annually
Senior level
97K-164K Annually
Senior level
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Develop and maintain Master Data Management, data governance, stewardship, quality, and reference data processes. Partner with enterprise stakeholders and governance groups to define standards, validate master data, establish quality rules, support data owners, and prioritize initiatives. Lead requirements for system configuration changes while using data profiling, modeling, and analytics to improve data validity and consistency across systems.
Top Skills: AgileInformaticaProfiseePythonRestSemarchySoapSQL
An Hour Ago
Remote or Hybrid
97K-164K Annually
Senior level
97K-164K Annually
Senior level
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Develop and maintain master data management and integration capabilities, including data quality rules, governance processes, stewardship workflows, data validation, profiling, modeling, and integration design. Collaborate with enterprise stakeholders, data owners, stewards, and governance groups to define requirements, configure systems, and support strategic MDM initiatives. Use Python, SQL, AWS services, APIs, Dataiku, and ETL/MDM tools to improve data accuracy, consistency, transformation, and retention.
Top Skills: AgileAmazon RedshiftAPIsAws LambdaAws Step FunctionsDataikuETLInformaticaPl/SqlProfiseePythonSemarchySQL

What you need to know about the Austin Tech Scene

Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.

Key Facts About Austin Tech

  • Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
  • Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
  • Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
  • Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account