Back to jobs

Snowflake Data Engineer

Remote

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.

 

Create a Job Alert

Interested in building your career at Affinitiv? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...

Please include full address, apt #, city, state and zip code

No PO Box

Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Affinitiv’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.