Snowflake Data Engineer - US Based - 100% Remote

Company Description

CoEnterprise is an award-winning B2B software and professional services company headquartered in New York City. Founded in 2010, CoEnterprise delivers Supply Chain and Business Analytics solutions and services that transform how companies connect and do business. CoEnterprise approaches each relationship and engagement from the perspective of three core values: collaboration, ownership, and excellence. We value collaboration with both our partners and clients in order to present the best possible outcome for our customers. Our vow to accept ownership ensures that our entire staff takes pride in our work and it is our commitment to excellence that ensures that this work is at the highest standard possible.

Job Description

The candidate will: 

• Collaborate with the CoEnterprise onshore team to design and implement effective data warehousing solutions using Snowflake
• Develop and maintain scalable and efficient data pipelines, ensuring seamless data extraction, transformation, and loading (ETL/ELT) processes
• Provide expertise in Snowflake's features and functionality, including the creation and management of users, roles, warehouses, resource monitors, tasks, pipes, streams, and implementing Snowflake role-based access control (RBAC)
• Manage the integration of Snowflake with cloud storage solutions and analytics tools such as Tableau and Power BI
• Conduct QA testing, adhere to system development lifecycle, and execute promotion activities DEV/QA/PROD
• Create and maintain technical documentation, including data flow diagrams and business documentation, to support system design and architecture

Technical Skills:

• 2+ years working with the Snowflake Data Cloud
• 3+ years prior experience in data solution delivery within mid-market or Enterprise-level consulting environments
• Advanced SQL skills, including the ability to write and optimize stored procedures and views.
• Proficient in data warehouse concepts, specifically in designing and implementing fact and dimension tables
• Proficient coding skills in at least one of the following: Python, JavaScript, R, or other data science language
• Integration of AWS S3 and Snowflake
• Experience with system development lifecycle, from requirement analysis to production deployment and monitoring
• Knowledge of authentication methods using platforms like Okta for secure identity management related to Snowflake

• Familiarity w/system integration methods such as APIs and custom connectors

Qualifications

Professional Skills:

• Strong capability in creating technical business documentation, with a structured and methodical approach to maintaining deliverables and work artifacts
• Exceptional problem-solving skills and the ability to work methodically in a fast-paced, dynamic environment
• A strong command of the English language, enabling effective interaction with the onshore team and stakeholders
• Bachelor’s degree in computer science, Engineering, Information Technology, or a related field
• Snowflake certification a plus

Additional Information

Come experience our spirited culture and work with a smart, dedicated and high-energy team in a stable and fast-growing company! Here is a small sample of our benefits and perks we offer:

• Comprehensive Health Insurance with generous employer contribution
• Matching 401(k) - $$$$
• Generous PTO Policy
• Virtual Team Lunches
• Wellness Program
• Monthly Mingles
• Birthday Celebrations
• Virtual Events- Happy Hours, Casino Night, Magic Show, Scavenger Hunt of National History Museum

At CoEnterprise, we believe diversity drives innovation. We are committed to creating and maintaining a workplace in which all employees have an opportunity to participate and contribute to the success of our business.  In recruiting for our team, we welcome the unique contributions that you can bring. We value employees for their differences represented by a variety of dimensions including demographics, behaviors, work style and perspectives.

We are an AA/EOE employer.