ECommerce - POS Database System Administrator

eCommerce & POS Database System Administrator

Pauline Books & Media is looking for a full-time eCommerce & POS Database System Administrator to manage and support our multi-platform database system: to verify and maintain accurate catalog information and up-to-date customer data in order to ensure seamless customer service; to be the main point of contact for upgrades, testing, maintenance and support; to build professional working relationships with sisters & staff in other departments, and
third-party software vendors.

ROLES & RESPONSIBILITIES
• Reports directly to the IT Manager
• Works closely with the IT Manager and ensures all third-party integrations
and plugins on our eCommerce & POS platforms are working as expected.
• Work closely with our POS Database Inventory Manager and eCommerce
Manager to ensure the eCommerce catalog is accurate and that
discrepancies are resolved in a timely manner
• Works closely with other departments to ensure customer data is up-to date (contact info, house account info, gift cards, store credit, etc.)
• Responsible for managing customer data in our eCommerce & POS
platforms - maintaining accuracy and merging duplicate records
including sales history as needed.
• Responsible for all transactional and related email communications
(eCommerce, POS, MailChimp/Mandrill).
• Day-to-day maintenance and upkeep of our eCommerce & POS platforms: managing users and resetting passwords and resetting passwords as required; troubleshooting issues in collaboration with IT Manager and third-party support teams.
• Monitor emails and notifications relating to bot attacks, site downtime, and coordinate the return of service in collaboration with our IT Manager and third-party support teams.
• Ensure backups are viable and running successfully on a regular basis
• Participate in webinars for a comprehensive understanding of the
eCommerce & POS platforms as needed
• Assist IT Manager in rolling out eCommerce & POS system upgrades
• Coordinate and schedule upgrades and training for sisters & staff as
needed.
• Adapt to changing priorities, learn new skills, and contribute to cross functional projects at the direction of the supervisor
KNOWLEDGE & QUALIFICATIONS REQUIRED
BSc in Computer Science, Information Technology or a related field and a
minimum of two (2) years experience in website administration and/or database
management.
Desirable:
• The software platforms in use in our environment (and in which the
successful candidate will be expected to become competent) are:
• Microsoft Office 365 (email and inter-company communications,
document processing in Word/Excel, cloud file storage in SharePoint)
• Experience with any of the following systems:
o POS Database Systems (Teamwork CHQ)
o eCommerce platforms (Magento or BigCommerce) and third-party
integrations/plugins
o Publishing House or other B2B software (Acumen Book)
o CRM software (MailChimp) integrated with other platforms
• Prior experience with any of the above platforms would be an asset
• Previous web development or eCommerce experience would be an asset.
• Use of VPN, private home office, and fast home internet connection if
working remotely
SKILLS & COMPETENCIES
• Attention to detail with high levels of accuracy
• Working knowledge of Microsoft 365, Excel and Outlook
• Display a high level of initiative and understanding
• Excellent communication skills - verbal, listening and written
• Ability to juggle tasks while prioritizing and maintaining the ability to
quickly identify errors and omissions.
• Basic knowledge of cybersecurity privacy laws and regulations related to
handling customer records and proprietary information
• Proficiency in Spanish for data entry is desirable by not required
PERSONAL CHARACTERISTICS
• High degree of integrity and trustworthiness
• Display a high degree of respect for self, colleagues, and superiors
• Willing to work in a team environment