Snowflake Engineer Job at Purple Drive, Dublin, OH

VWlRRHV1SzA4b09iVUZGWlJIT1V6NDlxNXc9PQ==
  • 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

Aequor Allied

Travel Occupational Therapist Job at Aequor Allied

 ...Job Description Aequor Allied is seeking a travel Home Health Occupational Therapist for a travel job in San Ramon, California. Job Description & Requirements ~ Specialty: Occupational Therapist ~ Discipline: Therapy ~ Start Date: ASAP ~ Duration: 13 weeks... 

Birch Agency

Educational Sign Language Interpreter Job at Birch Agency

Job Description Job Description Seeking to hire an Educational American Sign Language Interpreter .This is a full-time contract and must be fluent in American Sign Language Interpreter. Training and Educational Requirements: Associates degree of deaf education...

Zobility

Purchasing Assistant Job at Zobility

Job Description: Tasks that are performed may involve complex documents, spreadsheets, reports, and presentations as well as completion of specialty-specific templates and forms. Principals provide most substance for such materials, but the incumbent will...

ABC Legal Services

Document Retrieval Specialist (Remote) at ABC Legal Services Tampa, FL Job at ABC Legal Services

Overview Document Retrieval Specialist (Remote) job at ABC Legal Services. Tampa, FL.About ABC Legal Services ABC Legal Service is proud to be the national leader in filing service of legal documents. We are growing and are looking for talented new team members to support... 

Balyasny Asset Management L.P.

Campus Recruiter Job at Balyasny Asset Management L.P.

Join to apply for the Campus Recruiter role at Balyasny Asset Management L.P.BAMs Campus team is responsible for recruiting best-in-class intern and grad level talent globally across our investment, data, technology and business and operations teams. We are seeking an...