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.)
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
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.