The Enterprise Data Warehouse Data Modeler will work with IQ's Extract/Transform/Load (ETL), Business Intelligence (BI), and Database Administrator (DBA) teams to develop a target architecture, bridging strategy, developing dimensional models and reporting structures to support current and projected reporting and data requirements.
Designs and develops enterprise-wide data analysis and reporting solutions against data warehouses and other reporting repositories to help business users make decisions by identifying trends and patterns in stored operational data.
In this role, the selected candidate will document database process that currently extracts the data from the existing system for reporting purposes; assist in establishing the organization's data warehousing strategy.
In this role, the selected candidate must have an experience Analyzing and generating technical requirements and design; xperience Development experience in implementation of data warehousing utilizing RDBMS.
In this role, the selected candidate must have the ability to organize, prioritize, and manage multiple workloads and projects with minimal supervision; excellent oral and written communication skills.
This position is to use his/her acquired knowledge of IBM's DB2, systems analysis, systems design, data analysis, database design, and data processing fundamentals/techniques to successfully develop, design, and implement database systems as well as maintaining DB2 Sub-system performance and assisting with Database employee development.
The ideal candidate will be very strong with SSIS/SSRS and Tableau or another similar Data Visualization tool as a main focus of this job will be to develop reports. SSAS experience is a major plus for this role as the candidate will be interfacing with this tool a decent amount.