Who we are:|
Guaranteed Rate, one of the largest and the fastest growing independent mortgage companies in the U.S., is an industry leader in delivering low rate, low fee mortgages with unparalleled customer service. Headquartered in Chicago, we have more than 2,800 employees in 162 offices nationwide. Our company is the 8th largest retail lender in the country and has recently been recognized in Inc. magazine as a top private job creator.
At Guaranteed Rate, we’ve built a corporate culture that places an emphasis on achieving success through career development, as well as through individual wellness and a healthy, balanced lifestyle. We offer our employees attractive compensation plans combined with a benefits package that includes health, medical, dental, vision and a 401K matching plan.
We are currently seeking a hard-working, dedicated Data Warehouse Developer to join our innovative and passionate team.
The data warehouse developer position is responsible for designing, developing, and implementing reporting solutions to be used throughout the organization. Additionally, the data warehouse developer will provide analytical support to various departments consuming the data within the various data marts. The data warehouse developer will also be responsible for maintaining scalable and high performing ETL processes.
Duties & Responsibilities:
Supporting existing reporting solutions and implementing new reporting requests
Monitoring existing reporting environment and troubleshooting performance issues
Designing, developing, and implementing various data marts to be used by multiple departments within the organization
Creating processes to mine the information stored within our systems, looking for patterns and trends that can be used to improve different areas of the business
Knowledge, Skills, & Abilities Required:
Knowledgeable of dimensional modeling concepts
Extensive knowledge of SQL Server Reporting Services
Extensive knowledge of importing and exporting data using bulk insert, BCP and format files, and/or SQL Server Integration Services
Experience working with large data sets and high transaction environments
Fluent in one or more scripting languages for use data migration tasks a plus
Good communication and presentation skills, ability to communicate across technology organization and other business units.
Computer Software & Experience:
Experience with standard SQL Server performance monitoring and tuning concepts in large data environments.
- In depth knowledge of Microsft SQL Server 2005, 2008. SQL Server 2012 a plus.
5+ years of logical and physical Microsoft SQL Server database design experience.
5+ years of database development experience including stored procedures, functions, views (T-SQL).
Click here to apply online