Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Database Warehouse Architect

HonorVet Technologies

Database Warehouse Architect

HonorVet Technologies is a Service Disable Veteran-Owned IT staffing firm, ISO 9001, and ISO 270001 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

  • 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.

Data Governance & Legacy Data Planning

  • 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.

Technical Design & Implementation Guidance

  • 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.

Stakeholder Collaboration & Knowledge Transfer

  • 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 View email address on click.appcast.io

Vacancy posted 7 hours ago
Similar jobs that could be interesting for youBased on the Database Warehouse Architect in United States vacancy
  •  ...and maintain the ETL pipelines that feed the enterprise data warehouse. You will work with data engineers, analysts, and business stakeholders...  ...query rewriting, caching, and materialized views. Monitor database performance and fix issues before they affect users. Design... 
    Suggested
    Full time
    Remote work
    Work from home

    South Geeks

    Wyoming State
    20 days ago
  •  ...Title: Data Warehouse Architect 3 Duration: 6+ Month Contract; Highly possible for long-term extension Location: Lansing, MI 48933 Job Description: Data Engineer Lead/Data Warehouse Architect (Level 3) Data Engineering Lead excels in data modeling, Lakehouse... 
    Suggested
    Contract work

    ARK Solutions, Inc.

    Lansing, MI
    6 days ago
  •  ...platform for statewide adoption Knowledge of and skill in relational database platforms including DB2, SQL Server, Snowflake and Oracle Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics. Experience... 
    Suggested
    Work experience placement
    Work at office

    Software Technology Inc

    Tallahassee, FL
    3 days ago
  •  ...requirements. Performs analyses, development, and evaluation of data mining in the Snowflake cloud data warehouse environment which includes data design, database architecture, and data management utilizing Informatica PowerCenter, Intelligent Data Quality, and Enterprise... 
    Suggested
    Work experience placement
    Work at office

    Voluble Systems LLC

    Tallahassee, FL
    3 days ago
  •  ...To support analytics and application development, the full-time remote Data Warehouse Engineer will design, develop, and maintain scalable data warehouse solutions, focusing on building efficient data pipelines and integrating data from various sources. Key Responsibilities... 
    Suggested
    Full time
    Remote work

    Virtual Vocations Inc

    United States
    5 days ago
  •  ...Strong Python, PySPARK, Azure and have worked on a data warehouse Data Warehouse Data Engineer to build, enhance and optimize...  ...curated datasets. Work closely with BI analysts, BI developers, architects and stakeholders. Data engineering and pipeline development... 

    Canyon Associates

    Eatontown, NJ
    18 days ago
  •  ...Job Description: Data Engineer Lead/Data Warehouse Architect (Level 3) Data Engineering Lead excels in data modeling, Lakehouse and Medallion Architecture concepts, and data/ML products delivery using an agile DevOps framework with a mastery of distributed data architectures... 

    RICEFW Technologies Inc

    Lansing, MI
    6 days ago
  • $115k - $165k

     ...contribute to technology initiatives in a collaborative environment with opportunities for professional growth.  Job Title: Data Warehouse Developer  Location: Remote  Position Type: Full-time, Direct W2 - [Not open to C2C or 1099]  Salary Range: $115,000–$165,00... 
    Full time
    H1b
    Local area
    Immediate start
    Remote work
    Visa sponsorship

    Bright Vision Technologies

    Remote
    2 days ago
  •  ...As a Senior Data Warehouse Developer in the Claims IT organization, this full-time remote position will focus on building scalable solutions using modern cloud architecture, applying new technologies and CI/CD practices, and ensuring the integrity and availability of critical... 
    Full time
    Work experience placement
    Remote work

    Virtual Vocations Inc

    United States
    2 days ago
  •  ...to ensure current and reliable data is available for critical business processes and decision making. # Responsible for Data Warehouse change management infrastructure and all promotions of code and ddl; performing build engineer tasks for both manual and automated... 

    Kaav Inc.

    Lansing, MI
    3 days ago
  •  ...Data Warehouse Architect 5Job Location: Lansing, MI (Hybrid)ContractJob Description/Requirement:Minimum 12 years Teradata experience.Minimum 10 years SQL experience.Minimum 10 years shell scripting experience.Minimum 5 years Linux experience.Supporting the loading of data... 

    Global Information Technology

    Lansing, MI
    1 day ago
  •  ...Title : Data Warehouse Architect 5 - Solutions Architect Location : Lansing MI Required Skills (Must haves): 1. Minimum 5 years experience in leading Data Architects and working with Enterprise Architects to develop Data Landscape, Data Strategy... 
    Contract work
    Local area
    Remote work
    Relocation

    My3Tech Inc

    Lansing, MI
    3 days ago
  •  ...Data Warehouse Architect DHHS is the agency recognized by the Department of Health and Human Services (DHHS), Administration for Children...  ...CCWIS system developers to ensure that the operational system database will support the data needs of the Child Welfare Data... 
    Permanent employment
    Contract work
    For contractors
    Work at office
    Local area
    Remote work
    2 days per week

    Argyle Infotech

    Lansing, MI
    3 days ago
  • $88.4k - $154.7k

     ...redefine what’s possible. Job Description: We are seeking a Data Warehouse Engineer to design, develop, and maintain scalable data...  ...reporting Write efficient, scalable SQL queries and optimize database performance Integrate data from systems such as relational... 
    Full time
    Flexible hours

    Parsons Corporation

    Texas
    17 days ago
  •  ...your perfect career fit is waiting for you at the client. This client is an Equal Opportunity Employer. Job Title: Data Warehouse Architect 3 Location: Lansing, MI 48933 Duration: 11 Months Job Type: Temporary Assignment Work Type: Hybrid Shift... 
    Full time
    Temporary work
    Shift work

    TekWissen LLC

    Lansing, MI
    5 days ago
  • Job Summary: The Data Warehouse Architect 3 is a technical leadership role focused on designing, developing, and maintaining enterprise data...  .... Familiarity with Kafka, Kubernetes, NoSQL and Graph databases, Glue, DBT, and machine learning frameworks. Experience... 
    Full time
    Work at office
    Relocation

    vTech Solution

    Lansing, MI
    4 days ago
  • Our client is seeking a Data Warehouse Developer to join their team. As a Data Warehouse Developer, you will be part of the Data Management...  ...using Informatica tools (4+ years). Knowledge of relational database technologies such as Oracle, DB2, SQL Server, and strong SQL... 
    Contract work

    Experis/Manpower Group

    Madison, WI
    3 days ago
  • Data Warehouse Engineer LOCATION Reston, VA 20190 CLEARANCE TS/SCI Full Poly (Please note this position...  ...TITLES Data Engineer, ETL Developer, Data Architect, Business Intelligence Engineer, Data Integration Engineer, Database Engineer, Data Systems Engineer, Analytics... 
    Temporary work
    For contractors
    Immediate start
    Flexible hours

    Cymertek

    Reston, VA
    3 days ago
  • $95k - $115k

     ...American Heart Association has an excellent opportunity for a Data Warehouse Developer ! This position can be home-based. This is a full-...  ...maximum performance, compliance and efficiency of the database and delivery to researchers in the American Heart Association... 
    Full time
    Work experience placement
    Local area
    Remote work
    Work from home
    Night shift

    American Heart Association

    Dallas, TX
    3 days ago
  • $96.25k - $137.5k

     ...Snowflake and Databricks while resolving ETL/ELT bottlenecks Architect, maintain, and optimize scalable batch and streaming pipelines...  ...designing, developing, and engineering large-scale Enterprise Data Warehouses (EDW) and modern data lake architectures Advanced proficiency... 
    Local area
    Flexible hours

    EchoStar

    Centennial, CO
    3 days ago
  • Data Warehouse ETL Developer The candidate will be responsible for assisting in ETL design, development, testing, maintenance, metadata...  ...applications using technologies such as COBOL and DB2 databases to implement maintenance and enhance mainframe functionality Top... 
    Temporary work

    Samprasoft

    Madison, WI
    3 days ago
  •  ...Developer Understand and translate business requirements into Data Warehouse solutions Create data models and designs to meet specific...  ...ELT / Data pipelines that will extract data from an operational database and populate the staging and target data warehouse schemas... 

    Samprasoft

    Quincy, MA
    3 days ago
  • $140k - $180k

    Senior Data Warehouse Engineer We are seeking a Senior Data Warehouse Engineer to join our...  ...based environments. Contributions Lead and architect the migration of data environments with...  ...diagrams. Strong knowledge of SQL and database optimization techniques (Preferably SQL... 

    Steampunk.com

    New York, NY
    3 days ago
  • Job Title: Senior Data Warehouse Engineer Location-Type: Remote Start Date Is: ASAP Duration...  ..., retention, and compliance controls. Architect solutions for historical data, high-volume...  ...performance impact on core SQL Server databases. Enable embedded/customer-facing analytics... 
    Permanent employment
    Contract work
    Immediate start
    Remote work

    Mondo Staffing

    New York, NY
    3 days ago
  •  ...Thursdays Work from Home: Mondays and Fridays JOB SUMMARY The Data Warehouse & ETL Developer designs, develops, maintains, and supports...  ..., and operational support procedures. Collaborate with data architects, analysts, application teams, and business stakeholders to deliver... 
    Work from home
    Home office
    Monday to Friday

    At Home Stores LLC

    Coppell, TX
    3 days ago
  • $101.5k - $188.5k

    Cadence Data Warehouse Engineer Opportunity At Cadence, we hire and develop leaders and innovators who want to make an impact on the world...  ...Design, implement and maintain Data Pipelines using ADF Database Design and Implementation: Designing and implementing relational... 

    Cadence Inc

    San Jose, CA
    3 days ago
  • POSITION Sr. Data Warehouse ETL Developer LOCATION Remote- The manager is open to candidates looking to be remote until conversion...  ...Statements and so forth) * Creation, Optimization and Maintenance of Databases * Responsible for developing ETL Processes for the Enterprise... 
    Contract work
    Remote work

    3B Staffing LLC

    Fairfield, CA
    3 days ago
  •  ...development, testing, maintenance, metadata and implementation of data warehouse initiatives. They must understand user requirements and...  ...warehouse architecture, including programming in relational database technologies (e.g., Oracle, DB2, SQL Server). Clear knowledge... 
    Temporary work
    For contractors
    Remote work
    Relocation

    Samprasoft

    New York, NY
    3 days ago
  • The State of Wisconsin is looking for a Data Warehouse Developer II. Must be current WI resident. Power BI Report and SQL Query Developer...  ...and agile practices Work with MS SQL Server 2019+ and Oracle databases. Create operational processes including test cases & user... 
    Remote work
    Relocation

    Concord IT Systems

    Madison, WI
    3 days ago
  • Description The Data Warehouse Engineer I is part of a team dedicated to supporting Network Health's Enterprise Data Warehouse. This individual...  ...Experience with T-SQL development, SSIS development, and database troubleshooting skills required Network Health is an Equal... 
    Work at office
    Local area
    Work from home
    Home office
    Monday to Friday

    Network Health

    Brookfield, WI
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Warehouse Architect. Be the first to apply!