Lead BI Architect Prosper
THIS JOB HAS EXPIRED Company Overview:
Want to change the world AND have a fantastic business model to do it with? With over $400 million in loans funded and over 1.6 million members, Prosper Marketplace has created the world?s first peer-to-peer lending marketplace. We bring together creditworthy borrowers with individual and institutional investors. We were named one of the Wall Street Journal?s top venture-backed companies in 2011 as well as 2012 and are one of Lead411?s hottest companies in San Francisco in 2012. We have a solid foundation, but we need your expertise to help take this concept to an even higher level.
Lead Prosper's BI effort from design to implementation
Lead technical discussions and business meetings for modeling, development, and deployment of data warehouses and system integrations
Create Kimball style conformed dimensions and fact tables
Assist Data Analysts in validating data and identifying reconciliation issues and root causes
Ensure BI efforts are addressing business requirements and represent a business-wide view of data assets
Self-driven to generate documentation in a collaborative atmosphere. Ex?
Schema definition and ETL Lineage
Requirements: (some or all of these below)
5+ years data-warehousing experience with proven understanding of Kimball method data-warehousing architecture, implementation processes and best practices
Excellent problem-solving skills
Self-starting attitude and good communication skills are essential. Ability to communicate with business analysts and to translate complex business requirements into a manageable database schema
Able to interpret, write, tune, and reverse engineer T-SQL queries and procedures
Must be able to work in a team-oriented environment and as a member of the production support team.
Advanced SSIS 2008 R2 experience; development, deployment, and administration with an emphasis on data warehouse ETL
Advanced SSRS 2008 R2 experience
Able to troubleshoot SQL jobs
Experience logging and reporting on ETL status and performance
Experience with physical database design for SQL Server 2005/2008.
Experience with SSIS.
Experience with SSRS.
Experience with SSAS desirable
Experience with SQL Server encryption and other encryption technologies desirable
Experience with financial Statements desirable
Experience with Perforce desirable
Experience with JIRA desirable
Experience with Cache? desirable
Bachelors Degree in Computer Science or equivalent experience
||111 Sutter Street |
San Francisco, CA 94104
THIS JOB HAS EXPIRED