Snowflake Data Warehouse Developer - w2

Overview

Remote
$40 - $50
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Able to Provide Sponsorship

Skills

Access Control
Amazon S3
Amazon Web Services
Analytical Skill
Apache Airflow
Attention To Detail
Business Intelligence
Cloud Computing
Collaboration
Communication
Computer Science
Conflict Resolution
Continuous Delivery
Continuous Integration
Data Engineering
Data Extraction
Data Flow
Data Governance
Data Integration
Data Management
Data Modeling
Data Processing
Data Quality
Data Security
Data Warehouse
Debugging
Documentation
DevOps
ELT
Extract
Transform
Load
Flat File
Git
Good Clinical Practice
Google Cloud Platform
Informatica
Information Systems
Management
Microsoft Azure
Microsoft Power BI
Offshoring
Orchestration
Organized
Performance Tuning
Problem Solving
Python
Regulatory Compliance
Relational Databases
Reporting
SQL
Scala
Scheduling
Snow Flake Schema
Streaming
Tableau
Version Control
Warehouse Management
Workflow

Job Details

Position Overview

We are seeking an experienced Snowflake Data Warehouse Developer to design, build, and maintain scalable data warehouse solutions. The ideal candidate will have hands-on expertise with Snowflake, SQL, and ETL/ELT pipelines, along with strong analytical and collaboration skills. This role involves developing efficient data models, ensuring data quality, and supporting enterprise data management initiatives in a cloud-based environment.

Key Responsibilities

  • Snowflake Development:
    Design, implement, and manage scalable, high-performance data warehouse solutions using Snowflake Cloud Data Platform.
    Develop Snowflake data models using Star and Snowflake schemas to optimize query performance and reporting.

  • ETL/ELT Pipeline Development:
    Build and optimize ETL/ELT processes using tools such as dbt, Apache Airflow, Informatica, or equivalent.
    Integrate data from multiple sources including APIs, flat files, and relational databases.

  • SQL Development:
    Write and optimize complex SQL queries for data extraction, transformation, and analysis.
    Ensure efficient query performance and minimize resource utilization in the Snowflake environment.

  • Data Integration & Cloud Operations:
    Manage data ingestion from various on-prem and cloud sources (AWS S3, Azure Blob, Google Cloud Platform).
    Automate data loads and transformations using scheduling and orchestration tools.

  • Performance Tuning & Monitoring:
    Monitor system performance, query execution, and data pipeline health.
    Troubleshoot and resolve data performance issues proactively.

  • Data Governance & Security:
    Implement data governance, access control, and security best practices in Snowflake.
    Ensure compliance with enterprise standards and regulatory data protection policies.

  • Collaboration & Documentation:
    Work closely with data analysts, engineers, and business stakeholders to understand requirements and deliver high-quality solutions.
    Maintain detailed documentation of data flows, models, and workflows for operational transparency.

Required Qualifications

  • Bachelor s degree in Computer Science, Information Systems, or a related technical discipline.

  • 8+ years of experience in Data Engineering or Data Warehouse Development.

  • 3+ years of hands-on experience developing with Snowflake (data modeling, performance optimization, and warehouse management).

  • Strong proficiency in SQL, ETL design, and data modeling techniques (Star and Snowflake schema).

  • Experience with ETL/ELT tools such as dbt, Airflow, or Informatica.

  • Familiarity with cloud platforms (AWS, Azure, or Google Cloud Platform) and their data ecosystem.

  • Working knowledge of CI/CD pipelines, version control (Git), and automation frameworks.

  • Understanding of data governance, security, and compliance standards.

Preferred Skills

  • Experience with Python or Scala for data processing automation.

  • Familiarity with Tableau, Power BI, or other BI tools.

  • Exposure to DevOps practices and cloud deployment automation.

  • Knowledge of Snowflake features such as Snowpipe, Streams, and Tasks.

Soft Skills

  • Excellent verbal and written communication.

  • Strong analytical, problem-solving, and debugging skills.

  • Proven ability to work in cross-functional teams and coordinate with offshore resources.

  • Highly organized with attention to detail and strong documentation habits.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Bridge Flair LLC