- Development of data warehousing data models in Snowflake
Strong SQL & Python
3NF data modeling experience
Siemens Teamcenter knowledge (preferrable)
Technical Degree required. B.S or M.S in Computer Science Business Analytics Engineering
Understanding of Data Engineering/processing Business Intelligence and Advanced analytics using Teamcenter data
Thorough understanding of the backend models for Teamcenter
8 years of strong working knowledge of databases (Snowflake MSSQL SAP HANA)
5 years building scalable ETL pipelines with data processing and/or developing applications and data sources.
Experience with the backend data structures tables relationships ER 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.
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 datawarehousing solutions for extended Product Lifecycle Management encompassing production cycle definitions of products equipment facilities etc.
Familiarity with the integration of Teamcenter & SAP as related to data warehousing solutions.
Various phases of Unit Integration & User Acceptance testing