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