Snowflake Engineer Job at Purple Drive, Dublin, OH

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

AllJobs

Remote Work From Home Jobs / Data Entry Clerk - Typing Job at AllJobs

 ...About the job Remote Work From Home Jobs / Data Entry Clerk - Typing Job Title: Remote Work From Home Jobs / Data Entry Clerk -...  ...Benefits: Excellent weekly pay Safe workplace Multiple shifts are available from morning to night and no experience is... 

City of Danville, VA

School Resource Officer/Police Officer (DCJS Law Enforcement Certified) Job at City of Danville, VA

 ...radio, computer, personal devices, MS Office, other software and related hardware. Standard law enforcement equipment including a firearm, baton, taser and other equipment as assigned. WORK ENVIRONMENT The work is normally performed in various locations... 

Coptic Orphans

Compliance Officer Job at Coptic Orphans

 ...Compliance OfficerPurpose of the JobThe Compliance Officer is responsible for monitoring the external regulatory environment across Coptic Orphans' five operating jurisdictions (USA, Canada, Australia, UK, and Egypt) and ensuring the organization understands, manages... 

Centerstone

Health Coach CCBHC Job at Centerstone

## Health Coach CCBHCApplyremote type: Community Based and Office Basedlocations: Nashville, Indianatime type: Full timeposted on: Posted...  ...** Effectively communicate via written, verbal, in person and virtual methods.* Customer service skills.* Time management skills.* Analytical... 

Swissport International

ANC Ramp Agent - Full Time, Overnight Hours Job at Swissport International

 ...Report all equipment malfunctions to the appropriate supervisor/manager Comply with all federal, state, municipal, airport authority and carrier security requirements Other duties as assigned Your profile: Previous ramp experience is a plus Valid...