Snowflake Engineer – Architect

Role Overview

• Participate as a Snowflake Engineer in the project team and provide agile software delivery
• Play a key role in delivering data-driven solutions for our client
• Proactively develop relationships with clients to understand their needs
• Provide expertise as a Snowflake SME to solve complex business issues
• Design, develop, and operate highly reliable large scale data lake systems
• Embrace Snowflake innovations with open source standards and tool sets
• Ensure all deliverables are high quality by setting development standards
• Participate in integrated validation and analysis sessions of components and subsystems on cloud servers
• Ability to perform market research and make specific recommendations including a SWOT Analysis
• Provide deployment information technology planning and implementation support
• Ensure successful analysis, design, evaluation, modification, testing, and implementation of agile software development solutions across the enterprise
• Work closely with the Project Manager to develop detailed plans and assist with business process changes

Requirements

• Experience assessing, designing, deploying, and/or sustaining applications within the Snowflake Ecosystem
• Expertise in Snowflake concepts like setting up resource monitors, integration with matlab, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel
• Expertise in Snowflake data modeling, ELT using Snowpipe and other open source tools such as Azure Data Factory and Apache Nifi, implementing stored procedures
• Proven track record of successfully building data driven solutions using integration, big-data processing and database and storage technologies
• Experience establishing data quality processes, performing data analysis, participating in technology implementation planning
• Experience in architecting data pipelines and solutions for both streaming and batch integrations using Azure Data Factory.
• Experience in Data Migration to Snowflake cloud data warehouse
• Experience in developing DBT models to transform data into useful, actionable information
• Significant experience in systems analysis and solution development of IT solutions to meet government business requirements
• Significant experience translating and mapping business requirements to technical requirements
• Experience in Microsoft Azure, Python, Java, C++, and SQL
• Experience developing solutions in at least 4 of the following technology areas: Government Cloud IaaS and PaaS (FEDRAMP Authorized solutions) Microservices and Containers DevSecOps Data Analytics ML/AI (Machine Learning / Artificial Intelligence)

Tech Stack

• Apache
• Azure
• Cloud
• Java
• Microservices
• Open Source
• Python
• SQL

Benefits

• Equal Opportunity Employer