Data Architect

Tech Army, LLC; Tallahassee (FL); On-site; USD 120,000 - 160,000; Full time

Job summary

Tech Army, LLC is seeking an experienced Data Architect to support enterprise modernization and IV&V for a 12-month engagement in Tallahassee, FL. The role emphasizes architecture assessment, data migration, data quality controls, and governance, without owning day-to-day development.

Candidates should excel in data modeling, ETL/ELT, APIs, and multi-system integrations, with strong communication to executives and stakeholders.

Qualifications

• Proven ability to model conceptual, logical and physical data for enterprise architectures.
• Strong SQL and relational database design skills.
• Experience with data migration/conversion strategies and source-to-target mappings.
• Expertise in ETL/ELT and enterprise data integration.
• Experience with data governance, metadata, lineage, and auditability.
• Familiarity with SDLC, system integration testing, and traceability.
• Ability to perform architecture reviews and risk assessments at program level.
• Effective communication with executives and stakeholders.

Responsibilities

• Review current and proposed enterprise data architectures, designs, schemas, and models.
• Evaluate multiple data models for architectural consistency across the solution.
• Assess data migration, transformation, sequencing, and cutover readiness.
• Assess data profiling, cleansing, deduplication, accuracy, and quality controls.
• Identify risks around historical data, referential integrity, and data loss.
• Review ETL/ELT processes, APIs, interfaces, messaging, and data exchange structures.
• Evaluate data exchanges between AIMS, FDLE systems, and external partners.
• Verify requirements traceability through architecture, development, testing, and implementation.
• Evaluate testing coverage, acceptance criteria, and cutover readiness.
• Review data governance, metadata, lineage, access controls, and change management.
• Assess backup, high availability, DR, and operational readiness.
• Provide remediation recommendations and contribute to IV&V reports and briefings.
• Collaborate with technical teams, leadership, and oversight bodies while remaining independent.

Skills

Data modeling

SQL

Data migration

ETL/ELT

Data governance

SDLC/testing

Architecture risk

Stakeholder comms

Legacy modernization

APIs/multi-system

Data quality

Requirements mgmt

Security/compliance

Tools

Oracle Database

Microsoft SQL Server

Azure data integration

ETL/ELT tools

API/messaging

SharePoint

Visio

Microsoft Project

Excel

PowerPoint

Word

Job description

Job Title: Data Architect – Enterprise Modernization / IV&V

Engagement: 12 month + potential ext

Overview:

We are seeking an experienced Data Architect to support our customer. This is an excellent opportunity for a senior data professional with experience supporting large-scale enterprise modernization, legacy-system replacement, data migration, data integration, and highly regulated information environments.

The Data Architect will serve as a senior technical subject-matter expert supporting Independent Verification & Validation (IV&V) activities. This role is focused on independently assessing architecture, data migration, quality, integrations, testing, security, and modernization readiness—not owning day-to-day application development.

What You'll Be Doing

• Review current-state and proposed enterprise data architectures, database designs, schemas, and data models.
• Evaluate conceptual, logical, and physical data models and ensure architectural consistency across the solution.
• Assess data migration and conversion strategies, including source-to-target mappings, transformation logic, sequencing, reconciliation, and cutover readiness.
• Evaluate data profiling, cleansing, deduplication, completeness, accuracy, and data-quality controls.
• Identify risks involving historical data, referential integrity, duplicate identities, incompatible data formats, downstream dependencies, and potential data loss.
• Review ETL/ELT processes, APIs, system interfaces, messaging, XML/data-exchange structures, and batch/real-time integrations.
• Assess interoperability and data exchanges between AIMS, other FDLE systems, and external criminal-justice partners.
• Review functional and non-functional data requirements and verify requirements traceability through architecture, development, testing, and implementation.
• Evaluate system integration testing, interface testing, test data, test coverage, acceptance criteria, and cutover readiness.
• Review data governance, metadata, lineage, access controls, auditability, retention, configuration management, and change-control practices.
• Evaluate backup/recovery, high availability, operational readiness, and disaster-recovery considerations.
• Identify architecture and data risks and provide clear, actionable remediation recommendations.
• Contribute to IV&V assessments, periodic review reports, risk findings, executive briefings, and project-status reviews.
• Work with technical teams, project leadership, business stakeholders, and oversight organizations while maintaining the independence required of an IV&V function.

Required Experience

We're looking for candidates with strong experience in:

• Conceptual, logical, and physical data modeling
• Relational database architecture and advanced SQL
• Source-to-target mapping and transformation
• ETL / ELT and enterprise data integration
• Data profiling, cleansing, reconciliation, and data-quality management
• APIs, interfaces, messaging, and multi-system integrations
• Data governance, metadata, lineage, and auditability
• Requirements management and traceability
• SDLC, system integration testing, acceptance testing, and implementation readiness
• Legacy-system modernization
• Technical architecture reviews and risk assessments
• Executive-level technical documentation and stakeholder communication

Preferred Technology Experience

Candidates with experience in the following environments will be especially attractive:

• Oracle Database and/or Microsoft SQL Server
• ETL/ELT and enterprise integration technologies
• API and messaging architectures
• Modern Azure data integration, analytics, warehouse/lake, or governance technologies
• SharePoint, Visio, Microsoft Project, Excel, PowerPoint, and Word

Highly Desirable

• Previous U.S. federal, state, or local government IT modernization experience
• Florida public-sector technology experience
• Law-enforcement, public-safety, courts, corrections, or justice-information systems
• Records-management, case-management, investigative, or criminal-history systems
• NIEM, XML, IEPD, or Interface Control Document (ICD) experience
• Project assurance, technology assessment, IT governance, or architecture-review experience
• Florida DMS Rule 60GG-1 / Category 4 project oversight knowledge
• Experience with high-volume, mission-critical transactional systems
• High availability, disaster recovery, backup/recovery, data retention, and auditing