Maganti IT Resources, LLC→
Data Warehouse Specialist # 17501/200660 at Maganti IT… · Albany
Skills
Job Description
Job Description
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:
Work with SMEs, BI Business Analyst and BI Technology team to understand the data requirements and the full attribute set for entities and dimensions;
Convert business processes, domain specific knowledge, and information needs into a conceptual model;
Convert conceptual models into logical models with detailed descriptions of entities and dimensions;
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;
Develop data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc
Model aggregation layers and specific star schemas as subject areas within a logical and physical model
Understand and meet referential data integrity requirements
Document decisions made in meetings and alternative solutions discussed
Qualifications
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
Additional Information
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.