Data Warehouse Engineer

Company  Quicken Loans Inc. City  Detroit

Apply for This Position

Position Details

Who We Are

We’re the #1 online mortgage lender in America, closing loans in all 50 states, and we’ve grown to be one of the largest full-service residential mortgage lenders in the country. There’s a simple reason we’ve won the J.D. Power Award for Highest Client Satisfaction four years in a row: We care about the people we work with. If you’re tired of a stuffy, bureaucratic workplace then you’ll be delighted to find something different. We strive to create a creative, fun and collaborative environment you simply won’t find anywhere else. We've been on Computerworld's "Top Places to Work in IT" for nine years running, hitting #1 in 2013 and have been named to Fortune's list of "100 Best Companies to Work For" for the past 11 years, ranking as high as #2.

What You'll Do/Need

The Data Warehouse Engineer (DWE) is responsible for the full life cycle of back-end development of the data warehouse. Responsibilities include the development of ETL processes, dimensional design of the table structure, cube development for performance, and database administration. The DWE will work closely with the Business Analyst to work through business requirements and develop processes necessary to provide visibility into the data via the centralized data warehouse and reporting platform. The DWE will also work closely with the front-end developers to ensure data that is being brought in and managed is clean, accurate, available, and complete. The DWE will help to ensure the data warehouse processes are running optimally. Responsibilities Design and support the database and table schemas for new and evolving sources of data being brought into the data warehouse Create and support the ETL to facilitate bringing data into the data warehouse using SSIS Create and support the Analysis Services 2008 cubes to help with query performance Monitor and troubleshoot performance issues on the data warehouse servers Follow the design principles and best practices defined by the team for data warehousing techniques and architecture  Requirements Bachelor's degree in Computer Science or equivalent experience Experience with SQL Server 2005/2008 T-SQL Coding Experience with SQL Server 2005/2008 Database Administration Experience with SQL Server Integration Services (or similar ETL tool) Experience with SQL Server Analysis Services Programming experience (i.e. VBScript, .Net) Strong understanding of dimensional modeling and other data warehousing techniques Strong performance-tuning skills Strong analytic and research skills Demonstrated ability to work independently as well as with a team Ability to troubleshoot problems and quickly resolve issues Strong communication skills

What You'll Get

Excellent benefits package that includes a 401(k) match, medical/dental/vision, and much more Opportunities to participate in professional and personal development programs, including personal empowerment coaching, leadership training and ongoing personal growth training Other incentives, contests and rewards, including trips, event tickets, cash prizes, and more Why We're Different Corporate politics not your strong suit? The anti-corporate culture of Quicken Loans gives our team members the initiative to build solutions together and grow both personally and professionally. At Quicken Loans, we’re in the business of putting roofs over our clients’ heads, but we certainly aren’t putting ceilings on our team members’ careers.  If you’re interested in working in a place with a philosophy that’s truly different, apply today.  Quicken Loans is an equal opportunity employer.