Senior Data Analyst

Manchester, Connecticut

Perform analysis, design, development, implementation and testing of Client/server applications in MS SQL Server. Create Star and Snow-Flake Schemas, FACT and Dimensions Tables and perform Physical and Logical Data modelling using Erwin. Create user interface reports in web enabled reporting tool SSRS and SharePoint. Develop SSIS packages to extract data from OLTP to OLAP Systems. Transfer data from various sources like MS Excel, MS Access, Oracle and SQL Server using SSIS and create the report using SSRS. Perform backup/ restore, database objects such as tables, procedures, triggers, constraints, indexes and views using T-SQL. Data Conversions and migrate the legacy data from MS SQL server to Netezza. Perform Extract, Transform and Load (ETL) using SSIS. Will work in Manchester, CT and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.

Apply Online

Back to job openings