Snowflake Data Engineer/ Architect Job at TalentOla, Virginia

ZEk1NHNodjl2U0xNT3Q3ZWxBbHZPWWpkT3c9PQ==
  • TalentOla
  • Virginia

Job Description

Job description

Data Engineer

  • Support a range of Snowflake DBA-related requests, including virtual warehouse configuration changes, warehouse tagging logic implementation, schema and database creation, role setup, authentication configuration, and platform governance feature enablement.
  • Develop data engineering ELT pipelines using SQL and dbt-based technologies to support analytics and AI-related data processing use cases.
  • Design, develop, and integrate a Snowflake RBAC architecture using Snowflake database roles.
  • Participate in the Data Reliability Engineering on-call rotation, providing tier-1 support for affiliation data engineering pipelines, including weekend coverage as needed.
  • Develop Snowflake Streamlit applications to automate DBA-related tasks and improve operational efficiency.
  • Orchestrate ELT pipelines using Apache Airflow to schedule, monitor, and manage workflow execution.
  • Develop AI capabilities using AWS AI services such as Textract and Snowflake Cortex AI functions.

  1. Expert-level understanding of Snowflake architecture and core warehousing concepts, including virtual warehouses, databases, schemas, roles, data engineering workflows, and data modeling principles.
  2. Strong SQL development skills, including experience building and optimizing complex queries and stored procedures using SQL and/or Python, preferably within Snowflake.
  3. Hands-on experience designing and implementing ELT/ETL patterns, data pipelines, and reusable data transformation logic for reliable and scalable data processing.
  4. Experience building CI/CD automation for data platform or infrastructure workflows using tools such as Terraform, CircleCI, GitLab CI/CD, or similar technologies.

Desirements"

  1. Previous experience working with Airflow.
  2. Previous experience developing Snowflake Streamlit applications.
  3. Previous experience working with dbt.

Job Tags

Full time, Part time, Seasonal work

Similar Jobs

Howden Insurance Local UK

Investment Banking Analyst Job at Howden Insurance Local UK

 ...team and are expected to make a personal impact right from the start. You will work on some of the biggest deals in insurance investment banking, interact with clients almost immediately, travel for the firm and handle increasingly important responsibilities.... 

Bayer

Sr. Materials Manager - O'Hara, PA Job at Bayer

 ...At Bayer were visionaries, driven to solve the worlds toughest challenges and striving for a world where 'Health for all Hunger for none is no longer a dream, but a real possibility. Were doing it with energy, curiosity and sheer dedication, always learning from unique... 

Aramark

Seasonal Deckhand - Fort Sumter Tours - Ft. Sumter - NPS Job at Aramark

 ...The Marina Services Worker is responsible for ensuring guest satisfaction at the marina location by navigating vessels, assisting guests with boat operations, appropriately maintaining the dock area(s), cleaning and restocking vessels, and providing general customer service... 

Tata Consultancy Services

Chief of Staff - Leadership Operations and Executi Job at Tata Consultancy Services

 ...Role Summary The Chief of Staff (CoS) as a strategic partner to CxO and senior leadership, driving governance, executive communication, and data-driven decision-making. The role focuses on structured leadership reporting, dashboarding, and cross-functional alignment to... 

System One

Web & Mobile Content Developer Job at System One

 ...Job Title: Web & Mobile Content Developer Location: Vienna, VA Work Schedule: hybrid, onsite 3 days per week and remote 2 days per week Pay Rate: W2 only Position Type: Multiyear Contract Senior Web Content & Search Engine Optimization (SEO) Specialist....