New York Seasonal Jobs

Job Information

VISTRADA Sr. Data Architect in New York, New York

Vistrada, IT Consulting Company, is seeking a Senior Data Architect for a Financial Services client.


  • Extensive data architecture and data modeling experience

  • Act as a technical conduit with internal stakeholders to onboard new data sources to the CSRE data warehouse. Ability to translate business requirements into functional and technical design specifications.

  • Lead discussions across teams and communicate business and technical requirements in terms that are understandable for technical and non-technical audiences

  • Maintain a strong strategic view of end users' needs and its relations to the broader data strategy of the Services division. Help develop frameworks and end-state views that support the vision the Data Strategy team.

  • Demonstrated ability clearly express ideas and complex concepts in both verbal and written form (documents, presentations, diagrams, wikis, etc.)

Technical Skills:

  • Proven expertise in Information ETL Development, performance tuning (targets, sources, mappings and sessions) and turning SQL queries - DDL. DML (Pre SQL, Post SQL, etc.)

  • Experience working with large database containing several terabytes of data and expanding on a regular basis. Strong database skills; complex SQL view development, performance tuning and data governance

  • Experience in resolving ongoing maintenance issues, bug/leak fixes and troubleshooting ETL failures

  • Strong understanding of data structures and experience in the development of logical and physical data models

  • Experience in writing UNIX shell scripts and automation of ETL processes using UNIX shell scripting

  • Experience in one or more high-level languages (Java preferred0-

  • Experience with IlT Real-time data streaming and analytics (Configuring Stream Analytics jobs, Stream Analytics query development, etc.)

  • Experience with big data technology (Hadoop, Apache, Spark, MapReduce, etc.) a plus

  • 10+ years of relevant experience

Company Background:

Vistrada is a business, technology and operations services organization dedicated to helping clients plan, design, implement and manage initiatives to generate revenue, manage costs, build and sustain operations, and analyze and optimize their business.?

Vistrada distinguishes itself by providing seasoned expertise with a flexible team structure allowing agility and responsiveness to our client?s evolving needs. This ensures we bring the right team at the right time while optimizing the client?s investment.