Sr. Business Systems & Database Analyst

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.

Requirements

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

Benefits

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.