We are seeking a talented and driven Digital Designer / Developer with knowledge of SQL, Microsoft 365 and SharePoint to join our team. In this role, you will help automate and streamline data collection, analysis, and report generation processes across various departments. You will play a critical part in integrating with external client systems, leveraging a variety of tools and platforms to deliver efficient and scalable solutions. This position is ideal for someone experienced in SQL development, with a strong understanding of MS365/SharePoint, and a passion for creating data-driven solutions within an engineering environment.
Position Responsibilities
- Develop, maintain, and optimize SQL queries, databases, and ETL processes to support business operations and reporting needs.
- Design and implement automated solutions for data collection, processing, and reporting using MS365 tools, Power BI, Power Automate, PowerApps, and SharePoint.
- Integrate and interface SQL databases with MS365 applications, SharePoint, and other client systems.
- Support our SQL based ERP System (Trimergo)
- Collaborate with engineering teams to gather requirements, create technical designs, and implement data solutions that enhance operational efficiency.
- Assist with SharePoint administration, workflows, and customizations to support the company’s business processes.
- Develop and maintain Power BI dashboards and reports to provide actionable insights for the engineering teams and management.
- Troubleshoot, optimize, and maintain our customized SQL project databases and related applications.
- Work closely with clients and internal teams to understand integration requirements with third-party systems.
Position Location
The incumbent will be developing tools and reports to assist our engineering workforce that is distributed between CANAL’s offices and customer sites spread across North America. The incumbent shall be available for collaboration and meetings during normal office hours. Preference given to candidates willing and able to come to a CANAL office (North Vancouver, BC or St. Catharines, ON) on a regular basis.
Position Requirements
Required Skills and Qualifications
- Post-secondary education in Computer Science, Information Technology, or a related field.
- Experience in SQL development and relational databases.
- Proficient in MS365 tools, including Excel, SharePoint, Power BI, Power Automate, and PowerApps.
- Strong understanding of database design principles, data normalization, and SQL performance tuning.
- Familiarity with PowerShell scripting for SharePoint and MS365 administration.
- Knowledge of APIs and integration techniques with third-party applications.
- Excellent communication and collaboration skills, with the ability to work effectively with both technical and nontechnical stakeholders.
Preferred Qualifications
- Experience in the engineering environments.
- Knowledge of Azure, including Azure SQL, and other cloud technologies.
- Familiarity with AI/ML integration and data visualization tools.
- Strong understanding of engineering data types and their applications in an industrial setting.
Job Types: Full-time, Part-time, Fixed term contract
Pay: $80,000.00-$130,000.00 per year
Benefits:
- Casual dress
- Dental care
- Disability insurance
- Life insurance
- On-site parking
- RRSP match
- Vision care
Flexible language requirement:
Schedule:
Work Location: Hybrid remote in St. Catharines, ON