Home > New Haven jobs > New Haven computer/technical

Posted: Tuesday, January 2, 2018 6:00 AM

Manager, Global Data WarehousingWork Location: Trumbull, CT 06611Term: FULL TIME EMPLOYMENTSalary: $100,000 per yearYears of Relevant Experience: 2+ years of Data Warehousing and SQL development with SQL Server 2008/2012/2014 Preferred Education: Bachelor's degree in Computer Science, MIS or equivalentPLEASE TAKE THE TIME TO READ THROUGH THIS REQUIREMENT AS IT WILL HELP US TO SUCCESSFULLY PLACE THE RIGHT CANDIDATE!Job Summary: This position is responsible for developing and supporting Business Intelligence systems for all application software, and to provide support for the end-users.Duties and Responsibilities:Design SSIS Packages to transfer data from flat files, ftp, or other means to SQL Server using Business Intelligence tools.Extensively using SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.Writing T-SQL queries, Store Procedures and using them to build packages.Generating Reports, Drill down reports, drill-through reports and parameterized reports using Business Objects.Cube creation using MS SQL Server Analysis Services (SSAS).Responsible for developing Business Objects Universe Designs, Database Design and Administration functions for Business Intelligence.Coordinates the testing and implementation of business Intelligence systems.Work closely with end users to identify requirements for new systems and customizations.Initiates the change control process for any and all changes to Production systems.Develops and implements end-user tools for accessing Data Warehouse.Develop, implement and maintain documentation.Recommends new information systems solutions to management.Provides end-user training.Performs additional duties or assignments as required by management.REQUIRED SKILLSBachelor's degree in Computer Science, MIS or equivalent2+ years of Data Warehousing and SQL development with SQL Server 2008/2012/2014Working knowledge utilizing Microsoft ETL/data integration tools (SSIS and T-SQL scripts)Demonstrated SQL skills with extensive experience in developing stored procedures, views, functions, triggers, and advanced logical methodsWorking knowledge of Microsoft BI Suite includes SSAS, SSIS & MDXWorking knowledge of Microsoft suite of products, including Word, Outlook, and ExcelKnowledge of SAP Business Objects, Design Studio, Mobile, and Analysis products a plusKnowledge of IBM DataStage products a plusDemonstrated analytic, written, and oral communication skillsPassing of background check, which may include verification of prior employment, criminal conviction history, educational and driving records - provided by DiceData Warehousing, ETL, SQL Server, stored procedures, views, functions, triggers, and advanced logical methods, SSAS, SSIS, MDX, Microsoft Word, Outlook, Excel, SAP Business Objects, Design Studio


• Location: New Haven, Trumbull

• Post ID: 22025832 newhaven is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2018