Monday, July 06, 2015

eBags - Data Warehouse

The Sr Data Warehouse Developer 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 11G.  Upgrading to 12c in 2016.
    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, marketing costs, freight costs, 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 (using data vault concepts), 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 and SQL Server Analysis Services for OLAP solutions.  SQL Server 2008 R2.  Actively evaluating 2014 and MS Power BI.
    Source control utilizes MS Team Foundation Server (TFS).

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.
    Develop OLAP (SSAS ) and canned reporting (SSRS) solutions to satisfy end-user information needs.
    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.

Requirements:
    Bachelor’s Degree in Computer Science, Information Technology, other related technical discipline or the equivalent combination of education, technical training, and work experience
    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.
    Experience with Microsoft Analysis Services and Reporting Services a plus, but not required.  Willing to train the chosen candidate in this area.

Location, Location, Location! we are located in the heart of the Denver Tech Center between Belleview and Orchard sitting right on 1-25!  We have AWESOME dining and entertainment less than a 5 minute walk from our office at the Landmark Theater district.

Enjoy life Happy hours, baseball games, and a dog-friendly workplace: we believe fun fosters creativity and camaraderie.

Balance and Harmony Generous paid vacations, paid holidays, paid community service time off, health club discounts and reimbursements, financial education, and employee discount on our website: we want you to do more of what makes you happy.

Healthy, Wealthy and Wise We provide the serious stuff, too. Our health benefits include Medical, Dental, and Vision. We provide a Health Reimbursement Account to help cover unexpected expenses, Life Insurance and Long-Term Disability, 401(k) Savings Plan with a Roth Option and Company Match, and Stock Option Grants, to mention a few.