Data Architect

Booz Allen Hamilton

Actively hiring
Locations Albuquerque, New Mexico, US Posted 51 days ago $61,900–$141,000 / year
View original post Log in to save

At a glance

AI generated

TL;DR

As a Junior Data Architect on our team, you will work alongside engineers and business stakeholders to design and maintain data structures that support analytics and reporting across the organization within AWS environments. Your responsibilities include designing logical and physical data models, writing optimized SQL queries for data transformation, collaborating with engineering teams to develop data pipelines, translating business requirements into scalable architecture patterns, and supporting data governance initiatives to ensure data quality and consistency. You will also assist in maintaining reliable and performant data storage systems while working closely with cross-functional stakeholders to address their data needs. The ideal candidate has 2+ years of experience in data engineering or architecture, proficiency in SQL and Python, knowledge of AWS services like S3, Glue, Redshift, and Athena, and a strong understanding of ETL processes and modern data pipeline architectures.

Skills

AWS SQL Python ETL ELT data modeling relational databases data governance data pipelines Airflow dbt Redshift S3 Glue Athena

What you'll do

  • Design and maintain logical and physical data models for analytics.
  • Write and optimize SQL queries to transform raw data into structured formats.
  • Support the implementation of data pipelines within AWS environments.
  • Translate business requirements into scalable data architecture patterns.
  • Assist in maintaining data schemas and metadata standards for governance.

What we're looking for

  • 2+ years of experience in data systems, engineering, or architecture.
  • Proficient in SQL for query writing and optimization.
  • Expertise in data modeling concepts like dimensional modeling and schema design.
  • Experience with relational databases and AWS cloud platforms.
  • Knowledge of ETL/ELT processes and modern data pipeline architectures.
  • Understanding of data governance principles including metadata management.
  • Bachelor's degree required; CDMP certification preferred.

Market check

Salary context

This $61,900–$141,000 range sits above 6% of similar postings on FindRole.

Peer median band

$124,000–$202,000

Median floor and ceiling across peers.

Typical midpoint (25–75%)

$126,800–$206,637

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 629 open roles on FindRole.

Listed pay typically runs $86,800–$198,000 across 616 roles with salary data.

Most-posted roles

View all roles at Booz Allen Hamilton

More like this

Similar roles

Data Architect

Lam Research

Fremont, Ca,Us, US 72 days ago $137,000–$287,000
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

Sr Staff Data Architect

Gap Inc

Remote (Dallas-Coppell/Vari, US) 28 days ago
SQL ERwin PowerDesigner ER/Studio Hadoop Spark NoSQL dimensional_modeling star_schema snowflake_schema machine_learning agile_methodologies data_governance data_security data_privacy compliance_standards
Remote

Data Architect

The Federal Reserve

St. Louis, Mo, US 9 days ago
AWS SQL DataOps Kubernetes Terraform Docker CI/CD Prometheus Grafana PostgreSQL Apache Hadoop Apache Spark AI/ML Data Governance Time-Series Databases Metadata Management Platforms Elasticsearch Kafka

Data Architect II

Ann & Robert H. Lurie Children's Hospital of Chicago

Chicago, Il, US 41 days ago $99,840–$164,736
SQL SSIS SSAS SSRS PowerBI Azure ETL Data Modeling Object Oriented Programming SQL Server Python PostgreSQL CI/CD Kubernetes Docker Git JIRA Terraform AWS

Data Architect I

Ann & Robert H. Lurie Children's Hospital of Chicago

Chicago, Il, US 55 days ago $93,600–$154,440
SQL SSIS SSAS SSRS PowerBI T-SQL ETL Data Modeling Dimensional Modeling Relational Modeling Modern Data Models Office 365 MS Teams Healthcare Data Analytics Epic Clarity Epic Clinical Data Warehouse Database Design Application Development System Administration Maintenance Activities Project Management Code Review Customer Service HIPAA Compliance JCAHO Standards

Data Architect Senior

The Federal Reserve

Cleveland, Oh, US 24 days ago $111,400–$153,100
AWS Terraform GitLab CDK TOGAF C4 PostgreSQL NoSQL CI/CD Docker Kubernetes Python Java API Microservices Messaging Queues Data Modeling Relational Databases Non-relational Databases Cloud-Native Applications