Job Description
Join our award-winning A-Team!
Ready to produce exceptional results with exceptional people? Get in touch, we would love to get to know you.
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.
Key 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
Required Qualifications
- 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 Qualifications
- 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
Nice to Have
- 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)
What You’ll Work On
- Scalable reporting datasets for executive and dealer-facing dashboards
- Backend data logic that powers modern Angular applications
- Real-world integrations with external vendors and data providers
Work from Here
At Affinitiv, we have the best of both worlds. Our team members have embraced remote work and our Work from Here program allows for remote working and the utmost flexibility while keeping in person collaborating thriving in a safe work environment. Our Work from Here approach gives team members a choice to work on campus or remote, leaders can hold in person or virtual team meetings to collaborate and cultivate relationships.
Affinitiv knows you have interests outside of work, which is why we offer a comprehensive benefits package that includes medical, dental, vision and 401K effective day 1 just to name a few. We also offer generous PTO so you can enjoy off time with family and friends.
At Affinitiv, we celebrate diversity, equality, and an inclusive environment.
Affinitiv is committed to providing an environment of mutual respect where equal employment opportunities are extended to all employees and applicants for employment. We prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
All aspects of employment are decided on the basis of qualifications, competence, merit, and business needs. Affinitiv is proud to be an equal opportunity employer.
