Returning Candidate?

Data Warehouse Engineer

Data Warehouse Engineer

Company 
Quicken Loans Inc.
Location 
US-MI-Detroit

Position Details

Who We Are

OUR NEXT BIG THING

Could Be Your Thing

 

The Quicken Loans Family of Companies is obsessed with always finding a better way through the creativity, innovation and transformative thinking of our leaders and team members. We certainly have the desire and ability to adapt to a changing world. And we are known to have changed the world ourselves – from revolutionizing the mortgage banking industry, to creating new technology-driven ventures, to developing life-changing career experiences, to revitalizing the communities in which we live, work and play.

 

We understand that the type of people we hire have a lot to share. They are transformative thinkers who help us bring about radical change. We give our team members the creative environment, freedom to think and explore, and to advance their new ideas and thoughts. That’s why we created Bullet Time, our signature program for rapid-fire innovation that nurtures “intrapreneurs” among our tech team members.

 

Here, the Next Big Thing could be your thing.

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.