Lead Data Architect
Location: Hybrid, Washington, DC Metro Area
Clearance: Public Trust, or ability to obtain
Position Summary
Inadev is seeking a highly experienced Lead Data Architect to define and drive the data architecture for the SEC’s EDGAR program. This role will lead 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 will establish data architecture standards, guide database modernization and migration, and work closely with application architects, engineers, DevSecOps teams, cybersecurity personnel, and business stakeholders. The ideal candidate combines strong enterprise data architecture experience with deep hands-on expertise in PostgreSQL, AWS, data modeling, database performance, and cloud-native architecture.
Key Responsibilities
Data Architecture & Technical Leadership
Define and maintain the EDGAR enterprise data architecture and modernization roadmap.
Establish architectural 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.
AWS & Open-Source Database Architecture
Architect cloud-native database solutions using AWS and PostgreSQL/open-source technologies.
Design solutions using technologies such as 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 appropriate storage, replication, caching, and performance strategies.
Support infrastructure automation and repeatable deployment of database environments.
Database Modernization & Migration
Lead database modernization from legacy platforms to AWS-hosted open-source database technologies.
Define migration, transformation, reconciliation, and validation approaches.
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.
Performance & Reliability
Establish database performance engineering and optimization practices.
Lead analysis of complex database performance and scalability issues.
Define monitoring, observability, capacity, availability, backup, and disaster-recovery requirements.
Support architecture for mission-critical workloads requiring high levels of reliability and data integrity.
Security & Governance
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.
Technical Leadership
Provide technical leadership and mentoring to database engineers, developers, and data specialists.
Collaborate with application, cloud, integration, security, and DevSecOps architects to ensure cohesive end-to-end designs.
Develop architecture documentation, standards, reference patterns, and technical decision records.
Communicate complex data architecture decisions to both technical and non-technical stakeholders.
Required Qualifications
Bachelor’s degree in Computer Science, Information Systems, Engineering, or 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.
Ability to obtain and maintain a Public Trust clearance.
Preferred Qualifications
Experience migrating enterprise databases from commercial or legacy technologies to PostgreSQL/Aurora PostgreSQL.
Experience with AWS Database Migration Service (DMS) and 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.
Key Competencies
Enterprise Data Architecture
PostgreSQL / Aurora PostgreSQL
AWS Cloud Architecture
Database Modernization
Data Modeling
Database Migration
Performance Engineering
High Availability & Disaster Recovery
Data Security & Governance
Data Integration
Cloud-Native Architecture
Technical Leadership
DevSecOps
NO THIRD PARTY PLEASE- DIRECT CANDIDATES ONLY.
CANDIDATE WHO CAN WORK FOR ANY EMPLOYER IN USA WITHOUT ANY SPONSORSHIP
Please submit your resume along with the following must required information to:
Contact number
Email
Current location
Work Authorization
Availability
Salary Expectation
