Data Warehouse Engineer
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.
. Apply now!Estimated Salary: $20 to $28 per hour based on qualifications.
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.
. Apply now!Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
