Database Warehouse Architect

Remote • Posted 18 minutes ago • Updated 18 minutes ago
Contract W2
6 Months
Remote
$100.34/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • DATA WAREHOUSE
  • DATA WAREHOUSING
  • DATA LAKE
  • ERP
  • CLOUD
  • DATA GOVERNANCE
  • WORKDAY

Summary

HonorVet Technologies is a Service Disable Veteran-Owned IT staffing firm, ISO 9001, and ISO 27001 certified, working with federal agencies, state governments, and Fortune 500 enterprise clients across the US. What makes us different isn't a tagline; it's the way we work. We don't forward resumes and hope for the best. We take the time to understand where a professional like you are headed and only reach out when we genuinely believe there's a fit worth exploring.
 
Job Role: Data Warehouse Architect
Location: Athens, GA (Remote) - Locals Preferred
Duration: 6+ months
 
Position Overview
We are seeking an experienced Data Warehouse Architect to lead the design and development of a future-state reporting, data warehousing, and analytics architecture as part of a large-scale Enterprise Resource Planning (ERP) modernization initiative.
The organization is transitioning from multiple legacy systems supporting Human Capital Management (HCM), Financial Management, and Student Information Systems to a unified Software-as-a-Service (SaaS) platform.
The Data Warehouse Architect will establish the target-state data architecture, defining how cloud-based ERP reporting, enterprise data warehouses, data lake services, legacy data, integrations, and downstream analytics platforms work together.
This role will collaborate with IT leadership, data engineering teams, reporting teams, vendors, and business stakeholders to establish architecture standards, minimize reporting disruptions, ensure reliable data access, and develop a scalable roadmap for long-term enterprise reporting and analytics.
 
Key Responsibilities
1. Data Architecture & Strategy (40%)
  • Develop the future-state reporting and data warehouse architecture strategy, including data flows, integration patterns, and data consumption approaches.
  • Define the target-state enterprise data warehouse architecture and determine how data lake services will support reporting and analytics requirements.
  • Establish architecture standards, design principles, and technical guidelines for data integration and reporting solutions.
  • Develop comprehensive architecture documentation, solution designs, and phased implementation roadmaps.
  • Evaluate architectural approaches to ensure scalability, reliability, performance, and long-term maintainability.
  • Define strategies for integrating cloud-based ERP data with enterprise reporting and analytics platforms.
 
2. Data Governance & Legacy Data Planning (30%)
  • Recommend and establish enterprise data governance standards covering data ownership, definitions, quality, metadata, privacy, security, and access controls.
  • Develop strategies for retaining, accessing, and utilizing legacy data to support historical, operational, and analytical reporting.
  • Evaluate data management approaches to ensure data consistency, accuracy, availability, and compliance with organizational standards.
  • Assess architectural options and document assumptions, dependencies, technical risks, and key design decisions.
  • Work with business data owners to establish data stewardship and governance practices.
  • Ensure appropriate data access and security standards are incorporated into the overall architecture.
 
3. Technical Design & Implementation Guidance (20%)
  • Provide architectural guidance for data integration, data warehouse development, and reporting solutions.
  • Review technical designs and implementation approaches to ensure alignment with the approved enterprise architecture.
  • Collaborate with data engineers, integration specialists, and report developers to ensure data structures and data feeds support prioritized business reporting requirements.
  • Guide source-to-target data integration and data transformation design decisions.
  • Provide recommendations for data quality validation, testing, deployment, and production support.
  • Identify technical challenges and recommend solutions to support successful implementation and ongoing operations.
 
4. Stakeholder Collaboration & Knowledge Transfer (10%)
  • Facilitate architecture discussions and design workshops with technical and business stakeholders.
  • Collaborate with project managers, IT teams, vendors, data owners, and reporting teams to align architecture decisions with business objectives.
  • Present technical recommendations and architecture decisions in a clear and understandable manner.
  • Maintain architecture documentation, design records, and technical decision logs.
  • Provide knowledge transfer and architectural guidance to internal teams responsible for ongoing operations and maintenance.
 
Required Knowledge, Skills & Abilities
  • Strong knowledge of enterprise data architecture, data warehousing, and modern data lake architectures.
  • Experience designing enterprise reporting and analytics solutions.
  • Understanding of cloud-based ERP platforms and SaaS data architectures.
  • Knowledge of data integration, data migration, and data consumption patterns.
  • Strong understanding of data governance, data quality, metadata management, and data stewardship.
  • Knowledge of data privacy, security, and access control principles.
  • Ability to evaluate architectural solutions for scalability, reliability, performance, and maintainability.
  • Experience developing architecture documentation, technical roadmaps, and design standards.
  • Strong analytical, problem-solving, documentation, and communication skills.
  • Ability to collaborate effectively with technical teams, business stakeholders, vendors, and leadership.
  • Ability to balance immediate project implementation requirements with long-term enterprise architecture objectives.
 
Project Overview
The organization is undertaking a large-scale ERP modernization initiative to replace multiple legacy enterprise systems with a unified SaaS-based platform.
The initiative will modernize core business functions, including Human Capital Management, Financial Management, and Student Information Systems, while improving operational efficiency, data accessibility, reporting capabilities, and analytics.
A key component of this transformation is establishing a modern enterprise data architecture that supports seamless data integration, historical data retention, operational reporting, and advanced analytics.
The Data Warehouse Architect will play a critical role in defining the target-state architecture and ensuring continuity of enterprise reporting and analytics throughout the modernization process.

If you are interested, feel free to reach out to me directly at
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 90941473
  • Position Id: 26-31445
  • Posted 18 minutes ago
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.