Senior Datawarehouse Business Intelligence Engineer

Senior Data Warehouse Engineer

Job Description

Our client’s e-commerce solution includes Web site design and development, e-commerce technology, managed hosting, order fulfillment, customer service, merchandising and order management, online merchandising, customer relationship management, content development and online marketing. The company operates either all or a portion of the e-commerce businesses for approximately 60 partners.


The Senior Data warehouse Engineer will plan and execute projects that require close coordination with Business and Information Technology groups. Position supports overall development and service delivery projects reporting to the Sr. Manager of Business Intelligence Systems department.

Duties include, but are not limited to:
• Educate client management and business users on business value and capabilities of data warehousing
• Provide advice and guidance on data warehousing approaches and solutions, and use of data warehousing methodology
• Assist in identifying and prioritizing business information needs, and defining business benefit of data warehousing
• Assist in evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration
• Responsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiatives
• Identify data warehousing issues and assist in their resolution
• Review project work products, including project work plans, business activity and information models, test plans, content storage design, and application component design
• Performs table and interface design, development of logical and physical data model/database, ETL processes, BI reporting/OLAP cubes/OLAP reporting, and population and tuning of databases/ETL processes/BI reports/queries while meeting business/user requirements
• Facilitates requirements definition and contributes to documentation of project and system documentation
• Code, test, implement, monitor ETL processes in our data warehouse environment
• Provide infrastructure support for the BI/ETL environment
• Research and analyze various data source systems, applications and perform data research/analysis
• Provide project, system and other technical documentation as required
• Provide on-call, off-hour support of BIS systems

Required skills include, but are not limited to:

• Bachelor's degree in Computer Science, Information Technology or related field
• 6-9+ years of IT development experience in developing full lifecycle implementations, support, and upgrades.
• 6+ years of Data Warehouse experience.
• 3+ years of experience with ETL tool, preferably Sagent, DataStage or Informatica
• 6+ years of relational database experience (SQL, tuning, optimizer, relational concepts)
Strong Oracle and PL/SQL skills and relational database experience
• Strong MS Windows OS knowledge
• 2+ years UNIX experience
• Excellent written and verbal communicate skills with both technical and non-technical staff
• Ability to form durable, flexible work relationships
• Minimum of 5 years experience in the development and maintenance of data warehouse/data mart and BI reporting applications