Sr. Data Architect

Location: New York, NY

Department: Technology

Type: Contracted

Min. Experience: Experienced

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
Forward this Position
Recipient email address (one)
Your name
Your email address
Enter a message (optional)
Human Check*
Apply for this Position
* Required fields
First name*
Last name*
Email address*
Phone number*

Attach resume as .pdf, .doc, or .docx (limit 2MB) or paste resume

Paste your resume here or attach resume file

Cover Letter*
In 150 characters or fewer, tell us what makes you unique. Try to be creative and say something that will catch our eye!*