Thursday, January 05, 2012

eBags - Data Warehouse Developer

Senior Data Warehouse Developer

eBags is looking for an experienced and motivated senior-level Oracle data warehouse developer to join our Business Intelligence Team. The chosen candidate will have the opportunity to provide immediate and recognized value across the entire organization; marketing, merchandising, fulfillment, customer care, etc. This is a great opportunity for someone who loves data warehousing and enjoys seeing the positive impact their work will have on all areas of the business. The chosen candidate will be part of a small BI team, will have direct interaction with end-users and will provide direct input into the underlying data warehouse and reporting architecture as well as overall direction of the BI team.

Existing Data Warehouse Architecture

• Enterprise data warehouse on Oracle 10G. Upgrading to 11G in early 2012.

• Data sources include Oracle, SQL Server, web log files and other flat file sources both internal and external to eBags.

• Subject areas include customers, orders, web traffic, e-mail and direct mail marketing, social interactions (Facebook), purchasing, inventory and more.

• ETL architecture is PL/SQL centric and includes the use of perl, korn shell and cron.

• DW is composed of the following architectural layers; staging, integration (data vault approach), conforming dimensions, atomic fact tables, aggregate fact tables, output to enterprise systems and short-term stop-gap reporting.

• SQL Server Reporting Services for reporting solutions.

• SQL Server Analysis Services for OLAP solutions.

• Source control and project tracking will be moving to MS Team Foundation Server (TFS).

• Just getting started with the definition and implementation of scrum and agile development processes.


Responsibilities

• Design and implement solutions for the entire scope of the data warehouse environment: Load processes for data sources, data integration, conforming dimensions, fact tables, stop-gap reporting, etc. Will work directly with report developers, data analysts and other end-users to define solutions that will accurately and efficiently answer high priority business questions.

• Tune processes to ensure service level agreements are continually met. Primary focus will be SQL, PL/SQL and Oracle database tuning, but will also include any other non-database processes.

• Collaborate with manager and team members to continually improve all development and maintenance processes. Includes database design, naming standards, coding standards, source control, code reviews, etc.

• Ongoing maintenance and support. Includes on-call rotation to resolve unexpected load process failures.

Minimum Requirements:

• Bachelor’s degree in Computer Science

• Solid written and verbal communication skills.

• Ability to quickly develop rapport with end-users and peers.

• 6+ years data warehouse development within any RDBMS.

• 4+ years data warehouse development within Oracle. Must have solid SQL and PL/SQL experience including tuning.

• Broad and deep skills with Oracle data warehouse related functionality; streams, materialized views, external tables, partitioning, table functions, fact table structures, bitmap indexing, etc.

• Proven ability to create robust, efficient and maintainable data warehouse related solutions that satisfy end-user requirements.