Data Architect: Cloud Modeling & Real-Time Analytics

Strategic Staffing Solutions; Virginia (MN); Hybrid; USD 100,000 - 150,000; Full time

Job summary

Strategic Staffing Solutions is seeking an experienced Data Modeler / Data Architect to join our Hampton Roads data and analytics team in a hybrid role. You will design and maintain enterprise data models supporting transactional systems, real-time streaming, and cloud analytics using SQL Server, PostgreSQL, Kafka, BigQuery, and GCP.

The ideal candidate has strong relational database design, cloud warehouse experience, and collaboration skills across engineering, analytics, and business teams to

Qualifications

• 3–6 years of experience in Data Modeling, Database Design, or Data Architecture.
• Production experience designing normalized OLTP schemas using Microsoft SQL Server and PostgreSQL.
• Strong knowledge of database normalization, indexing, referential integrity, and constraints.
• Experience with data modeling tools such as erwin Data Modeler, ER/Studio, SQLDBM.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models for enterprise applications.
• Create normalized OLTP database schemas for Microsoft SQL Server and PostgreSQL environments.
• Design dimensional data models for cloud-based analytics platforms including star schemas and SCDs.
• Develop scalable event schemas for Apache Kafka with Schema Registry compatibility (Avro/Protobuf).
• Collaborate with Data Engineering to support ingestion, transformation, and streaming architectures.
• Partner with developers and analysts to define data requirements and scalable database solutions.
• Optimize database performance through indexing, tuning, and schema optimization.
• Maintain metadata management and data governance initiatives.

Skills

Data Modeling

Database Design

Data Architecture

Tools

erwin Data Modeler

ER/Studio

SQLDBM

Job description

Strategic Staffing Solutions is seeking an experienced Data Modeler / Data Architect to join our Hampton Roads data and analytics team in a hybrid role. You will design and maintain enterprise data models supporting transactional systems, real-time streaming, and cloud analytics using SQL Server, PostgreSQL, Kafka, BigQuery, and GCP.

The ideal candidate has strong relational database design, cloud warehouse experience, and collaboration skills across engineering, analytics, and business teams to