Data Warehouse Specialist # 17501/200660

Title: Data Warehouse Specialist # 17501/200660 Location: Albany, NY Duration: 24 Months Day to Day Tasks The Data Modeler will participate in a team approach to: 1. Work with SMEs, BI Business Analyst and BI Technology team to understand the data requirements and the full attribute set for entities and dimensions; 2. Convert business processes, domain specific knowledge, and information needs into a conceptual model; 3. Convert conceptual models into logical models with detailed descriptions of entities and dimensions; 4. Develop and maintain fully defined conceptual, logical and physical dimensional data model to ensure the information models are capable of meeting end user and OBIEE developer needs; 5. Develop data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc 6. Model aggregation layers and specific star schemas as subject areas within a logical and physical model 7. Understand and meet referential data integrity requirements 8. Document decisions made in meetings and alternative solutions discussed Requested Qualification: 60 Months Demonstrated hands-on experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc 60 Months Demonstrated hands-on proficiency in a data modeling tool (e.g, ErWin) 60 Months Demonstrated hands-on experience in relational data management disciplines and strong design and development experience using Oracle technologies 60 Months Demonstrated hands-on experience with SQL programming 60 Months In-depth hands-on experience with business intelligence tools (e.g.OBIEE 11G) which demonstrates a strong data analytics background 60 Months Demonstrated hands-on, in-depth understanding of how to design and create BI applications and health care business intelligence reporting solutions 36 Months Demonstrated analytics and communications experience (e.g., math, statistics, quantitative methods, and writing proficiency) Bachelors degree in business intelligence, information science, computer science, or mathematics A copy of the degree must be submitted with the Candidate Response Form Please note that we allow Skype/remote interviews. However we reserve the right to require an in-person interview. Please respond with updated resume and covering letter with few sentences how you meet each Requested Qualification referring your earlier projects 3 references are must with the resume. Contact mvkramarao@mitresource.com or Ph # 203-567-0129 for further information.