Snowflake Developer

Title: Snowflake Developer
Location: Boise, Idaho (Remote allowed)
Type: Contract
Duration: Long Term
What's Encouraged Daily:

• 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/Client solutions.
• Determine transformation requirements and develop processes to bring structured and unstructured data from the source to a new physical Data Model

• 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

• 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