As a Mission System Data Architect on our national security team, you will lead the design of data architecture solutions for large-scale systems involving data ingest, analytics, enrichment, and security. Your daily tasks include optimizing data pipelines, identifying optimal storage solutions, and recommending enhancements to improve data management efficiency. You’ll collaborate with business analysts and technology teams to resolve routine issues, introduce best practices, and leverage tools like SQL and real-time data streaming to design robust ETL pipelines and metrics reporting systems. Additionally, you will facilitate the development of cloud solution components and act as a liaison between clients and developers to ensure project requirements are met. This role requires extensive experience with data modeling, ETL/ELT pipelines using Python, Java, and Apache NiFi, knowledge of SQL, and proficiency in relational and non-relational databases such as Oracle, MongoDB, PostgreSQL, Redis, and Neo4J. Experience with multiple cloud platforms like Amazon and Oracle is a plus, along with relevant certifications like AWS Certified Data Engineer and Oracle Certified Professional.
Lead the design of data architecture solutions for large-scale data systems.
Optimize data ingest pipelines to enhance efficiency and cost-effectiveness.
Collaborate with project teams to identify optimal storage strategies and structures.
Recommend enhancements to existing data architectures based on best practices.
Design data models, standards, ETL pipelines, and metrics collection systems.
What we're looking for
Extensive experience in data modeling and design across conceptual, logical, and physical models.
Proficiency with ETL/ELT pipelines using Python, Java, Apache NiFi, and other frameworks.
Expertise in both relational (Oracle) and non-relational databases (MongoDB, PostgreSQL).
Strong knowledge of SQL for database management and querying.
Bachelor’s degree in Computer Science or Information Science required.
Market check
Salary context
This
$99,000–$225,000
range sits above
47%
of similar postings on FindRole.
Peer median band
$130,647–$209,268
Median floor and ceiling across peers.
Typical midpoint (25–75%)
$126,800–$211,200
Middle half of comparable postings.
Based on 240 comparable postings.*
* 240 is the maximum number of comparable postings sampled.
Employer
About Booz Allen Hamilton
Booz Allen Hamilton is a management and technology consulting firm that provides analytics, digital, engineering, and cybersecurity solutions primarily to U.S. government agencies and commercial clients. Industry: Management & Technology Consulting
Booz Allen Hamilton currently has
627 open roles
on FindRole.
Listed pay typically runs
$86,800–$198,000
across 614 roles with salary data.
Azure
AWS
Databricks
SQL
Python
Spark
Workday Adaptive
Anaplan
SAP BPC
Azure Synapse
Redshift
ETL/ELT
REST
SOAP
MS Fabric
Power BI
Data Lake
Data Warehousing
Dimensional Data Modeling