Snowflake Data Acquisition and Integration Specialist

Comerit; United States; Remote; USD 110,000 - 160,000; Full time

Job summary

Comerit is seeking a Snowflake Data Acquisition and Integration Specialist for a remote position. You will design and implement data extract/load pipelines with Snowflake as the sink, sourcing from cloud SaaS APIs and on-premise sources; collaborate with solution and data architects and lead a team of developers through implementation and deployment.

The ideal candidate has 5+ years in data integration, 3+ years with Snowflake and Python, and experience with Dell Boomi, SAP BODS, SAP SLT, and

Qualifications

• 5+ years of experience with data extract and load integration patterns.
• 3+ years of experience with the Snowflake data platform.
• 3+ years of experience with Snowflake data integration patterns.
• 3+ years of experience with Python.
• 2+ years of experience with Dell Boomi.
• 2+ years AWS Data.
• 5+ years of SQL experience.
• 2+ years SAP BODS.
• 2+ years SAP SLT (Landscape Transformation Replication Server).
• Experience with orchestration tools such as Redwood.
• Power BI experience is a plus.

Responsibilities

• Support the analytics solution in data extract and load solution delivery.
• Translate functional specifications and business requirements into architectural designs that include complex data models and front-end visualizations.
• Propose and implement potential improvements for existing integration patterns.
• Maintain data extract and load programs.
• Select appropriated technology components to realize solution designs.
• Anticipate future data needs in solution designs and reference architecture.
• Ensure accurate and up-to-date project and solution life cycle documentation.

Skills

Team leadership

Data extraction design

Data integration strategy

Analytics collaboration

Tools

Snowflake

Python

Dell Boomi

SAP BODS

SAP SLT

Redwood

Power BI

AWS Data

SQL

Job description

This is a remote position. The Snowflake Data Acquisition and Integration Specialist will be responsible for the design and implementation of the data extract and load with Snowflake as the target data sink. This role will extract data from numerous 3rd party data platforms, including cloud SaaS API and on-premise sources. The candidate will work closely with the solution architect and data architect to implement a high-performing data platform that fulfills the requirements of the business. They will lead a team of developers through the implementation, deployment, and enhancement of analytics solutions.

Requirements Responsibilities

• Support the analytics solution in data extract and load solution delivery
• Translate functional specifications and business requirements into architectural designs that include complex data models and front-end visualizations
• Propose and implement potential improvements for existing integration patterns
• Maintain data extract and load programs
• Select appropriated technology components to realize solution designs
• Anticipate future data needs in solution designs and reference architecture
• Ensure accurate and up-to-date project and solution life cycle documentation

Who you are

• 5+ years of experience with data extract and load integration patterns
• 3+ years of experience with the Snowflake data platform
• 3+ years of experience with Snowflake data integration patterns
• 3+ years of experience with Python
• 2+ years of experience with Dell Boomi
• 2+ years AWS Data
• 5+ years of SQL experience
• 2+ years SAP BODS
• 2+ years SAP SLT (Landscape Transformation Replication Server)
• Experience with orchestration tools such as Redwood
• Experience with Power BI a plus

Originally posted on Himalayas