Job Summary:
Booz Allen Hamilton is seeking a Junior Data Architect to support the design and maintenance of data systems that enable analytics and operational insights. The role involves collaborating with engineers and business stakeholders to create scalable data architectures and improve data governance practices.
Responsibilities:
• Design and maintain logical and physical data models that support analytics and reporting use cases.
• Write and optimize SQL queries to transform and structure data for downstream systems and reporting.
• Collaborate with engineering teams to support the design and implementation of data pipelines and data integration workflows within AWS environments.
• Translate business and analytical requirements into scalable data structures and architecture patterns.
• Help design and maintain data schemas, metadata standards, and documentation to improve data discoverability and usability.
• Support development and optimization of ETL and ELT workflows that transform raw data into curated analytical datasets.
• Assist in maintaining the reliability, performance, and scalability of data storage and processing systems.
• Work with cross-functional stakeholders including product, analytics, and engineering teams to understand and address data needs.
• Support data governance initiatives, including improving data quality, lineage visibility, and consistency across datasets.
• Help enforce data standards and best practices to ensure data integrity, appropriate access, and responsible data usage across the organization.
Qualifications:
Required:
• 2+ years of experience working with data systems, data engineering, analytics engineering, or data architecture
• Experience writing and optimizing SQL queries for data transformation and analysis
• Experience with data modeling concepts including dimensional modeling, star schemas, normalization, and schema design
• Experience working with relational databases or cloud data platforms such as AWS
• Experience using Python for data processing, automation, or scripting
• Knowledge of ETL and ELT processes and modern data pipeline architectures
• Knowledge of data governance concepts, including data quality, metadata management, and data documentation
• Ability to communicate technical concepts and collaborate with cross-functional stakeholders
• Ability to obtain a Secret clearance
• Bachelor's degree
Preferred:
• Experience with AWS data services such as S3, Glue, Redshift, or Athena
• Experience supporting data warehouse or lakehouse architectures
• Experience with data orchestration or transformation tools such as Airflow or dbt
• Experience with data governance tools such as data catalogs, lineage tools, or metadata management platforms
• Experience working with large-scale analytical datasets
• Secret clearance
• CDMP certification
Company:
Booz Allen Hamilton is a consulting firm that specializes in analytics, technology, and engineering. Founded in 1914, the company is headquartered in Mclean, USA, with a team of 10001+ employees. The company is currently Late Stage.