Data Warehouse Engineer | loanDepot Lake Forest, CA, US

Job Details:
*. 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.
Skills & Qualifications
*. 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
..More Details» [Apply]

»Subscribe to

No comments: