Data Developer/Architect (Sr. Associate)

New York, NY

Responsibilities

 

  • Responsible for design of Data Layer as part of Data Strategy for structured, semi structured and unstructured data
  • Design, develop and maintain Data Lake that can store, compute and query relational data, columnar data and unstructured blobs
  • Enhance and maintain database design for Master Data Management using normalization models
  • Enhance and maintain database design for Reporting Data Layer using Star Schema
  • Responsible for all development of SQL and NOSQL scripts, tables, View, stored procedures, extended functions in .Net/python etc in data layer
  • Develop data processes using control flow and data flow components in SSIS and/or Talend
  • Perform the role of a data steward, manage data design sessions for all applications, and
  • centralized data dictionary
  • Define standards, configurations and operational/administration guidelines for data layer
  • Collaborate with team members in overall data application delivery
  • Provide Level 3 support for all data applications, especially for data layer

 

Requirements

 

  • College degree , additional degree preferred
  • At least 6-8 years of experience working in the Finance industry
  • Experience and competency with data development tools like SQL Server, Snowflake, and Azure data services like sql database or sql data warehouse
  • Proficient in data design methodologies for relational, columnar, analytical, semi-structured and unstructured data
  • Experience in working on integration tools like SSIS, Azure integration services and/or Talend
  • Expertise in performance tuning databases and queries, using query plans to tune queries, indexing, partitions etc
  • Exposure to BI & Reporting tools like Tableau and SSRS

 

 

 

 

Note: Qualified candidates will be contacted within 2 business days of application. If an applicant does not meet the above criteria, we will keep your resume on file for future opportunities and may contact you for further discussion.

Date Posted 8/4/2020
Salary $100,000 - $140,000 + bonus






(2MB Max; allowed file formats: doc, docx, pdf, pptx, txt)



characters left