Data Warehouse Engineer


Quicken Loans

2019-12-02 23:12:18

Job location Detroit, Michigan, United States

Job type: fulltime

Job industry: Engineering

Job description

Who We Are

Were Americas largest mortgage lender, closing loans in all 50 states. J.D. Power ranked Quicken Loans Highest in Customer Satisfaction in Primary Mortgage Origination for the past nine consecutive years, . The company was also ranked highest in the nation for client satisfaction among mortgage servicers by J.D. Power for five consecutive years, 2014 through 2018, each year the company was eligible. Theres a simple reason weve been so successful: We care about the people we work with.

If youre tired of stuffy, bureaucratic workplaces, then youll be delighted to find something different here. We strive to make a creative, fun and collaborative environment you simply wont find anywhere else. Quicken Loans was named #1 in ESSENCE Magazines first ever list of Best Places to Work for African Americans in 2015. We've been on Computerworld's "Best Places to Work in IT" list for 13 years running, hitting #1 the last five years. We were also ranked #14 in FORTUNE Magazines list of "100 Best Companies to Work For" in 2018, remaining in the top-30 for the past 15 years.

Job Summary

The Data Warehouse Engineer works on the back end development of the data warehouse and the maintenance of front-end reporting tools. This team member is a self-driven individual whos 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
  • Handle dimensional design as new areas of the business are loaded 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 database architects to define resource utilization needs
  • Provide technical expertise and advice to business areas to help them smoothly transition manual reports and applications to the Business Intelligence environment
  • Guide business areas in identifying new data needs and delivery mechanisms for reporting information
  • Establish documentation of reports and data definitions
Requirements
  • Degree in business management, computer science or information technology
  • 5 years of experience with T-SQL coding
  • 2 years of experience in performance tuning (SQL, ETL)
  • 3 years of experience with SQL Server Integration Services or similar ETL tools
  • 2 years of experience with SQL Server Analysis Services
  • 2 years of experience with dimensional modeling and other data-warehousing techniques
Whatll Make You Special
  • 3 years of experience with SQL Server database administration
  • 1 year of experience using .NET, C#, VB.NET, VBA, ASP.NET and/or Java
  • Experience with SQL Server Analysis Services and MDX query language
  • Familiarity with master data management concepts
  • Experience working in the Apache Hadoop ecosystem
  • Experience using Tableau
  • Ability to work cross-functionally
  • PowerShell

Inform a friend!

Nearby jobs

HVAC Service Manager Midland

Penetration Tester Dallas

Digital Director New York City

Top