Senior Data Architect
Herndon, VA
Full Time
USDA
Experienced
Job Title: Senior Data Architect
Location: Remote
Clearance: Public Trust
Type: Full-time, W2
About VivSoft:
VivSoft is a mission-driven technology company specializing in Cloud, DevSecOps, Artificial Intelligence, and Digital Experience. We are a diverse team of innovators focused on creating open, scalable, and automated solutions that drive digital transformation in federal space. Our work culture fosters collaboration, creativity, and continuous learning.
Job Summary:
We are seeking a Senior Data Architect to support the USDA Farm Production and Conservation (FPAC) Enterprise Data and Analytics Platform (EDAPT). This role will lead enterprise-wide data architecture initiatives across cloud and hybrid environments, enabling scalable analytics, secure integration, and governance-driven data management.
The ideal candidate will translate business and mission requirements into modern data solutions that support enterprise reporting, advanced analytics, and trusted decision-making while ensuring compliance with federal security and data governance standards.
Key Responsibilities:
Required Skills & Experience:
Preferred Qualifications
JIRA | Confluence | Power BI | Tableau | SQL | Snowflake | Azure Data Factory | AWS Analytics | Data Warehouse | Agile | Scrum | Federal Delivery
Benefits:
Location: Remote
Clearance: Public Trust
Type: Full-time, W2
About VivSoft:
VivSoft is a mission-driven technology company specializing in Cloud, DevSecOps, Artificial Intelligence, and Digital Experience. We are a diverse team of innovators focused on creating open, scalable, and automated solutions that drive digital transformation in federal space. Our work culture fosters collaboration, creativity, and continuous learning.
Job Summary:
We are seeking a Senior Data Architect to support the USDA Farm Production and Conservation (FPAC) Enterprise Data and Analytics Platform (EDAPT). This role will lead enterprise-wide data architecture initiatives across cloud and hybrid environments, enabling scalable analytics, secure integration, and governance-driven data management.
The ideal candidate will translate business and mission requirements into modern data solutions that support enterprise reporting, advanced analytics, and trusted decision-making while ensuring compliance with federal security and data governance standards.
Key Responsibilities:
- Define and maintain enterprise data architecture standards, frameworks, and roadmaps supporting FPAC’s EDAPT environment.
- Translate business requirements into scalable technical architectures across data lakes, warehouses, analytics platforms, and operational systems.
- Establish end-to-end data strategy including ingestion, transformation, storage, governance, and consumption patterns.
- Develop architecture artifacts including conceptual, logical, and physical data models.
- Architect enterprise data ecosystems spanning cloud and hybrid environments including AWS and on-premises platforms.
- Lead implementation of scalable data solutions using AWS S3, Athena, Glue, Redshift, Databricks, Oracle, SQL Server, PostgreSQL, and related technologies.
- Design and govern multi-source integrations and enterprise data pipelines.
- Establish patterns for secure data sharing and interoperability across business domains.
- Drive metadata management, lineage tracking, cataloging, and governance practices.
- Implement and maintain governance frameworks leveraging tools such as Unity Catalog and enterprise metadata repositories.
- Ensure architecture alignment with federal security and compliance requirements including FISMA, FedRAMP, and NIST 800-53.
- Define standards for data quality, stewardship, retention, and lifecycle management.
- Serve as the senior technical authority for enterprise data architecture initiatives.
- Collaborate with executives, product owners, developers, and data engineering teams.
- Review architectural designs, database models, and engineering implementations for scalability and performance.
- Mentor technical teams and establish architectural best practices.
Required Skills & Experience:
- Bachelor’s degree in computer science, Information Systems, Engineering, or related field.
- 10+ years of experience in enterprise data architecture, data engineering, or data platform modernization.
- U.S. Citizenship required.
- Proven experience leading large-scale enterprise data architecture initiatives.
- Hands-on experience with AWS data services such as S3, Athena, Glue, and Redshift.
- Experience across hybrid environments including Oracle, SQL Server, PostgreSQL, Informix
- Strong experience with: Data Warehousing, Data Lakes, Metadata Management, Data Governance, Data Modeling, Enterprise Integration Patterns
- Knowledge of: FISMA, FedRAMP, NIST 800-53.
Preferred Qualifications
- Experience supporting USDA or other Federal Civilian agencies.
- PMP, PMI-ACP, Scrum Master, or SAFe certifications.
- Exposure to cloud data ecosystems (AWS, Azure, GCP).
- Knowledge of ETL, data lake, data governance, and modern BI platforms.
JIRA | Confluence | Power BI | Tableau | SQL | Snowflake | Azure Data Factory | AWS Analytics | Data Warehouse | Agile | Scrum | Federal Delivery
Benefits:
- Comprehensive Medical, Dental, and Vision Plans (Healthcare benefits are 100% employer-paid for employees only)
- Life Insurance
- Paid Time Off (Flexible/Combined PTO, Bereavement Leave, 11 Company Paid Holidays)
- 401K Retirement Plan with employer match
- Professional Development Training Reimbursement
Apply for this position
Required*