Snowflake DB Developer - ETL/SQL (4-20 yrs)

Job Summary :

This is a full-time Snowflake Developer role at Strategic Systems. The Snowflake Developer will be responsible for developing and maintaining data pipelines, optimizing queries, designing data models, and ensuring data quality and security. The role involves collaborating with cross-functional teams, implementing best practices, and contributing to the continuous improvement of data solutions.

Skills Required :

- Data Engineering : Snowflake, SQL, ETL

- Data Modelling : Dimensional Modelling, Data Warehousing concepts

- Data Management : Data quality, data security practices

- Cloud Platforms : AWS, Azure, or Google Cloud Platform

- Experience with data integration tools and techniques

- Strong problem-solving and analytical skills

- Effective communication and collaboration abilities

Key Responsibilities :

- 8+ years of strong working knowledge of databases (Snowflake,- MS-SQL, SAP HANA).

- 5+ years- building scalable ETL pipelines with data processing and/or developing applications and data sources.

- Thorough understanding of the back-end models for Teamcenter.

- Experience with the back-end data structures, tables, relationships, E-R relationship of

Teamcenter and translating them to data warehouse constructs.

- Ability to define & build hierarchical relationships of Product Lifecycle Management like BOM, etc. in data warehouse like Snowflake.

- Familiarity with the integration of Teamcenter & SAP as related to data warehousing solutions

- Understanding of Data Engineering/processing, Business Intelligence and Advanced analytics using Teamcenter data

- Communicate effectively with stakeholders regarding all facets of data warehousing solutions pertaining to PLM Teamcenter.

- Ability to architect & develop solutions pertaining to attributes, relationships for master data including slowly changing dimensions.

- Ability to architect & develop data-warehousing solutions for extended Product Lifecycle Management encompassing production cycle definitions of products, equipment, facilities, etc.

Various phases of Unit, Integration & User Acceptance testing

- Familiarity with software architecture (data structures, data schemas, etc.)

- Software development skills and knowledge in Cloud based data engineering.

- CI/CD pipelines including ADO repos