For one of our long-term multiyear projects, we need a Microsoft Azure Architect out of New York, NY.

Responsibilities:

• Experience in data integration activities including: architecting, designing, coding, and testing phases

• Architect the data warehouse and provide guidance to the team in implementation using Snowflake SnowSQL and other big data technologies

• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python

• Experience in performance tuning of the snow pipelines and should be able to trouble shoot the issue quickly

• Extensive experience in relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modeling)

• Understanding of data transformation and translation requirements and suggest tools to leverage to get the job done

• Understanding data pipelines and modern ways of automating data pipeline using cloud based implementation and Testing and clearly document the requirements to create technical and functions specs

• Possesses strong leadership skills with a willingness to lead, create Ideas, and be assertive.

• Should be able to demonstrate the proposed solution, with excellent communication and presentation skill

• Engage with onsite-offshore team for daily activities Status reporting – weekly and monthly basis.

Qualifications:

• Should have minimum of 12 years of IT experience.

• Minimum 4+ years of experience in designing and implementing a fully operational solution on Snowflake Data Warehouse

• Experience with Python and a major relational database.

• Understanding of RESTful API design

• Passion for industry best practices and computer programming

• Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies

• Should be having good presentation and communication skills, both written and verbal Ability to problem solve and able to convert the requirements to design

• Ability to troubleshooting issues as and when arisen.

• Ability to test the developed jobs and preparing test documents

• Work Experience on optimizing the performance of the Spark jobs.