Data Warehouse Analyst

Data Warehouse Analyst   JOB SUMMARY: Be the person responsible for the design, implementation and documentation of the Enterprise Data Warehouse systems to meet end-user and client expectations and then continue to support and maintain these systems.

 

RESPONSIBILITIES:
Utilizing given requirements; design/model, develop, implement and maintain efficient Data Marts
Work with Business and Reporting Analysts to create new Data Marts
Interface with senior ETL developers to document and provide requirements

 

EDUCATION:
Bachelor?s degree in information systems, computer science, or related degree
Equivalent combination of relevant education and/or experience with acceptable technical skills required

 

EXPERIENCE:

?2+ years experience in data warehouse/data mart development which includes conceptual, logical and physical dimensional data modeling

?Must have expert SQL skills

? Must have experience and understanding of relational databases such as SQL Server 2005, DB2, Oracle

?Knowledge of ETL development tools such as Informatica, Datastage

?Knowledge of data modeling tool(s), such as Erwin

? Required experience with computer programming languages and techniques including structured application analysis, design and database practices

? Must have knowledge, and practical experience in following proper SDLC (system development life cycle) methods

 

SKILLS REQUIRED:
Results oriented and positive attitude
Ability to work well in teams, provide excellent customer service
Self-directed, self-motivated and dependable
Demonstrate strong analytical and problem solving skills
Able to effectively communicate with management, piers and end users
Ability to focus on improving quality and flow of data
Strong verbal and written communications skills
Strong ability to be organized, manage time and handle multiple tasks/projects and priorities in a very dynamic environment