lead Data Warehouse/BI architect

Company Name:
The Windows Phone Marketplace team is looking for a Senior Data Warehouse / BI architect to help us bring our business intelligence capabilities to the next level by leading the design and implementation of our data warehouse from the ground up. We are seeking someone who is passionate about architecture, design and development of data warehousing and BI solutions and data mining, reporting and analysis to enable the business to make data driven decisions.
This position has a broad and significant impact. The Marketplace BI & Analytics team delivers data and insights that drive our business and changes how we source and sell mobile apps. Our team powers the analytics behind the world of Windows Phone apps. As an architect in our team, you will provide leadership and guidance to the BI team by applying best practices while devising and implementing analytical solutions to produce effective results.
Required qualifications include:
o 8+ years of data warehouse implementation experience.
o 6+ years of business intelligence development expertise.
o Track record of successfully leading 2+ data warehouse / BI projects following the Kimball methodology.
o Expert level experience architecting solutions with the Microsoft BI stack: SQL Analysis Service (SSAS), Integration Service (SSIS), SQL Reporting Services (SSRS), Reporting tools (Excel, PPS).
o Significant implementation experience of Data Warehousing and Dimensional Modeling.
o Experience using COSMOS distributed storage and data processing system highly desirable.
o Broad knowledge of Enterprise Data Architecture and data integration patterns.
o Extensive experience writing complex SSIS packages, T-SQL queries, views and stored procedures.
o Broad OLAP experience in designing, building and deploying cubes using SSAS, including writing MDX queries.
o Demonstrated experience in designing, developing and maintaining SharePoint / PerformancePoint solutions for creation of KPI dashboards and Reports.
o Excellent knowledge on performance tuning (Indexes, mirroring, log shipping and replication).
o Excellent programming skills with any one of these languages C++/C#, VBA is a plus.
o Hands-on experience with Data Analysis, Data Mining and BI Business Models.
Preferred qualifications include:
o Bachelor or Master's Degree in Computer Science, Engineering, or related field or equivalent.
o Certified Business Intelligence Professional (CBIP) or MCTS Microsoft Certified Technology Specialist (MCTS) is a big plus.
o A job history that demonstrates a consistent commitment to excellence, and ability to collaborate well with cross functional groups and virtual teams to effectively solve technical challenges.
o Strong cross team collaboration and organizational skills.
o Effective problem solving and analytical skills.
o Excellent critical thinking, verbal and written communication skills.
o Agile development practice experience (e.g. SCRUM, Kanban)
o Experience through a product cycle with track record of shipping with high quality on schedule.
o Passionate smartphone user
Detail the skills and experience that you are looking for in a successful candidate?
We are looking for self-driven, self-organizing, passionate and experienced architect to lead the design and development of our data warehouse. The kind of architect we seek thrives in a changing and challenging environment, and is a dependable individual with a proven track record of strong results. Someone who steps up to do whatever is needed without waiting to be asked. This role will demand strong working relationships and interactions with the BI & Analytics team, and cross group collaboration with other data groups at Microsoft. The candidate will have the unique opportunity to advance our BI capabilities by building our warehouse from the ground up.

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Data Architect Lead - Enterprise Data Warehous...
Seattle, WA Seattle Children's Hospital
Data Warehouse Lead
Seattle, WA U.S. Bank
Senior Data Warehouse Engineer
Renton, WA Kforce
Sr Data Warehouse Engineer/ ETL Programmer
Renton, WA Kaiser Permanente
Data Warehouse Developer
Renton, WA Excell
Data Warehouse Engineer I
Seattle, WA Blue Nile