Data Engineer

Collectivus Holdings is a dynamic business group encompassing brands many of the most prestigious brands in the Collecting, Trading Card Game, and Hobby industries.

With a century's worth of collective experience in driving product and service innovation, high-end quality standards, and elevated customer experience, Collectivus brands are among the most recognized and loved throughout the world by the communities they serve.

Website: https://www.collectivusholdings.com Locations: Nashville Garland Aarhus Lisbon Worldwide Job Title: Data Analyst Job Location: Remote - US Collectivus is building a modern data platform on Snowflake to serve its portfolio of 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 Architect on design decisions and with the Data Analysis team on delivery.

Our data engineering team actively uses AI assistants in day-to-day development, and we expect engineers to adopt these tools thoughtfully and responsibly.

Responsibilities Pipeline Development & Data Integration Build and maintain Python-based ETL/ELT pipelines that ingest data from REST APIs, SFTP/flat files, and SaaS platforms (e.g., Qualtrics, Shopify, UKG, ERP, HubSpot) into Snowflake.Implement incremental loads, MERGE-based upserts, watermark/control-table patterns, soft deletes, and idempotent reruns following team conventions.

Data Modeling & Warehousing Develop and tune Snowflake SQL across raw, staged, and presentation layers, including views, tasks, and streams.Design and build data marts in Snowflake (fact and dimension tables, conformed dimensions, and aggregate layers) that serve Power BI reporting and downstream analytics.

Orchestration, Security & Data Quality Schedule and orchestrate jobs using GitHub Actions, monitor runs, and resolve failures.Manage secrets and credentials securely via AWS Secrets Manager and Snowflake key-pair authentication.Build data quality checks and assertion tests, and detect and remediate schema drift from upstream sources.

AI & Advanced Data Services Support Snowflake Cortex and MCP-based data services (semantic views, search services) by preparing and governing the underlying data.Use AI coding assistants (e.g., Claude) as part of the daily workflow to accelerate pipeline development, code review, debugging, and documentation, while retaining full ownership of correctness and quality.

Collaboration, Documentation & Engineering Standards Collaborate with analysts and business stakeholders to translate reporting needs into data models and Power BI-ready datasets.Write clear runbooks and data dictionaries.Participate in code reviews and follow Git branching and pull req...