Data Architect with Snowflake

Skills

Description

1. Having 8+ years of experience in Data Engineering, ETL/ELT, data ingestion, data migration in AWS/Azure landscape in migration and/or greenfield projects.

2. Having experience in data platform requirement understanding, design and implementation, logical and physical data modelling.

3. End-to-end experience in large scale data project implementations for global customers.

4. At least one full-fledged project experience with the R&D division of any global manufacturing customer is mandatory. The candidate must be well-versed with the end-to-end project life-cycle and special needs of Manufacturing R&D projects.

5. Engage with the business users to understand the business process, conceptualize and prepare the architectural diagrams/DFDs.

6. Develop and validate the logical data model and transform it into a physical representation working with DBAs.

7. Good in SQL for writing/tuning complex sql joins, views, aggregation queries, stored procedures.

8. DDL, DML scripts creation and Schema/Object/DB creation in any prominent data-warehouse tool like Snowflake, Oracle DW, Redshift, Terradata, Synapse etc.

9. Knowledge of AWS/Azure Cloud and any leading job orchestration tool like AWS Glue, Airflow, ADF, DBT will be preferred.

10. Expertise in Python/PySpark will be added plus.

11. Understanding of Data Governance, Data Observability concepts.

12. Collaborate with the BI and Analytics teams on creating the optimized, reusable semantic models complete with metadata and lineage information.

13. Excellent spoken and written communication skill is mandatory.