Returning Candidate?

Data Warehouse Architect

Data Warehouse Architect

Company 
Title Source, Inc.
Location 
US-Remote

Opportunity Details

Who We Are

Title Source is the largest independent provider of title insurance, property valuations and settlement services in the nation. The company is a preferred provider to nine of the top 10 retail mortgage lenders and provides commercial title services to real estate professionals, corporations and attorneys nationwide. Title Source is based in Detroit, Michigan, and retains regional operating centers in California, Ohio, Pennsylvania and Texas.

What You'll Do/Need

The Senior Data Warehouse Architect is responsible for the full life cycle of back-end development and design of the data warehouse. Responsibilities include the development of ETL processes, dimensional design of the table structure, cube development for performance, and database administration. The Senior Data Warehouse Architect works closely with the Business Analyst to work through business requirements and develop processes necessary to provide visibility into the data via the centralized data warehouse and reporting platform. The Senior Data Warehouse Architect also works closely with the front-end developers to ensure data that is being brought in and managed is clean, accurate, available and complete. The DWE will help to ensure the data warehouse processes are running optimally.

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 SQL Server Integration Services
  • Create and support the SQL Server Analysis Services cubes to help with query performance
  • Monitor and troubleshoot performance issues on the data warehouse servers
  • Follow the design principles and best practices defined by the team for data warehousing techniques and architecture.
  • Participate in an on-call rotation and in production code pushes after regular business hours
  • Design data models in SQL Server environment

Requirements

  • Expert experience in SQL Server Integration Services and SQL Server 2005 or newer
  • Advanced experience in T-SQL coding and performance tuning in SQL Server environment
  • Familiarity with SQL Server Analysis Services
  • Advanced data modeling experience
  • Detailed understanding of data de-normalization
  • Ability to share best practices to help develop others  

What’ll Make You Special

  • Bachelor’s degree in computer science or related field
  • Experience leading small project teams

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

Meet the anti-corporate culture of Title Source, where there's no daunting hierarchy, "boss" is a four-letter word, and if you work hard you're the one who'll reap the rewards, both personally and professionally. More than any other place you'll work, we’re dedicated to honing your skills, helping you grow and making sure you have plenty of fun while you’re at it.

Title Source is an equal-opportunity employer.

Stay Connected

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