Data Architect

T-Rex Solutions•Suitland, MD

6d•$150,000 - $195,000

About The Position

T-Rex Solutions is seeking a Data Architect to support the 2028 Census Test, an end-to-end dry run of operations in preparation for the 2030 Decennial Census. The program will verify and refine enterprise processes and data systems. The solution is a data-centric system centered on a data lake using Amazon Redshift on AWS. It is intended to shift processing from a historical batch approach to incremental processing of individual responses as they are collected, while increasing the use of administrative data. Data structures must support flexible addition and use of administrative data, incremental processing, and large-scale statistical analysis. The Data Architect will design and develop the Census Enterprise Data Lake architecture for 2030 Census processing, spanning hundreds of millions of person records, millions of address records, and associated administrative data. The role works closely with client teams, system owners, other contractors, statistical organizations, and the Census Bureau data architect to define and align data structures, models, and architecture with business needs and the Enterprise Master Data Model. The position also provides technical and management leadership, develops strategy and roadmaps, and supports software development and system design activities. T-Rex Solutions provides data-centric mission services to the Federal government, including cloud and infrastructure services, cybersecurity, and big data engineering. The company describes a diverse and collaborative work environment and offers opportunities for professional growth. The listed annual base salary range is $150,000–$195,000.

Requirements

At least 7 years of experience developing enterprise-scale data architecture and data engineering solutions.
Bachelor’s degree in Computer Science or a related field.
Expertise in AWS and/or other cloud environments.
Expertise with data warehouses such as Redshift, Snowflake, or similar technologies.
Expertise with cloud data services and data structures, including data lakes, Iceberg tables, document databases, key-value databases, and time-series databases.
Strong general data engineering knowledge, including data transformation, data loading, procedure writing, and querying.
Solid skills in distributed and concurrent data processing, including using partitions and indexes to improve performance.
Strong background in data infrastructure and services such as AWS EMR clusters, AWS RDS, EC2, and S3.
Ability to design scalable data models across hybrid big data platforms and traditional databases.
Ability to evaluate designs and implementations from a data security perspective.
Strong data management and transformation skills for delivering efficient business outcomes.
Hands-on working knowledge of data fabric architectures, data meshes, data analytics, big data platforms, and data visualization.
Solid understanding of software engineering principles, design methodologies, technology architecture, and IT industry best practices.
Solid understanding of Agile methodologies and experience working in an Agile development environment with development and architecture teams.
Ability to obtain Public Trust (MBI) clearance.

Nice To Haves

Expertise recommending analytical and reporting tools in the federal market.
Expertise in data transformation and migration using AWS technologies and open-source tools.
Experience adopting AI/ML technologies and applying them to enterprise datasets.
Hands-on experience with data engineering and data science efforts such as data ingestion, cleansing, and transformation.

Responsibilities

Design the data architecture for the Census Enterprise Data Lake supporting 2030 Census processing, including structures for person, address, and administrative data.
Analyze data workflows and detailed requirements and map them into big data artifacts in a cloud environment.
Review the high-level decennial data architecture across more than 50 enterprise systems.
Produce conceptual, logical, and lineage data models for management and technical users.
Work with system owners to identify key data entities and relationships based on business context.
Build prototypes to demonstrate the effectiveness and efficiency of big data design approaches.
Review Census datasets and conduct empirical studies as needed to build an optimal data infrastructure.
Identify complex relationships across datasets and define data objects for incremental processing.
Coordinate with system teams and contractors to design structures that support updates, maintenance, search, and comparison with administrative data for quality assurance and other purposes.
Coordinate with statistical organizations to design data structures that facilitate analysis.
Coordinate with the Census Bureau data architect to align with the Enterprise Master Data Model.
Work closely with client teams to understand business needs and identify key solution areas.
Provide technical and management leadership on major tasks or technology assignments and establish goals and plans that meet project objectives.
Develop roadmaps and provide technical strategy for developing and delivering a new enterprise data framework.
Transform business requirements into data-driven solutions, including architectural design, component standardization, technical process flows, and cost-effective implementation approaches.
Participate as needed in software development planning, analysis, design, integration, and presentation.
Apply data architecture principles and design methods to requirements within a complex, large-scale enterprise data framework.
Coordinate with senior management on project activities, including business analysis, client collaboration, product provisions, and project staffing.
Provide high-level support for system design, development, integration, and coordination.