Snowflake Developer

Qualifications
Digital : Data Governance, Digital : Snowflake, EIS : Teamcenter Product (PLM)
Technical Degree required. B.S or M.S in Computer Science, Business Analytics, EngineeringUnderstanding of Data Engineering/processing, Business Intelligence and Advanced analytics using Teamcenter data
Thorough understanding of the back-end models for Teamcenter8+ 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
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 reposExperience 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
Strong business domain knowledge in Product Lifecycle Management
Experience with 3NF data modeling
Experience with transformation & development of data models in Snowflake
Experience with Coalesce
Responsibilities
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
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
Job description
Role name:

Developer

Role Description:

Build and maintain data models and data/solution pipelines to cater to analytical applicationsWork 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

Competencies:

Digital : Data Governance, Digital : Snowflake, EIS : Teamcenter Product (PLM)

Experience (Years):

8-10

Essential Skills:

Technical Degree required. B.S or M.S in Computer Science, Business Analytics, EngineeringUnderstanding of Data Engineering/processing, Business Intelligence and Advanced analytics using Teamcenter dataThorough understanding of the back-end models for Teamcenter8+ 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 reposExperience 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

Desirable Skills:

Strong business domain knowledge in Product Lifecycle Management.Experience with 3NF data modelingExperience with transformation & development of data models in Snowflake.Experience with Coalesce

Country:

United States

Branch City Location:

BOISE

Boise, ID