DATA WAREHOUSE ARCHITECT

Responsible for providing senior level expertise on decisions and priorities regarding the enterprise’s overall systems architecture. Facilitates the establishment and implementation of standards and guidelines that guide the design of technology solutions including architecting and implementing solutions requiring integration of multiple platforms, operating systems and applications across the enterprise. Reviews, advises and designs standard software and hardware builds, system options, risks, costs versus benefits and impact on the enterprise business process and goals. Develops and documents the framework for integration and implementation for changes to technical standards. Assists in the development of and manages an architecture governance process. Provides technical guidance to project team areas as appropriate. Tracks industry trends and maintains knowledge of new technologies to better serve the enterprise’s architecture needs. Bachelors or Master’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience. Typically has 5 to 7 years of IT work experience in infrastructure/systems environments performing systems planning, architecture design, engineering (hardware and software) and optimization.

DATA WAREHOUSE ARCHITECT

ROLE

Work with business users and leads to gather requirements, conduct analysis and prioritize requests
Translate business user requirements into technical architecture and implementation plan
Design and implement multi-dimensional models while adhering to enforced development methodologies.
Define and direct security requirements for DW
Design and implement the data loading (ETL) processes within the DW/BI environment

QUALIFICATIONS:
 5 years in Dimensional Modeling
 Strong Knowledge on Data warehouse Concepts, Experience with Building
 Large/Complex Data warehouses
 Strong Experience in building an enterprise Data Warehouse
 Experience in overall data warehouse architecture (ETL, Data Models and Reporting)
 Must have strong skills in PL/SQL
 Must have the ability to understand complex data relationships and business requirements and formulate efficient and reliable solutions.
Data modeling experience in OLAP environment.
Excellent communication skills, including effective collaboration with non-Technical business users.