Database architect Jobs in Hamilton, ON

Role Summary

The Solution Architect leads the design, implementation, and continuous improvement of enterprise business systems that support Finance, Supply Chain, Operations, Manufacturing, and Project Management functions across Modern Niagara. This role translates business requirements into scalable technology solutions, establishes architectural standards, and ensures business applications, integrations, and data platforms align with organizational objectives and long-term technology strategy.

Why This Role Matters to Modern Niagara

Epicor ERP is a critical platform supporting finance, supply chain, manufacturing, field operations, and project delivery. This role ensures the platform remains scalable, maintainable, and aligned with business needs while reducing reliance on external consultants and enabling long-term operational efficiency through strong architecture, governance, and integration practices.

Key Impact / Purpose

• Own the end-to-end architecture, governance, and roadmap for the Epicor ERP ecosystem.
• Drive business value through scalable ERP configurations, integrations, customizations, and data solutions.
• Support operational excellence by ensuring reliable, secure, and maintainable ERP processes and technologies.
• Bridge business stakeholders, implementation partners, and technical teams to deliver effective solutions.

Duties and Responsibilities:

• Own the end-to-end solution architecture for Epicor ERP, including configuration, customization, security, environment management, and extension strategy.
• Lead or support Epicor implementations, upgrades, and migrations from discovery and requirements gathering through go-live and post-implementation support.
• Translate business requirements into functional and technical specifications and provide recommendations on configuration, customization, and third-party solutions.
• Design and oversee integrations between Epicor and enterprise systems, including Azure services, middleware platforms, Power Platform, analytics environments, and other business applications.
• Develop and maintain Epicor customizations using BPM workflows, Epicor Functions, Kinetic UI Customization, Application Studio, BAQs, reporting tools, and APIs.
• Define and manage Epicor data architecture, including master data management, reporting strategies, data migration, and downstream data consumption.
• Partner with Data, Analytics, Integration, and Infrastructure teams to ensure reliable and governed data flows.
• Establish architectural standards, governance practices, security frameworks, change management processes, and environment strategies.
• Act as the escalation point for complex Epicor technical issues and work directly with Epicor Support, implementation partners, and vendors.
• Mentor analysts and developers on Epicor best practices, development standards, and solution design.
• Evaluate the impact of system upgrades, new modules, third-party applications, and enhancement opportunities.
• Create and maintain architecture documentation, technical standards, diagrams, runbooks, and decision records.

Must Haves:

• 5+ years of hands-on experience with Epicor ERP.
• Experience leading or supporting at least one full-cycle Epicor implementation, upgrade, or migration.
• Strong knowledge of Epicor modules, including Financials, Accounts Payable, Accounts Receivable, Order Management, Inventory, Purchasing, Production
• Management, and Project Billing.
• Experience with Epicor customization tools, including BPM, Method Directives, Data Directives, Epicor Functions, Kinetic UI Customization, Application Studio, BAQs, and reporting tools.
• Understanding of Epicor data architecture, including tables, relationships, custom fields, and reporting structures.
• Experience managing Epicor environments, upgrades, and deployment strategies.
• Strong SQL skills with the ability to perform data analysis, troubleshooting, and reporting development.
• Experience with C#/.NET development and API-based integrations.
• Experience designing and supporting integrations with enterprise systems and middleware platforms.
• Knowledge of REST APIs, SOAP APIs, OAuth , and modern integration patterns.
• Strong business analysis, stakeholder management, and communication skills.
• Ability to translate complex business requirements into practical technical solutions.
• Excellent documentation and technical writing skills.

Nice to Haves:

• Epicor certifications.
  Experience with Azure services, including Azure SQL, Logic Apps, Data Factory, and Entra ID.
• Experience with Power Platform, including Power Apps and Power Automate.
• Experience with Epicor Data Fabric, Data Lake, Power BI, or modern analytics platforms.
• Experience with EDI integrations.
• Experience with SharePoint administration and configuration.
• Experience with asset management or maintenance management systems.
• Experience with QuickBooks migrations or integrations.
• Experience working within construction, manufacturing, distribution, or project-based organizations.
• Previous experience as a Solution Architect, ERP Manager, Principal Consultant, or ERP Technical Lead.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or an equivalent combination of education and experience.

This is a new position. Expected annual compensation; $74,000 - $110,000.

Modern Niagara offers a competitive total compensation package including:

• Performance based bonus opportunities.
• Defined Contribution Pension Plan with a generous employer contribution
• Flexible Health and Dental benefits with tiered options to meet the needs of you and your family
• An annual health spending account to support your overall wellness
• 24/7 confidential support through our Employee and Family Assistance Program with access to comprehensive resources and professional services
• A competitive vacation package with additional vacation granted throughout your tenure with the organization.
• Employer Paid Parental Leave Top Up
• Annual Community Day dedicated to volunteering and giving back to the communities where we live and work
• Corporate Discounts through various vendors across Canada for programs such as fitness, mobile phones, travel, home and auto insurance and many others

Here at Modern Niagara, because we know our people are the best in the industry, we pride ourselves on providing a total compensation package that rewards employees for their hard work and supports employees and their families in their overall wellbeing.

About Modern Niagara

Who We Are

Modern Niagara helps building owners, managers, and general contractors meet the mechanical, and electrical needs of their buildings across Vancouver, Calgary, Edmonton, Toronto, Southwestern Ontario, and Ottawa. We are committed to having a positive and meaningful impact on Canada’s infrastructure — and on the communities where we live, learn, work, and heal. We build for life.

Our Culture & Values

We value passion, initiative, determination, professionalism, and teamwork. Health and safety are embedded in everything we do, and our award-winning safety culture consistently performs well above industry standards.

Diversity, Equity & Inclusion at Modern Niagara

We are committed to building a diverse, equitable, and inclusive organization where everyone has access to opportunity, feels a sense of belonging, and can thrive. We actively work to remove barriers faced by members of equity-seeking groups (including women, Indigenous, Black, racialized, 2SLGBTQIA+ people, people with disabilities, and newcomers to Canada) in the construction industry. We encourage applications from candidates of all backgrounds and lived experiences and are committed to a barrier-free hiring process. If you require accommodation at any stage of the recruitment process, please contact us at so we can make appropriate arrangements.

We appreciate every applicant’s interest in joining Modern Niagara. Only those selected for an interview will be contacted.