Previous Job
Data Analyst (Data Mart) - RTH
Ref No.: 18-00676
Location: Newark, New Jersey
Scope of Work:

Position Overview

Our client is looking for a Senior Datamart Developer whose primary responsibility will be enhancing and supporting internally developed applications. The candidate will be part of a team that works with Business Analysts, Investment Professionals, Operations, Quality Assurance Testers and other System Professionals. The candidate will also be responsible for trouble shooting and resolving support issues for the Fixed Income supported systems. .

The qualified candidate must:
  • Analyze business requirements then design and develop applications to support them
  • Understand and follow the complete software development life cycle methodology
  • Build and maintain positive relationships with customers and co-workers
  • Possess excellent oral and written communication skills
  • Have the ability to manage multiple tasks and projects simultaneously
  • Possess the ability to associate past experience with current events in order to resolve problems or generate new ideas
  • Develop and execute test scenarios to ensure the stability and performance of applications
  • At least 5-8 years of experience in application & database development, including SQL Server 2016
  • Hands-on experience with Business Intelligence tools and data mart/warehouse(s)
  • Data Architecture and Data Modeling experience
  • Extensive knowledge of SQL Server best practices
  • T-SQL development, including stored procedures, functions, complex queries and dynamic SQL
  • Performance tuning experience
  • Strong experience with SQL Server column store feature.
  • Experience with Sybase and Sybase replication is a plus.
  • Knowledge of Jira, Confluence, Agile/Scrum development methodology and DevOps is a plus
  • Desire to learn the Fixed income Business