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
- ...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...SuggestedFull timeRemote workWork from home
- ...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...SuggestedContract work
- ...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...SuggestedWork experience placementWork at office
- ...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...SuggestedWork experience placementWork at office
- ...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...SuggestedFull timeRemote work
- ...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...
- ...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...
$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 timeH1bLocal areaImmediate startRemote workVisa sponsorship- ...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 timeWork experience placementRemote work
- ...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...
- ...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...
- ...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 workLocal areaRemote workRelocation
- ...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 employmentContract workFor contractorsWork at officeLocal areaRemote work2 days per week
$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 timeFlexible hours- ...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 timeTemporary workShift work
- 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 timeWork at officeRelocation
- 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
- 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 workFor contractorsImmediate startFlexible hours
$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 timeWork experience placementLocal areaRemote workWork from homeNight shift$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 areaFlexible hours- 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
- ...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...
$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...- 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 employmentContract workImmediate startRemote work
- ...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 homeHome officeMonday to Friday
$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...- 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 workRemote work
- ...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 workFor contractorsRemote workRelocation
- 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 workRelocation
- 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 officeLocal areaWork from homeHome officeMonday to Friday
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Database Warehouse Architect. Be the first to apply!
- remote data architect United States
- azure data architect United States
- sr data modeler United States
- hadoop big data architect United States
- principal data architect United States
- data center architect United States
- database designer United States
- senior data architect United States
- salesforce data architect United States
- enterprise data architect United States



