DATA WAREHOUSE/ETL ARCHITECT
The primary role of the Data Warehouse/ETL Architect is to provide Architectural Guidance, ETL Rationalization, and Data Modelling. General Job Responsibilities/Accountabilities/AuthorityETL and existing primary data      repository Analysis      - Detailed analysis of existing ETL will provide insight into data      elements for new enterprise data model and development efforts required to      migrate to the new platform.  The      detailed analysis of the existing primary data repositories will provide      insight to the design of the new EDW as well as the historical data      migration.  Based on the high level      discovery during the BI Assessment project, this work effort will focus on      the source system to Repository ETL jobs and a review of the Repository,      CORE, and Stage Repository data models.       If additional ETL jobs and/or data models are identified during the      analysis, this will increase the amount of time for this work effort.Catalog and Inventory Business      Reports for the Enterprise  - Client will provide a primary resource      to work with the business units to identify and catalog reports they      produce and the usage of those reports.       During this effort, BAC will manage and provide guidance during      this process and will then analyze the results of this work and review the      data sets consumed by these reports.       Currently within Client, there are a few other projects in progress      which have performed some analysis on reports used within the Client for      migration purposes.  This      information may be consumed and reviewed for the purposes of this project      and possibly reduce the timeframe of this work effort.Application Integration      Analysis – A      detailed analysis of the existing custom applications and the data they      read and manipulate needs to be performed.       This analysis will provide insight and assist in timeline development      for their migration to the EDW.BI Roadmap Detailed Planning – As progress is made during      the detailed analysis of the existing source system ETL, Report Inventory,      and Application Integration, BAC will be able to work with client team      members to define a detailed work plan for the development of the EDW and      its deployment.  This detailed plan      would include the development tasks, communication plan, training and      education, client BI best practices, and an overall delivery      timeline.  The detailed work      breakdown would include resource allocations of client employees and      contractors.DeliverablesETL and Data Model analysis summary – this deliverable be an enterprise wide source and use of data and will list source systems, tables, and data entities for each along with a summary of business rules applied to the data. There are approximately 1200 total DataStage jobs that must be analyzed.Enterprise Reporting Catalog – this catalog will provide a list of reports generated by the Client along with a summary of the reports contents, purpose, and data sources.  This catalog can then be shared throughout the Client organization.Application analysis summary – this deliverable will list all applications currently linked to Repository and the data entities they consume and any data entities which they may produce and/or update.Detailed BI Development &amp; Deployment Roadmap - This detailed plan will include the development tasks, communication plan, training and education, Client BI best practices, and an overall delivery timeline.  The detailed work breakdown would include resource allocations of Client employees and contractors.High level logical data model – Based on the ETL and existing data model analysis, the enterprise reporting catalog, and the analysis of existing Repository custom applications, a high level logical data model will be developed to provide insight into the overall EDW data flow and data subject areas.
Title: DATA WAREHOUSE/ETL ARCHITECT
Salary: None
Description: The primary role of the Data Warehouse/ETL Architect is to provide Architectural Guidance, ETL Rationalization, and Data Modelling. General Job Responsibilities/Accountabilities/AuthorityETL and existing primary data      repository Analysis      - Detailed analysis of existing ETL will provide insight into data      elements for new enterprise data model and development efforts required to      migrate to the new platform.  The      detailed analysis of the existing primary data repositories will provide      insight to the design of the new EDW as well as the historical data      migration.  Based on the high level      discovery during the BI Assessment project, this work effort will focus on      the source system to Repository ETL jobs and a review of the Repository,      CORE, and Stage Repository data models.       If additional ETL jobs and/or data models are identified during the      analysis, this will increase the amount of time for this work effort.Catalog and Inventory Business      Reports for the Enterprise  - Client will provide a primary resource      to work with the business units to identify and catalog reports they      produce and the usage of those reports.       During this effort, BAC will manage and provide guidance during      this process and will then analyze the results of this work and review the      data sets consumed by these reports.       Currently within Client, there are a few other projects in progress      which have performed some analysis on reports used within the Client for      migration purposes.  This      information may be consumed and reviewed for the purposes of this project      and possibly reduce the timeframe of this work effort.Application Integration      Analysis – A      detailed analysis of the existing custom applications and the data they      read and manipulate needs to be performed.       This analysis will provide insight and assist in timeline development      for their migration to the EDW.BI Roadmap Detailed Planning – As progress is made during      the detailed analysis of the existing source system ETL, Report Inventory,      and Application Integration, BAC will be able to work with client team      members to define a detailed work plan for the development of the EDW and      its deployment.  This detailed plan      would include the development tasks, communication plan, training and      education, client BI best practices, and an overall delivery      timeline.  The detailed work      breakdown would include resource allocations of client employees and      contractors.DeliverablesETL and Data Model analysis summary – this deliverable be an enterprise wide source and use of data and will list source systems, tables, and data entities for each along with a summary of business rules applied to the data. There are approximately 1200 total DataStage jobs that must be analyzed.Enterprise Reporting Catalog – this catalog will provide a list of reports generated by the Client along with a summary of the reports contents, purpose, and data sources.  This catalog can then be shared throughout the Client organization.Application analysis summary – this deliverable will list all applications currently linked to Repository and the data entities they consume and any data entities which they may produce and/or update.Detailed BI Development &amp; Deployment Roadmap - This detailed plan will include the development tasks, communication plan, training and education, Client BI best practices, and an overall delivery timeline.  The detailed work breakdown would include resource allocations of Client employees and contractors.High level logical data model – Based on the ETL and existing data model analysis, the enterprise reporting catalog, and the analysis of existing Repository custom applications, a high level logical data model will be developed to provide insight into the overall EDW data flow and data subject areas.
Requirements: Mid-Senior level experience, Bachelor's Degree education
Fraudulent: No