IT Business Analyst (Reporting Development)

Job Description

The IT Business Analyst’s role is to support the Business Applications project leads in the planning, design, develop, and launch efficient business systems in support of core organizational functions and business processes. This includes designing, developing, and writing reports, gathering and analyzing data in support of business cases, proposed projects, and systems requirements. The IT Business Analyst is also responsible for generating and compiling reports based on the findings, complete with probable causes and possible solutions to systems issues. This individual will apply proven communication, analytical, and problem-solving skills to help maximize the benefit of IT system investments.

Responsibilities Health and Safety:

- Having the authority and responsibility to maintain a safe and efficient working environment

- Following Company health and safety standards and reporting any unsafe acts or conditions

Strategy And Planning

- Meet with decision makers, system owners, and end users to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues

- Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems

- Identify and establish scope and parameters of systems analysis in order to define outcome criteria and measure-taking actions

Acquisition And Deployment

- Collaborate in the planning, design, development, and deployment of new applications, and enhancements to existing applications

- Conduct research on software and hardware products to justify recommendations and to support purchasing efforts

- Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions

Operations Management

- Prepare and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in operating systems across the organization, proposing solutions that are feasible and scalable

- Develop and configure reports to improve financial reporting and analysis

- BI report creation and maintenance, including managing and maintaining Oracle BI, Microsoft PowerBi, and other reporting tools

- Ensure compatibility and interoperability of in-house computing systems

- Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems, and other post-implementation support

- Provide orientation and training to end-users for all modified and new systems

- Learn, design and build reporting using proprietary tools in other third-party solutions

- Review query performance and optimize where required

- Assess and amend any errors in a timely fashion

- Provide status reports where required

- Follow proper change management processes when performing any changes to solutions

- Work with and assist project teams on implementation or upgrades of new and existing business solutions

Qualifications

Education Required: College diploma or university degree in the field of business administration, computer science, or management information systems and 3 years related work experience.

Work Experience Required: 3+ years’ experience in deployment and support of software systems implementations and global environment (cloud, hosted and on-premise platforms)

Knowledge Required

- Experience with Microsoft PowerBi, Oracle BI Publisher, and OTBI report and data model development

- Experience in SQL databases, programming, writing, and analyzing advanced SQL queries and procedures

- Oracle Fusion Knowledge (technical, ERP, HCM) including basic functional knowledge of related modules (GL, AR, AP, PPM, SCM, Core HR, Talent, Recruitment, Absence, OTL)

- Knowledge and hands on experience in applications such as Oracle Fusion, Hyperion Financial Management, Oracle EPM, InEight Cloud, SharePoint, Intelex Safety, E-Front LMS, Big Data applications is beneficial to this role

- Proven experience in overseeing the design, development, and implementation of software and hardware solutions, systems, or products

- Extensive practical knowledge in importing data for use in report software, spreadsheets, graphs and flow charts

- Proven experience in the operation and analysis of database hardware, software, and standards, as well as data retrieval methodologies

- Excellent understanding of the organization’s goals and objectives.

- Flexible and adaptable in learning new technologies and solutions

- Demonstrated project management skills; Business Analysis and Project Management Fundamentals training or PMP designation an asset

- Fluent English language skills.

Personal Attributes

- Excellent analytical, mathematical, and creative problem-solving skills.

- Excellent written and oral communication skills.

- Excellent listening and interpersonal skills.

- Logical and efficient. Keen attention to detail.

- Ability to conduct research into systems issues and products as required.

- Ability to communicate ideas in both technical and user-friendly language.

- Highly self-motivated and directed.

- Ability to effectively prioritize and execute tasks in a high-pressure environment.

- Strong customer service orientation.

- Experience working in a team-oriented, collaborative environment.

Additional Information

- Global travel where required for the purpose of meeting with stakeholders, or off-site personnel/management

Base Salary

CAD 85,000 to CAD 120,000 annually