Description
You will define and implement the enterprise Data Warehouse Solution to serve as the single source of truth.
Responsibilities
- Gather requirements from stakeholders and prepare Data Warehouse Requirements Document.
- Create Data Warehouse Design Document detailing operational, application, information, interface, technology, and security architecture.
- Map source system data to data warehouse models.
- Develop and test ETL processes.
Required Skills
- 10+ years defining, designing, and building relational and dimensional databases.
- Thorough understanding of modern information technology infrastructure practices.
- Translating business needs into long-term architecture solutions.
- Hands-on expertise in data warehousing, data modelling, master data, big data analytics, and data visualization.
- Hands-on management of SQL Server 2012 or higher, Oracle, or IBM DB2, including schema and index implementation.
- Experience with developing strategies for data acquisition and archive recovery.
- Coordinating with business users to develop scripts or queries to meet specific requirements.