Job Title: Systems / Data Analyst

Duties:  Work with other members of the technical team and business team to plan and document the digital interfaces and big data analytical system and application and project redesign development processes; perform technical and feasibility studies on the development of the new/enhanced system through re-design of existing system architecture and prepare documentation on the proposed changes to be made to the digital applications interface and big data analytical system and application; work with other team members to perform gap analysis and create 'As-Is' and “To-Be” business processes, work flows and documentation covering the functional and technical work flows for the existing and/or redesign Big Database system / application; design, code, program, develop and implement the web-based database models, digital interfaces, flow charts and work flows, database models and digital user interfaces using Visual Studio, HTML, C#, ASP, ASP.Net, SQL Script, SQL Server, HTML, XML; design, program and implement interfaces and database software code and software scripts for Data conversion and migration; perform Big data analytics, data validation and stored procedures developing and using SQL queries, JQuerty and SQL Server; design and develop packages for data warehouse using Integration services (SSIS) SQL Server; Analyzing requirement specifications defining business needs, scope, priorities and success criteria across the project; Writing Transaction Query Language (TSQL) as per needs; Implement Event Handlers and Error Handling in SSIS packages and process results to various user communities; Design SSIS packages to load Trading data from different sources Text file, Excel to staging and staging to Data warehouse; Design new job process, DTS packages and performance tune existing processes; Use DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages; Review requirements and design and front and backend Database applications; Developing Reports using SSRS based on the end user requirements; Perform tests and standardize data that meets the business standards using Fuzzy /exact lookups using SSIS Tasks.

Requirement:  Bachelor’s degree or equivalent in Computer Science or Information Systems, Engineering or related technological and analytical fields and 3 years of related experiences or a Master’s degree in relevant fields.

ANNUAL SALARY:              $55,000 - $65,000 / DOE

LOCATION:                             Columbia, MD and Moon Township, PA and other locations