Sr. Data Warehouse Engineer
Company Name:
Quicken Loans
Title Source is the largest provider of title insurance, property valuations and settlement services in the nation. The company is an authorized agent of the highest rated title insurers in the industry and its solutions power many of the nation's largest residential lending institutions. Title Source is a preferred provider to five of the top twenty Fortune 100 companies and many of the largest residential mortgage lenders. The company is based in Detroit, Michigan and retains regional operating centers in Ohio, California, Pennsylvania and Texas.
The Senior Data Warehouse Engineer (DWE) is responsible for the full life cycle of back-end development 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 DWE will work 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 DWE will also work 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.
If you're the type of person that keeps your skills sharp, is constantly reading about new technology and participates in online communities for database administrators, then you're the type of person we're looking for.
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
Participate in production code pushes after regular business hours
Requirements
Associate or bachelor's degree in computer science, or equivalent work experience
5 years of experience with SQL Server 2005/2008/2012 T-SQL coding
5 years of experience with SQL Server 2005/2008/2012 database administration
5 years of experience with SQL Server Integration Services (or similar ETL tool)
5 years of experience with SQL Server Analysis Services
5 years of programming experience (e.g. VBScript, .Net)
Experience leading small project teams
Experience mentoring others
Be a go-to person for team members and leaders both inside and outside of the team
Be the type of person who frequently shares best practices to help develop others
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.
Date: 2014-03-21
Country: US
State: MI
City: Detroit
Postal Code: 48226Estimated Salary: $20 to $28 per hour based on qualifications.
Quicken Loans
Title Source is the largest provider of title insurance, property valuations and settlement services in the nation. The company is an authorized agent of the highest rated title insurers in the industry and its solutions power many of the nation's largest residential lending institutions. Title Source is a preferred provider to five of the top twenty Fortune 100 companies and many of the largest residential mortgage lenders. The company is based in Detroit, Michigan and retains regional operating centers in Ohio, California, Pennsylvania and Texas.
The Senior Data Warehouse Engineer (DWE) is responsible for the full life cycle of back-end development 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 DWE will work 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 DWE will also work 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.
If you're the type of person that keeps your skills sharp, is constantly reading about new technology and participates in online communities for database administrators, then you're the type of person we're looking for.
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
Participate in production code pushes after regular business hours
Requirements
Associate or bachelor's degree in computer science, or equivalent work experience
5 years of experience with SQL Server 2005/2008/2012 T-SQL coding
5 years of experience with SQL Server 2005/2008/2012 database administration
5 years of experience with SQL Server Integration Services (or similar ETL tool)
5 years of experience with SQL Server Analysis Services
5 years of programming experience (e.g. VBScript, .Net)
Experience leading small project teams
Experience mentoring others
Be a go-to person for team members and leaders both inside and outside of the team
Be the type of person who frequently shares best practices to help develop others
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.
Date: 2014-03-21
Country: US
State: MI
City: Detroit
Postal Code: 48226Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
