Data Warehouse Architect

Description

Analyzes business or scientific system specificationsInterface with users/customers to determine scope, business objectives and system requirementsDevelops technical specifications and the technical system designEstablish and design technical framework for systemDesign System components including user interfacesAble to integrate ideas and concepts into architectural designs for complex systemsDefine operational requirements including scheduling, capacity planning, and resource requirementsDefine test environment including development of test casesWork with customers/users to compile data dictionary for the design being implementedMay oversee the technical design of the systemBuilds and tests the application software and integrations and implements it for useDesign data conversion requirementsMay generate executable code based on accepted industry and TVA programming May unit test executable codeMay perform integration testing of executable codeImplement robust error handling and data quality processesDevelop operational proceduresFollows change control procedures and quality assurance standardsMay oversee the building and testing of the proposed systemResponsible for System testingVerification that the system meets all business requirementsVerify all components of the system and interfacing systems work together as designedVerify system will handle volume expected when placed in productionConduct data validation sessions with the customers to verify system resultsPerform system testing and document all resultsReceive approval from user that system is ready for productionStrong analysis and problem solving skills