Data Warehouse Architect and Developer

Description

Working within a team environment, the qualified individual will be a key participant in the design, implementation, and management of the Volvo Financial Services Data Warehouse and associated Data Marts. This position provides the opportunity to work with major components of a Data Warehousing environment, including ETL, management of Meta Data and delivery of data to OLAP Reporting tools. A desire to work in a cooperative environment and a proven track record of planning tasks and taking leadership in resolving issues is essential. This position requires an intermediate level of experience and application of Data Warehousing principles. RESPONSIBILITIES Work with the Data Warehouse team to translate business requirements into a technical architecture vision. Assist BI development team in the design of database solutions. Work with business owners and business users to understand and translate user requirements into practical data models. Design and develop the architecture for data storage strategy, tool integration strategy, ETL strategy, data staging, movement and aggregation. Also work with Business Intelligence Analysts to develop information and analytic delivery and data quality strategy. Conduct profiling of data sources and determine cleansing and data quality rules Work with BI team to incorporate business requirements into Extract, Transformation and Load (ETL) processes. Develop and maintain ETL processes and ETL Meta Data Code the scheduling, extraction and loading of data to the Data Warehouse environment using the ETL tool Assist in the resolution of tuning issues within the Data Warehouse environment Administration of ETL tools as necessary EDUCATION