Snowflake Architect

Skills

Description

• Build and maintain data models and data/solution pipelines to cater to analytical applications

• Work in a technical team through development, deployment, and application of applied, predictive and prescriptive analytics using data engineering, machine learning engineering and artificial intelligence.

• Design and optimize data structures in data management systems (Snowflake, GCP, HANA) to enable reporting analytics using Tableau/Power BI as well as AI/ML solutions.

• Determine transformation requirements and develop processes to bring structured and unstructured data from the source to a new physical Data Model

Responsibilities

• • 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 back-end models for Teamcenter
• • 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.
• • 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.
• • 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.
• • Familiarity with the integration of Teamcenter & SAP as related to data warehousing solutions.
• • 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
• • Experience with various frameworks and processes, such as Agile (Scrum, Kanban, etc.)
• • Outstanding analytical thinking, interpersonal, oral, and written communication skills.  Proficiency in the Microsoft Office suite 
• • Ability to prioritize and meet critical project timelines in a fast-paced environment.
• • Self-motivated and team-oriented