Snowflake Data Architect

Jobs via Dice
Woodbridge Township, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Woodbridge Township, United States of America

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Data analysis
Azure
Bash
Cloud Computing
Data Architecture
Information Engineering
Data Governance
Data Integration
ETL
Data Transformation
Data Migration
Data Warehousing
IBM DB2
Database Queries
Monitoring of Systems
Python
Machine Learning
Meta-Data Management
Microsoft SQL Server
Performance Tuning
Data Processing
Scripting (Bash/Python/Go/Ruby)
Google Cloud Platform
Informatica Powercenter
Snowflake
Data Strategy
Data Lake
Information Technology
Amazon Web Services (AWS)
Data Pipelines
Redshift

Job description

We are seeking an experienced Data Architect to join our team and take a lead role in designing, developing, and optimizing our data architecture. As a Data Architect, you will play a crucial role in shaping our data strategy by leveraging AWS services such as S3 for data lakes, Redshift, AWS Glue, Informatica, Python for Scripting and automation, Snowflake for data warehousing, DBT for modeling, and Fivetran for data integration. Key Responsibilities

  • Design, implement, and maintain Snowflake data warehouse solutions to fulfill business requirements effectively.
  • Deploy and optimize DBT models and transformations to streamline data processing and facilitate analytics.
  • Manage Fivetran data pipelines to enable seamless data integration and synchronization.
  • Utilize AWS Glue for data cataloging, executing ETL jobs, and performing data transformation operations.
  • Apply Python and SageMaker for advanced analytics, machine learning initiatives, and data science projects.
  • Employ DB2, SQLServer, and Informatica as necessary for data migration, integration, and administration tasks.
  • Collaborate with data engineers, analysts, and stakeholders to comprehend data needs and deliver actionable insights.
  • Develop and enforce data governance and security protocols to uphold data quality and regulatory compliance.
  • Monitor system performance, troubleshoot issues, and implement performance optimization strategies.
  • Stay abreast of industry best practices and emerging technologies in data warehousing and cloud computing domains.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • Proven experience working with Snowflake, DBT, Fivetran, AWS Glue, Python, SageMaker, DB2, SQLServer, and Informatica technologies in a data engineering or analytics role with 5-6 years of experience.
  • Certifications in Snowflake, DBT, AWS Glue, Python, SageMaker, or related technologies.
  • Knowledge of data governance frameworks and data privacy regulations (eg, GDPR, CCPA).
  • Strong SQL skills and experience with data modeling, ETL/ELT processes, and data pipeline management.
  • Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform.
  • Experience with Scripting languages (eg, Python, Bash) for automation and orchestration tasks.
  • Excellent analytical, problem-solving, and communication skills.
  • Ability to work independently and collaboratively in a fast-paced environment.

Apply for this position