Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

or

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.
* DCE

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

Add To My Jobs
Job type you want
Full Time
Part Time
Internship
Temporary

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 -
$217,000
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 -
$170,000
Business Intelligence/Data Warehouse Engineer/Architect John Wiley & Sons, Inc. Hoboken, NJ Sep 01, 2015 $150,000
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
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
Business Intelligence and Data Warehouse Solutions Architect Tricore Solutions LLC Quincy, MA Jan 11, 2016 $140,000
VP, Business Intelligence & Data Warehouse Architect Barclays Services Corp. New York, NY Apr 03, 2015 $140,000 -
$170,000
Data Warehouse Architect City of Hope National Medical Center Duarte, CA Nov 14, 2016 $135,000
Data Warehouse Architect 4 Sutter Health Mather, CA Jun 22, 2016 $131,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 -
$217,000
SR. Data Warehouse Architect & Administrator Civanatic Corp Irving, TX Sep 19, 2016 $115,000
Data Warehouse Architect Rosetta Stone Ltd. Harrisonburg, VA Apr 06, 2015 $112,736 -
$135,532
Data Warehouse Architect Charter Communications Saint Louis, MO May 08, 2015 $110,000
Data Warehouse Architect Florida League of Cities, Inc. Orlando, FL Mar 15, 2016 $110,000
Data Warehouse Architect Brunswick Corporation Fond du Lac, WI Mar 11, 2015 $110,000
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
Data Warehouse Architect (Software ENG) Holland America Line N.V. Seattle, WA Jan 01, 2015 $100,000 -
$120,000
Data Warehouse Architect ABB Enterprise Software, Inc. Atlanta, GA Aug 03, 2015 $100,000 -
$161,052
Data Warehouse/(BI) Architect Technet LLC Washington, DC May 12, 2015 $100,000
Data Warehouse Architect/Developer IQ Associates, Inc. Chelmsford, MA Sep 23, 2015 $95,000
Data Warehouse Architect Nirvana Infotech, Inc. Union, NJ Oct 14, 2016 $95,000
Data Warehouse Architect Infinity Tech Group Inc. Atlanta, GA Apr 07, 2015 $93,413

No Results

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

Show More

Top Skills for A Data Warehouse Architect

DataWarehouseETLDatabaseDesignPl/SqlBusinessIntelligenceDataArchitecturePhysicalDataModelsSQLServerInformaticaPowercenterProceduresUnixSchemaDataMartsCognosSsisMetadataDB2UDBDataQualityFinancialOlap

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

×