Job Description :
Work Location: Bellevue, WA
Job Category: EDW Architect
Type: Full time
Basic
Bachelor''s degree or foreign equivalent required from an accredited institution.
Will also consider three years of progressive experience in the specialty in lieu of every year of education
At least 7 years of experience with Information Technology
Required
Strong in Data modeling
Extensive experience in bulding Star and snow flake schemas
Experience in Performance Tuning
Prepare design for all metadata according to various ETL processes.
Perform troubleshoot on all ETL processes and resolve issues effectively.
Develop both physical and logical data models.
Prepare designs for database systems and recommend improvements for performance.
Develop various ETL processes and prepare OLAP cubes.
Design various ETL processes and perform tests on data.
Define meta data standards for the data warehouse
Monitor processes and develop plans to capture and access all metadata.
Develop and implement various work plans for projects.
Evaluate all proposals requests and assist to improve structure of data warehouse.