Procase Consulting is looking for an experienced Oracle Systems Analyst to support one of our long-term enterprise application clients.
This role is ideal for someone with a strong Oracle development background who has moved into systems analysis, business analysis, or solution design. The successful candidate must be comfortable working directly with business users, product owners, QA analysts, and project managers to understand business needs, document requirements, analyze system impacts, and support delivery of changes to an Oracle-based enterprise application. The role also requires close coordination with developers to review technical findings, clarify implementation details, and support issue resolution.
This is not a purely technical development role. Strong communication, relationship-building, and requirements-gathering skills are essential. The person in this role will work closely with client business teams and must be able to explain technical concepts clearly, ask good questions, document decisions, and help move work forward.
Key Responsibilities
- Conduct analysis sessions with business users, product owners, QA analysts, and project managers to understand business needs and confirm expected system behaviour.
- Document business requirements, functional requirements, system analysis findings, and technical impact analysis for system changes.
- Review existing Oracle-based application logic, data structures, SQL, PL/SQL, screens, reports, jobs, and integrations to understand current system behaviour.
- Review and triage incoming Jira tickets by analyzing reported issues, identifying likely impact areas, documenting findings, and helping route work to the appropriate developer.
- Work with developers to review technical findings, production issues, system impacts, implementation options, and required changes.
- Support QA by helping define acceptance criteria, test scenarios, and expected results.
- Investigate production issues, analyze root causes, and help recommend practical solutions.
- Participate in client meetings and represent Procase professionally.
- Help bridge the gap between business users and the technical development team.
Required Skills and Experience
- 7+ years of experience conducting analysis sessions with business users.
- 7+ years of experience creating requirements documents, functional specifications, system analysis specifications, or technical impact analysis documents.
- 10+ years of experience working with Oracle SQL and PL/SQL.
- Strong Oracle development background.
- Strong understanding of relational databases, stored procedures, packages, triggers, views, and data-driven application logic.
- Experience analyzing complex business systems with multiple screens, reports, jobs, integrations, and workflows.
- Strong written and verbal communication skills.
- Strong interpersonal skills and ability to work directly with client teams.
- Strong attention to detail and ability to follow issues through from initial review to resolution.
- Ability to understand both business process and technical implementation.
- Ability to work independently, ask the right questions, and document findings clearly.
Preferred Skills
- Oracle APEX experience.
- Experience with pension administration systems, benefits systems, financial systems, or other complex enterprise applications.
- Experience working with Jira or similar issue-tracking tools.
- Experience writing Jira tickets, acceptance criteria, test scenarios, or QA support notes.
- Experience working in Agile or hybrid delivery environments.
Candidate Profile
The ideal candidate is Oracle-centric and technically strong, but also comfortable working closely with business users. We are looking for someone who can understand how an Oracle application works under the hood while also being able to capture requirements, explain options, document findings, and build trust with client teams.
The right person does not need to be a full-time hands-on developer, but they must be able to read and understand Oracle SQL and PL/SQL well enough to analyze system logic, identify likely impact areas, and communicate clearly with developers.
This role also requires strong attention to detail. Part of the work involves reviewing incoming tickets, separating business issues from technical issues, identifying whether the issue relates to screen behaviour, back-end logic, reports, jobs, data, or configuration, and helping route the work to the right person for resolution.
Role Details
- Position: Oracle Systems Analyst
- Work arrangement: Primarily remote, but candidates must be located in the Greater Toronto Area and able to attend in-person meetings at the client office in Oakville as required for training, meetings, and project needs.
- Start timing: Immediate start preferred
- Term: Long-term opportunity
- Client environment: Oracle-based enterprise application, including Oracle APEX
About Procase Consulting
Procase Consulting provides systems analysis, business analysis, project management, software development, QA, and long-term system support for enterprise clients. We specialize in complex business systems where strong technical understanding and close client collaboration are both required.
Job Types: Full-time, Permanent
Pay: $90,000.00-$100,000.00 per year
Benefits:
- Casual dress
- Dental care
- Extended health care
- Flexible schedule
- Paid time off
- Profit sharing
- Vision care
- Work from home
Application question(s):
- Have you personally written functional specifications, system analysis documents, technical impact analysis documents, or similar system documentation?
- Briefly describe one example where you analyzed a production issue and determined whether the issue was related to front-end logic, back-end logic, reports, jobs, data, or configuration.
Education:
- Bachelor's Degree (preferred)
Experience:
- Oracle SQL / PL/SQL: 10 years (required)
- Systems/business analysis or requirements documentation: 7 years (required)
Language:
Location:
- Greater Toronto Area, ON (required)
Work Location: Remote
