Data Architect

CloudIngest; Issaquah (WA); On-site; USD 140,000 - 190,000; Full time

Job summary

CloudIngest is seeking an experienced Retail Data Architect to re-architect enterprise data models and modernize platforms on GCP. You will design OLTP/OLAP data structures, support JSON-heavy datasets, and guide governance and metadata practices across the organization.

The role requires strong leadership, mentoring of junior engineers, and collaboration with onsite-offshore delivery teams to align retail workflows with modern data architecture.

Qualifications

• Must have hands-on Erwin Data Modeling experience.

Responsibilities

• Design enterprise data models for OLTP and OLAP environments.
• Reverse engineer existing data models and transform to future-state architectures.
• Lead modernization initiatives and implement data governance.
• Evaluate DB2, Cloud SQL, AlloyDB, and BigQuery on GCP for structured and unstructured data.
• Mentor junior data modelers and collaborate with onsite-offshore teams.
• Communicate across cross-functional teams to align with retail processes.

Skills

Erwin Data Modeling

OLTP/OLAP models

JSON data modeling

Data governance

Metadata management

GCP database strategy

Cloud-native architecture

DB2

Cloud SQL

AlloyDB

BigQuery

Retail domain

Legacy modernization

Domain Driven Design

Leadership & communication

Onsite-offshore delivery

Job description

We are looking for an experienced Retail Data Architect with strong expertise in modern data architecture, retail domain knowledge, and cloud-native database technologies.

The ideal candidate will play a key role in rearchitecting and modernizing enterprise business applications and data models for scalable, high-performance platforms on GCP.

Key Responsibilities

Design and develop enterprise data models using Erwin for both OLTP and OLAP environments, including support for JSON and mixed data types.

Create and optimize modernized web application data models focused on scalability, performance, and efficient application processing. Reverse engineer existing data models and transform them into future-state architectures aligned with business and technical requirements.

Lead data modeling efforts for modernization and re-architecture initiatives across enterprise applications. Define and implement data governance and data management best practices.

Evaluate and recommend appropriate database technologies on GCP for structured and unstructured datasets. Work across multiple database technologies including DB2, Cloud SQL, AlloyDB, BigQuery, and related platforms. Collaborate with cross-functional teams to understand retail business processes, module interdependencies, and enterprise data elements.

Support Domain Driven Design (DDD) principles and architectural best practices in solution design. Guide and mentor junior data modelers and architects within an onsite-offshore delivery model.

Effectively manage multiple priorities in a fast-paced and evolving environment.

Required Skills & Qualifications

• Strong hands-on experience with Erwin Data Modeling tools. Expertise in designing OLTP and OLAP data models, including JSON-based and complex data structures.


• Experience building high-performance data models for modern web applications.


• Strong understanding of data governance, metadata management, and data management principles.


• Experience with GCP database selection strategies and cloud-native architecture.


• Hands-on experience with technologies such as DB2, Cloud SQL, AlloyDB, BigQuery, and other modern database platforms.


• Strong retail domain experience with understanding of retail workflows, business processes, and data dependencies.


• Proven experience in rearchitecting legacy application data models for modern technology stacks.


• Ability to reverse engineer and modernize complex enterprise data models.


• Strong communication and leadership skills with experience working in onsite-offshore delivery models. Self-driven, adaptable, and capable of navigating ambiguity and changing priorities.


• Solid understanding of Domain Driven Design patterns and principles.

Preferred Qualifications

• Experience with enterprise modernization and digital transformation initiatives.


• Prior experience leading data architecture discussions with business and technical stakeholders.


• Exposure to cloud-native application architectures and distributed systems.

Mandatory Areas

Must Have Skills – Retail Data Architect

• Skill 1 – 8 + Years of exp in Data Architecture


• Skill 2 – 3 + Years of Exp in Data Modeling