Snowflake Engineer Job at Purple Drive, Dublin, OH

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

13th Judicial District Attorney

Deputy District Attorney - County Court Job at 13th Judicial District Attorney

 ...visions benefits for employee, as well as a retirement plan. RELOCATION: A one-time relocation bonus of $2,500 may be offered to the...  ...on UBE Score Transfer. The District Attorneys Office will assist with the cost of any Attorney admission fees or dues. . Must... 

General Dynamics Mission Systems

CNC Machine Operator Sr Job at General Dynamics Mission Systems

 ...will remain open until the position is filled. Combined Salary Range USD $0.00 - USD $0.00 /Yr. Company Overview General Dynamics Mission Systems (GDMS) engineers a diverse portfolio of high technology solutions, products and services that enable customers... 

ONEOK

Pipeline Operator - Senior Job at ONEOK

 ...Leading midstream service provider. Safety first. Sustainable operations. Environmentally responsible. Employee focused. JOB SUMMARY...  ...Perform advanced level work related to gas and/or liquids pipeline system operations acting as a subject matter expert. Essential... 

Pacific Office Automation

Copier/ Printer Field Service Technician Job at Pacific Office Automation

Overview Copier/ Printer Field Service Technician role at Pacific Office Automation. Pacific Office Automation is one of the largest independently-owned document imaging and technology dealers in the nation, serving customers since 1976 with growing branches across ten... 

Optiver

Campus Recruiter Job at Optiver

 ...biggest asset are our people. Theyre the individuals solving the most challenging problems that drive our business forward. The Campus Recruitment team is instrumental to getting the best and brightest individuals into the firm. As a Technology Campus Recruiter, you will...