Latest Jobs  
 
 
This job has expired.
 
Job Information
Job title

System Analyst

Company ESG Consulting
Wage between $0.00 - $0.00 Annually
Location United States, Texas, Austin
Employment type Full Time
Education Not Specified
Year Experience 4 - 5 Years of Practical Experience
Travel Not Specified
Published on 9/18/2009
Description

Duration: Services expect to start ASAP and are to be completed by February 28, 2010

Duties:
A. Ensuring timely and accurate communications between other EDW project teams and external stakeholders as appropriate.
B. Analysis of requirements and data sources in the overall design and implementation of the Enterprise Data Warehouse
C. Systems and data analysis required for Datawarehouse planning phase and the creation of deliverables required to develop a comprehensive alternative analysis and cost benefit analysis for an enterprise data warehouse.
D. Development of infrastructure, storage, and networking requirements for an enterprise data warehouse.
E. Working with business and data analysts, developers, database administrators and requirements analysts to translate business requirements into technical requirements.
F. Development of conceptual and logical data models from data analysis results of business requirements translation.
G. Assist in cost estimation for project resources staffing, hardware, and software.
H. Gather and document security requirements for the enterprise data warehouse.
I. In-depth knowledge of data warehousing tools. J. Analysis of application and data integration problems, provide solutions and recommend corrective actions
K. Interpreting new and changing business requirements to determine the impact on Datawarehouse design
L. Analyzing source system data structures and mapping the structures to target Datawarehouse schemas. Must have excellent skills in requirements analysis, data assessment, business process reengineering, and familiarity with data warehousing design concepts such as third normal form and dimensional modeling.
M. Responsible for preparation and/or review of any technical designs and/or documents.

Provide input and feedback, as requested, to the development of an Implementation Advanced Planning Document (IAPD) and Request for Offer (RFO).

Minimum Requirements:

Experience on enterprise level systems projects in the Information Technology (IT) industry (with a minimum of 4 years on data warehouse/business intelligence projects) including end-to-end experience on at least 2 data warehousing projects.

Strong analytical and complex problem solving skills with experience as a systems analyst for all phases of the system development lifecycle, including requirements analysis, design, development, implementation, operations, and maintenance.

Data Warehouse data modeling and design.

Data Warehousing data population techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models in conjunction with 2 or more years experience with GUI based ETL tools such as Informatica PowerCenter, IBM DataStage, or Albinito.

Knowledge of Datawarehouse design and implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, end-user tools, database and SQL performance tuning.

Ability to develop complex logical data models & support compliance to policies and procedures including data structures & data elements naming standards.

A proven ability to implement appropriate enterprise Datawarehouse development methodologies that ensure effective management of technical risk, smooth integration of COTS products, identification and control of interfaces and development dependencies, and system quality through configuration management quality assurance and testing.

Understanding of Data Warehouse Metadata concepts, tools and repositories.

Excellent oral and written communication skills.

Bachelor s degree in Computer Science, Electrical Engineering, Systems Engineering, or other relevant discipline.

df-tc

Experience/Skills
See Above
This job has expired.
 
Bookmark and Share