SNOW FLAKE ARCHITECT

  • St. Louis, MO
  • Posted 31 days ago | Updated 31 days ago

Overview

On Site
Hybrid
$160,000 - $180,000
Full Time
Able to Provide Sponsorship

Skills

Computer Science
EC2
ETL processes
Github
ETL
Jira
S3
Strong communication skills
Terraform
agile development
collaborate
communication skills
data engineering
data integration
data pipelines
data warehouse
data warehouses
data warehousing
fintech
problem - solving
problem - solving skills
project management
quality

Job Details

Position: Snowflake Architect

Location: St. Louis, MO (Onsite/Hybrid)

Salaries : $150K - $160K + Benefits

Key responsibilities:

  • Design, build, and maintain data pipelines that enable the extraction, transformation, and loading (ETL) of data from various sources into Snowflake data warehouses.
  • Utilize AWS services such as S3, Glue, EC2, Lambda, and others to manage data storage, processing, and automation.
  • Administer and optimize the Snowflake data warehouse environment, including managing data warehouses, roles, and access controls.
  • Create and manage infrastructure as code (IAC) using Terraform to automate and maintain AWS and Snowflake resources.
  • Develop and maintain integrations between data sources, ensuring data consistency and accuracy.
  • Work within an agile development framework, collaborating with cross-functional teams to deliver data solutions that meet the evolving needs of the organization.
  • Use Jira for task tracking and project management.
  • Implement data quality checks and validation processes to ensure data integrity and reliability.
  • Maintain detailed documentation of data engineering processes and solutions.

Required Skills:

  • 8+ years proven experience in data engineering and architecture, including ETL processes, data pipelines, and data warehouse modeling.
  • Experience using Github for CI/CD pipeline
  • Experience with using Airflow for scheduling and monitoring data workflows
  • Expertise in AWS services, particularly for data and analytics, and experience with Snowflake data warehousing.
  • Agile Methodology: Experience working in an agile development environment and using Jira for task management.
  • Strong problem-solving skills and the ability to work with large datasets.
  • Strong communication skills and the ability to collaborate with cross-functional teams.
  • A commitment to data accuracy, quality, and security.
  • Experience with data integration tools and practices is a plus.

Good to have skills:

  • Master s degree in Computer Science, Engineering or related field is preferred
  • Proficiency in infrastructure as code (IAC) using Terraform for AWS and Snowflake is a big plus
  • Experience with CI/CD data infrastructure build-up
  • Experience in banking, financial services, credit card, fintech in a start-up environment