Snowflake Data Engineer - AI Pipelines (Remote)

Collectivus Holdings; United States; On-site; USD 100,000 - 150,000; Full time

Job summary

Collectivus Holdings is building a modern data platform on Snowflake to serve its brands. As a Data Engineer, you will design, build, and maintain the pipelines that move data from our source systems (ERP, CRM, e-commerce, marketing, survey, and finance platforms) into Snowflake, and shape it into reliable, well-modeled data for analytics, Power BI reporting, and AI-driven applications.

You will work within an established architecture and set of engineering standards, partnering with the Data

Qualifications

• 3–5 years of hands-on data engineering experience.
• Experience building star-schema data marts for BI consumption.
• Strong Python and SQL skills for production pipelines.
• Advanced SQL and Snowflake or similar cloud data warehouse experience.
• Experience with REST APIs, authentication, pagination, rate limiting.
• Familiarity with AWS services in data workflows and CI/CD tooling.
• Experience with AI-assisted development and data workflows.

Responsibilities

• Build and maintain Python-based ETL/ELT pipelines from REST APIs, SFTP/files, and SaaS platforms into Snowflake.
• Develop Snowflake SQL across layers and design data marts for BI.
• Schedule, monitor, and troubleshoot jobs with GitHub Actions and CI/CD.
• Manage secrets securely via AWS Secrets Manager and Snowflake key-pair auth.
• Create data quality checks and guard against schema drift.
• Collaborate with analysts and stakeholders to deliver Power BI-ready datasets.
• Leverage AI coding assistants to accelerate development while maintaining quality.

Skills

Python

SQL

Data modeling

CI/CD

GitHub Actions

AWS

AI-assisted coding

Tools

Snowflake

Qualtrics

Shopify

UKG

ERP

HubSpot

AWS Secrets Manager

Job description

Collectivus Holdings is building a modern data platform on Snowflake to serve its brands. As a Data Engineer, you will design, build, and maintain the pipelines that move data from our source systems (ERP, CRM, e-commerce, marketing, survey, and finance platforms) into Snowflake, and shape it into reliable, well-modeled data for analytics, Power BI reporting, and AI-driven applications.

You will work within an established architecture and set of engineering standards, partnering with the Data