Returning Candidate?

Data Warehouse Engineer

Data Warehouse Engineer

Company 
Quicken Loans Inc.
Location 
US-MI-Detroit

Position Details

Who We Are

Transform an Industry. Transform Your Career.

 

We’re constantly innovating the mortgage industry, so we’re constantly looking for flexible, curious minds that thrive when collaborating to solve complex problems.

 

And once those problems are solved, they’re ready for whatever’s next.

 

On the Technology team, when you’re not busy revolutionizing the mortgage industry with the technology that you create, you’ll get personal time each week to work on whatever tech projects you want.

 

If you’re ready to transform an industry and transform your career, we want to hear from you. 

 

What You'll Do/Need

The Data Warehouse Engineer works on the back-end development of the data warehouse and the maintenance of front-end reporting tools. We’re looking for a self-driven individual who’s ready to dig deep into business needs and work closely with the Business Intelligence team to find solutions. This team member is also expected to think outside of the box, and clearly communicate better solutions to our needs.

 

Responsibilities

  • Design and support the database and table schemas for new and evolving sources of data
  • Monitor and troubleshoot data issues on data warehouse servers
  • Responsible for dimensional design as we load new areas of business into the data warehouse
  • Design and support the analysis services cubes to help with analytics
  • Diagnose and resolve data warehouse ETL processes, data flows and business logic failures
  • Work with DBA’s to define resource utilization needs
  • Provide technical expertise and advice to business areas to help them smoothly transition manual reports and applications to the BI environment
  • Guide business areas in identifying new data needs and delivery mechanisms for reporting information
  • Establish documentation of reports and data definitions

Requirements

  • Associate, bachelor’s or master’s degree in business management, computer science or information technology
  • Five years of experience with T-SQL coding
  • Two years of experience in performance tuning (SQL, ETL)
  • Three years of experience with SQL Server integration services or similar ETL tools
  • Two years of experience with SQL Server Analysis Services
  • Two years of experience with dimensional modeling and other data-warehousing techniques

What’ll Make You Special

  • Three years of experience with SQL Server database administration
  • One year of experience using .NET, C#, VB.NET, VBA, ASP.NET, Java
  • Experience with SQL Server Analysis Services and MDX query language
  • Familiarity with MDM concepts
  • Experience working in Hadoop ecosystem
  • Experience using Tableau
  • Ability to work cross-functionally
  • Powershell

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.

 

Quicken Loans received the highest numerical score in the proprietary J.D. Power 2010–2015 Primary Mortgage Origination and 2014–2015 Primary Mortgage Servicer StudiesSM. 2015 Origination (or Sales) based on 4,666 total responses and measures experiences and perceptions of consumers who originated a new mortgage, surveyed in July–August 2015. 2015 Servicing based on 5,922 total responses and measures experiences and perceptions of consumers with their current mortgage servicer, surveyed in March–April 2015. Your experiences may vary. Visit JDPower.com.

 

Quicken Loans is the #1 online lender and the second largest retail mortgage lender in the U.S., according to National Mortgage News, Quarter 2, 2015.

Stay Connected

Not ready to apply? Click here to create a profile and stay connected with Quicken Loans and our Family of Companies.