Snowflake Data Engineer

We are looking for a candidate to perform data engineering tasks using Snowflake. Multidisciplinary work supporting data pipelines, data warehouses and develop data movements using Snowflake capabilities like Snow SQL, Tasks, Streams and stored procedures. This role is a remote contract opportunity with our exclusive client. Fun Things You Will Do: • Be an active member of an EDW team focused in building best-in-class data solutions on a large data warehouse and analytics project • Effectively communicate objectives, plans, status, issues and risks in a timely manner to team members, stakeholders, and management. • Work with analysts, developers, and management to scope projects, and ensure designs are implemented and tested to specifications. • Create solutions utilizing industry-standard dimensional models and data architecture to support business users that include data scientists, analysts, and non-technical functional users • Communicates clearly promptly in both verbal and written communication with other Software & Database Development Engineers. • Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements. Technical Skills: • Architect, design and implement data solutions using Snowflake as a cloud service (virtual warehouses, staging, etc). • Experience with optimizing security models around data access and authorization with Snowflake Cloud DW and AWS • In-depth knowledge of Snowflake architecture to create performance tuning and optimized data pipelines, query, and storage solutions. • Hands-on experience with ETL tools such as Matillion • Understanding relational and big data models to both store and access data from data visualization and other query tools. • A total of 4+ years of relevant experience in a multi-platform environment, including, but not limited to database development. • Knowledge and experience in a data warehouse environment with knowledge of data architecture patterns. • Experience with Jira and source control environments like Git, GitHub etc. • Minimum 7 years of experience in developing software applications including analysis, design, coding, testing, deploying, and supporting of applications. Who We Are EtiVenture Analytics is a premier consulting and staffing organization specializing in Data, Analytics, and Cloud technologies. Our expertise enables our clients to achieve their goals by building better data solutions, customer experiences, and efficient processes using proven and emerging technologies. We also specialize in talent management for data and IT professionals working with some of the best companies in the world. Matching talented, high performers with the right company is what we do best. At EtiVenture, all team members are valued. We promote a collaborative culture where people can be creative, learn new ways of working smartly and grow professionally. We support a healthy work and home life balance by providing comprehensive health insurance plans, retirement plans, paid holidays, vacation, and sick time. We also have fun in the workplace like our weekly techno trivia contests with entertaining rewards. EtiVenture is an equal-opportunity employer that values diversity in the workplace. All qualified applicants are reviewed without consideration of race, religion, color, sexual orientation, sex (including pregnancy), national origin, age, veteran or disability status, or any other characteristic protected by federal, state or local laws.