Data Engineer

FCP Euro is seeking a highly skilled Data Engineer with hands-on experience across the modern data stack to design, build, and maintain our data infrastructure. In this role, you will manage end-to-end data pipelines - from ingestion to transformation, warehousing, and analytics - ensuring our teams have timely, accurate, and actionable data. You'll work closely with analytics, product, and engineering teams to deliver reliable data solutions that power business insights and operational efficiency.

FCP Euro is the trusted home and online destination for European car owners and professionals. Family-owned since 1986, our mission is to make European vehicle ownership more enjoyable and enduring by delivering the highest quality parts, knowledge, and support people can rely on. At FCP Euro, we exist to empower owners and professionals with the confidence and support to care for their European cars properly. That commitment has made us more than a retailer, but a long-term partner for those who value quality, expertise, and trust throughout the life of their vehicle.

Responsibilities and Duties:

• Architect, develop, and maintain robust data pipelines and ETL/ELT processes using Coalesce , Fivetran , and Census .

• Manage data warehousing solutions in Snowflake , ensuring scalability, security, and performance.

• Build and maintain BI and analytics tools, including Sigma for dashboards and Hex.tech for collaborative notebooks.

• Implement and monitor data workflows, leveraging AWS services such as CloudWatch , ECS Fargate , RDS , Lambda , and Transfer Family .

• Containerize and deploy workloads using Docker/Dockerhub in Linux environments.

• Write and optimize complex SQL queries and leverage Python and R for data processing, automation, and analytics.

• Integrate APIs to enable seamless data exchange between systems and applications.

• Maintain version control and collaborative workflows with Git .

• Monitor, troubleshoot, and optimize system performance and data reliability.

• Proven experience in a data engineering or similar technical role.

• Deep proficiency with Snowflake , Coalesce , Census , Fivetran , Sigma , and Hex.tech .

• Strong programming skills in Python , R , and SQL .

• Experience with AWS services (CloudWatch, ECS Fargate, RDS, Lambda, Transfer Family).

• Skilled in Docker , Linux systems , and container-based deployment workflows.

• Familiarity with API integration and automation.

• Strong understanding of data modeling, warehousing concepts, and performance optimization.

• Excellent problem-solving and communication skills.

• Experience with CI/CD pipelines for data workflows is preferred.

• Knowledge of security and compliance best practices for data systems is preferred.

• Familiarity with infrastructure-as-code tools (e.g., Terraform, Pulumi) is preferred.

• Company-subsidized Medical, Dental, and Vision insurance, including a zero-premium Medical plan for employees. Company HSA contribution.

• 120 hours of PTO (Paid Time Off), 40 hours of Paid Sick Time, plus Company Holidays

• 401 (k) with Company deposit and match., This is an exempt role with a base salary of $110,000 - $135,000 depending on experience, with a total compensation opportunity of $120,300 to $147,650 annually.