Job Summary:
The Product Development Data Coordinator is the Airtable owner for our product development team. This person builds and runs the Airtable bases that track every new product from development through launch handoff, captures final approved product information, and keeps that data clean and complete so the Item Master team, which sets up new items in our ERP system, receives it on time. The role is also the day-to-day link between our New York product teams and our overseas supply chain teams and vendors, making sure everyone works from the same, current product information. This person will work cross-functionally with Design, Product Development, Engineering, the Product Data Launch and Governance teams, the Item Master team, Merchandising, Planning, Purchasing, and overseas management. This is a hands-on, highly analytical role for someone who builds in Airtable every day, lives in Excel, and is comfortable holding multiple teams to one source of truth. Hudson Valley Lighting Group is a worldwide leader in the design, manufacturing, and omnichannel distribution of decorative and architectural lighting fixtures, encompassing six brands: Hudson Valley Lighting, Mitzi, Troy, Corbett, CSL, and Sonneman (on behalf of Hudson Valley Lighting, Inc., Troy-CSL, Inc. and SN Modern, LLC). As the one-stop shop for the most comprehensive selection of lighting, HVLG seeks to inspire and support our customers in their pursuit to achieve a home that perfectly reflects their clients. HVLG takes a designer-forward approach to the light-purchasing process — making the experience more inspiring, exciting, and inviting. At HVLG, we believe that great lighting has the power to elevate any space and enrich people's lives — and it's that guiding philosophy that ties our family of brands together.
Key Responsibilities
Airtable Administration and Best Practice:
Own the design, structure, and day-to-day administration of the department's Airtable bases.
Set and maintain data standards, required information, and access for each team.
Build views, interfaces, and automations that make Airtable easy to use for every team that relies on it.
Map and document the end-to-end process in Airtable, and train users to work in it correctly.
Continuously improve how the business uses Airtable.
Airtable Data Ownership:
Partner with the Product Data Launch Manager to build and maintain the skeleton template for each launch in Airtable, so every required piece of information is captured from the start.
Work hand in hand with the Launch team to confirm all launch information is gathered and complete before items move to the Item Master team.
Collect final approved product information and maintain it accurately and completely in Airtable.
Keep Airtable as the single source of truth for new product data, with a clear record of changes over time.
Deliver complete, accurate data to the Item Master team on schedule and resolve questions quickly.
Product Pipeline Visibility:
Stay ahead of upcoming launches by understanding what is in development, what is approved, and what is at risk.
Capture decisions and changes from development meetings and make sure every affected team is informed.
Track open items and approvals through to completion so launches stay on schedule.
Engineering and Governance Coordination:
Make sure approved engineering and product changes are reflected in Airtable and communicated to the Item Master team and overseas partners.
Follow changes through to completion so production, quality, and service teams work from the current approved specification.
Partner with the Product Data Governance team on item master changes that affect existing products.
Work with Governance and Engineering to standardize product data and drive consistency across brands.
Overseas Vendor and Supply Chain Coordination:
Serve as the main point of contact between the New York team and overseas supply chain teams and vendors on new product development.
Make sure overseas partners get clear, complete, and timely information at every stage of development.
Confirm updates were received and understood, and follow up across time zones until open issues are closed.
Make sure overseas partners have the tools and access they need to work from the same data as the New York team.
Other duties assigned as needed.
QUALIFICATIONS:
RequiredStrong Airtable experience is a must: hands-on experience building and administering Airtable bases, including base design, linked records, lookups and rollups, formulas, views, interfaces, automations, permissions, and data imports. Be ready to walk us through a base you built. Project management experience: coordinating timelines, open items, and approvals across multiple teams through to completion. Bachelor's degree in Business, Information Systems, or a related field, or equivalent experience.3+ years in product data, product development coordination, merchandising operations, or a similar role, ideally in consumer products, lighting, or home furnishings. Advanced Excel: XLOOKUP or INDEX/MATCH, pivot tables, data validation, conditional formatting, and cleaning and reconciling large data sets. Highly analytical, with a sharp eye for detail and data accuracy. Proven ability to work cross-functionally and keep multiple teams aligned on one source of truth. Clear, direct written communication, including with overseas teams and non-native English speakers. Able to read product spec sheets and understand technical drawings at a basic level. Ability to reliably commute full-time to Wappingers Falls, NY 12590.US citizen or permanent resident (no Visa sponsorship available).Preferred Experience with ERP item master data, ideally SAP S/4HANA, and PIM systems. Experience working with overseas factories or supply chain teams in Asia. Experience with Jira or a similar engineering change or ticketing system. Airtable scripting, Airtable certification, Power Query, or similar automation experience.
WHAT SUCCESS LOOKS LIKE:
Every new product has one accurate, complete record in Airtable before it moves to the Item Master team. Approved changes reach every team without anyone having to chase them. Overseas partners get what they need at every stage, on time, with no surprises. Fewer launch errors, late changes reaching production, and product information mistakes. Airtable bases are well structured, documented, and easy for every team to use, and teams use them consistently and correctly.
Compensation & Benefits:
Competitive base salary (dependent on experience).Comprehensive health insurance (single medical plan).Life insurance and long-term disability coverage.401(k) with employer match.
Eligible for annual bonus program.
Generous vacation, sick, and holiday pay program.
WORKING CONDITIONS
Physical Demands:
The physical demands described here represent those that an employee must meet to perform the essential functions of this job successfully. Reasonable accommodation may be made to enable individuals with disabilities to perform essential functions. This position requires lifting up to 30 lbs., standing, sitting, walking, bending, kneeling, stooping, crouching, crawling, and climbing all day. As well as sitting for the duration of the work shift, except on breaks and mealtimes.
Work Environment:
The work environment characteristics described here are representative of those employees encounter while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform essential functions. Ability to work in a Distribution Center environment with varying temperatures and noise.
Equal Opportunity Employer:
Hudson Valley Lighting is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, physical or mental disability, genetic factors, military/veteran status, or other characteristics protected by law.
Disclaimer:
This position description indicates the general nature and level of work expected. It is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required. Employees may be asked to perform other duties as needed.