Data Warehouse Specialist
Eagle is currently seeking a Data Warehouse Specialist for a six (6) month contract to hire opportunity, scheduled to begin immediately.
The successful candidate will be responsible for:
- Maintaining and enhancing an existing data warehouse solution, troubleshooting issues, making recommendations to the client and working with conventional data warehouse technologies to come up with plans that best support the client;
- Multiple solutions including an operational data store (ODS), a dimensional data warehouse and a business intelligence reporting solution;
- The analysis, design, and delivery of the various solution components;
- Working with key solution stakeholders to respond to any issues or requests that occur regarding the solution;
- Understanding of user data requirements, analysis of source data and designing data models to support analytic reporting;
- Extracting, transforming, and loading (ETL) design, development, and support for moving transactional data from source system(s) into the enterprise Operational Data Store;
- Monitoring and maintaining data integrity throughout ETL load process.
- Designing and executing data quality processing;
- Fully documenting designs, processes, and procedures to align with defined solution standards;
- Performing logical and physical database design for schemas required in support of Business Intelligence tools such as Oracle OBIEE and Microsoft Power BI;
- Performing key support contact role with user community to identify new requirements, enhancing existing function, enforcing data integrity, and improving operational efficiency; and,
- Tuning of ETL process and user reports through coordination with users, DBA, and data warehouse designer.
Skills and Qualifications
The qualified candidate must have:
- A BSc in Computer Science or other related area is preferred, but will consider equivalent in experience;
- Five (5) years’ experience with ETL and Business Solution Support and Maintenance;
- Five (5) years’ experience with Dimensional Data Model (Kimball Methodology);
- Three (3) years’ experience with Data Conversions / Data Warehouse / Big Data / Business Intelligence;
- Three (3) years’ Operational Data Store experience;
- Three (3) years’ experience with Oracle DB / Oracle OBIEE;
- Excellent verbal and written communication skills;
- The ability to present complex solutions to users and management in a non-technical format;
- The ability to partner with SYSAdmin, DBA, users and others to drive cross-functional project efforts;
- The ability to think and act independently and to thrive in a dynamic environment; and,
- The ability to discuss and understand user requirements and map these into highly-available, high-performance system designs.
Don’t miss out on this opportunity, apply online today!
We would like to thank all applicants for their interest; however, only candidates under consideration will be contacted. Please note that your application does not signify the beginning of employment with Eagle and that employment with Eagle will only commence when placed on an assignment as a temporary employee of Eagle.