Data Architect

T-Rex Solutions is seeking a qualified Data Architect to support the 2028 Census Test program, an end-to-end dry run of the operations in preparation for the 2030 Decennial Census. During the test both the enterprise processes and data systems will be verified and fine-tuned to ensure the success of the large-scale national survey. Specifically relevant to this position, the solution will be a data-centric system with a data lake using Redshift on AWS at its core. This solution is expected to transform the processing within the system from what was historically a batch processing system to a more incremental one that processes individual responses as they are collected. Additionally, the Census Bureau intends to increase the usage of Administrative Data during this processing.  As such, the data structures used within this data lake must be efficiently defined to maximize the flexibility for the potential use and addition of administrative data as well as facilitate incremental and large-scale statistical processing.

Responsibilities:

• Hands-on design of the data architecture to be used within the Census Enterprise Data Lake for 2030 Census processing. This structure will compose data from 350+ million person records, 18-+ million address records, and other associated administrative data.
• Perform analysis on data workflow and detail requirements to map them into big data artifacts in Cloud environment
• Review the high-level design of the entire decennial data architecture across 50+ different enterprise systems
• Produce data architecture artifacts such as decennial-wise conceptual, logical, and lineage data models for both management and technical users
• Work with system owners to identify key data entities and relationships on the basis of business context
• Build data architecture prototypes to demonstrate the effectiveness and efficiency of the big data design approach
• Review Census data sets and conduct empirical studies as needed to build an optimal data infrastructure to support the mission
• Identify the complex relationships within various data sets and define corresponding data objects for incremental processing
• Frequently coordinate and collaborate with the various system teams and other contractors that will populate and use data via these structures to efficiently build the structures to facilitate their update, maintenance, ability to search, and ability to compare to administrative data for QA and other purposes.
• Frequently coordinate and collaborate with the various statistical organizations that will analyze this data to efficiently build the structures to facilitate this analysis.
• Coordination with the Census Bureau data architect to drive alignment with the Enterprise Master Data Model.
• Be in a highly visible position to work with client team closely to understand the business needs and identify the key solution areas.
• Provides technical/management leadership on major tasks or technology assignments. Establishes goals and plans that meet project objectives.
• Develop roadmaps and provide technical strategy directions for the development and delivery of a new enterprise data framework.
• Transform business requirements into data driven solutions including architectural design, component standardization, technical process flow, and cost-effective implementation approaches.
• Participate as needed in all aspects of software development with emphasis on the planning, analysis, design, integration, and presentation.
• Apply principles, design methods and data architecture knowledge to specific requirements in the context of 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.

Requirements:

• 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 Amazon Web Services (AWS) environment and/or other Cloud environments
• Expertise in using data warehouses such as Redshift, Snowflake, or similar technologies
• Expertise in a wide range of cloud data services and data structures  (in addition to data warehouse), such as data lake, Iceberg table, document DB, key-value DB, and time-series DB
• Strong general data engineering knowledge, including data transformation, data loading, data procedure writing, and data querying
• Solid skills in distributed and concurrent data processing, including the use of data partitions and indexes for performance enhancement
• Strong background in various types of data infrastructure and services such as AWS EMR clusters, AWS RDS, EC2, and S3.
• Ability to design data models that are scalable in a hybrid environment of big data platforms and traditional databases
• Ability to evaluate design and implementation from data security perspective
• Strong data management and transformation skills to provide efficient solutions to business outcomes
• Strong, 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 best practices in IT industry
• Solid understanding of Agile methodologies, with strong background working in an Agile development environment, collaborating with development and architecture teams
• Ability to obtain Public Trust (MBI) Clearance

Desired Skills:

• Expertise recommending analytical and reporting tools in the federal market.
• Expertise with Data Transformation and migration using AWS technologies and open-source tools.
• Experience in adopting AI/ML technologies and applying them to enterprise data sets.
• Hands-on experience with other Data Engineering and data science development efforts such as Data Ingestion, Cleansing, and Transformation.

T-Rex Overview

Established in 1999, T-Rex Solutions, LLC is a proven mid-tier business providing data-centric mission services to the Federal government as it increasingly tries to secure and leverage the power of data. We design, integrate, secure, and deploy advanced technical solutions for our customers so they can efficiently fulfill their critical objectives. T-Rex offers both IT and professional services to numerous Federal agencies and is a leader in providing high quality and innovative solutions in the areas of Cloud and Infrastructure Services, Cyber Security, and Big Data Engineering.

T-Rex is constantly seeking qualified people to join our growing team. We have built a broad client base through our devotion to delivering quality products and customer service, and to do that we need quality individuals. But more than that, we at T-Rex are committed to creating a culture that supports the development of every employee's personal and professional lives. T-Rex has made a commitment to maintain the status of an industry leader in compensation packages and benefits which includes competitive salaries, performance bonuses, training and educational reimbursement, Transamerica 401(k) and Cigna healthcare benefits.

T-Rex is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex (including pregnancy and sexual orientation), parental status, national origin, age, disability, family medical history or genetic information, political affiliation, military service, or other non-merit based factors.

In compliance with pay transparency guidelines, the annual base salary range for this position is $150,000 - $195,000. Please note that the salary information is a general guideline only. T-Rex considers factors such as (but not limited to) scope and responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as market and business considerations when extending an offer.

T-Rex offers a diverse and collaborative work environment, exciting opportunities for professional growth, and generous benefits, including: PTO available to use immediately upon joining (prorated based on start date), paid parental leave, individual and family health, vision, and dental benefits, annual budget for training, professional development and tuition reimbursement, and a 401(k) plan with company match fully vested after 60 days of employment among other benefits.