Returning Candidate?

Associate BI Engineer

Associate BI 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 Associate Business Intelligence (BI) Engineer will support and/or assist in the full life cycle of back-end development of the data warehouse, as well as the maintenance of front-end reporting tools. We're looking for a self-driven individual who is ready to dig deep into the business needs and work closely with the BI team to drive solutions back to the business. The Associate BI Engineer should think outside of the box, be willing to piece different areas of the business together and clearly communicate not just challenges – but better solutions to our needs.

 

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
  • Monitor and troubleshoot data issues on the data warehouse servers
  • Assist in dimensional design as we load new areas of business into the DW
  • Create and support SSRS Reports used for automation
  • Support the Analysis Services cubes to help with analytics

Requirements

  • Associate, bachelor's or master’s degree in business management, computer science, information technology or the equivalent work experience
  • Understanding of dimensional modeling and other data warehousing techniques
  • Ability to diagnose DW ETL process, data flows and business logic failures and to quickly resolve issues

What Will Make You Special

  • Two years of experience preferred with SQL Server Analysis Services and MDX query language
  • Two years of experience preferred SQL Server database administration
  • Three years of experience with SQL Server T-SQL coding
  • Two years of experience with SQL Server Integration Services or similar ETL tool
  • Very good oral and written communication skills, regardless of audience
  • Ability and desire to take charge of projects and help drive to completion
  • Demonstrated ability to work independently as well as with a team
  • Ability to troubleshoot problems
  • Passion for analytics, technology and troubleshooting
  • Great personality with strong ambitions to succeed and seek out new challenges and growth opportunities

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.

 

Disclaimer: Quicken Loans received the highest numerical score in the proprietary J.D. Power 2010-2016 Primary Mortgage Origination StudiesSM. 2016 study based on 3,267 total responses measuring 13 lenders and measures opinions of consumers who originated a new mortgage. Proprietary study results are based on experiences and perceptions of consumers surveyed in July-August 2016. Your experiences may vary. Visit jdpower.com

 

Quicken Loans is the #1 online lender and the 3rd largest retail mortgage lender in America – according to National Mortgage News

Stay Connected

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