Position Summary:

As a key member of the engineering organization, this person will be responsible for architecting and implementing a highly scalable and extensible data layer for SignalDemand’s hosted application. This layer consists of databases, schemas and the processes for extracting data from customer sources, transforming it and populating the databases. The ideal candidate will have software development experience and be well versed in building data structures for analytic enterprise applications (data warehouses, meta-data repositories, etc). They should also have intimate knowledge of database internals (MySQL, Oracle) and ETL tools (Informatica), and be adept at identifying and fixing performance bottlenecks. This is a ground floor opportunity at a fast growing start-up, located in downtown San Francisco.

Responsibilities:

• Work closely with product managers to develop a good understanding of the SignalDemand solution and product road map.
• Take a leadership role in architecting and developing an extensible and robust ETL layer.
• Review PRDs / functional specifications and design ETL to meet business requirements.
• Provide logical and physical schema design required to support business requirements.
• Build and test configurable data flow logic (ETL) to transform data from one schema to another.
• Educate the services team on how best to map customer data to the SignalDemand application.
• Assist in the configuration of ETL mappings to transform customer data into the format required by the application.
• Develop clean interfaces with the goal of ensuring repeatability in customer deployments.
• Design and develop scripts and/or software to perform data upgrades from one product version to another.
• Create detailed schedules for completion of work and communicate progress pro-actively.
• Debug and troubleshoot database problems at SignalDemand or at a customer site.
• Work across teams to ensure data layer requirements (content, security, performance) are met.
• Perform administrative tasks on databases in the data center and monitor performance pro-actively.
• Use the version control and bug tracking tool effectively for managing parallel development and different versions of the product.
• Participate in rapid prototyping of certain features and proof of concepts.

Skills:

• Expert with database design concepts in both OLTP and Data Warehouse environments such as normalization and dimensional modeling.
• Expert knowledge in designing and building ETL applications to load fact tables and dimension tables, SCDs type I, 2, and 3.
• Expert with ETL tools (e.g. Informatica Powercenter).
• Expert with set and procedural database programming (SQL and PL/SQL).
• Experience with E/R and database modeling tools (ERWin, PowerDesigner, Oracle Designer).
• Strong quantitative data analysis skills.
• Experience with database administration/tuning and designing databases that scale to thousands of users.
• Ability to point out data layer problems early in the design phase based on known access patterns.
• Passion for creating building blocks that can be reused again and again.
• Fluent in Object Oriented design and building reusable/extensible modules.
• Firm believer in unit testing and know how to automate tests.
• Experience using a revision control systems (e.g. Perforce) and bug tracking tools (e.g. Bugzilla)
• Must be a team player and comfortable interacting with product managers, engineers, scientists, QA and docs.
• Must be independent, detail oriented, ready to take ownership, and be a self-starter.
• Excellent communication skills, both written and verbal.
• Flexible, willingness to learn and a can-do attitude.

Minimum Requirements:

• 4+ years experience building enterprise class ETL software in Data Warehousing related work.
• BS in Computer Science, Information Systems or equivalent

Desirable Experience:

• Experience with hosted analytical applications.

Compensation:

• Competitive salary
• Stock options
• Medical, dental and vision benefits
• 401K
• 3 weeks vacation