Sign up to Zippia and discover your career options with your personalized career search.

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss


The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In


Become A Data Warehouse Architect

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.

Working As A Data Warehouse Architect

  • Interacting With Computers
  • Updating and Using Relevant Knowledge
  • Getting Information
  • Communicating with Supervisors, Peers, or Subordinates
  • Making Decisions and Solving Problems
  • Mostly Sitting

  • $106,622

    Average Salary

What Does A Data Warehouse Architect Do At CVS Health

* Identifying and crafting table partitions, indexes and assist with the cleansing and maintenance of the databases.
* Participating in data model review board discussions and in support design reviews and code walk throughs to ensure high quality work.
* Collaborate closely with the project teams to produce realistic effort estimates, ensuring task completion within estimates, identifying and communicating variances as early as possible.
* Work with upstream system architects, developers and program managers to resolve data issues and drive collection of data needed by business customers.
* Evolve and support the basic tenets of good data architecture.
* Work on one or more projects at all stages of the system life-cycle (define, design, and build).
* This position must be located in Smithfield, RI ONLY.
* Telecommuting and remote work not available.

What Does A Data Warehouse Architect Do At Virginia State Government

* Prepares and presents recommendations for data warehouse/business intelligence solutions options that best achieve business needs, simplifies the data landscape, and increases the ability to discover, manage and analyze data as a whole.
* Maintains a detailed knowledge base of the underlying data and data structures, and manages data content, current and potential future uses, and the quality and integrity of data with the EDW.
* Performs hands-on analysis, designs, development and deployment of solutions.
* Designs and develops data warehouse architecture, data modeling and data conversion solutions.
* Establishes standards and guidelines for coding, performance optimization, documentation, quality assurance and production support.
* Develops product-based performance and scalability options to meet requirements.
* Develops business intelligence reporting applications and dashboards.
* Establishes and maintains a modern, robust, flexible, secure, reliable, and efficient technology environment.
* Designs varying levels of complex frameworks to support system-wide technical and business architecture requirements.
* Works closely with the engineering and development teams to identify non-functional requirements, builds out data visualizations and data access capabilities in support of business requirements.
* Ensures training, cross training/knowledge transfer occurs for self, team members, across teams and clients.
* Keeps up to date on database warehouse/business intelligence products and technologies.
* Assists and provides direction to co-workers in using new techniques and in solving their more complex technical problems.
* Minimum Qualifications

What Does A Data Warehouse Architect Do At Planned Systems International, Inc.

* The Data Warehouse Architect will provide leadership and expertise in modernizing and maintaining data warehouse solutions for a federal government agency.
* The candidate's core responsibilities will include, but are not limited to:
* Responsible for overall direction, oversight, and successful delivery of Oracle data warehouse design and implementation.
* Leverage experience in architecting data warehouse solutions, including a strong Oracle background in Data Architecture, Data Modeling, Data Governance.
* Research, analyze, design, and implement database solutions and changes.
* Transform complex customer business requirements into effective, efficient, and maintainable enterprise-level solutions.
* Serve as an escalation point of contact for all issues related to the data warehouse environment.
* Develop and execute functional and technical specifications and testing for advanced system configuration, interfaces, installation and modifications.
* Provide input to project planning, requirements gathering, process recommendations, etc.
* Execute project plan tasks and other duties as assigned

What Does A Data Warehouse Architect Do At Eileen Fisher

* a business intelligence tool/system implementation, planning and execution of projects and enhancements (lifecycle), and the management of day-to-day production system operations.
* The function of the BI/DW Architect is to understand needs, drive requirements, propose solutions and manage the delivery of multiple cross-functional data, reporting and analytics projects and integrations between different systems.
* Additionally, the Architect will be required to present a strong understanding of BI/DW architecture concepts, possess hands-on experience with BI tools and technology, and be able to serve as the primary subject matter expert and guide team members.
* Summary of Duties and Responsibilities:
* General
* Serve as the technical expert responsible for the architecture, design and implementation of BI/DW solutions, with complete and accurate information information/ data delivery to business users using maintainable, systematic, and automated procedures.
* Make recommendations and guidance about data collection methods, master data management concepts, metrics, data definitions, and data evaluation methods, in collaboration with internal and external partners.
* Evaluate, create and deliver on data needs for assigned projects, ensuing data integrity.
* Help establish and define data validation, data cleansing, data integration, and transformation practices.
* Facilitate data/ reporting/ analytics design review sessions, testing cycles, validation and other post-deployment activities.
* Lead exercises around data architecture standards and documentation
* Map configurations and complex data architectures, ensuring documentation meets current and forecasted needs.
* Business Relationship Management
* Establish close partnerships within the IT department and with the business teams to provide data strategy expertise, ensuing overall data quality within all enterprise systems including interfaces between applications/ systems.
* Work with the business teams to gather requirements for data and reporting enhancements, change requests and new functionality.
* Stay abreast of contemporary technology trends/concepts and serve as an SME for the business teams.
* Coach staff on BI/DW best practices
* System Maintenance and Support
* Help to facilitate unit, system, integration and user acceptance test plan development and execution, including the creation of test scenarios/scripts, test data setup and verification/validation of test results.
* Manage issues and bugs within the system using tracking/ support systems; liaise with internal and external resources to facilitate resolution and closure.
* Serve as the main point of escalation for issues requiring external/ vendor support.
* Vendor Management
* Work with vendor to validate and refine technical specifications against business requirements.
* Communicate with external vendors and other departments to resolve production issues, upgrades, and software evaluations.
* Prepare for and participate in vendor relationship activities and stewardship meetings on an ongoing basis

What Does A Data Warehouse Architect Do At Lendmark Financial Services

* Champion the role of ETL Architect, define needs for technical and functional standards, promote best practices for tool use, and develop related processes/technical documentation.
* Proven experience developing successful ETL solutions in data warehousing, analytic and reporting, portal and dashboard development, and scorecard methodologies
* Manage ETL tool set and compel best practices for use with business and project teams.
* Provide business and project teams with a consistent level of service and problem resolution.
* Assess ETL requirements, define ETL strategy and technical architecture that supports the creation of databases, table spaces, tables, indexes, triggers, procedures, and other database objects.
* Extract data from multiple operational sources for loading staging area, Data warehouse, Data Marts.
* Design customized ETL solutions to support the transition and optimization of data transfers between internal source databases to data warehouse, based on specific Business requirements.
* Change management procedures (Implements, and maintains best practices.
* Implement changes and provide post-implementation user support and system support)
* Provide training and expertise to business users and other stakeholders on utilizing ETL assets for reporting needs.
* Stay abreast of latest Business Intelligence and ETL technologies and tools and Hands on experience with different ETL (i.e. SSIS, Informatica, Data Stage, Preferred Pentaho)
* Qualifications

Show More

Show Less

Data Warehouse Architect jobs


Aw snap, no jobs found.

Add To My Jobs

Data Warehouse Architect Career Paths

Data Warehouse Architect
Business Intelligence Architect Solutions Architect Program Manager
Chief Information Officer
11 Yearsyrs
BI Architect Data Architect Solutions Architect
Customer Relationship Management Manager
8 Yearsyrs
Enterprise Architect Chief Information Officer
Deputy Chief Information Officer
12 Yearsyrs
Senior Data Architect Senior Database Administrator Information Technology Manager
Director Information Technology Infrastructure
13 Yearsyrs
Warehouse Manager Operations Manager Senior Manager
Director Of Enterprise Architecture
14 Yearsyrs
Business Intelligence Architect Data Architect Project Manager
Director Of Information
10 Yearsyrs
Technical Manager Information Technology Consultant Information Systems Manager
Director Of Information Services
9 Yearsyrs
Warehouse Manager Technician Network Administrator
Information Technology Director
10 Yearsyrs
Enterprise Architect Technical Project Manager Senior Product Manager
Principal Product Manager
10 Yearsyrs
Solutions Architect Senior Project Manager Senior Product Manager
Product Management Director
12 Yearsyrs
Principal Consultant Senior Manager Director Of Information
Senior Director Of Information & Technology
13 Yearsyrs
Technology Architect Information Technology Manager Infrastructure Manager
Senior Manager Infrastructure
13 Yearsyrs
Lead Consultant Information Technology Specialist Information Systems Manager
Senior Manager-Systems
12 Yearsyrs
Solutions Architect Program Manager
Senior Project Manager
12 Yearsyrs
Principal Consultant Information Technology Project Manager Director Of Information
Vice President Information Systems
10 Yearsyrs
Enterprise Data Architect Solutions Architect Senior Manager
Vice President Of Information Technology
12 Yearsyrs
Show More

Average Length of Employment
Architect Manager 3.7 years
Architect 3.0 years
Senior Architect 2.8 years
Database Architect 2.7 years
Lead Data Analyst 2.7 years
Data Architect 2.6 years
Lead Architect 2.5 years
ETL Architect 2.3 years
Data Modeler 2.2 years
BI Architect 2.0 years
Data Consultant 1.7 years
Top Employers Before
Consultant 6.3%
Top Employers After
Consultant 6.8%
Architect 3.8%

Data Warehouse Architect Demographics












Hispanic or Latino




Black or African American

Show More
Languages Spoken
















Show More

Data Warehouse Architect Education


University of Phoenix


Indiana Institute of Technology


University of Connecticut


Wright State University


Webster University


Georgia State University


Johns Hopkins University


University of Massachusetts Amherst


State University of New York College at Buffalo


Purdue University


University of Houston


Central Connecticut State University


University of California - San Diego


Georgia Institute of Technology -


New York University


Villanova University


American University


University of Nebraska - Lincoln


DePaul University


University of Texas at Dallas

Show More

Computer Science




Computer Information Systems


Electrical Engineering




Management Information Systems


Computer Engineering


Computer Applications


Information Systems


Information Technology








Management Science








Environmental Control Technologies/Technicians


Mechanical Engineering



Show More














Show More
Job type you want
Full Time
Part Time

Real Data Warehouse Architect Salaries

Job Title Company Location Start Date Salary
Enterprise Data Warehouse Architect Linkedin Corporation Calabasas, CA Feb 25, 2016 $187,010 -
Enterprise Data Warehouse Architect Lynda.Com, Inc. Calabasas, CA Jan 05, 2015 $170,000
Data Warehouse Architect/Manager Nanometrics, Inc. Milpitas, CA May 11, 2015 $152,901
Data Warehouse Solutions Architect Apple Inc. Cupertino, CA Apr 20, 2015 $152,776 -
Senior Data Warehouse Architect Henry Schein, Inc. Melville, NY Sep 26, 2016 $150,000
Business Intelligence/Data Warehouse Engineer/Architect John Wiley & Sons, Inc. Hoboken, NJ Apr 27, 2016 $150,000
Business Intelligence/Data Warehouse Engineer/Architect John Wiley & Sons, Inc. Hoboken, NJ Sep 01, 2015 $150,000
Lead Principal Data Warehouse Architect University of Utah Salt Lake City, UT Feb 16, 2015 $145,000
Data Warehouse Architect Charter Communications, Inc. Saint Louis, MO Apr 22, 2016 $143,811
VP, Business Intelligence & Data Warehouse Architect Barclays Services Corp. New York, NY Apr 03, 2015 $140,000 -
Business Intelligence and Data Warehouse Solutions Architect Tricore Solutions LLC Quincy, MA Jan 11, 2016 $140,000
Datawarehouse Architect Innovative Systems Group, Inc. Chicago, IL Oct 13, 2015 $139,829
Software Datawarehouse Architect YASH & Lujan Consulting, Inc. Baltimore, MD Sep 14, 2016 $137,280
Data Warehouse Architect Charter Communications, Inc. Saint Louis, MO Mar 11, 2016 $120,950
Datawarehouse Architect, Team Lead Forrester Research, Inc. Cambridge, MA Jun 05, 2016 $120,000 -
Data Warehouse Architect City of Hope National Medical Center Duarte, CA Jun 20, 2016 $120,000
Data Warehouse Architect Charter Communications Saint Louis, MO May 08, 2015 $118,000
Enterprise Data Warehouse Architect Linkedin Corporation Calabasas, CA Jun 22, 2015 $117,000 -
SR. Datawarehouse Architect & Administrator Civanatic Corp Bartlett, IL Jan 10, 2016 $115,000
SR. Data Warehouse Architect & Administrator Civanatic Corp Irving, TX Sep 19, 2016 $115,000
Datawarehouse Analyst/Architect Technogen Inc. Chantilly, VA Jul 06, 2016 $114,300
Data Warehouse Architect Smart Erp Solutions Inc. Duluth, GA Nov 05, 2016 $100,268
Data Warehouse Architect II PSCU Saint Petersburg, FL Jan 04, 2016 $100,000
Senior Data Warehouse Architect Teleflora, LLC Oklahoma City, OK Feb 02, 2016 $100,000
Datawarehouse Architect Protege, LLC New York, NY Mar 02, 2015 $100,000 -
Data Warehouse/(BI) Architect Technet LLC Washington, DC May 12, 2015 $100,000
Data Warehouse Architect (Software ENG) Holland America Line N.V. Seattle, WA Jan 01, 2015 $100,000 -
Data Warehouse Architect ABB Enterprise Software, Inc. Atlanta, GA Aug 03, 2015 $100,000 -
Data Warehouse Architect/Developer IQ Associates, Inc. Chelmsford, MA Sep 23, 2015 $95,000

No Results

To get more results, try adjusting your search by changing your filters.

Show More

Top Skills for A Data Warehouse Architect


Show More

Top Data Warehouse Architect Skills

  1. Data Warehouse
  2. ETL
  3. Database Design
You can check out examples of real life uses of top skills on resumes here:
  • Extracted business rules and other analysis to create facts and dimensions for the data warehouse.
  • Used Oracle Replication to manage the Extraction/Translation/Loading (ETL) processes on an Oracle 10g platform.
  • Gained experience in Data Warehousing, Database design, Data modeling and Database triggers.
  • Developed data mining and data analysis tools with custom codes in PL/SQL.
  • Trained in Business Intelligence with Microsoft Enterprise technologies.

Top Data Warehouse Architect Employers

Data Warehouse Architect Videos

Data Vault Data Warehouse Architecture

2 - Data warehouse Architecture Overview