Data Warehouse Architect

$120,000 - $150,000/Yr

Janus Research Group - Austin, TX

Full-time - Mid Level

Austin, TX

Social Assistance

About the position

The Data Warehouse Architect will play a crucial role in establishing and supporting the data warehouse for Army Futures Command within the Microsoft Azure Gov Cloud. This position requires an experienced data architect to lead the data architecture efforts, ensuring efficient data management and integration within cloud environments. The role involves collaboration with various teams to implement scalable data solutions and optimize data operations.

Responsibilities

• Serve as the primary Data Warehouse Architect for Army Futures Command in Azure Gov Cloud.
• Provide guidance and implement the strategic vision for data architecture as a subject matter expert.
• Design and implement scalable ETL pipelines for data movement, transformation, and security.
• Collaborate with cloud infrastructure and DevOps teams for seamless data system integration.
• Apply advanced data engineering techniques for efficient cloud performance.
• Support data validation, optimization, and troubleshooting in cloud environments.
• Utilize cloud-native tools for data ingestion, storage, and processing.
• Evaluate and implement emerging cloud data services.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a relevant technical discipline.
• 10 years of related work experience in data architecture, with at least 5 years in Commercial Cloud Service Providers' native data architecture solutions.
• Active Secret Clearance or ability to obtain one.
• Ability to work onsite in Austin, TX weekly.
• Experience in developing strategies for data acquisitions, archive recovery, and database implementation.
• Experience in a data warehouse environment, including data design and database architecture.
• Experience translating business needs into long-term architecture solutions.
• Experience defining, designing, and building dimensional databases.
• Experience developing data warehousing blueprints and integrating systems.
• Experience evaluating reusability of current data for additional analyses.
• Experience reviewing object and data models for better data management.
• Experience coordinating ongoing data-related efforts and forecasting future requirements.
• Experience assessing emerging technologies in data storage/management.

Nice-to-haves

• Experience with Cloud Data Services (Azure).
• Experience in a government cloud environment (Azure Government, AWS GovCloud).
• GitHub/GitLab experience with Git-based deployment strategies.
• Familiarity with cloud security practices, DevSecOps, and CI/CD pipelines.
• Ability to troubleshoot and optimize data pipelines in cloud environments.

Benefits

• Health insurance
• Referral program