Sr Snowflake Developer

job summary:
For this contractor assignment, we are looking for a Snowflake ETL/ELT contractor. This contractor will thrive in a collaborative team setting, using creative and analytical skills to tackle problems. We are looking for someone who is passionate about digital technology and takes pride in making a tangible difference. This role requires strong communication, interpersonal, and leadership skills, along with comfort working in an agile environment.

location: Telecommute
job type: Contract
salary: $58.57 - 68.57 per hour
work hours: 9am to 4pm
education: Bachelors

responsibilities:
- Work on data projects that involves profiling, mapping, and engineering pipelines.

- Work on database migrations and build ETL/ELT solutions in Snowflake

- Be a part of a fast-moving development team using Agile methodologies.

- Utilize cloud environments, connectors, 3rd party partner software, and tools to develop solutions

- Document known solutions to internal and external knowledge base

- Support project activities and your team

qualifications:
Required skills:

-Ability to build queries from Snowflake data

- Ability to create additional views in Snowflake, and create an excel connection to the Snowflake views

- Development in Snowflake that requires queries to transform the data based on business rules that would then be pulled into Power-BI

- ETL/ELT (extract, transform, load) development experience, preferably with Snowflake.

- Experience working on Amazon AWS and/or Microsoft Azure ecosystems

- Experience writing, troubleshooting, and debugging advanced SQL queries

- Deep understanding of SQL data types, functions and, database objects.

- Experience developing and supporting large size Data Warehouses and Data Marts

- Ability to understand basic SQL query profiles and execution plans

- Experience troubleshooting data issues and database connectivity issues using a variety of methods (client - software, drivers/connectors)

- Excellent writing and communication skills with an attention to detail

Preferred skills and experiences:

- Scripting/coding experience in any of the following: Python, Java, .Net, NodeJS, R

- Experience supporting applications running on either Amazon AWS or MS Azure

- Knowledge of CDC technologies such as Fivetran, Attunity or HVR.

- Experience working with big data and/or MPP (massively parallel processing) databases.

- Experience with virtualization solutions (docker, Kubernetes, etc.)

- Understanding of cloud computing security concepts

- Minimum of 7 years related work experience programming and supporting software applications.

- {OR} Completion of a technical training program and 4 years related work experience programming and supporting software applications.

- {OR} Bachelor's degree or higher in an Information Technology related field of study and 4 years related work experience programming and supporting software applications.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected].


Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.