Snowflake Data Engineer

Affinitiv

6h•Remote

About The Position

Affinitiv is the largest provider of end-to-end, data-driven marketing and software solutions exclusively focused on the automotive customer lifecycle. Backed by 20+ years of automotive and marketing expertise, we pride ourselves on being the go-to experts in the industry. Not only do we work with over 6,500 dealerships and every major manufacturer in the country, we’re well-versed in OEM standards and the intricacies of a dealership or group’s local business. We are seeking a Snowflake Data Engineer to support and scale our cloud data warehouse and analytics ecosystem. This role is critical to ensuring reliable data pipelines, performant reporting datasets, and seamless integration between our operational systems, third-party vendors, and reporting applications. You will work closely with engineers, product owners, and analysts to monitor ETL processes, design aggregate datasets for BI tools, and build Snowflake stored procedures that power Angular-based reporting through APIs.

Requirements

3+ years of experience in a data engineering or analytics engineering role
Strong hands-on experience with Snowflake
Proficiency in SQL, including complex joins, aggregations, and stored procedures
Experience supporting ETL pipelines and troubleshooting data flow issues
Familiarity with BI tools such as Tableau and/or Power BI
Experience designing data models for analytics and reporting use cases
Ability to read and implement third-party technical documentation
Strong problem-solving skills and attention to detail
Ability to manage multiple priorities in a fast-moving environment

Nice To Haves

Experience working with API-driven reporting architectures
Familiarity with Angular or frontend-consumed APIs (understanding how data is consumed, not UI development)
Experience with cloud data integrations and vendor-provided data feeds
Knowledge of data warehousing best practices (star schemas, aggregates, performance tuning)
Experience working in a SaaS or analytics-heavy environment
Experience with Snowflake cost optimization strategies
Familiarity with CI/CD practices for data or analytics engineering
Exposure to multiple data sources (CRM, marketing platforms, operational systems)

Responsibilities

Monitor and support ETL processes moving data from on-premise or hosted servers into Snowflake
Troubleshoot data pipeline issues, including failed loads, data discrepancies, and performance bottlenecks
Design and maintain aggregate and reporting tables optimized for Tableau and Power BI dashboards
Create and maintain Snowflake stored procedures (GET procs) used by APIs to support Angular reporting applications
Optimize Snowflake performance and cost, including warehouse usage, query tuning, and table design
Support ad-hoc data requests from product, engineering, and analytics teams
Integrate third-party vendor data by reviewing technical documentation, designing ingestion processes, and validating data accuracy
Collaborate with application engineers to ensure data structures align with frontend and API requirements
Maintain clear documentation for data pipelines, stored procedures, and integrations