Snowflake Architect

SNOWFLAKE consulting ARCHITECT

15-18 YRS 

PUNE/BANGALORE/HYDERABAD

 

What's this role about?

 

As a Snowflake Data Architect, you will be responsible for providing advisory and thought leadership on migration to Snowflake or implementing data solutions using Snowflake Cloud services including integration with existing data and analytics platforms and tools. You will contribute in pre-sales and design, implement scalable data architectures, and information solutions covering data security, data privacy, data governance, metadata management, multi-tenancy and mixed workload management, and provide delivery oversight. You would be guiding customers on setting up data & analytics platform for their business requirements, advise on next best technologies and help them plan next set of solutions and services to create value for their business users and end customers.

 

Here's how you'll contribute:

 

Snowflake Architect at Zensar participates in end to end cycle from opportunity identification to its closure and takes up complete ownerships of project execution and provide valuable expertise in the project. You will do this by:

 

• Collaborate with clients to understand their business objectives and challenges and provide data-driven solutions.
• Design and implement end-to-end data architecture solutions, considering scalability, performance, and security requirements.
• Conduct data assessments and develop strategies for data management, integration, and analytics.
• Lead and mentor a team of data professionals, providing guidance on best practices and industry standards.
• Responding to client RFI, RFP documents with proper solution design including cost estimates. Provide technical expertise and support during the pre-sales process, including proposal development and client presentations.
• Stay updated on industry trends and advancements in data architecture and analytics.
• Contributing to SoWs, technical project roadmaps, etc required for successful execution of projects leveraging Technical Scoping & Solutioning approach 
• Planning end to end technical scope of the project and customer engagement area including planning sprint and delivery 

 

Skills required to contribute:

15+ Years of experience in  Data and Analytics experience with minimum 7-8 years in Snowflake and 2-3 years in one of cloud platforms like Azure or AWS 

1. Proven experience as a Data Architect, with a focus on consulting and solution design.
2. Extensive experience in Cloud Data stack from consulting, setting up data platform, rearchitecting or refactoring data platform to cloud native services along with industry leading tools/products, Strong expertise in data modeling, database design, and ETL processes.
3. Excellent communication and presentation skills.
4. Extensive experience in Snowflake – Virtual warehouse (Compute), Data modeling & storage including LDM/PDM design, data loading/unloading and data sharing, SnowSQL (CLI) as well as Snowflake Internals and integrations, SnowPipe implementation, S3 Internal data copy/movement, Snowflake security including readers and consumers accounts.
5. Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions, Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge on stored procedures 
6. 6+ Years of experience in Informatica 10.x & above / IICS with all modules including ETL design & development and troubleshooting / debugging, Repository Manager, Strong experience in Informatica Mapping Designer (Mapping & Mapplets creations using all Transformations) and Workflow Designer (Session & Task implementation and Job scheduling)
7. Minimum 2 data lake & EDW implementations using Azure/AWS/GCP Cloud Data native services along with Snowflake cloud data warehouse. 
8. Design and build production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, Scala.
9. Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.
10. Experienced in internal as well as external stakeholder management
11. Familiarity with data science and machine learning concepts is a plus.
12. Exposure to various data visualization tools (e.g. Tableau, Power BI etc)
13. Experience in MDM / DQM / Data Governance technologies like Collibra, Atacama, Alation, Reltio will be added advantage.
14. SnowPro-Core / SnowPro-Advanced certification will be added advantage.

 

How we’d like you to lead:

Take part in and host regular knowledge sharing sessions, mentor more junior members of the team and support the continuous development of our practice. 

We also want you to:  

• Share project stories with the wider business. 
• Provide recommendations and best practices for application development, platform development, and developer tools
• Actively stay abreast on industry best practices, share learnings, and experiment and apply cutting edge technologies
• Provide technical leadership and be a role model/coach to software engineers pursuing technical career path in engineering
• Provide/inspire innovations that fuel the growth of Intuit as a whole and generate creative ideas for emerging business needs
• Create content to promote your personal brand and Zensar to the world.
• Live Zensar's values, both, internally and externally