Affinitiv · 5 hours ago
Snowflake Data Engineer
United States
Full-time
Remote
Mid Level
3+ years expAffinitiv is the largest provider of end-to-end, data-driven marketing and software solutions focused on the automotive customer lifecycle. They are seeking a Snowflake Data Engineer to support and scale their cloud data warehouse and analytics ecosystem, ensuring reliable data pipelines and performant reporting datasets.
Computer Software
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
Qualification
Required
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
Preferred
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)
Benefits
Medical
Dental
Vision
401K
Generous PTO
Company
Affinitiv
Affinitiv is the only industry partner that offers OEMs and dealerships the ability to achieve better results through the unique combination of our end-to-end, integrated platform, proprietary data analytics, and full range of marketing agency services.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Adam Meier
Chief Executive Officer & President
Mike Trevino
President and Chief Technology Officer
Company data provided by crunchbase