Snowflake Engineer Job at Purple Drive, Dublin, OH

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

The Josef Group

Network Analyst Job at The Josef Group

 ...Network AnalystTS/SCI Full Scope Poly Dulles, VA The Network Analyst will be a member of the customer's NA team and will be responsible for their daily substantive work to the NA Team Lead and the Management Team. A candidate is likely to be a subject matter expert... 

Wheeler Staffing Partners

Data Analytics Engineer Job at Wheeler Staffing Partners

 ...Job Title: Data Analytics Engineer Location: Dallas, TX Employment Type: Full-Time | Hybrid (Onsite MondayWednesday, Remote ThursdayFriday after training) Compensation: $80,000 annually + 10% bonus Note: C2C and/or sponsorship is not available for this... 

DetaPent

Data Analyst Job at DetaPent

 ...Entry-Level Data Analyst &##128205; Location: Remote (U.S. based) | Hybrid options available &##128338; Employment Type: Full-time &##128706; Visa Eligibility: GC, OPT, CPT, TN, H4EAD Job Description: We are seeking a motivated and detail-oriented Entry... 

DanceBUG Inc.

Live Action Photographer Job at DanceBUG Inc.

 ...Location: Nationwide travel across the U.S. Compensation: $150-$400 Per Day + ALL Expenses About DanceBUG DanceBUG is the industry leader in Dance Media and Software, celebrating 25 years of innovation serving the dance community. We capture tens of... 

Portico Recruitment - Interior Design Jobs

Senior Interior Designer (Hotel Design) Job at Portico Recruitment - Interior Design Jobs

 ...Senior Interior Designer (Hospitality Focus) Position Overview A leading design studio is seeking an experienced Senior Interior Designer to lead and inspire teams on high-profile hospitality projects, with a primary focus on luxury hotels. The ideal candidate will...