18 Sql Developer jobs in Canada

Job Overview:

We are seeking a detail-oriented and experienced SQL Server & SSIS Developer to join our data engineering team. The ideal candidate will be responsible for designing, developing, and maintaining robust ETL processes using Microsoft SQL Server and SQL Server Integration Services (SSIS). This role involves working closely with business analysts and stakeholders to ensure data accuracy, performance optimization, and seamless data integration across systems.

Client: Fintech

Location: 3 days a week onsite Toronto

Duration: 6 months

Key Responsibilities:

• Develop and maintain complex SSIS packages for data extraction, transformation, and loading (ETL)
• Design and optimize SQL queries, stored procedures, and database structures
• Monitor and troubleshoot SQL Server performance issues and SSIS package failures
• Collaborate with cross-functional teams to gather requirements and deliver scalable data solutions
• Ensure data integrity, security, and compliance with organizational standards
• Document technical processes and provide support for production deployments

Qualifications:

• Proven experience with Microsoft SQL Server (2016 or later)
• Strong proficiency in SSIS and ETL development
• Solid understanding of relational database design and normalization
• Experience with performance tuning and query optimization
• Familiarity with version control systems and deployment pipelines
• Excellent problem-solving and communication skills

Job Description

Job Description

Are you looking to work for a growing software company? How about a socially responsible company that cares about its employee? If so, keep reading! CMiC has been awarded one of Canada’s Best Managed Companies and is continuing to grow and strive for the best.

Whether you are a seasoned PL/SQL Developer or a Junior Programmer willing to learn, this may be the role for you! CMiC offers learning opportunities through our learning portal which gives employees access to thousands of courses!

Apply today to get the opportunity to join the CMiC Team.

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

The Application Developer (PL/SQL Developer) is responsible for the development of CMiC software modules using a variety of development tools including PL/SQL and Java. An essential aspect of this role involves designing, developing, troubleshooting, debugging and testing of user interface, business logic components, and/or reports. The Application Developer works with team members and clients to design and develop business applications and/or reports that support client needs. This is a Hybrid full time, permanent role.

Duties & Responsibilities

• Write high quality and well-documented code according to accepted standards based on user requirements using PL/SQL, Java, Oracle JDeveloper.
• Test and debug program units in conjunction with other units and/or systems and integrate with other program modules and systems.
• Participate in project and team meetings interacting and collaborating with team members and other departments as appropriate.
• Evaluate alternative design approaches to meet business and user requirements.
• Provide analysis of problems reported by customers.
• Other related duties as assigned.

Requirements

• Minimum 4 years professional programming experience using PL/SQL.
• Exposure to Java and Oracle JDeveloper is a must.
• Experience with coding and working with RESTful APIs is preferred
• A self-starter who takes initiatives but seeks the assistance of others when necessary.
• Excellent problem solving and customer service abilities.
• Excellent verbal and written communication skills.
• University Degree, preferably in Computer Science

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.

**The Big Data and SQL Developer is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to lead applications systems analysis and programming activities.**
**Responsibilities:**
**This role balances hands-on technical work with strategic influence, mentorship, and vital stakeholder engagement:**
**Technical Design & Implementation (60-70%):**
**Architecture & Design:** **Lead the design and implementation of highly scalable, robust, and performant Big Data solutions, including data warehouses, streaming platforms, and analytical systems.**
**Hands-on Development:** **Write high-quality, production-ready code for complex data pipelines, processing frameworks, and analytical tools using languages like Scala, Python, or Java.**
**Performance Optimization:** **Drive performance tuning, troubleshooting, and optimization of Big Data applications and infrastructure.**
**Technical Problem Solving:** **Act as a go-to expert for resolving complex technical challenges across the Big Data ecosystem.**
**Innovation:** **Research, evaluate, and integrate new Big Data technologies and tools to enhance existing platforms and capabilities.**
**Best Practices:** **Champion and enforce engineering best practices, including code quality, testing, CI/CD, and documentation.**
**Technical Leadership & Mentorship (15-20%):**
**Technical Guidance:** **Provide technical leadership and guidance to multiple engineering teams, ensuring alignment with architectural principles and strategic goals.**
**Mentorship:** **Mentor senior and junior engineers, fostering their technical growth, problem-solving skills, and adherence to best practices.**
**Code Review & Quality Assurance:** **Lead comprehensive code reviews, ensuring high standards of code quality, efficiency, and maintainability.**
**Strategic Input:** **Contribute significantly to the Big Data strategy and roadmap, influencing technical decisions and long-term planning.**
**Knowledge Sharing:** **Drive initiatives for knowledge sharing, technical documentation, and community building within the Big Data engineering group.**
**Recruitment Support:** **Participate in interviewing and evaluating senior technical candidates.**
**Stakeholder Management & Client Engagement:**
**Client & Business Partner Liaison:** **Act as a key technical liaison between the Big Data engineering team and internal business units, product managers, and clients.**
**Requirements Gathering:** **Proactively engage with stakeholders to understand business requirements, pain points, and opportunities, translating them into clear, actionable technical specifications and data solutions.**
**Technical Consultation:** **Provide expert technical consultation and guidance to clients and business partners on Big Data capabilities, limitations, and potential solutions.**
**Query Resolution:** **Assist clients and internal stakeholders with complex data queries, troubleshooting data discrepancies, and providing insights derived from Big Data platforms.**
**Communication:** **Effectively communicate complex technical concepts, project progress, risks, and solutions to non-technical audiences, ensuring transparency and alignment.**
**Cross-Functional Collaboration:** **Collaborate seamlessly with other teams (e.g., architecture, data sourcing) to ensure end-to-end delivery and support of data-driven initiatives.**
**Leadership, Communication & Interpersonal Skills:**
**Exceptional problem-solving and analytical skills, with the ability to tackle highly complex technical and business challenges.**
**Strong architectural thinking and the ability to design solutions that are scalable, maintainable, and resilient.**
**Excellent verbal and written communication skills, with a proven ability to tailor technical explanations to diverse audiences, from engineers to senior business stakeholders and external clients.**
**Demonstrated ability to build consensus, manage expectations, and influence outcomes with various stakeholders.**
**Experience in mentoring and coaching other engineers.**
**Proactive, self-motivated, and able to work effectively in a fast-paced, agile environment, often juggling multiple priorities.**
**Education:**
**Bachelor's degree/University degree or equivalent experience**
**Master's degree preferred**
**Experience:**
**6+ years** **of progressive experience in software engineering, specifically focused on designing, building, and optimizing large-scale Big Data systems.**
**Proven track record as a lead or principal engineer on significant data initiatives, demonstrating ability to drive technical projects from conception to deployment.**
**Significant experience in client-facing or business partner-facing roles, with a proven ability to manage expectations, resolve issues, and build strong relationships.**
**Experience in the financial services domain - Liquidity Management, Liquidity Stress Modelling, should be well verse with Markets terminologies. Also, experience with large data volumes, real-time processing, and stringent data quality/security requirements.**
**Deep Technical Proficiency:**
**Core Big Data Frameworks:** **Expert-level proficiency with Apache Spark (Spark SQL, Spark Streaming, PySpark/Scala Spark), Hadoop ecosystem (HDFS, YARN).**
**Programming Languages:** **Expert in Scala, Python, or Java, with experience in developing robust, high-performance data processing applications.**
**Data Warehousing/Lakes:** **Deep understanding and practical experience with data warehouse models, and relevant technologies (e.g., Delta Lake, Iceberg, Parquet).**
**Databases:** **Strong proficiency in SQL; experience with NoSQL databases (e.g., Cassandra, MongoDB) is a plus.**
**DevOps & MLOps:** **Experience with CI/CD pipelines (e.g., Jenkins, GitLab CI), infrastructure as code (e.g., Terraform), containerization (Docker, Kubernetes/OpenShift), and monitoring tools. Familiarity with MLOps principles for data science workflows.** **Data Governance & Security:** **Solid understanding of data governance, data quality, data lineage, and data security principles in a Big Data environment.**
---
**Job Family Group:**
Technology
---
**Job Family:**
Applications Development
---
**Time Type:**
Full time
---
**Primary Location Full Time Salary Range:**
$120,800.00 - $170,800.00
---
**Most Relevant Skills**
Please see the requirements listed above.
---
**Other Relevant Skills**
For complementary skills, please see above and/or contact the recruiter.
---
_Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law._
_If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review_ _Accessibility at Citi ( _._
_View Citi's_ _EEO Policy Statement ( _and the_ _Know Your Rights ( _poster._
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.

**As an AVP, SQL & ETL Developer, you will play a critical role in the design, development, optimization, and maintenance of robust and scalable data solutions. This position requires deep expertise in SQL, database systems, and Extract, Transform, Load (ETL) processes, coupled with an understanding of data warehousing principles.** **Crucially, you must possess strong domain knowledge in banking, specifically related to liquidity management, stress modeling, and markets data, to effectively translate complex business requirements into data solutions.** **Based in Canada, this role will contribute to key data initiatives, ensuring data quality, availability, and integrity to support critical business operations and analytical needs. You will be expected to lead specific projects, mentor junior developers, and engage with stakeholders to deliver high-quality data solutions within the financial domain.**
**Key Responsibilities**
**SQL Development & Optimization:**
**Design, develop, and optimize complex SQL queries, stored procedures, functions, and views for data extraction, transformation, and loading.**
**Analyze and tune database performance (e.g., query optimization, indexing strategies) to ensure efficient data processing and retrieval.**
**Implement data integrity checks and validation rules within SQL scripts.**
**Develop and maintain database schemas and data models in collaboration with data architects.**
**ETL Solution Design & Development:**
**Lead the design, development, and implementation of robust, scalable, and automated ETL processes using various ETL tools (e.g., Informatica PowerCenter, SSIS, DataStage, Talend, or cloud-native ETL services).**
**Develop and maintain data pipelines for ingesting data from diverse sources (e.g., relational databases, flat files, APIs, cloud storage) into target data warehouses or data marts.**
**Implement error handling, logging, and monitoring mechanisms within ETL workflows.**
**Ensure data quality and consistency throughout the ETL process.**
**Data Warehousing & Data Management:**
**Apply strong understanding of data warehousing concepts (e.g., Kimball, Inmon methodologies), dimensional modeling, and OLAP principles.**
**Work closely with data architects and business analysts to translate business requirements into technical data solutions.**
**Manage and maintain data dictionaries and data lineage documentation.**
**Project Leadership & Mentorship:**
**Lead small to medium-sized data development projects from inception to completion, including planning, execution, and deployment.**
**Provide technical guidance and mentorship to junior developers on SQL, ETL best practices, and troubleshooting.**
**Participate in code reviews to ensure adherence to development standards and quality.**
**Troubleshooting & Support:**
**Diagnose and resolve complex data-related issues, including data discrepancies, performance bottlenecks, and ETL job failures.**
**Provide production support for data solutions, ensuring high availability and reliability.**
**Collaboration & Stakeholder Engagement:**
**Collaborate effectively with cross-functional teams including business users, data analysts, data scientists, architects, and IT operations.**
**Translate business requirements into technical specifications for data solutions.**
**Communicate project status, challenges, and solutions clearly to technical and non-technical stakeholders**
**Education:**
**Bachelor's degree/University degree or equivalent experience**
**This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.**
**5+ years of progressive experience** **in SQL development and ETL design/implementation.**
**Must have significant experience in the banking or financial services domain.**
**Demonstrated strong domain knowledge in one or more of the following areas: Liquidity Management, Stress Modeling, and Markets Data (e.g., trading data, market risk data).**
**Proven experience in leading data projects and/or mentoring junior team members.**
**Experience working with large datasets and complex enterprise data architectures.**
**Technical Proficiency:**
**Expert-level proficiency in SQL** **(e.g., T-SQL, PL/SQL, PostgreSQL, MySQL) with strong experience in query optimization, stored procedures, functions, and triggers.**
**Extensive experience with at least one major ETL tool** **such as Informatica PowerCenter, Microsoft SSIS, IBM DataStage, Talend, or equivalent cloud-native ETL services (e.g., AWS Glue, Azure Data Factory, GCP Dataflow/Cloud Data Fusion).**
**Strong understanding of** **data warehousing concepts** **and** **dimensional modeling** **.**
**Experience with BigData technologies is good to have**
**Experience with database management systems (e.g., SQL Server, Oracle, DB2, PostgreSQL).**
**Familiarity with scripting languages (e.g., Python, PowerShell) for automation is a strong plus.**
**Knowledge of version control systems (e.g., Git) and SDLC methodologies (Agile/Scrum).**
**Experience with job scheduling tools (e.g., Autosys, Control-M) is an asset.**
**Familiarity with cloud platforms (AWS, Azure, GCP) and their data services is a plus.**
**Skills & Competencies:**
**Strong analytical and problem-solving skills, with meticulous attention to detail.**
**Excellent communication and interpersonal skills, capable of interacting effectively with both technical and non-technical stakeholders.**
**Ability to translate complex banking domain requirements into effective data solutions.**
**Ability to work independently, prioritize tasks, and manage multiple projects concurrently in a fast-paced environment.**
**Proactive attitude with a strong commitment to quality and continuous improvement.**
---
**Job Family Group:**
Technology
---
**Job Family:**
Applications Development
---
**Time Type:**
Full time
---
**Primary Location Full Time Salary Range:**
$94,300.00 - $141,500.00
---
**Most Relevant Skills**
Please see the requirements listed above.
---
**Other Relevant Skills**
For complementary skills, please see above and/or contact the recruiter.
---
_Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law._
_If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review_ _Accessibility at Citi ( _._
_View Citi's_ _EEO Policy Statement ( _and the_ _Know Your Rights ( _poster._
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.

Job Description

Job Description

Salary:

Who we are?

Leader in specialized and alternative financing, Iceberg Finance has experienced exceptional growth over the past few years including an major acquisition in 2022 of the firm iFinance Canada. Finalist in 2022 and 2023 as a top lender according to the Canadian Lender Association (CLA), Iceberg Finance's ambition is to be among the top 3 alternative and specialized lenders in Canada by 2026.

We are seeking an experienced developer to support the maintenance of a mission-driven system primarily focused on credit granting. This system is approximately twenty years old and is currently being replaced. This position will ensure ongoing maintenance while the new version of the system becomes operational.

More specifically, the candidate will work with the credit and accounting teams to adjust existing system modules to improve operational efficiency and support the company's growth. The candidate will be required to take the needs, identify the risks and impacts of the requested changes, propose solutions and rigorously test the changes.

Tasks to be carried out by the candidate:

• VB and VBA Programming
• SQL Server (2008) Query and Stored Procedure Programming
• Programming User Interfaces Using Access 2003
• Needs analysis and proposal of solutions
• Acceptance testing support

The following skills are required:

• At least ten (10) years of IT experience
• VB or VBA programming experience
• Excellent SQL knowledge
• Ability to work/speak in English
• Good analytical and synthesis skills
• Autonomous and able to take initiatives
• Good communication and willingness to work in a team

The following skills are an asset:

• Speak French
• Experience with at least one accounting system or integration project with an accounting system.

Job Description

Job Description

Design and develop large-scale applications
Developing and testing, working on software analysis, troubleshooting, and debugging
System designing and Financial Industry Software development
Ensure designs meet specifications.
Ensure applications are tested for functionality, performance, and security.
Write efficient, scalable, and reusable code.

6+ years of experience in Java (Spring Boot)
Experience in SQL programming
Experience using Gitlab for code management.
Proficiency in modern Java frameworks.
Knowledge of web development frameworks like REST/API, OAUT2, Spring, Hibernate, and Struts.
Experience in Rexx, Phyton programming.

Exp Required: 5 Developer Skills Required: Digital : Microsoft Power BI~PL/SQL

Job Description: - • 5 years of experience with Strong Power BI developer with large and complex projects experience, Data Transformation Modeling - Integrate, cleanse, and transform raw data from multiple sources into usable models. - Dashboard Report Development - Design, build, and maintain interactive dashboards, visual reports, and KPI scorecards using Power BI Desktop. -  Data Analysis - Analyze data to identify patterns, trends, and outliers, translating them into actionable business insights. • Technical Expertise - Write DAX (Data Analysis Expressions) for advanced calcu-lations and implement data security measures like row-level security. • Experience in CICD Tools such as jenkin, Bamboo, Ansible. Hands on GithubExperience working in an AGILE environ-mentCarrying out software analysis, testing, debugging, and update to ensure that applications can be used on all web browsersExper- SQL. • Experience with SQL for data querying, transformation, and connecting to data sources. • Data Modeling Expertise in developing tabular and multidimen-sional models that are compatible with warehouse standards. • Analytical Thinking - Strong ability to interpret complex datasets and provide strategic insights.