Database Engineer

| Chicago
Sorry, this job was removed at 4:58 p.m. (CST) on Tuesday, March 10, 2020
Find out who's hiring remotely in Chicago.
See all Remote Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Location

3940 N. Ravenswood , Chicago, IL 60613

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Guaranteed RateFind similar jobs