Job Category: I.T. & CommunicationsJob Description:
US citizen or permanent resident only.
Position Description:
The BI Data Architect is responsible for developing OLTP and dimensional data models to support operational and Business Intelligence systems. This individual will be part of a dynamic team that builds and implements Business Intelligence solutions that serve as key decision support systems for the leadership of the company. A key for success in this role is a unique blend of technical skills, business knowledge, and strong interpersonal communication skills. This role provides the opportunity to work with a global view of the entire business.
Responsibilities:
Data modelling and architecture experience implementing proper data structures for a reporting solution from enterprise OLTP systems Dimensional modelling and architecture experience implementing proper data structures for a reporting solution from an enterprise Datawarehouse a must using tools such as Cognos, Microsoft, Actuate and/or other BI tools Maintain and version control data modelling repositories Responsible for detail Data analysis and translates Business requirements into logical data models. Experience re-engineering physical data structures, and recommends efficiencies as it relates to data storage and retrieval Working knowledge of the software implementation life cycle, leadership skills and the ability to work well with both business clients, developers and other architects Full understanding and experience in implementing a Datawarehouse is a plus Full life cycle experience in Data Warehousing (good understanding of Kimball & Inmon methodologies), Data Modeling, Data Integration, and Master Data Management Leads complex technical Datawarehouse discussions on modelling, integration, and overall technology solutions and design Ability to create robust, scalable, sustainable data architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources Excellent communication (written and verbal). May require some travel (20%) to gather business requirements
Required Skills, Knowledge and Experience:
5+ years - Data Architecture/Modeling experience; delivering both logical models and physical designs with extensive experience with translating business needs into data requirements A degree in Computer Science, a related discipline, equivalent work experience of 7+ years overall IT or the equivalent combination of education, training and experience from which comparable skills can be acquired At least 3-5 years experience with data modelling tools like ERwin, ER Studio, PowerDesigner, Oracle Designer and/or other modelling tools Experience with normalized OLTP, MDM and DW Dimensional modelling techniques, Star & Snowflake schemas, modelling slowly changing dimensions and role playing dimensions, dimensional hierarchies, and data classification Experience with maintaining data dictionary and managing technical, process, and business metadataPreferred Skills, Knowledge and Experience:
Experience in data modelling in a Freight Forwarding, logistics or similar industry is preferred.Email your Resume with ' 106-1122 BI Data Architect " in the subject line
EmoticonEmoticon