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 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
- Validate the completeness, accuracy, structure, and usability of key operational data including item, location, inventory, and order data.
- Extract, transform, clean, and organize data using SQL, Excel, database queries, and BI tools to support analysis and readiness activities.
- Reconcile data across source systems and operational outputs to identify mismatches, and develop repeatable validation routines.
- Build and maintain operational reports, dashboards, and scorecards to translate operational questions into clear metrics and actionable insights.
- Support testing cycles and launches by preparing data sets, analyzing test outputs, and monitoring stabilization metrics and exception trends.
- Serve as a data-focused partner, facilitating data review sessions and communicating data quality issues clearly to business and technical audiences.
- 3+ years of experience as a data analyst, reporting analyst, operations analyst, or similar role supporting fulfillment, distribution, or ecommerce environments.
- Demonstrated expertise in querying, wrangling, and transforming raw operational data into actionable business insights using advanced SQL and sophisticated data manipulation tools.
- Advanced proficiency in executing complex ETL (Extract, Transform, Load) workflows, leveraging SQL, relational database querying, and advanced spreadsheet modeling to structure large-scale datasets
- Experience building operational reports and dashboards using business intelligence or visualization tools.
- Strong understanding of data domains such as item master, location, slotting, inventory, transaction, and productivity data.
- Ability to investigate root causes of data issues, summarize business impact, and coordinate remediation.
- Experience using Snowflake, AWS data services, Python, or AI-assisted analysis tools is a plus.
- Exposure to agile/waterfall delivery or product lifecycle management is a plus.
- Bachelor's Degree 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.
- Discounted prices on our catalog of European car parts!
This is an exempt role with a base salary of $65,000 - $98,000 depending on experience, with a total compensation opportunity of $70,400 to $104,500 annually.
FCP Euro provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination or harassment of any kind on the basis of race, color, religion, sexual orientation, sex, gender identity or expression, national origin, cultural heritage, ancestry, political belief, age, marital status, family status, pregnancy, physical or mental disability, intellectual disability, learning disability, veteran status or any other characteristic protected by the law.
No phone calls or agency referrals, please.
Skills Required
- 3+ years as a data analyst, reporting analyst, operations analyst, or similar supporting fulfillment, distribution, or ecommerce
- Advanced SQL querying, wrangling, and transforming raw operational data
- Advanced proficiency executing complex ETL workflows and relational database querying
- Proficiency with Excel and advanced spreadsheet modeling
- Experience building operational reports and dashboards using business intelligence or visualization tools
- Strong understanding of data domains (item master, location, slotting, inventory, transaction, productivity)
- Ability to investigate root causes of data issues, summarize business impact, and coordinate remediation
- Experience using Snowflake, AWS data services, Python, or AI-assisted analysis tools
- Exposure to agile/waterfall delivery or product lifecycle management
- Bachelor's Degree
What We Do
FCP Euro was established by Harry & Kathy Bauer in 1986 as a small brick and mortar auto parts store in Groton, CT. Transitioned to an online store in 2001 by their son Nick Bauer & friend Scott Drozd, we have grown to become a leading eCommerce provider of Genuine, Aftermarket, OEM, and Performance parts for European cars. Throughout our journey the company’s values have remained the same: sell only the highest quality replacement parts, provide unparalleled customer service, and offer the do it yourself enthusiast technical support to help fix and maintain their vehicles. Today, FCP Euro has grown to over $100 million in annual sales funded through the continuous reinvestments of its profits. On our website, we maintain a sharp focus on high-quality parts of all quality tiers. We’ve committed ourselves to building a culture of service, quality, and continuous improvement - because we know that if our employees care deeply about our products, it will be reflected in what our customers receive. In Milford, CT, our total of 100,000 square feet FCP Euro Distribution Center space between two locations stocks over $15 million of inventory and has developed a highly efficient distribution model that has the ability to ship out almost all orders placed within 24 hours. Everything sold by FCP Euro is backed by an industry-leading comprehensive, Lifetime Replacement Guarantee - including wear and tear items like wiper blades, brake pads, and more. We can do this because we’ve spent over a decade tirelessly cataloging our own products with precise and accurate fitment data, checking quality of every single brand line and part, and constant development by our products team.
