Jobs

    Developer - SQL - Canada - Scotiabank

    Scotiabank
    Scotiabank Canada

    1 week ago

    Scotiabank background
    Description
    Automotive Finance IT support team is responsible for supporting the technology solutions implementations to drive the bank's automotive business.

    As a member of Automotive team, the Data Developer is responsible for operational data support and development for Automotive Finance System applications.

    The incumbentis responsible for providing specialized development and support work in data integration to and from Enterprise Data Lake and Data Warehouse and development work within our agile lab based on business requirements.

    Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems, and knowledge.

    • Serves as a liaison between the business community and the IT organization in order to provide technical solutions to meet user needs.
    • Exercise good judgment in selecting methods and techniques for obtaining solutions.
    • Understand how the Bank's risk appetite and risk culture should be considered in day to day activities and decisions.

    Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with SQL Server data warehouse.


    • Design and develop physical data model structures in SQL Server
    • Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Crystal Report, Excel/PowerPivot, and Tableau.
    Builds and maintain proper documentation, data lineage and extract-transform-load (ETL) processes.

    • Collecting business requirements / user stories while working in a lab with a product owner, Business Analyst, Scrum Master, and application developers.
    • Developing SQL views to enable data consumers to read data from data warehouse.
    • Documenting databases, data process flows and maintain data dictionaries, support and onboarding procedures.
    • Troubleshoot and resolve database and application defects in a timely manner with consultation with internal and external groups as needed.
    -generate technical specifications to design or redesign complex software components and applications.

    • Act as an expert technical resource in Data Warehouse/DBs and ETL
    • Leverage industry best practices to design, test, implement and support a solution.
    • Assure quality, security and compliance requirements are met for supported area.
    • Be flexible and thrive in an evolving environment.
    • On call responsibilities to operate as the L2 point of contact for monitoring TIDAL/EDL jobs requests may be required for weekends rotation.
    3-5 years previous experience working within a technically focused environment as a database analyst / data developer.

    • Experience with databases such as Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager, MySQL, Crystal Report, Tidal jobs etc.
    • Experience working in an agile development team engaged in the SDLC process and SDLC methodologies (agile / waterfall).
    • Experience with EDL / Hadoop / Hive / Tableau a plus.
    Hands-on programming experience and advanced knowledge of SQL.

    • Expertise with data visualization / BI tools like e.
    g., Power BI.

    • Familiarity with JIRA/SharePoint
    • Experience with MS Azure / SQL Server MI / Machine Learning services a plus.
    • Experience with databases, dimensional data modeling design.
    • Experience with data warehouse, ETL, SSIS, SSAS/cubes a must.
    • Experience with implementing DevOps / CIAD a plus.
    • Experience with web development (in ASP.
    NET MVC / C#) a plus.


    Technical Environment:

    • Database: SQL Server / MS SQL Enterprise Manager / Oracle
    • Platform: Microsoft.
    NET, IIS, SharePoint Online / Azure

    • Languages: T-SQL, C#, .
    NET, Python

    • Source Control: MS Team Foundation Server / Git / Bitbucket / TFS
    • Reporting:MS SQL Server Reporting Services, Crystal Reports, SSRS
    • Data Visualizations: MS PowerBI / Tableau / Excel

    Diversity, Equity, Inclusion & Allyship-We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank.

    We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.


    • Accessibility and Workplace Accommodations
    • We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone.
    Upskillingthrough online courses, crossfunctional development opportunities, and tuition assistance.
  • Competitive Rewardsprogram including bonus, flexible vacation, personal, sick days and benefits will start on day one.
  • Community Engagement no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more
    • Scotiabank is a leading bank in the Americas


    Guided by our purpose:
    "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

    At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone.

    If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know.

    If you require technical assistance, please click here. Candidates must online to be considered for this role.
  • PdsSoft Inc

    SQL Developer Job

    6 days ago

    PdsSoft Inc Canada

    Développeur SQL · POSTE EN TÉLÉTRAVAIL 100% OU AU BUREAU DE LONGUEUIL OU AU BUREAU DE QUÉBEC · Travailler chez Genius Solutions: · Vous vous joindrez à une équipe passionnée et dynamique, engagée dans le succès de la compagnie. Vous vous joindrez aussi à une compagnie en plein ...

  • Techedinlabs

    BI/SQL Developer

    3 weeks ago

    Techedinlabs Canada

    Save this job with your existing LinkedIn profile, or create a new one. Save this job with your existing LinkedIn profile, or create a new one. · Your job seeking activity is only visible to you. Email Welcome back · Sign in to save SQL/BI Developer at Techedin . · We currentl ...

  • Leith Wheeler Investment Counsel Ltd.

    Tableau Developer with SQL

    3 weeks ago

    Leith Wheeler Investment Counsel Ltd. Canada

    Leith Wheeler Investment Counsel Ltd. Is an employee-owned firm, headquartered in Vancouver with offices in Calgary and Toronto. We manage over $23 billion of assets on behalf of pension, foundation, corporate, Aboriginal, and individual clients across Canada. · We are looking f ...

  • Maplesoft Group

    Net Developer with SQL

    3 weeks ago

    Maplesoft Group Canada Part time

    Maplesoft implements TimeLive for Electronic time tracking. · At Maplesoft, we value the contributions of all our employees and contractors. In turn, Maplesoft contributes to the communities where we live and operate. Build your future with Maplesoft's exciting technologies, dee ...

  • Compunnel Inc.

    Oracle PL/SQL Developer

    2 weeks ago

    Compunnel Inc. Canada

    Mandatory Skills · "Developer should have 3+ years development experience with Oracle SQL,PL/SQL, and conventional SQL. · Developer should have 3+ years development experience with Oracle Forms/Reports. · Developer has experience maintaining complex Oracle Forms/Reports (>30 arti ...

  • Nomadgao

    BI Developer, Python/SQL

    3 weeks ago

    Nomadgao Canada

    Mar 11, Bloom Talent Partners is hiring a remote BI Developer using Plotly Dash. Salary: usd payment. Location: LATAM. · Job Summary · We are seeking a talented BI Developer with expertise in frontend development using Plotly Dash. As a BI Developer, you will be responsible for ...

  • Wagepoint

    Senior .NET Developer with SQL

    3 weeks ago

    Wagepoint Canada $110,000 - $130,000

    Senior .NET Developer · Department: Engineering · Employment Type: Full Time · Location: Canada - Remote · We're an authentic team who bring our diverse backgrounds, ideas, experiences and cultures together to make payroll magic. Speaking of, we "pull rabbits out of hats" for ...

  • ROSS

    Oracle/ SQL Developer for an Industry Leader

    16 hours ago

    ROSS Canada

    Scorecard Systems, a growing and dynamic organization that provides reporting and analysis solutions , has selected ROSS () to manage their recruitment process. ROSSis an innovative leader in Recruitment Process Outsourcing (RPO). Our unique model truly creates strategic alignmen ...

  • ROSS

    Oracle/ SQL Developer for an Industry Leader

    16 hours ago

    ROSS Canada

    Scorecard Systems, a growing and dynamic organization that provides reporting and analysis solutions , has selected ROSS () to manage their recruitment process. ROSSis an innovative leader in Recruitment Process Outsourcing (RPO). Our unique model truly creates strategic alig ...

  • Talasoft

    Senior Developer-SQL Server Analysis Services

    3 weeks ago

    Talasoft Canada

    Old Montreal, Canada | Posted on 02/28/2024 - Participate in all phases of the Software Development Life Cycle (SDLC), encompassing requirements gathering, analysis, design, development, testing, and production. · - Provide support in post-production within an agile development ...

  • Samay Consulting

    ETL Quality Analyst Lead

    2 days ago

    Samay Consulting Canada

    We are seeking an experienced and dedicated Senior Data Warehouse Quality Analyst with a minimum of 7 years of relevant experience, possessing a deep understanding of SQL and data warehousing concepts. As a critical member of our quality assurance team, you will be responsible fo ...

  • West Works & BluElephant

    Data & Reporting Analyst-Remote

    2 weeks ago

    West Works & BluElephant Canada

    · Our client is a fully integrated provider of instrumentation, electrical, automation, communication, combustion and emissions, and meter proving services throughout Western Canada. They are a globally recognized business celebrated for their tenacious full-service approach and ...

  • BrickRed Systems

    Report Engineer

    3 weeks ago

    BrickRed Systems Canada

    Overview: · We are seeking a skilled Report Engineer to join our team. The ideal candidate will have expertise in designing, developing, and maintaining reports using tools such as Power BI, SSRS (SQL Server Reporting Services), and creating database views. Proficiency in Extract ...

  • BrickRed Systems

    Back End Developer

    3 weeks ago

    BrickRed Systems Canada

    Job Description: · We are seeking a talented and motivated BackEnd Developer to join our dynamic team specializing in Title Insurance. As a BackEnd Developer, you will play a crucial role in the design, development, and maintenance of our software systems, focusing on the backend ...

  • Newport Williams

    Oracle EBS Developer

    4 days ago

    Newport Williams Canada

    Our Toronto client is need of a Senior Oracle EBS Developer for permanent position. The candidate would preferably be based out of Toronto, Calgary, or Vancouver. This is a remote position. · Job Summary · As an Oracle E-Business Suite (EBS) Developer, you will play a critical ro ...

  • Akkodis

    Power BI Developer Apply in 3 Minutes

    5 hours ago

    Akkodis Canada

    Skills Required: · - Should be proficient in creating power queries and DAX logics. · - Should be able to create, maintain and deploy powerbi data models. · - Good experience in relational databases SQL. Experience in azure databricks and azure SQL is a plus. · - Analytical think ...

  • Quarry Consulting

    C# Developer

    1 week ago

    Quarry Consulting Canada

    The ideal candidate will be responsible for developing high-quality applications. They will also be responsible for designing and implementing testable and scalable code. · - 10 years developing/ designing enterprise software solutions in C# · - 5 years experience with version co ...

  • Focus Systems Inc.

    (Urgent Search) Senior Informatica Administrator

    2 days ago

    Focus Systems Inc. Canada

    Title: Senior Informatica Administrator (Remote - Canada) · RFP ID: 1458 · Contract Term: 13 Months · Role Overview: · Seeking an experienced Senior Informatica Administrator for a pivotal remote role in our team, managing and optimizing our data management infrastructure using v ...

  • Atlantis IT Group

    ETL Developer

    3 weeks ago

    Atlantis IT Group canada, Canada

    Role name: Data Bricks/ETL Developer · Role Description: ? Designing and implementing efficient data ingestion pipelines from multiple sources using Azure Data factory and/or Azure Databricks? Integrating the end-to-end data pipeline to take data from different source systems to ...

  • OneBridge Solutions, Inc.

    Implementation Engineer

    1 week ago

    OneBridge Solutions, Inc. Canada

    OneBridge Solutions Inc. is an innovative technology company that develops SaaS solutions for the oil & gas industry. Our solutions are unparalleled within the pipeline integrity management software space. The special ingredient in our sauce is the ability to welcome any challeng ...