Snowflake Engineer Job at Purple Drive, Dublin, OH

MTMxR2xKQjF1QVgxSnlrbmg1TXRYTHM5bnc9PQ==
  • Purple Drive
  • Dublin, OH

Job Description

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

Revolution Technologies

Clinical Documentation Specialist - Remote (Must have CCDS OR CDIP) Job at Revolution Technologies

 ...one of the following: o License to practice as a Registered Nurse preferred (any state) o Credentialed as a RHIA (Registered Health...  ...quality and completeness of clinical documentation in the legal medical record. Facilitates necessary documentation in the... 

24 Seven Talent

Email Marketing Specialist Job at 24 Seven Talent

 ...A contemporary fashion and lifestyle brand is seeking a Email Marketing Specialist to lead strategies that deepen customer relationships and drive repeat engagement through best-in-class Email, SMS, and Loyalty programs. In this role, youll own the retention roadmap... 

CyberCoders

Roofing Project Manager - Government, Industrial, Commercial Job at CyberCoders

 ...Roofing Project Manager Position Overview The Roofing Project Manager will oversee and manage roofing projects from inception to completion, ensuring they are delivered on time, within budget, and to the highest quality standards. This role entails coordinating with... 

Dexian

Senior Construction Contracts Manager Job at Dexian

We're Hiring: Senior Construction Contracts Manager Data Center Projects Are you a seasoned professional with a passion for driving operational excellence in high-stakes environments? We're looking for a Senior Construction Contracts Manager to lead critical initiatives... 

LeMans Corporation

Information Technology Technician Job at LeMans Corporation

 ...by-step support guides, equipment lists, and troubleshooting flows, reflecting any changes in infrastructure or process Maintains clean and organized IT workspaces and inventory of spare parts and hardware components Collaborates with internal teams to ensure...