Manager BI
ITAS, INC - Hoffman Estates, IL

This job posting is no longer available on Dice. Find similar jobs: Manager Bi jobs - ITAS jobs

Hi Please send any relevant resume for the below position to psurabhiitascorpcom mailtopsurabhiitascorpcom Role Manager – Business Intelligence Location Hoffman Estates IL Duration 6 months+ Summary This position manages the global business intelligence processes data integrations software and databases for the client The position reports directly to the The Director of Information analysis Responsibilities include development maintenance and continuous improvement of the data warehouses used by all Business Units within a division Data warehousing is focused around the three key areas of Finance (profit analysis sales order book and purchased cost) Product Lifecycle management and Customer Relationship management Effective administration of business intelligence empowers the organization with the data necessary to make proper strategic decisions which makes the role vital to the Group Major Duties Migrate existing MS Office AS400 based Divisional Profit Analysis and Orderbook data warehouses to MS SQL Server (currently using version 2008R2) Optimize SQL start schema and table structures Automate run process using data manager SQL server triggers procedures and windows scheduler Collect requirements and build a data warehouse solution for the Divisional Product Lifecycle Management and Purchasing data Liaison with business unit subject matter experts to collect requirements Create effective enduser frontends for secured dissemination of data warehouse information to the organization Leverage existing SQL Server SharePointCognosTM1 tools Establish data warehouse integrations between source and destination systems including the CRM and PLM systems Setup integrations for regular data refresh intervals and proper field interfaces Continuously improve the core data warehouses by working with the Business Unit consumers to resolve issues with source data inputs queries as well as the transformation processes analytics carried out within the data warehousing layer Convert current reporting to a sustainable automated format using TM1 Cognos MS SQL Server Share point and MS OFFICE Maintain data warehouse training curriculum using Oracle based User Productivity Kits for end users Maintain written documentation and protocols for maintenance of the data warehouse solutions Knowledge Skills and abilities Education requirement either a BS in Computer Science Information Systems or Accounting Finance and administrative proficiency with data warehouse software (such as MS SQL Server Cognos and Essbase) Must possess prior experience in financial related data warehousing Must possess expert skills in MS Excel ACCESS and SQL Server (current version is 2008 R2) Prefer experience with Cognos (Data Manager IBM Adaptive Warehouse Report Studio) SharePoint IBM TM1 AS400 Net C and JD Edwards Prefer prior experience managing information technology projects Judgement Analytica Interpretive Complexity This positionrequires the ability to dig into and optimize business system processes worlflows Candidate must have excellent attention to details when dealing with data transformation analysis The role will require a self starter who can work independently to intergrate the appropriate FinancialProduct Lifecycle n d Customer Relationship information into an effective business intelligence layer Planning The position will utilize MS Project to track pojects related to converting the existing MS ACCESS DW into the next generation MS SQL Server platform Ongoing this position will require planning to properly prioritize change requests related to continuously improvement of the DW Thanks Regards Surabhi P ITAS Inc 9000 Keystone CrossingSuite 150 Indianapolis IN 46240 Work 3175758950 Extn 4244 Emailpsurabhiitascorpcom Fax 3175758953 Fax(eFax) 6305660636 wwwitascorpcom httpwwwitascorpcom Business intelligence, MS office, AS400, SQL Server
Dice - 22 months ago - save job - copy to clipboard