Database Engineer

| Chicago

Job Description

The Financial technology space "Fintech" is booming and Guaranteed Rate is at the center of it. We are growing like crazy, and are one of the most successful Chicago startups. We are focused on automating the mortgage process for consumers. Imagine getting a mortgage with no email, no faxing, no stack of papers in 10 days or less instead of 40 or more! If you have been through the process of buying a home you know how amazing this will be. We are the #8 lender in the country and one of only 2 that is independent (not a bank) so we are in a good spot to win this race. We have already made tremendous strides and we are looking for someone who wants to help us finish the job and disrupt the entire industry.

Who is GR?

Guaranteed Rate is not your typical company and certainly not your typical mortgage company. We are technology driven, have tons of energy and we love what we do – great people and great products alongside our impeccable customer service (83 NPS, unheard of!). We’re in a River North office with exposed brick and duct work, windows we can actually open during the summer. The awesomeness doesn’t end there, we also have:

  • Holiday parties? We got’em! Not just major holidays, any holiday….Mardi Gras, Valentine’s Day, St. Paddy’s Day, Opening Day, Boxing Day (for our Canadian employee), Sweetest Day, Groundhog Day, etc..
  • Game room, library and white board paint for collaboration – yeah, it’s awesome.
  • Access to our free GR nurse practitioner. Psshh who needs a doctor’s appointment when our nurse can do it all? Did we mention the free part?
  • 401k with some matching, Blue Cross health care coverage – yup, dental and vision too, short-term disability, life insurance – we got ya covered on this one, legal assistance – for a small monthly fee.
  • Oh and did we mention you get a big fat employee discount on the origination fees to get a new mortgage or refinance thru Guaranteed Rate?

So what do we want from you?

The Analytics Platform Team is seeking a Microsoft BI SQL Developer to be a primary support person for day to day operations of the current production SSIS and SSRS environments. This person will be a main point of contact for end users with resolving day to day support requests such as modifying reports, resolving ETL bugs, resolving reporting bugs, troubleshooting mismatching data reported by end users. Project work will include proactively improving processes (e.g. performance tuning), discovery and inventory of the systems and documenting findings.

Tasks

  • Work directly with end users to resolve data related support tickets (ETL and Reporting)

  • Gather requirements for new requests, troubleshooting with the end users to identify, resolve, and test issues

  • Modifying and creating ad-hoc SSRS or Power BI reports

  • Maintaining, creating, and improving SSIS ETL jobs (performance tuning and reliability)

  • Assist taking inventory of current database objects, processes and reports, identifying usage, documenting processes.

Requirements

  • 3-5 years SQL

  • 3-5 years SSIS/ETL

  • 2-3 years SSRS

  • Knowledge of Kimball Fact/Dimension architecture (star schema)

Bonus Points If You

  • Power BI, Tableau, or other related dashboarding

  • AWS or other cloud related

  • GIT or other source control

  • SSAS Tabular Cube development

  • C# SSIS scripting

  • PostgreSQL

  • Python

 

About Guaranteed Rate…

Guaranteed Rate is the seventh largest retail mortgage lender in the United States. Headquartered in Chicago, the company has approximately 195 offices across the U.S. and is licensed in all 50 states. Since its founding in 2000, Guaranteed Rate has helped hundreds of thousands of homeowners with home purchase loans and refinances and funded nearly $23 billion in loans in 2018 alone. The company has become the Home Purchase Experts® by introducing the world's first Digital Mortgage technology and offering low rate, low fee mortgages through an easy-to-understand process and unparalleled customer service. Guaranteed Rate won an American Business Award for its Digital Mortgage technology in 2016, ranked No. 1 in Scotsman Guide's Top Mortgage Lenders 2015, was chosen Top Lender 2016 by Chicago Agent magazine and made the Chicago Tribune’s Top Workplaces list five of the past six years. Visit rate.com for more information.

Read Full Job Description

Location

3940 N. Ravenswood , Chicago, IL 60613

What are Guaranteed Rate Perks + Benefits

Guaranteed Rate Benefits Overview

• Our location rocks – right off the brown line at Irving Park. Our home base is a hip office with exposed brick and duct work, windows we can actually open during the summer, and an open floor plan. Rather than a cubicle life, we work in an open and collaborative environment.
• An in-house café offers breakfast, lunch and a late afternoon healthy snack. We subsidize all meals so you’ll never pay full price.
• Access to the office gym for only $20 a year. Yes, a whole year! There is also yoga, cross fit, and boxing offered for a very small fee. We want our folks happy, healthy, and feeling good.
• A FREE on-site nurse. Psshh who needs a doctor’s appointment when our nurse can do it all?
• A 5,000 square foot rooftop deck that’s available to everyone all day and all evening with WiFi, two bars, music, grills, fun umbrellas, a ping pong table, corn hole, and fire pits. All of this is offered when Chicago gives us those non-snow covered days.
• Holiday parties? We got’em!! Not just major holidays, any holiday. We also have monthly celebrations on our Rooftop.
• Inter-office contests like the Great Mac-Off, Chili Cook-Off and Limbo. We always keep you guessing, participating, and wanting more.
• 401k with percentage matching, Blue Cross health care coverage (yup, dental and vision too), short-term disability, life insurance, and even legal assistance (for a small monthly fee)…and did we mention the awesome rooftop deck?

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Someone's primary function is managing the company's diversity and inclusion initiatives
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Acme Co.'s team fitness initiatives include In-office yoga, In-office fitness classes.
Retirement & Stock Options Benefits
401(K) Matching
Vacation & Time Off Benefits
Paid Holidays
Paid Sick Days
Perks & Discounts
Commuter Benefits
Happy Hours
Professional Development Benefits
Mentorship program
More Jobs at Guaranteed Rate73 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Marketing
Operations
Project Mgmt
Sales
Content
Developer
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Finance
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
HR
new
Chicago
Project Mgmt
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Design + UX
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Operations
new
Chicago
Content
new
Chicago
Content
new
Chicago
Content
new
Chicago
Content
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Content
new
Chicago
Marketing
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago