*Please share resume to [email protected] <[email protected]>* *EAD, GC or Citizen *
*Role: BI/ETL Developer* *Location: Burns Harbor, IN* *Interview: Phone/Skype is fine* As a BI Developer you will be involved in the analysis, design, implementation, and support of existing systems including, but not limited to: Business Intelligence Warehouses and interfaces between SAP and non-SAP applications affecting Logistics and Quality areas. *Primary Responsibilities:* - Analyze the business requirements and evaluate data available and needed by data profiling and source-target mappings for business requirements - Design the data collection, data staging, data movement, analytics delivery, data quality and archiving strategies - Develop, test, and implement ETL processes to transform the data. - Develop detailed technical specifications and ETL documentation - Comply to internal standards and guidelines - Performance tune new and existing packages - Gather data requirements to implement complex analytical calculations in MDX - Design cube projects including cube hierarchies, partitioning, processing, and loading strategies. - Provide post-implementation support by performing problem analysis and resolution as needed *Required Skills: (7+ years)* - Visual Studio 2012, 2010 and 2005 (Visual Basic) - SQL Server 2005, 2008, and 2012 - T-SQL Queries, Stored Procedures, Views - SQL Server Integration Services (SSIS) 2012 - SQL Server Analysis Services (SSAS) 2012, MDX - Working knowledge of MDS - Working knowledge of Online Analytical Processing (OLAP) - Working knowledge of Business Intelligence warehouse modeling utilizing Kimball Methodology - Advanced database design and SQL syntax knowledge - Excellent organization, prioritization, time-management, and decision-making skills - Excellent oral & written communication skills - Experience utilizing the SDLC (System Design Life Cycle) - Work in concert with business to help design a new OLAP cube for Logistics Equipment Forecasting, load cube staging data, and implement. (Advanced SSIS and SSAS skills). - Maintain and enhance existing Logistics OLAP Cube (Inventory & Shipment performance) utilizing ETL via SSIS and creating New Dimensions/Measures via SSAS -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
