Cloud Data Architect – AWS Redshift & Data Lake Innovator

T-Rex Solutions; Suitland (MD); On-site; USD 150,000 - 195,000; Full time

Benefits offered by this job

PTO available to use immediately upon‑

Parental leave

Health, vision and dental benefits

Tuition reimbursement

Job summary

T-Rex Solutions is seeking a Data Architect to design and implement the Census Enterprise Data Lake, leveraging Redshift on AWS and a data-centric architecture for incremental processing of large-scale data.

The role requires deep expertise in cloud data services, data modeling, and data governance to support 350+ million person records and 18+ million addresses, with coordination across multiple teams and stakeholders.

Qualifications

• 7+ years of experience developing data architecture and data engineering solutions at enterprise scale.
• Bachelor’s degree in Computer Science or related field.
• Expertise with AWS and cloud environments.
• Experience with data warehouses such as Redshift or Snowflake.
• Strong data engineering knowledge including data transformation, loading, querying.
• Solid understanding of distributed data processing and data partitioning.
• Experience with AWS EMR, RDS, EC2, and S3.

Responsibilities

• Hands-on design of the data architecture for Census Enterprise Data Lake.
• Analyze data workflow and map requirements to big data artifacts in the Cloud.
• Review high-level decennial data architecture across 50+ enterprise systems.
• Produce data architecture artifacts including conceptual, logical, and lineage models.
• Work with system owners to identify key data entities and relationships.
• Build data architecture prototypes to demonstrate big data design effectiveness.
• Review datasets and conduct empirical studies to optimize data infrastructure.
• Define data objects for incremental processing and enable QA with admin data.
• Coordinate with multiple teams and contractors to build and update data structures.
• Collaborate with statistical organizations to enable analysis of the data.

Skills

AWS

Data architecture

Data engineering

Redshift

Snowflake

Cloud data services

Data modeling

Data governance

Distributed processing

Education

Bachelor’s degree in Computer Science or related field

Tools

AWS EMR

AWS RDS

EC2

S3

Job description

T-Rex Solutions is seeking a Data Architect to design and implement the Census Enterprise Data Lake, leveraging Redshift on AWS and a data-centric architecture for incremental processing of large-scale data.

The role requires deep expertise in cloud data services, data modeling, and data governance to support 350+ million person records and 18+ million addresses, with coordination across multiple teams and stakeholders.