Data Warehouse Engineer
Tiva Systems, Inc - Emeryville, CA

This job posting is no longer available on Dice. Find similar jobs:Data Warehouse Engineer jobs - Tiva Systems jobs

(Direct Full time FTE with a client) Key things Data modeling Data Marts ETL – Must have BI Reporting – nice to have Retail experience from Ross, Gap, Safeway, Levis etc will be nice to have OVERALL FUNCTION The DWBI Engineer works closely with the product management team, other engineers and business users in the design of new data warehouse components and data marts, complex ETL loading procedures, and providing documentation (data mapping, functional specifications, data dictionaries, test cases, client support, etc.) for all projects. ESSENTIAL FUNCTIONS Gather, analyze and validate business requirements from non-technical functional users and subject matter experts Design, code, automate, schedule, and monitor load jobs. Design and implement reports and dashboards Implement reliable ETL processes Support end users on ad hoc data usage and be a subject matter expert on functional side of the business Analyze and improve efficiency, scalability, and stability of data collection, storage, and retrieval processes Work closely with data analysts to construct creative solutions for their analysis tasks Maintain an awareness of existing, new and emerging data warehousing technologies Experience 4-8 years experience ( we will consider any candidate between 4- 8 years experience) 4-5 years industry experience as Cognos Business Intelligence Developer Experience writing complex SQL queries and ETL development Strong SQL Server (2000, 2005, 2008) skills Understanding of OLAPMultidimensional Data Objects (Cubes) Advanced quantitative and problem resolution skills exhibiting the ability to resolve complex databasedata warehouse issues successfully analyze and evaluate alternatives and draw valid conclusions. Some level of expertise around database programming and performance tuning techniques Experience in Cognos 8+ Experience in MSAS, SSIS, Reporting Services, Framework Manager, SSRS, Cognos Report Studio Bachelor (4-year) degree, with a technical major, such as engineering or computer science.

Keywords BI Engineer, DW Engineer, Business Intelligence Engineer Please send your MS Word Resume to DW, BI, ETL, SQL, Cognos

About this company
Tiva Systems operates at the intersection of people and technology, specializing in project and program management, PMO setup, project...