Jobs
>
Toronto

    Data Engineer Data Analytics - Toronto, ON, Canada - Colliers International

    Default job background
    Description
    Our people are passionate, take ownership and always do what's right for our clients, people and communities.

    As a Data Engineer you will develop and maintain Microsoft SQL databases (including creating and maintaining tables, views, stored procedures), and ETL (Azure Data Factory, Azure functions, logic apps, Databricks, Spark, PySpark) processes.

    Excellent communication is key, as well as motivation to learn new technologies as Colliers data management platform evolves over time.

    Two plus years' experience in Azure Data Factory, Azure functions, logic app
    Intermediate to advanced SQL, preferably MS SQL Server and experience in object-oriented programming languages like C#, VB.Net and Python
    Intermediate MS SSIS scripting
    Advanced MS SQL Server Stored Procedures
    MS SQL Server database management, as in building tables and tuning queries and stored procedures
    Data profiling and data quality assessment skills
    Strong technical problem-solving skills and proficiency in trouble shooting issues related to operating systems and application systems.
    A drive to learn and master new technologies and techniques.
    Experience in DevOps and CI/CD
    Knowledge of Master Data Management including matching, survivorship and golden record creation.
    GCP experience including Dataflow, BigQuery, Cloud SQL and Cloud Storage

    You have the ability to work with technical architecture and design teams throughout the organization to turn requirements into solution deliverables.

    You successfully conduct technical requirements reviews with design teams to make sure there is clarity of deliverables and to recommend improvements.

    You develop and build embedded software solutions, sometimes on your own, utilizing internal and external resources to assist or answer questions if needed.

    Design, develop and test code for new software system using programming languages like python, C#, Develop ETL programs using Azure Data Factory, Azure functions, Logic apps, Stored Procedures, SSIS, Databricks and other development tools used by Colliers.

    Design database schema model using Erwin software and design data warehouse architecture for data flow application and implement the schema in SQL Server database.

    Design and develop optimized database architecture for information systems projects and develop optimized data processing scripts to evaluate the performance and reliability of designs.

    Work in both Azure cloud and on-prem SQL Server databases, lead and coordinate with teams of information systems professionals in the development of integrated data center.

    Work in agile environment and develop CI/CD pipelines for automatic installation of data migration pipelines to different environment.
    Work with Different computer systems across various networks and coordinating with Infrastructure teams in deployment activities.

    Automate the code promotion from one environment to other including the production implementation and ensure data quality is consistent across different computer systems.

    Analyze information from different existing systems, Design and Develop master data management solutions using Profisee MDM product.
    Collect and document business users' requirements and develop logical and physical technical specifications document.
    Assess, test, troubleshoot, document, upgrade and develop maintenance procedures for ETL systems and applications software.
    Operate database management systems to analyze data and perform data mining analysis and data profiling activities.
    Colliers is an equal opportunity employer and values diversity in its workforce.

    Colliers encourages applications from all qualified individuals and will accommodate applicants' disability-related needs, up to the point of undue hardship, throughout all stages of the recruitment and selection process.

    If you require a disability-related accommodation in order to participate in the recruitment process, please contact the recruitment team by email at .Our expert advice to property occupiers, owners and investors leads the industry into the future.

    Our people are passionate, take personal responsibility and always do what's right for our clients, people and communities.


  • Limelight Software Toronto, Canada

    Education: · Expérience: · Education · Bachelor's degree · Experience · 3 years to less than 5 years · Health benefits · Dental plan · Disability benefits · Health care plan · Paramedical services coverage · Vision care benefits · Durée de l'emploi: Permanent · Langue de travai ...

  • Vialto Partners

    Data Analytics

    1 week ago


    Vialto Partners Toronto, Canada

    Company Description · At Vialto we create the connections that build global careers and societies, bridging the gap between people and their aspirations. As the world of work continues to evolve, we are bringing together the individuals, ideas and technology to unlock business an ...


  • ADGA Group Consultants Inc Toronto, Canada

    Company Description · **Job Description**: · **Data Analytics Specialist Responsibilities**: · - Design methods to capture, structure, transform, and process data to be used to generate models; · - Lead design, development, implementation, and testing related to the IPA SQL Serve ...


  • Toronto School of Management Toronto, Canada

    **Job **Summary**: · Toronto School of Management is seeking a highly skilled **Data Analytics College Instructor**. As an instructor, you will be responsible for delivering engaging and comprehensive instruction in a range of data-related courses including Data Design, Data Hand ...


  • Technical Standards & Safety Authority (TSSA) Toronto, Canada

    **Location** · **City/Town** · - Toronto · **Department Name** · - Strategic Analytics · **Description** · **About Us**: · Since 1997, the Technical Standards and Safety Authority (TSSA) has delivered public safety services on behalf of the government of Ontario. With headquarter ...


  • Scotiabank Toronto, Canada

    Requisition ID: 178401 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · **The Team** · GOCT - International CRM Data and Analytics Team provides data management and analytical solutions to support business intelligence and ...


  • Equifax Toronto, Canada

    Equifax is where you can power your possible. If you want to achieve your true potential, chart new paths, develop new skills, collaborate with bright minds, and make a meaningful impact, we want to hear from you. · **Synopsis of the role** · The Intermediate Data Analytics and W ...


  • Institut Trebas Institute Toronto, Canada

    **ABOUT TREBAS** · The Trebas Institute, located in downtown Toronto, is a dynamic creative hub dedicated to creating media artists who will work both locally and internationally as creative professionals in the · Business, Technology and Entertainment industries. We offer variou ...


  • Institut Trebas Institute Toronto, Canada

    **ABOUT TREBAS** · The Trebas Institute, located in downtown Toronto, is a dynamic creative hub dedicated to creating media artists who will work both locally and internationally as creative professionals in the · Business, Technology and Entertainment industries. We offer variou ...


  • Trisura Guarantee Insurance Company Toronto, Canada

    At Trisura, we expect more because we believe it can be done better. · We are a young, growth oriented team with a commitment to exceptional talent and have been named one of Canada's Top Small and Medium Employers since 2017. Our growth and our entrepreneurial style, niche marke ...


  • Scotiabank Toronto, Canada

    Requisition ID: 199170 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · The Business Insight (BI) Manager leads BI projects in support of the IB Retail team, driving accelerated benefits for our customers. This role ensure ...


  • Rockwell Automation Toronto, Canada

    Rockwell Automation is a global technology leader focused on helping the world's manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers - amazing compan ...


  • Scotiabank Toronto, Canada

    Requisition ID: 173602 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · **Data Strategist** · As a Data Strategist in Global Data and Analytics Team, you will help integrate analytics capabilities into the Bank's digital p ...


  • Ontario Financing Authority Toronto, Canada

    **Attention finance professionals** Are you looking for your next leadership opportunity? Do you have expertise in risk analysis and management? Have you led, motivated, and inspired finance professionals? The Ontario Financing Authority (OFA) is seeking a strategic leader to joi ...


  • Toronto School of Management Toronto, Canada

    **About the Company**: · Toronto School of Management (TSoM) is an innovative college offering a broad range of career-focused programs in Business, Hospitality and Tourism, Big Data, Cybersecurity, and Accounting. We provide relevant programs, ensuring our students meet today's ...


  • TD Bank Toronto, Canada

    425878BR · Community & Environment · Toronto, ON · November 22, 2023 · Hours · 37.5 · Workplace Model · Hybrid · Pay Details · Department Overview · The Global Sustainability and Corporate Citizenship Group brings together TD's business, philanthropy, and human capital to deliver ...


  • International Data Group, Inc. Toronto, Canada

    Overview: · IDC Canada is seeking a **Data & Analytics** **Analyst** to join the consumer devices team. In this role, you will have the opportunity to work on several of IDC's consumer device programs, including wearables, AR/VR, smart home, personal computing devices like PCs an ...


  • Tiger Analytics Inc. Toronto, Canada

    Work Term: Permanent · - Work Language: English · - Hours: 40 hours per week · - Education: Bachelor's degree · - Experience: 5 years or more · **Work setting**: · - Consulting firm · **Tasks**: · - Confer with clients to identify and document requirements · - Data Science · - De ...


  • TD Bank Toronto, Canada

    **Decarbonization Data Analytics & Business Intelligence**: · BR · **Job Category - Primary** · - Community & Environment · **Work Location** · - TD Centre - North - 77 King Street West · **Employment Type** · - Regular · **City** · - Toronto · **Time Type** · - Full Time · **Pro ...


  • Rogers Communications Toronto, Canada

    Come play a key role in building the future of innovation in Canada. Everyone wants to be part of a transformational team - and that's exactly what we're building at Rogers. A team that innovates and a team that wins. Founded in 1960, we have grown to become a leading technology ...