Job Description :
Data Warehouse Engineer
12 Months Contract
Oregon - Hillsboro
Responsibilities:
Design data models, ETL mappings and associated objects of analytical solutions.
Design and development of analytical solutions including Business Objects based data marts and Salesforce analytics solution Wave.
Review solution design and ensure that the defined EDW standards and framework are followed.
Review and validate logical and physical design to ensure alignment with the defined solution architecture.
Create/review technical documentation for all new and modified objects.
Ensure quality assurance plan and cases are comprehensive to validate the solution thoroughly.
Support QA, UAT and performance testing phases of the development cycle.
Understand and incorporate required security framework in the developed data model and ETL objects.
Define standards and procedures; refine methods and techniques for data extraction, transformation and loading (ETL) both in batch and near real-time modes.
Evaluate, determine root cause and resolve production issues.
Work closely with other IT development groups to deliver coordinated software solutions
Required Skills:
Bachelor''s Degree in Computer Science, MIS, or related discipline, with 7+ years related information systems experience in Data Warehousing and delivery of BI solutions.
Deep understanding of data warehousing concepts, relational star-schema database designs and big data platforms and associated tools.
Deep understanding and hands-on experience of Business Objects, Informatica 9.x, Tableau and Oracle 11g system components, internal processes, and architecture.
Deep and strong knowledge of SQL and relational database models.
Hands-on experience with creating Unix shell scripts
Hands-on experience in data modeling
Experience working in an agile environment is required, must have a clear understanding of the role and responsibility of a Scrum Master.
Excellent team player able to work with virtual and global cross-functional teams at all levels.
Self-starter, highly motivated, able to shift directions quickly when priorities change, think through problems to come up with innovative solutions and deliver against tight deadlines.
Excellent spoken and written communication as well as receptive listening skills, with the ability to present complex ideas in a clear, concise fashion to technical and non technical audiences.
Excellent interpersonal skills will be needed in order to build strong relationships that will be critical to the success of this role.