Data Warehouse Engineer

Description

Senior Data Warehouse Engineer for Detroit, MI to maintain, support & develop data warehouse and ETL processes; conduct dimensional design of table structure; develop cubes for performance; work with data sources & relational databases to support large data sets; ensure data brought in is clean, accurate, available and complete & data warehouse processes are running optimally; act as application owner; lead design & code reviews; assist with delivery estimates; mentor junior personnel. Requires Master's in C.S., Computer Engineering, I.T., or closelyrelated field & 3 yrs experience working with SQL Server 2005 and above TSQL coding. Will also accept Bachelor's in said fields & 5 yrs progressive postBachelor's stated experience. Stated experience must include 3 yrs experience administering databases with SQL Server 2005 & above; using SQL Server Integration Services (SSIS) 2005 & above; designing, developing and deploying cubes with SQL Server Analysis Services (SSAS) 2005 & above; using MDX for querying & defining calculated measures; modeling data to create dimensional design of table structure & conducting Data Profiling based on client requirements; engaging in SQL query performance tuning; troubleshooting & optimizing SQL performance and data integrity issues; and programming with C# or .NET.