Data Architect
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.
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.
