Senior Data Warehouse Architect

Senior Data Warehouse Architect

 

Job Description

 

eToys Direct is looking for a skilled, experienced and dynamic data warehouse architect to join our  Business Intelligence Team.  The chosen candidate will have the opportunity to work with all areas of the company to build decision support solutions for marketing (e.g., catalog circulation, e-mail campaigns, on-line marketing efforts), merchandising (e.g., SKU forecasting, assortment planning, performance measurement), finance, fulfillment and others.

 

Responsibilities

 Work within the business intelligence team to extend and improve upon an existing Oracle 9i enterprise data warehouse solution.  Identify where improvements need to be made in order to support new requirements and/or more efficiently support existing functionality.Design, build and deploy new decision support solutions within the architecture.Improve upon existing standards, guidelines and ETL processes needed for the continued development of the data warehouse environment.Balance ease-of-use, performance and maintainability within the architecture.Ensure that service levels in regard to refresh times, query response times and data quality are maintained and do not unexpectedly erode over time.Ensure that new functionality and modifications to existing functionality are consistent with the existing architecture and any directional changes defined for the architecture.Work closely with the system administrators and DBAs that support the data warehouse hardware and database environment.

 

Skills and Experience

 5+ years data warehouse development.2+ years as a data warehouse architect.BS in Computer Science, Information Systems or other IT related field.Sound decision making with the ability to think and act independently in a dynamic work environment.Excellent analytical and problem solving skills.Strong written and verbal communication skills.Ability to develop rapport with end-users.Understanding of dimensional modeling, warehouse development, Unix command line, k-shell or other scripting languages.Solid SQL, PL/SQL and direct path load experience within Oracle.Data warehousing experience within Oracle 9i.