Data Reporting Analyst

KTek Resourcing

Brampton

On-site

CAD 65,000 - 95,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

KTek Resourcing is seeking a data analyst to assess, modify, and develop ERP reports for Oracle ERP Cloud. You will design data models, support UAT and hypercare, and ensure reports meet governance standards.

Strong skills in BI Publisher, OTBI, SQL, and data modelling are required, with a collaborative, detail-oriented, and proactive mindset to resolve data issues across Finance and IT teams.

Qualifications

  • Strong knowledge of BI Publisher (BIP) and OTBI reporting.
  • Experience with Oracle ERP Cloud Fusion reporting and data structures.
  • Experience with SQL and data modelling.
  • Excellent communication and collaboration skills.
  • Self-starter with strong analytical and problem-solving abilities.

Responsibilities

  • Assess, modify, and develop ERP reports to meet requirements.
  • Design data models and technical specs for reports.
  • Develop and execute test plans and scripts; track defects to closure.
  • Support UAT and hypercare; address feedback and report adjustments.
  • Assist deployment of reports to production following change management.
  • Create and maintain documentation including designs and user guides.
  • Collaborate with Finance, Oracle, and technical teams to resolve data issues.

Skills

Communication
SQL
Data modelling
Analytical thinking
Problem solving
Teamwork
Detail oriented
Independent
Quick learner

Tools

BI Publisher
OTBI
Oracle ERP Cloud Fusion
Office 365
ServiceNow
Oracle Cloud Financials
Excel

Job description

The data analyst is responsible for assessing, modifying, and developing ERP reports, ensuring they are accurately designed, tested, and deployed, and that business users are supported through UAT and hypercare.

Responsibilities include:

  • Assess existing ERP reports to determine reporting requirements, usage, gaps, and recommendations
  • Following data governance standards, modify existing reports using BI Publisher (BIP) and OTBI, applying strong working knowledge of both tools to meet business needs
  • Following data governance standards, design data models and technical specifications for reports, ensuring accuracy, performance, and alignment to Oracle best practices
  • Develop and execute test plans and scripts for reports, and track and resolve defects through to closure
  • Support business users during user acceptance testing (UAT), addressing questions, feedback, and required report adjustments
  • Support the deployment of reports to production following change management and release processes
  • Provide hypercare support after go-live, resolving reporting issues promptly to ensure stabilization
  • Create and maintain documentation, including technical designs, test evidence, and report user guides
  • Collaborate with Finance, Oracle, and technical teams to clarify requirements and resolve data issues

Requirements and skills:

  • Strong working knowledge of BI Publisher (BIP) and OTBI reporting, including report design, data models, and subject areas
  • Experience with Oracle ERP Cloud Fusion reporting and data structures
  • Experience with SQL and data modelling
  • Good communication skills are necessary
  • Self-starter, motivated and results oriented collaborator
  • Detail oriented, strong analytical and problem-solving skills and have an ability to find creative solutions
  • Strong teamwork skills, but ability to work independently
  • Familiar with Office 365 (intermediate skills in Excel preferred)
  • Quick learner
  • Preferably working knowledge of ServiceNow and Oracle Cloud Financials
  • Preferably Oracle reporting certification, but not necessary
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

JAE Consulting Inc. • Toronto

On-site
CAD 70,000 - 90,000
IT Business Analyst (Tech)
IT Business Analyst (Tech)

Redpath Mining Inc. • Vaughan

On-site
CAD 70,000 - 90,000
IT Business Analyst (Tech)
IT Business Analyst (Tech)

Redpath Mining Inc. • North Bay

On-site
CAD 70,000 - 90,000
Oracle Data Reporting Lead
Oracle Data Reporting Lead

Accenture PLC • Vancouver

On-site
CAD 99,450 - 209,900
IT Business Analyst (Finance)
IT Business Analyst (Finance)

Careermine • Vaughan

On-site
CAD 80,000 - 110,000
Oracle Data Reporting Lead
Oracle Data Reporting Lead

Accenture PLC • Toronto

On-site
CAD 99,450 - 209,900
Oracle Data Reporting Lead
Oracle Data Reporting Lead

Accenture PLC • Ottawa

On-site
CAD 99,450 - 209,900
IT Business Analyst (SCM)
IT Business Analyst (SCM)

Redpath Mining Inc. • North Bay

On-site
CAD 70,000 - 90,000
IT Business Analyst (SCM)
IT Business Analyst (SCM)

Redpath Mining Inc. • Vaughan

On-site
CAD 200,000 - 260,000
Oracle Sales Cloud Analyst
Oracle Sales Cloud Analyst

United Software Group Inc • Halifax

On-site
CAD 75,000 - 100,000