Snowflake Data Architect

QBrainX Inc; Bentonville (AR); Remote; USD 110,000 - 220,000; Full time

Job summary

A leading company is seeking a Data Architect for a remote position in Bentonville, AR. The role involves leading a data warehouse modernization project, transitioning from IBM technologies to Snowflake, and designing scalable cloud-based data solutions. Candidates should have extensive experience in data engineering and strong skills in data modeling and ETL processes. The position offers a competitive salary and the opportunity to work with a talented team on innovative projects.

Qualifications

• 12+ years of experience in data engineering, focusing on data warehouse migrations.
• Strong expertise in Snowflake, IBM iSeries DB2, and data modeling.

Responsibilities

• Lead migration of data warehouse systems to Snowflake.
• Design data models and optimize data pipelines.
• Collaborate with stakeholders to develop data strategies.

Skills

Data Modeling

Problem Solving

Analytical Skills

Tools

DBT

Prefect

SQL

Google Analytics

Snowflake

IBM iSeries DB2

IBM Sailfish

Google Cloud Platform

Google BigQuery

Job description

2 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Role: Data Architect - Data Warehouse Modernization

Location: Bentonville, AR- Remote

Type: Full Time or Contract

Job Overview

We are seeking a highly skilled Data Architect to lead a data warehouse modernization project, transitioning from IBM Sailfish on the IBM iSeries DB2 database to Snowflake. The successful candidate will work with a talented team to modernize our client’s data infrastructure and support the development and implementation of a scalable, cloud-based data platform on Google Cloud Platform (GCP).

Key Responsibilities

• Lead the migration of data warehouse systems from IBM iSeries DB2 and IBM Sailfish to Snowflake.
• Design and implement effectivedata models in Snowflaketo optimize for performance, scalability, and cost-efficiency.
• Architect, design, and optimize data pipelines usingDBTandPrefectto ensure efficient ETL processes.
• Collaborate with data analysts, data scientists, and business stakeholders to develop a data strategy that supports robust analytics and reporting.
• Implement best practices for data quality, data governance, and security within the data platform.
• Work withGoogle BigQueryon integration projects as required, ensuring compatibility with Snowflake.
• Analyze data collected from website clicks & generate business insights usingGoogle Analytics
• Define solution & ImplementChange Data Capture
• Drive continuous improvement in data engineering processes and ensure the platform's scalability, reliability, and availability
• Ability to own the tech stack & oversee multiple migration project tracks & talk to client with big picture

Required Skills and Experience

• 12+ yearsof experience in data engineering, with hands-on experience in data warehouse migration projects.
• Strong expertise withIBM iSeries DB2,IBM Sailfish, andSnowflake.
• Proven experience indata modeling with Snowflake, including star schema and snowflake schema design principles.
• Proficiency in usingDBTfor data transformation andPrefectfor workflow orchestration.
• Experience withGoogle Cloud Platform (GCP)andGoogle BigQuery.
• Solid knowledge of data warehouse design, data modeling, and ETL/ELT processes.
• Proficient inSQLand experienced with performance tuning for large-scale databases
• Experience inGoogle Analytics
• Experience inChange Data Capture
• Strong analytical and problem-solving skills, with the ability to understand complex data requirements.

Preferred Qualifications

• Hands-on experience withcloud migrationprojects.
• Experience in data governance, data security, and data quality management.
• Ability to work independently, manage multiple tasks, and drive projects to completion
• Excellent communication skills, with the ability to explain technical concepts to non-technical stakeholders.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at QBrainX Inc by 2x

Get notified about new Data Architect jobs in Bentonville, AR.

Bentonville, AR $110,000.00-$220,000.00 2 weeks ago

Bentonville, AR $110,000.00-$220,000.00 2 days ago

Bentonville, AR $110,000.00-$220,000.00 2 weeks ago

Integrated Justice Architect - Government Sector - Manager - Consulting - Location Open

Rogers, AR $124,300.00-$227,900.00 2 weeks ago

Fayetteville, AR $149,760.00-$216,320.00 1 month ago

Bentonville, AR $110,000.00-$220,000.00 2 weeks ago

Bentonville, AR $110,000.00-$220,000.00 2 weeks ago

Bentonville, AR $110,000.00-$220,000.00 2 weeks ago

Bentonville, AR $90,000.00-$180,000.00 2 weeks ago

Bentonville, AR $90,000.00-$180,000.00 2 weeks ago

Bentonville, AR $117,000.00-$234,000.00 2 weeks ago

Bentonville, AR $90,000.00-$180,000.00 2 weeks ago

Bentonville, AR $90,000.00-$180,000.00 2 weeks ago

Fayetteville, AR $112,597.33-$152,810.66 1 month ago

Fayetteville, AR $144,768.00-$209,109.33 1 month ago

Bentonville, AR $90,000.00-$180,000.00 2 weeks ago

Bentonville, AR $100,000.00-$120,000.00 1 month ago

Bentonville, AR $90,000.00-$180,000.00 2 weeks ago

Bentonville, AR $110,000.00-$220,000.00 2 weeks ago

Bentonville, AR $90,000.00-$180,000.00 2 weeks ago

Bentonville, AR $90,000.00-$180,000.00 3 days ago

Bentonville, AR $143,000.00-$286,000.00 1 week ago

Bentonville, AR $90,000.00-$180,000.00 1 week ago

Bentonville, AR $90,000.00-$180,000.00 2 days ago

(USA) Principal, Systems and Infrastructure Engineer, Data Security

Bentonville, AR $90,000.00-$180,000.00 1 week ago

Bentonville, AR $90,000.00-$180,000.00 2 days ago

Bentonville, AR $90,000.00-$180,000.00 2 weeks ago

Bentonville, AR $110,000.00-$220,000.00 2 weeks ago

Bentonville, AR $110,000.00-$220,000.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.