Data Architect

Booz Allen Hamilton•Springfield, VA

9d•$99,000 - $225,000•Remote

About The Position

For an organization to transform in today’s digital world, it needs to properly collect, store, and organize its data. Effective data management can enable more efficient operations, yielding more growth. As a data architect, you know how to apply your creative-thinking and analytical mindset to help organizations manage their data assets. We’re looking for a data architecture lead like you to solve complex challenges and deliver leading-edge solutions for Homeland Security. As a data architect on our team, you’ll use your extensive technical expertise to lead the design of data architecture solutions for big data in a cloud computing environment. You’ll resolve routine data architecture-related issues in collaboration with business analysts and technology teams. In this role, you’ll share your technical expertise, introduce best practices, and use tools like Azure Data Factory to ingest large amounts of data from multiple data sources. You’ll lead your team as it designs, defines, develops, and tests cloud solution components, and you’ll serve as a liaison between clients and developers to ensure that requirements are met and solutions are delivered.

Requirements

6+ years of experience in data warehouse development, including building enterprise data warehouses, dimensional models or star schema, and data marts, and supporting large-scale reporting environments
6+ years of experience developing scalable ETL/ELT workflows and leveraging Informatica, SSIS, Azure Data Factory, WhereScape, and metadata-driven patterns
5+ years of experience developing and maintaining scalable cloud-based data platforms, including Azure Synapse, ADLS, ADF, Logic Apps, and metadata‑driven architectures
Experience analyzing, integrating, and transforming data from multiple disparate systems
Experience with SQL and Python used in ETL/ELT pipelines, automation, data modeling, and QA validation
Experience designing and developing structured and semi‑structured data ingestion pipelines
Experience performing backend SQL testing, including regression testing, unit testing, column-level validation, and post‑deployment QA
Experience in data engineering, architecture, and analytics
Ability to obtain and maintain a Public Trust or Suitability/Fitness determination based on client requirements
Bachelor’s degree in Computer Information Systems

Nice To Haves

Experience collaborating across cross-functional teams, including business analysts, data scientists, IT architects, finance, governance teams, and senior leadership
Experience with Azure Synapse Analytics, Azure Data Factory, ADLS, LogicApps, and DevOps pipelines supporting CI/CD in cloud data environments
Experience with public cloud environments such as Microsoft Azure, including cloud migration, optimization, cost management, and performance tuning
Experience with distributed and scalable data architecture patterns such as Data Mesh and modern metadata-driven development frameworks
Experience using SDLC, Agile, and Waterfall methodologies across multiple engineering teams
Experience with PowerBI, SSRS, QlikView, and other reporting or visualization tools for downstream analytics

Responsibilities

Lead the design of data architecture solutions for big data in a cloud computing environment.
Resolve routine data architecture-related issues in collaboration with business analysts and technology teams.
Share technical expertise and introduce best practices.
Use tools like Azure Data Factory to ingest large amounts of data from multiple data sources.
Lead your team as it designs, defines, develops, and tests cloud solution components.
Serve as a liaison between clients and developers to ensure that requirements are met and solutions are delivered.