Data Architect

Job Description for Profile:

Location-Pune

Must Have

Technical Skills

• 10-13 Years Overall experience
• Experience with sound knowledge on database concepts like Entity-relationship, Data modeling, DDL and DML statements etc.
• proven experience in Snowflake in data modelling, data pipelines, data governance and performance tuning.
• 3+ years of SQL performance tuning, SQL/PL-SQL programing, UDF and Packages
• Good exposure to Azure SQL server and SQL data warehouse.
• Understanding of Snowflake capabilities like Snowpipe, STREAMS, etc.
• Strong understanding of the Snowflake architecture
• Understand of Snowflake roles and user security
• Understanding of migration, dev/ops, ETL/ELT, and BI required
• Understanding of data lineage and good in building such frameworks
• Works closely with all business units and engineering teams to develop strategy for long term data platform architecture
• Experience in various data cleansing techniques
• Leading a team of data engineers and data visualization experts
• Leading a team of frontend and backend engineers, product managers, and analysts
• Good in analyzing and organizing raw data
• Good working experience in Integrating various data sources
• Good in building scalable data pipelines using ADF, Databricks including full load and incremental loads
• Great numerical and analytical skills
• Sound knowledge and proven experience in SQL and PL/SQL including CTEs (Common Table Expressions), Aggregate Functions, sub-queries, cursors, anonymous blocks etc.
• Knowledge of Power Bi

Soft Skills

• Good Communication and Self-starter, Strong sense of ownership
• Managing stakeholder’s expectations and managing good relationship with the working team.
• Proven experience in working with on-shore/off-shore Model
• Good presentation skills and interpersonal skills