Expecting the architect to be able to roll up their sleeves and get their hands dirty, not just building a data warehouse, fostering stewardship of the data, etc... but also to be knowledgeable enough to contribute elsewhere when necessary and to mentor others. The Architect shall provide a Data Architecture to develop and implement an enterprise Data Warehouse Solution in support of the single source of truth and business process root cause analysis. The data warehouse will serve as a centralized repository for multiple data sources from internal and external sources. He or She shall gather requirements from stakeholders, prepare Data Warehouse Requirements Document, and create Data Warehouse Design Document.
The Data Warehouse Requirements Document will include usability requirements, security requirements, businesses requirements, data requirements, query requirements, and interface requirements. The Data Warehouse Design Document shall include the operational requirements, application architecture, information architecture, interface architecture, technology architecture, and security architecture.
Qualifications / Skills Matrix
Must have a thorough understanding of modern information technology infrastructure practices and possess at least ten (10) years of experience doing the following: Defining, designing and building relational and dimensional databases. Performing data access analysis design, and archive/recovery design and implementation. Maps source system data to data warehouse models Translating business needs into long-term architecture solutions. Developing and testing ETL processes Reviewing and developing object and data models and the metadata repository to structure the data for better management and quicker access. Coordinating with business users to develop scripts, queries, or software code to accomplish specific requirements or tasks. Hands-on expertise in data warehousing and architecture, data modelling, master data, big data analytics, real-time analytics, and data visualization, and reporting Hands-on management of SQL Server 2012 or higher, Oracle, or IBM DB2, involving implementation of schemas, indexes, and query optimization Experience with Developing strategies for data acquisition, archive recovery, and implementation of a database.