Snowflake Data Engineer
Delta Dental Plan Of Michigan
Contract Okemos, Michigan, United States Posted 9 months ago
About Position
Snowflake Data Engineer (Contract)
$65.00 / Hourly
Okemos, Michigan, United States
Snowflake Data Engineer
Contract Okemos, Michigan, United States Posted 9 months ago
Skills
Experience creating CICD pipelines from scratch Healthcare claims experience – “medium nice to have” – will be more relevant during the data transformation project Python scripting – will be useful for future projectsDescription
This team is currently supporting 2 major projects:
Customer Data Platform – this platform will allow customers who pay to use an in-house tool called Rosevelt to access their data via real-time streaming in Snowflake and manipulate it in whatever way they want
Phone System Migration – DDMI is transitioning to a cloud-hosted phone system. There are a lot of reports and data elements that DDMI needs to migrate. They are receiving some data from Snowflake and some data from an on-prem call system. They need to integrate the data and make it reportable for the Data Insights team to use
Responsibilities
- Design and develop data pipelines in Snowflake and StreamSets – they have some templates built out for the Customer Platform project, but these may or may not work for the Phone System project.
- Will be using existing templates and developing new pipelines from scratch
- Execute ETL processes to integrate on-prem data with data stored in Snowflake
- Participate in on-call rotation – each team member is on-call for 2 weeks, about every 8 weeks
- Must Haves:
- 3+ years of experience in Snowflake
- StreamSets or similar tool – Matillion, FiveTran, etc.
- Experience with T-SQL PL/SQL or both
- Experience automating processes
By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.