Snowflake Engineer Job at Purple Drive, Dublin, OH

c0phWU1Hd25jVmt1V3RZTnE0OHUvNFZmOVE9PQ==
  • Purple Drive
  • Dublin, OH

Job Description

Overview:

Job Summary:

We are seeking a Snowflake Engineer to design, build, and optimize scalable data solutions using the Snowflake Data Cloud . The ideal candidate will have strong expertise in data modeling, ELT/ETL pipelines, SQL performance tuning , and cloud integration , enabling robust and efficient data processing for analytics and business insights.

Key Responsibilities:

  • Design, develop, and maintain data pipelines and data models in Snowflake.
  • Implement data ingestion , transformation, and integration processes from multiple structured and unstructured data sources.
  • Optimize Snowflake performance through clustering, partitioning, caching, and query tuning.
  • Build secure and efficient data sharing and data governance frameworks within Snowflake.
  • Collaborate with analytics, BI, and data science teams to deliver high-quality datasets and data marts.
  • Integrate Snowflake with ETL/ELT tools (Informatica, dbt, Matillion, Talend, etc.) and orchestration tools (Airflow, Azure Data Factory, AWS Glue).
  • Implement role-based access control (RBAC) , data masking, and other security mechanisms.
  • Automate monitoring and management of data pipelines and ensure data quality and reliability.
  • Stay updated with Snowflake's latest features, releases, and best practices.
Technical Skills:

  • Core Expertise: Snowflake Data Warehouse (architecture, performance tuning, best practices)
  • Data Modeling: Dimensional modeling (Star/Snowflake schema), normalization/denormalization
  • SQL Expertise: Advanced SQL scripting, query optimization, stored procedures, and UDFs
  • ETL/ELT Tools: dbt, Informatica, Talend, Matillion, Apache Airflow, Azure Data Factory, or AWS Glue
  • Programming Languages: Python, SQL, or Java (for automation and integrations)
  • Cloud Platforms: AWS, Azure, or GCP (with Snowflake integration)
  • Version Control: Git, CI/CD pipelines (Jenkins, GitLab CI/CD)
  • Optional (Nice-to-Have):

    • Knowledge of Snowpark , Streamlit , or Snowflake Native Apps
    • Experience with data lakes , Kafka , or real-time data streaming
    • Familiarity with Power BI, Tableau, or Looker
Soft Skills:

  • Strong analytical and problem-solving skills
  • Ability to work collaboratively with cross-functional teams
  • Strong communication and documentation skills
  • Detail-oriented with focus on data accuracy and reliability

Job Tags

Similar Jobs

Darkroomagency

Remote Paid Social Manager Scale High-Impact Campaigns Job at Darkroomagency

 ...A leading growth marketing firm is seeking a Paid Social Manager to manage and optimize performance-driven social media campaigns. You will oversee the full lifecycle of paid social campaigns and drive substantial results for U.S. brands. The ideal candidate will have... 

SANGA CONSULTING INC

Spanish Teacher Job at SANGA CONSULTING INC

 ...About the Job Escuela Avancemos is seeking a Certified Spanish Teacher for the 2026-2027 School Year. About Escuela Avancemos...  .... A Bachelors degree in the subject area and Michigan teaching certification with an endorsement in Endorsement(s) sought: FF... 

Nashville Public Radio

Proofreader Job at Nashville Public Radio

 ...talent gap - Right Talent - Right Time - Right Place - Right Price and acting as a Career Coach to our consultants.Job Title: ProofreaderLocation: New York, NYDuration: 12+ Months contractShift: 8:00am to 5:00pmJob Description: Client's Enterprise Colleague Communications... 

NBCUniversal

Sports Digital Editor & Content Writer (24/7) Job at NBCUniversal

NBCUniversal is seeking a Freelance Digital Content Writer/Editor for NBC Sports Bay Area in San Francisco. The role involves editing and publishing sports content, managing social media, and writing timely news stories. Candidates should have a Bachelors in journalism... 

C4 Advanced Tactical Systems

Global Trade Compliance Associate (Entry Level) Job at C4 Advanced Tactical Systems

A U.S. manufacturer specializing in trade compliance is seeking a Trade Compliance Associate (entry-level) in Orlando, Florida. This role will ensure adherence to import and export regulations, supporting compliant international trade operations. Responsibilities include...