Data Warehouse Engineer

loanDepot is America's lender offering home purchase and refinance loans, personal loans and home equity products nationwide. Headquartered in Southern California, the company operates Direct, Retail and Wholesale business channels nationwide.

• Design and implement parts of the data warehouse data model
• Design and implement ETL flows for the data warehouse
• Design, implement and deliver reports based on business requirements
• Design and implement an OLAP Cube database and build reports using MDX
• Understand the source systems and source data in detail and become a SME on them
• QA any work done by self and other team members
• Document all of the design and development artifacts
• Troubleshoot and support all BI related production processing
• Understand the current reporting environment and use that knowledge to continuously improve the enterprise data warehouse.

• BS or BA (or equivalent) in computer science or equivalent discipline (EE, Math etc.)
• 4+ years experience in the design, development, and testing of Data Warehouse implementations
• 4+ years of experience with SQL and Relational Databases
• 5+ years of overall software industry experience
• Experience with MS SQL Server 2008
• Deep knowledge of dimensional modeling and experience with it on at least 2 large projects
• Experience with ETL tools (SSIS)
• Experience with Reporting tools (esp. OLAP reporting) (SSAS)
• Ability to communicate and work with both technical and non-technical team members
• Ability to work in a fast-paced and dynamic environment
• Excellent interpersonal skills including verbal and written communication, teamwork, and issue resolution
• A problem-solving mindset; the individual should be highly motivated and self-directed
• Strong Experience with MS BI Stack (SSIS, SSAS, SSRS) is a big plus