Data Architect Manager – Data Warehouse Modernization

Springfield, MO, US • Posted 8 days ago • Updated 8 days ago
Full Time
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

  • IBM
  • IBM iSeries
  • Data Warehouse
  • Data Engineering
  • Data Architecture
  • SQL
  • Snow Flake Schema

Summary

We are looking for a Data Architect Manager to lead a large-scale data warehouse modernization initiative, migrating legacy systems (IBM iSeries DB2 / IBM Sailfish) to Snowflake on Google Cloud Platform. This role requires strong technical expertise along with leadership capabilities to drive architecture, oversee multiple workstreams, and engage with stakeholders at all levels.

 

Key Responsibilities:

 

Lead end-to-end data warehouse modernization from IBM iSeries DB2/Sailfish to Snowflake

Define and implement scalable data architecture on Google Cloud Platform (Google Cloud Platform)

Design optimized data models (star/snowflake schemas) for performance and cost efficiency

Oversee development of ETL/ELT pipelines using DBT and Prefect

Drive Change Data Capture (CDC) implementation for real-time/near real-time data processing

Collaborate with business stakeholders, analytics teams, and leadership to define data strategy

Ensure data governance, security, and data quality standards are implemented

Integrate Snowflake with Google BigQuery and other Google Cloud Platform services as needed

Provide insights using Google Analytics and clickstream data

Lead multiple migration tracks and ensure timely delivery with high reliability

Act as a client-facing technical leader, presenting architecture and solutions at a strategic level

Required Skills & Experience

12+ years in Data Engineering / Data Architecture, with leadership experience

Strong expertise in Snowflake, IBM iSeries DB2, and legacy data warehouse systems

Hands-on experience in data warehouse migration projects

Proficiency in DBT, Prefect, SQL, and performance tuning

Strong experience with Google Cloud Platform (BigQuery, cloud-native services)

Expertise in data modeling, ETL/ELT, and CDC frameworks

Experience with Google Analytics / clickstream data analysis

Ability to manage teams, prioritize workstreams, and drive delivery

Preferred Qualifications

Experience in cloud modernization programs

Strong background in data governance and security frameworks

Excellent stakeholder communication and leadership skills

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91052859
  • Position Id: 8920259
  • Posted 8 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Springfield, Missouri

Today

Full-time

USD 80,000.00 - 125,000.00 per year

Springfield, Missouri

Today

Full-time

USD 140,000.00 - 200,000.00 per year

Remote

28d ago

Easy Apply

Full-time

Depends on Experience

Remote

23d ago

Easy Apply

Full-time

Depends on Experience

Search all similar jobs