Sql database administrator Jobs in Ottawa, ON

About AMBICO

AMBICO is a family-owned business with a proud legacy of excellence dating back to 1955. As a world-class manufacturer of high-performance and decorative doors, frames, and windows, our mission is to deliver innovative solutions that meet the evolving needs of our clients while maintaining a commitment to quality, precision, and design. Together, we are shaping the future of door hardware manufacturing with innovation, integrity, and craftsmanship.

At AMBICO, we value potential as much as experience. If you believe you can bring value to the team, even if your background doesn’t align perfectly with the job description, please apply.

AMBICO is committed to diversity and equity in our workplace. We welcome applications from individuals of all backgrounds, including but not limited to Women, Aboriginal persons, Persons with disabilities, Ethnic minorities, Persons of minority sexual orientation or gender identity, Visible minorities, and others who may contribute to the diversification of our workforce and share our values.

If you are invited to continue the selection process, please notify us at hr@ambico.com as soon as possible if you require any adaptive measures to support your participation. We provide accommodation to ensure a fair and inclusive recruitment process for all candidates.

About the role

Reporting to the Director of Customer Relations, the Order Administrator works with the Estimator and/or Senior Estimator to ensure the correct scope of work and price is accurate and has been approved by the Customers Purchase Order to set the order in motion. They coordinate with Accounts Receivable to ensure adequate credit and/or payment terms have been established. They create and manage sales and quote reports for sales funnel management and they create the order package for the PM team.

What you'll do

• Administer the purchase order process by verifying quote and order accuracy, resolving discrepancies, and preparing the final electronic order package with quotation history, including communicating with customers to gather and confirm all required information.
• Ensure that each order is accurately assigned to the appropriate account.
• Provide new accounts with the necessary documentation to establish payment terms and submit required information to the Finance Department
• Create and organize order folders/shortcuts on shared drive to electronically file all details. Log project updates into the CRM tracking system
• Generate and authorize the use of new item numbers in accordance with established procedures.
• Create the Sales Order, Order Confirmation and the Order Acknowledgement using the financial tracking system (SAGE).
• Prepare line listings as required.
• Complete wood specification sheets as needed.
• Research and document project locations and descriptions for tracking, establishing proper commission splits, and preparing order package covers.
• Check Sales Rep Commission and adjust for split commission where appropriate. Send finalized Acknowledgement copies to the Customer and/or Area Representative
• Transition approved orders to the project management team and recommend internal handoff meetings where necessary - or auxiliary orders to the appropriate board for the production team to fulfill.
• Follow up or coordinate with the Customer on auxiliary orders with courier tracking or shipment pickup details
• Prepare sales, quote, and cancellation reports for management.
• Back up to reception
• Work collaboratively with colleagues in cross-functional roles and departments for related projects.
• Ensure compliance with all company policies, procedures, and standard operating processes to maintain quality, safety, and efficiency standards.
• Other related duties, as assigned.

Qualifications

Education: Diploma in office administration, project management or a related field and some demonstrated experience in administration related to sales or equivalent knowledge and experience

• Knowledge of how to read architectural drawings and specifications.
• Knowledge of accounts receivable.
• Research and analytical skills with exceptional eye for detail.
• Experience providing office administration, including preparing documents and tracking information for follow up.
• Experience preparing and delivering quotes, purchase orders, and invoices.
• Hands-on experience with MS 365 (Excel, Outlook), Adobe Acrobat required; experience with Monday.com, ACCPAC or content management systems is an asset.
• Bilingual (English/French) is an asset.
• Experience working in a manufacturing or construction environment is an asset

WORK CONDITIONS:

• Extensive computer use and may involve long periods of sitting.
• Extensive mental effort to analyze information and prepare written materials.
• Attendance in the office 5 days a week normally.
• Significant relationship management with internal and external stakeholders.

WHY JOIN AMBICO?

• Comprehensive health, dental, and vision coverage
• Paid time off and a supportive work environment
• Salary range: $53,050 - $65,000
• This posting is for an existing vacancy.
• Opportunities for professional development and training
• Work with a team that values family, tradition, and excellence

PIca1cdc7a14ea-30511-40099570