Lead Data Architect

Inadev•Reston, VA

9d•$205,000 - $220,000•Hybrid

About The Position

Inadev is seeking a highly experienced Lead Data Architect to define and drive the data architecture for the SEC’s EDGAR program. The role leads the design and modernization of highly available, scalable, secure, and resilient data platforms using AWS cloud services and open-source database technologies. The Lead Data Architect establishes data architecture standards, guides database modernization and migration, and collaborates with application architects, engineers, DevSecOps teams, cybersecurity personnel, and business stakeholders. The role calls for enterprise data architecture experience and hands-on expertise in PostgreSQL, AWS, data modeling, database performance, and cloud-native architecture. The position requires a hybrid schedule of 3–4 days in Reston, Virginia, and client locations in the Washington, D.C. area as required. Applicants must be U.S. citizens and able to pass a seven-year background check and obtain and maintain a U.S. Government Clearance. Inadev is an equal opportunity employer and federal contractor.

Requirements

Must be a U.S. citizen.
Must be willing to work a hybrid schedule of 3–4 days in Reston, VA, and client locations in the Washington, D.C. area as required.
Ability to pass a seven-year background check and obtain and maintain a U.S. Government Clearance.
Strong communication and presentation skills.
Ability to prioritize and self-start; adaptability as priorities shift; enthusiasm for learning and continuous improvement; openness to collaboration, feedback, and client requests.
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical discipline.
10+ years of experience in database engineering, data architecture, or related disciplines.
5+ years in a senior or lead data architecture role supporting complex enterprise systems.
Deep expertise with PostgreSQL and open-source relational database technologies.
Strong experience designing database solutions in AWS.
Experience with Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL.
Strong knowledge of relational data modeling, normalization, indexing, partitioning, query optimization, and transaction processing.
Experience architecting highly available, resilient, and scalable database platforms.
Experience with database modernization and migration.
Strong understanding of database security, encryption, access control, backup, recovery, and auditing.
Experience supporting Agile and DevSecOps delivery environments.
Strong technical leadership, communication, and architecture documentation skills.

Nice To Haves

Experience migrating enterprise databases from commercial or legacy technologies to PostgreSQL or Aurora PostgreSQL.
Experience with AWS Database Migration Service (DMS), AWS Schema Conversion Tool (SCT), or comparable migration technologies.
Experience with AWS Glue, Amazon S3, CloudWatch, Secrets Manager, KMS, and related AWS services.
Familiarity with Infrastructure as Code and automated database deployment.
Experience with APIs, microservices, event-driven architectures, and distributed systems.
Knowledge of data governance, metadata management, lineage, and data-quality practices.
Familiarity with FISMA, NIST, and federal cybersecurity requirements.
Experience supporting large-scale financial, regulatory, or federal information systems.
AWS database, solutions architecture, or PostgreSQL-related certification.

Responsibilities

Define and maintain the EDGAR enterprise data architecture and modernization roadmap.
Establish architecture standards and patterns for relational, transactional, analytical, and distributed data workloads.
Lead logical and physical data modeling across EDGAR applications and services.
Define database design, partitioning, indexing, replication, availability, backup, recovery, and retention strategies.
Conduct architecture and design reviews and provide technical direction to engineering teams.
Establish standards for data quality, integrity, lineage, security, and lifecycle management.
Architect cloud-native database solutions using AWS and PostgreSQL or other open-source technologies.
Design solutions using Amazon Aurora PostgreSQL, Amazon RDS for PostgreSQL, PostgreSQL, Amazon S3, AWS DMS, AWS Glue, and related AWS data services.
Define patterns for highly available, fault-tolerant, scalable, and recoverable database environments.
Evaluate database workload requirements and recommend storage, replication, caching, and performance strategies.
Support infrastructure automation and repeatable deployment of database environments.
Lead modernization of legacy databases to AWS-hosted open-source database technologies.
Define migration, transformation, reconciliation, and validation approaches, and develop strategies to minimize application disruption and migration risk.
Partner with application teams to identify and remediate database dependencies, incompatible features, stored procedures, schemas, and data-access patterns.
Establish performance baselines and validate migrated database workloads.
Establish database performance engineering and optimization practices, and lead analysis of complex performance and scalability issues.
Define monitoring, observability, capacity, availability, backup, and disaster-recovery requirements.
Support architecture for mission-critical workloads requiring high reliability and data integrity.
Define database security architecture, including encryption, access controls, secrets management, auditing, and data protection.
Ensure data architecture aligns with SEC security and federal compliance requirements.
Collaborate with cybersecurity and DevSecOps teams to incorporate security controls throughout the data lifecycle.
Provide technical leadership and mentoring to database engineers, developers, and data specialists.
Collaborate with application, cloud, integration, security, and DevSecOps architects on cohesive end-to-end designs.
Develop architecture documentation, standards, reference patterns, and technical decision records.
Communicate complex data architecture decisions to technical and non-technical stakeholders.