Reporting to the Director of Technology. An integral part of the ALMAG Aluminium Information Technology Department the Sr. Business Systems & Database Analyst will assist with the planning, organizing, and optimizing the overall operation of business systems at ALMAG. Responsible for technical, operational support and maintenance of critical business systems at ALMAG.

Ensure that business systems meet business objectives while maintaining accessible and reliable systems for internal customer use. The incumbent will monitor changes in industry trends, innovations and customer behaviours and identify potential impact and applicability to ALMAG’s strategic, market, sales and functional plans. The incumbent will develop recommendations and once approved, will collaborate and support various teams to design and implement process and enhancements within mission-critical business systems.

DUTIES AND RESPONSIBILITIES
The duties and responsibilities of the Sr. Business Systems & Database Analyst are detailed below, but not limited to the following:

Planning

Participate in the review of business processes to generate recommendations for productivity improvements through technology

Risk mitigation and planning

Work with partners to eliminate redundant or ineffective business procedures

Enhance the customer service experience

Work with partners to gain agreement on solutions

Analyse data to quantify benefits and assess costs

Participate in presentations and meetings with Senior Management

Participate in the preparation of RFPs, bid proposals, and contracts

Work closely with the Director of Technology to develop application architecture and underlying services to run enterprise business systems

Research emerging practices and technologies and participate in long‑range planning for the development of business systems solutions, evaluating current deployment and migration models and methodologies

Operations

Develop and implement business systems projects that meet agreed business outcomes

Communicate effectively with various partners, setting clear expectations and explaining complex concepts to non-technical audiencesProvide expert guidance with hands‑on support to solve complex and challenging business problems to the satisfaction of key partners

Plan, develop, and on‑time delivery of effective business solutions

Coordinate and perform in‑depth testing of modified and new systems, including end‑user reviews and other post‑implementation support

Support the organization through the design and implementation of robust training

Maintain, administer,



and upgrade existing database and application systems as required

Ensure the proper management and integrity of ALMAG data

Identify and compile metrics from business systems to support data analysis and business improvements

Apply methods and techniques to ensure the security of applications and data

Responsible for using problem‑solving and analytical skills to support the design, implementation, and maintenance of solutions that support the extrusion production system

Support the business through the ongoing implementation, configuration, support, and testing of an alternate ERP system

Design, deploy, and maintain dashboards ad‑hoc reports, perform data analytics, and build data visualization solutions to meet business needs using Power BI or Crystal reporting

Develop and maintain dashboards, reports, and data visualizations

Create standard operating procedures, support new user onboarding, and train users on system functionality

Perform additional duties as required to support the business

Governance

Collaborate with Business and IT to resolve issues and ensure solutions are viable, consistent and secure.

Simultaneously manage multiple complex projects to ensure they meet stated requirements.

Deliver concise communication of Business Systems plans, goals, project direction and achievements.

Support the development of documentation as appropriate.

Support data stewardship, security, quality, compliance and best practice.

MINIMUM QUALIFICATIONS
Education/Experience

Diploma or Degree in a technical discipline, Computer Science, Information systems management, or related field and/or equivalent combination of education

Minimum 5 years’ experience in a Technical Business Systems Analyst role or similar

Minimum 5 years’ relevant experience, end user training, data analysis or data management, process improvement

Minimum 5 years’ experience with MS Power Platform (PowerBi, PowerApps, Power Automate)

Minimum 5 years’ experience with Database management

Systems literate, preference given to those with manufacturing, CRM, ERP system, BI & Analytics applications experience and knowledge

Experience with software development methodologies - SDLC, agile, waterfall





Experience maintaining master data & report management

Ability to work with cross‑functional teams

Proven decision‑making skills that engage and add value

Project management training and or certifications such as Agile SCRUM

Change management certification would be an asset

Technical Skills/Competence

Minimum 5 years’ IT experience with a focus on driving productivity through business systems and information architecture preferably within a manufacturing environment

Working knowledge of data modelling and data visualisation BIAI tools Advanced knowledge of building and maintaining reports and dashboards in Microsoft Power BI including DAX Queries or other reporting platforms

Minimum 3 years’ experience working with the support, implementation and configuration of Microsoft Dynamics 365 Business Central or other ERP system

Strong work experience writing/editing complex Crystal Reports and SQL queries

Experience with SQL Server: SSRS, SSIS, SSAS

Working technical knowledge of SQL languages

Strong analytical, problem solving, organizational and time management skills

Ability to learn and train on variety of software

Previous experience developing and implementing successful business systems

Excellent communication, customer service and presentation skills

Ability to work independently and as part of the team

Excellent understanding of IT service management

Excellent understanding of change and release management procedures

Ability to analyse, evaluate and define needs as well as to create and execute implementation test plans is essential

Knowledge of budget management and vendor management is an asset

Experience with API’s and web services is an asset

Perform cleanse, map and transform data to support integration initiatives

We offer a comprehensive and competitive benefits package that goes beyond base pay, supporting your health, growth, and long‑term success:

Profit Sharing

Health & Dental

Health Care Spending Account

Education Assistance Program

Employee Assistance Program (EAP)

Company Events

Floater Days

Paid Holidays

Shift Premiums

Annual safety footwear reimbursement program

The expected salary range for this position is $90,000 - $110,000 annually. Actual compensation will be determined based on factors including, but not limited to, skills, experience, qualifications, equity, and business needs.

Our organization may use Artificial Intelligence (AI) enabled tools to support our recruitment initiatives.

#J-18808-Ljbffr

📌 Sr. Business Systems & Database Analyst (Ontario)
🏢 ALMAG Aluminum
📍 Ontario