Snowflake Developer - ll - Dallas, TX

Photon Interactive UK Ltd
  • Dallas, TX
    3 days ago

    Job Description

    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.

    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

    Numbers & Facts

    LocationDallas, TX

    Skills

    • Agile Programming Methodologiesunmatched
    • Amazon Web Services (AWS)unmatched
    • Analysis Skillsunmatched
    • Apache Avrounmatched
    • Apache Sparkunmatched
    • Architectural Analysisunmatched
    • Automationunmatched
    • Best Practicesunmatched
    • Cloningunmatched
    • Cloud Computingunmatched
    • Computer Scienceunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Integrationunmatched
    • Data Analysisunmatched
    • Data Lakeunmatched
    • Data Managementunmatched
    • Data Modelingunmatched
    • Data Processingunmatched
    • Data Qualityunmatched
    • Data Setsunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Technologyunmatched
    • Detail Orientedunmatched
    • DevOpsunmatched
    • GCP (Good Clinical Practices)unmatched
    • Identify Issuesunmatched
    • Informaticaunmatched
    • Information Technology & Information Systemsunmatched
    • Information/Data Security (InfoSec)unmatched
    • JSONunmatched
    • Javaunmatched
    • Machine Learningunmatched
    • Microsoft Windows Azureunmatched
    • Performance Tuning/Optimizationunmatched
    • Problem Solving Skillsunmatched
    • Production Supportunmatched
    • Python Programming/Scripting Languageunmatched
    • Query Optimizationunmatched
    • Regulatory Complianceunmatched
    • Root Cause Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • Scalable System Developmentunmatched
    • Scrum Project Management and Software Developmentunmatched
    • Snowflake Schemaunmatched
    • Software Engineeringunmatched
    • Star Schemaunmatched
    • Stored Proceduresunmatched
    • Structured Dataunmatched
    • Team Playerunmatched
    • Warehousingunmatched
    • XML (EXtensible Markup Language)unmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder