Sr. Business Systems & Database Analyst

ALMAG Aluminum Corp.; Brampton; Hybrid; CAD 90,000 - 110,000; Full time

Benefits offered by this job

Profit Sharing

Health & Dental

Education Assistance Program

Employee Assistance Program (EAP)

Company Events

Floater Days

Paid Holidays

Shift Premiums

Annual safety footwear reimbursement

Job summary

ALMAG Aluminum Corp. is seeking a Sr. Business Systems & Database Analyst to help plan, implement and optimize enterprise business systems across the organization.

You will work with the IT team and business partners to design solutions that enhance productivity and data quality within the extrusion production environment. Responsibilities include delivering BI dashboards, data analytics, ERP and CRM integrations, and leading cross‑functional initiatives using Power BI, Dynamics 365 BC, and

Qualifications

• Diploma or Degree in a technical discipline or related field.
• Minimum 5 years’ experience as Technical Business Systems Analyst.
• Minimum 5 years’ experience with MS Power Platform (PowerBi, PowerApps, Power Automate).
• Minimum 5 years’ experience with database management.
• Experience with SDLC, Agile or Waterfall methodologies.
• Experience with CRM/ERP, BI & Analytics applications.
• Strong cross‑functional collaboration and communication skills.

Responsibilities

• Plan and implement enterprise business systems projects to meet business outcomes.
• Provide guidance and hands-on support to solve complex business problems for partners.
• Coordinate testing, end-user reviews and post‑implementation support.
• Develop and deliver training and maintain documentation.

Skills

Power BI

SQL

Data modelling

Analytical thinking

Cross-functional collaboration

SDLC

Change management

Education

Technical degree or diploma

5+ years in Technical Business Systems Analyst

MS Power Platform experience

Tools

Microsoft Dynamics 365 Business Central

Crystal Reports

SQL Server SSIS/SSAS

Power Automate

Power Apps

Job description

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 new 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 BI\AI 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.