Talent.com

Sql analyst Jobs in Toronto, ON

Create a job alert for this search

Sql analyst • toronto on

Last updated: 1 day ago

PL/SQL Developer

CMiCToronto, ON, CA
Full-time
Quick Apply

Headquartered in Toronto, CMiC is a software company focused on the Construction industry.We have built a comprehensive platform for construction companies to manage their most important workflows.... Show more

Quality Engineer (SQL, Cloud Azure)

Confiar ServicesToronto, ON, Canada
Full-time
Quick Apply

Quality Engineer (SQL, Cloud Azure)</div> <div>Toronto, Canada</div> <div> </div> <div> </div> <div> <table border="0" cellpadding=&qu... Show more

Analyst

We Are SocialToronto, ON, CA
Full-time
Quick Apply

We Are Social is looking for a.You will leverage analytics to inform strategies, identify emerging opportunities, and guide clients in making data-backed decisions.You should be curious, organized,... Show more

Data Analyst

Randstad CanadaToronto, Ontario, CA
Full-time +1
Quick Apply

Randstad is looking for a Data Analyst to work closely with Product Owners and development teams, to promote the growth and continuous improvement of digital channels through in-depth analytics.If ... Show more

Database analyst

Sodales Solutions IncToronto, ON, Canada
Permanent

Collect data to identify areas for improvement within an organization's IT infrastructure.Develop and maintain computer databases.Enact measures to make sure unauthorized users cannot access the da... Show more

Business Analyst

Royal Bank of Canada>TORONTO, Canada
Full-time

Global Functions Technology (GFT) is part of RBC’s Technology and Operations division.GFT’s impact is far-reaching as we collaborate with partners from across the company to deliver innovative and ... Show more

Software Engineer (Python/PL-SQL)

ScotiabankToronto, ON, CA
Full-time

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engi... Show more

Strategy Analyst

LightspeedToronto
Full-time

Hi there! Thanks for stopping by 👋.Are you actively looking for a new opportunity? Or just checking the market? Well… you might just be in the right place!.This role will support enterprise and bu... Show more

Business Analyst

The Home Depot CanadaToronto, ON, CA
CA$65,000.00 yearly
Full-time

At The Home Depot Canada, we want you to feel valued and supported.The pay range you see represents base salary only.In addition, your total rewards may include: semi-annual bonuses tied to busines... Show more

Sr. Analyst

MRMToronto, Ontario, Canada
Full-time

MRM Worldwide is committed to being the most relevant, effective, indispensable marketing agency in the digital world.We employ the most innovative talent in the industry to meet each client’s uniq... Show more

Financial Analyst

Sweat and TonicToronto, Ontario, Canada
CA$55,000.00 yearly
Full-time

Sweat, recover, connect: .S&T) brings the best of boutique fitness and wellness under one roof.S&T is Toronto's leading fitness and wellness hub, offering the widest collection of grou... Show more

Senior SQL Developer

Intact Financial CorporationToronto, Ontario, CAN
CA$101,800.00 yearly
Full-time

Pay at Intact is about much more than just salary.Multiple benefits offered to support.Wellness account and much more.Share plan & other savings: up to.Employee Share Purchase Plan (ESPP) – with In... Show more

Senior Data Analyst (SQL, Power BI, Looker)

NearSourceToronto, ON, Canada
Remote
Full-time
Quick Apply

Job Title: Senior Data Analyst (SQL, Power BI, Looker).This role involves working with cross-functional teams to analyze complex datasets, deliver actionable insights, and support strategic busines... Show more

Security Analyst

MercorToronto, Ontario, Canada
Remote
Part-time
Quick Apply

Headquartered in San Francisco, our investors include.Create realistic scenarios based on cybersecurity workflows such as incident response runbooks, threat hunting queries, and penetration testing... Show more

Data Analyst

GoBoltToronto, Ontario, Canada, M5V 3C3
CA$70,000.00 yearly
Full-time
Quick Apply

At GoBolt, we provide a technology-driven, customer-centric and sustainable approach to ecommerce and last-mile logistics for businesses of all sizes – from local brands to large national retailers... Show more

PL/SQL Developer

PL/SQL Developer

CMiCToronto, ON, CA
8 days ago
Job type
  • Full-time
  • Quick Apply
Job description

About CMiC

Headquartered in Toronto, CMiC is a software company focused on the Construction industry. We have built a comprehensive platform for construction companies to manage their most important workflows. Our customers have their choice of a SaaS or Private Hosted platform that includes industry focused modules to manage everything from Financials and Payroll to Project Management and Budgeting. Our market share is very strong in North America and rapidly expanding internationally in regions like Europe, Southeast Asia and the Middle East.

Job Overview

We are seeking a Back-End Developer with deep expertise in Oracle PL/SQL and experience in Java-based REST API development. This role will focus primarily on database development with additional responsibilities in API development and integration. Strong analytical thinking and problem-solving skills are essential to succeed in this role.

Important Information:

  • The overall hiring salary range for this position from Intermediate to Senior level, is $70,000 to $115,000 annually
  • This position is for an existing vacancy
  • We do not use AI to screen, assess, or select applicants

Duties & Responsibilities

Oracle / PL-SQL

  • Advanced PL/SQL development (packages, procedures, functions, triggers)
  • Strong SQL skills (complex joins, subqueries, performance tuning)
  • Query optimization and execution plan analysis
  • Data modeling (normalized/denormalized schemas)
  • Bulk processing and efficient data handling techniques
  • Use of Oracle development tools (PL-SQL Developer, TOAD, SQL*Plus)
  • Error handling, exception management, and logging
  • Working with large datasets and high-volume transactional systems

API Development

  • Object oriented programming
  • Java programming
  • RESTful API design and implementation
  • Java backend development (Java 8+ preferred)
  • Spring / Spring Boot framework (Nice to have)
  • API documentation (Swagger/OpenAPI)
  • JSON/XML data handling
  • Secure API development (OAuth2, JWT, basic authentication)

Nice to Have

  • IntelliJ experience
  • Oracle JDeveloper experience
  • CI/CD pipelines (Jenkins, GitHub Actions)
  • Database design principles and data architecture
  • Transaction management and concurrency control
  • API lifecycle management and versioning strategies
  • Software development lifecycle (SDLC)
  • Secure coding practices
  • Data integrity and validation techniques
  • Version control systems (Git)

Requirements

  • 3–7+ years in backend development
  • Significant hands-on experience with Oracle database development
  • Proven experience developing and maintaining PL/SQL code in enterprise environments
  • Experience building and consuming REST APIs in Java
  • Exposure to system integration across multiple applications
  • Experience in performance tuning and troubleshooting production issues
  • Working in Agile/Scrum environments

Analytical Skills

  • Strong problem-solving and root-cause analysis abilities
  • Ability to analyze complex data flows and system dependencies
  • Debugging and troubleshooting complex database and API issues
  • Translating business requirements into efficient technical solutions
  • Identifying performance bottlenecks and optimizing solutions
  • Data-driven decision-making mindset

Attitudes and Aptitudes

  • Detail-oriented, especially with data accuracy and integrity
  • Ownership mindset with accountability for deliverables
  • Continuous learning (especially evolving database and API technologies)
  • Proactive in identifying issues and proposing improvements
  • Collaborative team player with good communication skills
  • Adaptable to changing priorities and requirements
  • Quality-focused with emphasis on maintainability and scalability
  • Logical reasoning and structured thinking
  • Strong attention to detail (critical for database work)
  • Ability to work with abstract data models and complex logic
  • Capability to manage both deep backend processing and API layers

Benefits

  • Competitive benefits Package (including Health & Dental benefits)
  • Paid vacation and personal days
  • Townhall meetings where all employees are encouraged to participate in open discussions
  • Located on York University’s campus, easily accessible by transit (TTC, GO, etc.), walking distance to shopping and restaurants
  • Outdoor lunch space, including picnic tables
  • An active Social Events Committee (past events include annual seasonal parties, pool and bowling tournaments, karaoke nights, Game nights, BBQ’s, and more)
  • Health and Wellness focus including virtual yoga classes and wellness webinars
  • RRSP Matching Program after 2 years of employment
  • Experience in a rapidly growing, socially responsible corporation

CMiC is an Equal Opportunity Employer. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, CMiC will provide accommodation to applicants with disabilities throughout the recruitment, selection and/or assessment process. If selected to participate in the recruitment, selection and/or assessment process, please inform Human Resources staff of the nature of any accommodation(s) that you may require.