The worker will be responsible for day-to-day management of the EDW Technical Team. This individual should have full technical knowledge of all phases of data warehousing planning, design, and implementation. Worker responsibilities may include:
A. Day-to-day team operations and resource management.
B. Task scheduling and assignment for a *-10 member technical team.
C. Ensuring timely and accurate communications between other EDW project teams and external stakeholders as appropriate.
D. Project status reporting to management team as requested. Including timely up-to-date project status updates.
E. Identification of project risks and coordination with PMO and Program Manager for mitigation strategies.
F. Analysis of requirements and data sources in the overall design and implementation of the Enterprise Data Warehouse
G. Systems and data analysis required for data warehouse planning phase and the creation of deliverables required to develop a comprehensive alternative analysis and cost benefit analysis for an enterprise data warehouse.
H. Development of infrastructure, storage, and networking requirements for an enterprise data warehouse.
I. Working with business and data analysts, developers, database administrators and requirements analysts to translate business requirements into technical requirements.
J. Development of conceptual and logical data models from data analysis results of business requirements translation.
K. Assist in cost estimation for project resources � staffing, hardware, and software.
L. Gather and document security requirements for the enterprise data warehouse.
M. Providing guidance and mentoring to Technical Team members.
N. In-depth knowledge of data warehousing tools.
O. Analysis of application and data integration problems, provide solutions and recommend corrective actions
P. Interpreting new and changing business requirements to determine the impact on data warehouse design
Q. Analyzing source system data structures and mapping the structures to target data warehouse 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.
Responsible for preparation and/or review of any technical designs and/or documents
12+ Experience on enterprise level systems projects in the Information Technology (IT) industry including end to end experience on two or more enterprise data warehouse projects.
8+ Technical management / team leadership experience for teams of 4 or more
8+ Data Warehousing data population techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models in conjunction with 3 or more years experience with GUI based ETL tools such as Informatica PowerCenter, IBM DataStage, or Abinitio.
8+ Teradata, Oracle, or SQL Server implementation experience.
8+ Business Objects, Cognos, Hyperion, or MicroStrategy implementation experience.
8+ Knowledge of data warehouse 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.
7+ Experience with data warehouse/business intelligence projects, including experience on at least 2 data warehousing projects
APPLY ONLINE AT:
PLEASE DO NOT REPLY TO THIS NOTICE BY EMAIL,
your reply will not be seen by a human. To contact the
employer directly, please do so by visiting the link above.