Description
You will define and implement the enterprise Data Warehouse Solution to serve as the single source of truth.
This role is on-site.
Responsibilities
- Gather requirements from stakeholders and prepare Data Warehouse Requirements Documents.
- Create Data Warehouse Design Documents 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.
- 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.
- Thorough understanding of modern information technology infrastructure practices.
- Ability to translate business needs into long-term architecture solutions.
- Coordinating with business users to develop scripts or queries to meet specific requirements.
Preferred Skills