Home > New Haven jobs > New Haven computer/technical

Posted: Monday, October 30, 2017 10:07 PM

Position Summary: This position is responsible for developing and supporting Business Intelligence systems for all application software, and to provide support for the end-users. Essential Functions: 1. Design SSIS Packages to transfer data from flat files, ftp, or other means to SQL Server using Business Intelligence tools. 2. Extensively using SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc. 3. Writing T-SQL queries, Store Procedures and using them to build packages. 4. Generating Reports, Drill down reports, drill-through reports and parameterized reports using Business Objects. 5. Cube creation using MS SQL Server Analysis Services (SSAS). 6. Responsible for developing Business Objects Universe Designs, Database Design and Administration functions for Business Intelligence. 7. Coordinates the testing and implementation of business Intelligence systems. 8. Work closely with end users to identify requirements for new systems and customizations. 9. Initiates the change control process for any and all changes to Production systems. 10. Develops and implements end-user tools for accessing Data Warehouse. 11. Develop, implement and maintain documentation. 12. Recommends new information systems solutions to management. 13. Provides end-user training. 14. Performs additional duties or assignments as required by management. Qualifications: 1. Bachelor's degree in Computer Science, MIS or equivalent. 2. 2+ years of Data Warehousing and SQL development with SQL Server 2008/2012/2014. 3. Working knowledge utilizing Microsoft ETL/data integration tools (SSIS and T-SQL scripts). 4. Demonstrated SQL skills with extensive experience in developing stored procedures, views, functions, triggers, and advanced logical methods. 5. Working knowledge of Microsoft BI Suite includes SSAS, SSIS & MDX. 6. Working knowledge of Microsoft suite of products, including Word, Outlook, and Excel. 7. Knowledge of SAP Business Objects, Design Studio, Mobile, and Analysis products a plus. 8. Knowledge of IBM DataStage products a plus. 9. Demonstrated analytic, written, and oral communication skills. 10. Passing of background check, which may include verification of prior employment, criminal conviction history, educational and driving records. - provided by DiceData warehouse developer ETL developer, SSIS SSAS BI


• Location: New Haven

• Post ID: 20469272 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. © 2017