Senior Data Architect - AWS Redshift & Data Lake

T-Rex Solutions, LLC; Washington (District of Columbia); On-site; USD 150,000 - 195,000; Full time

Benefits offered by this job

PTO from start (prorated)

Parental leave

Health, vision, dental benefits

Tuition reimbursement

401(k) with company match

Job summary

T-Rex Solutions, LLC is seeking a qualified Data Architect to support the 2028 Census Test program. The role focuses on designing a data-centric architecture with a data lake and Redshift on AWS to enable incremental processing of responses and efficient use of administrative data.

You will work with enterprise systems, build data models, and collaborate with cross-functional teams to deliver scalable, secure data infrastructure aligned with the Enterprise Master Data Model.

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 in using AWS environment and cloud services.
• Experience with data warehouses such as Redshift and Snowflake.
• Experience with data lake architectures and broad data structures.
• Strong data transformation, loading, querying, and processing skills.
• Experience with distributed and concurrent data processing and indexing.
• Knowledge of data security considerations and compliant data handling.
• Familiarity with AWS EMR, RDS, EC2 and S3 ecosystems.
• Ability to design scalable data models for hybrid environments.

Responsibilities

• Hands-on design of the data architecture for the Census Enterprise Data Lake on AWS.
• Map requirements to big data artifacts and cloud data workflows.
• Review high-level decennial data architecture across 50+ systems.
• Produce decennial data models and data lineage artifacts.
• Identify data entities and relationships from business context.
• Build prototypes to demonstrate big data design effectiveness.
• Review Census datasets to optimize infrastructure.</br> (note: concise)
• Define data objects for incremental processing and QA purposes.
• Coordinate with system teams and contractors to populate and maintain structures.
• Collaborate with statistical organizations for data analysis alignment.
• Align with Enterprise Master Data Model and drive business understanding.
• Provide leadership on major tasks and develop technical roadmaps.

Skills

Data architecture

Data engineering

AWS cloud

Redshift

Data lake

Data modeling

Big data

Education

Bachelor's in CS or related

Tools

Redshift

AWS EMR

AWS EC2

AWS S3

RDS

Job description

T-Rex Solutions, LLC is seeking a qualified Data Architect to support the 2028 Census Test program. The role focuses on designing a data-centric architecture with a data lake and Redshift on AWS to enable incremental processing of responses and efficient use of administrative data.

You will work with enterprise systems, build data models, and collaborate with cross-functional teams to deliver scalable, secure data infrastructure aligned with the Enterprise Master Data Model.