Data Warehouse Analyst II
2+ years Contract
NOTE TO VENDORS:PLEASE DO NOT SUBMIT CANDIDATES THAT DON'T MEET THE REQUIRED SKILLS LISTED & DESCRIBED BELOW
DOT is looking for a candidate that can help provide BI ETL & Reporting needs for our DTIM Division.
The candidate will be a strong technical leader working on Data Integration, Data Warehouse, and BI Report Development projects, gathering & documenting requirements, performing analysis, designing solutions to meet business objectives, developing specifications, developing ETL mappings using Informatica PowerCenter, developing universes and reports using SAP Business Objects, testing, and implementing solutions. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Seek continuous improvement in performance & tuning and ensure security of data. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Work with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Work with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 7 - 9 years experience or equivalent education.
Ideal candidate will have experience designing BI solutions, with development experience using Informatica PowerCenter and SAP Business Objects.
DW & BI Knowledge and Skills Required for the position:
1.Data warehouse/data marts using Kimball & Inmon methodologies
2.Informatica PowerCenter V10.1
3.SAP Business Objects universe and report design/development
4.Xcelcius Dashboard design and development
7.Oracle, DB2 and SQL Server
8.Complex SQL development
9.Dimensional Data Modeling
Required DW & BI Knowledge areas:
Data warehouse design
Data warehouse development
SAP Business Objects (8+ years experience):
SAP Business Objects Universe design and development
SAP Business Objects report design and development
Database Knowledge (8+ years experience):
Complex SQL statements
Syed Ahmed Encore Consulting Services, Inc.
1701 East Woodfield Road, Suite #1030, Schaumburg, IL - 60173
Phone#: Ext: 404 Direct#: Fax:
Note: If you have received this mail in error or prefer not to receive such emails in the future, please send an email to with "REMOVE" in the subject line.
1. Data warehouse/data marts using Kimball & Inmon methodologies 2. Informatica PowerCenter V10.1 3. SAP Business Objects universe and report design/development
Encore Consulting Services