Data Warehouse Specialist

Company: Professional Technology Integration, Inc.

Updated: 4/3/2014


To Apply: Position: Data Warehouse Specialist (Ref: 9) Location: Little Rock ,AR United States,72201 Salary: $45.39/hr Duration: 1 Years 0 Months 25 Days - Contract Openings: 1 Description: The Data Warehouse Specialist will be primarily responsible for designing and implementing data warehouse and relational database applications also to include business intelligence development and administration. Local candidates preferred, but not required. We do not pay for travel. In addition, this person will be required to provide after-hours support, 24 x 7 on a rotating basis. Responsibilities: • Interviews customer and gathers requirements • Provides Data profiling, data cleansing, data validation, data standardization, data transformation • Provides systems analysis, data analysis and proposes appropriate solutions • Develop scripts and/or applications to integrate components needed for a complete solution • Provides knowledge transfer and technical support to other programming team members • Prepare, analyze, and design system requirements throughout the data warehouse implementation • Identify data sources and determine common data definitions across user groups • Perform design and implementation of data warehouse schema and cubes • Review data loaded into the data warehouse for accuracy • Perform database design, database architecture, and metadata creation • Provide technical consulting to users of the data warehouse and advises users on conflicts and inappropriate data usage • Monitor usage of warehouse to identify potential capacity overloads • Develop advanced reporting • Other duties as assigned Qualifications: • Bachelor’s Degree in Computer Science or related technical field • In-depth Data Warehouse design and implementation (5+ years) • Business Intelligence Software Development and Administration: • Cognos 10, Business Objects 4.1, Information Server, QualityStage 8.5, Data Manager 10 Required / Desired Skills * Data Warehouse Design Required - 5 Years * Data Warehouse Implementation Required - 5 Years * Relational Database Applications Required - 3 Years * BI Software (i.e. QualityStage and Cognos) Required - 3 Years * Data Analysis Required - 3 Years * DBMS: DB2 /UDB and SQL Server 2005/2008 Required - 3 Years To Apply: