Data Solutions Architect

Digital/Data / Westwood, MA


As a Data Solutions Architect you will be responsible for supporting all data management initiatives and projects, focusing in areas where the combination of door hardware product knowledge, Excel skills, knowledge of our ERP system and digital data are required. You will be a key contributor to our team, which is undergoing a full internal review of it’s vast product and inventory data store. The team is fully managed through JIRA with an Agile approach to project goals. We are looking for an exacting, meticulous individual to not only complement our existing team, but to raise the bar in terms of modern data integrity, fidelity, and integration.


Extensive experience using Excel to produce advanced relational and formula-based data sets. Basic understanding of data field mappings, databases, and relational data. Solid comprehension of how data is presented to both internal (ERP) and external (Website) customers. Ability to take door hardware product specifications and translate them into comprehensive data sets, or equivalent experience within a similar industry. Experience working with an ERP or similar business management system.


  • 3+ years of using Excel to produce rich, formulaic data sets
  • 3+ years of data entry or data management within a complex business system (ERP or equivalent)
  • Experience using pivot tables (or similar formulaic functionality) to optimize data entry
  • Product specification experience in the door hardware industry, or a willingness and ability to quickly attain product knowledge
  • Experience mapping similar but different data points to a common nomenclature
  • Ability to work independently while also collaborating closely with a team
  • Ability to multitask and balance shifting priorities
  • A true team spirit
  • Resourcefulness and a passion for solving data challenges

The ideal candidate has experience with one or more of the following:

  • Experience with Distribution One ERP-One Plus
  • Experience working in the distribution industry
  • Experience working with either customer- or business-facing e-commerce websites
  • Door hardware/Access hardware knowledge
  • Working with website data or databases
  • Working within an agile-based project management software cloud, such as JIRA or Trello
  • Interpreting data to make informed decisions
  • Scoping project requirements given from business units
Apply Now