Jobs
>
Kitchener

    REMOTE - SQL Data Engineer/Python/SQL - Waterloo, ON, Canada - Société Financière Manuvie

    Société Financière Manuvie
    Société Financière Manuvie Waterloo, ON, Canada

    1 week ago

    Default job background
    Description

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux.

    De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie en nous appuyant sur des valeurs, et ce, dans l'ensemble de nos activités.

    Pour nous aider à nous démarquer, nous vous aidons à progresser, parce que lorsque nos collègues sont en santé, respectés et vraiment valorisés, nous nous épanouissons tous.

    Manulife is embarking on replacing and building new data capabilities to help fuel our bold ambition to become a digital customer leader.

    We are seeking a skilled and motivated data engineer to join our dynamic team and play a key role in implementing, optimizing, and maintaining assets that deliver these capabilities.

    The ideal candidate possesses a solid background in data engineering, ETL processes, and data integration, with a passion for understanding data to drive strategic business decisions.


    Data Pipeline Development:

    Design, develop, and manage end-to-end data pipelines that facilitate the detailed extraction, transformation, and loading of data from diverse sources.


    Data Mapping & Integration:

    Collaborate closely with multi-functional teams to understand and design schemas for data from various source systems and other transactional or application databases, ensuring accuracy and reliability.


    ETL Optimization:

    Continuously improve and optimize ETL processes to enhance data flow efficiency, minimize latency, and support real-time and batch processing requirements.


    Data Transformation:
    Implement data cleansing, enrichment, and transformation processes to ensure high-quality data is available for analysis and reporting.

    Data Quality Assurance:

    Design testing plans, develop and implement data quality checks, validation rules, and supervising mechanisms to maintain data accuracy and integrity.


    Platform Enhancement:

    Collaborate with various technical resources from across the organization to identify and implement enhancements to the infrastructure, integrations, and functionalities.


    Data Architecture:

    Work closely with business leads and data architects to design, implement, and manage end-to-end architecture based on business requirements.


    User Documentation:
    Create and maintain comprehensive documentation for data pipelines, processes, and configurations to facilitate knowledge sharing and onboarding.

    Collaboration:

    Partner with other data engineers, data analysts, business collaborators, and data scientists to understand data requirements and translate them into effective data engineering solutions.


    Performance Monitoring:
    Monitor data pipeline performance and solve issues to ensure optimal data flow and proactively find opportunities for enhancement.

    Data Governance and Compliance:
    Ensure consistency with data privacy and compliance standards throughout the data lifecycle.

    You think big, with curiosity to discover ways to use your agile approach and enable business outcomes.
    Bachelor's Degree in Computer Science, Information Technology, or a related field.

    5+ years of experience as a Data Engineer, with a track record of efficiently implementing and maintaining data pipelines, scheduling, monitoring, notification, and ETL processes using Azure Data Factory, Databricks, Python\Pyspark, Java, Scala.

    ~ subscriptions, resource groups, resources, access control with RBAC (role-based access control), integrations with Azure AD and Azure security principles (user group, service principal, managed identity), network concepts (VNet, Subnet, NSG rules, private endpoints), password\credential\key management and data protection.
    ~ Experience deploying and integrating Azure Data Services (Azure Data Factory, Databricks) using DevOps tools and principles: GitHub Repository, Jenkins CI\CD pipelines, integrated unit tests, etc.
    ~ Knowledge of Azure Data Lake Storage (ADLS Gen2) and its topology on blob storage with file hierarchy, storage account, containers, and folders.
    ~ Proficient in data mart fact and dimension design concepts, ETL\ELT logic to perform upsert and type-2, and applying\implementing with python\pyspark\store proc\SQL in ADLS (with Lakehouse architecture using Databricks) or in Azure Synapse (with Dedicated SQL pool),
    ~ Experience using Power BI to connect to sources with ADLS (including Delta Lake), Databricks SQL, Azure Synapse (SQL pool), design semantic layer\data models, create\publish reporting content (data sets\paginate report\interactive dashboard), and manage workspaces.
    ~ Solid understanding of data privacy and compliance regulations and standard methodologies.
    ~ Excellent problem-solving skills and the ability to solve technical issues efficiently.
    ~ Effective communication skills to collaborate with technical and non-technical partners.
    ~ Thorough approach with a commitment to delivering high-quality work in a fast-paced environment.

    Flexible work policies and strong work-life balance.
    We create opportunities to learn and grow at every stage of your career.

    Continuous innovation:
    We invite you to help redefine the future of financial services.
    Delivering the promise of Diversity, Equity and Inclusion: We foster an inclusive workplace where everyone thrives.

    Championing Corporate Citizenship:
    We build a business that benefits all partners and has a positive social and environmental impact.
    #Au 30 juin 2021, l'actif géré et administré par Manuvie et ses filiales se chiffrait à 1 300 milliards de dollars canadiens milliards de dollars américains). Vous pouvez consulter le site de Manuvie à l'adresse manuvie.
    Salaire et avantages sociaux

    00 CAD - $137,930.00 CAD Si vous posez votre candidature à ce poste en dehors de la région principale, veuillez écrire à .Le salaire varie en fonction des conditions du marché local, de la géographie et de facteurs pertinents liés au poste telles les connaissances, les compétences, les qualifications, l'expérience et l'éducation ou la formation.

    Manuvie offre aux employés admissibles une vaste gamme d'avantages sociaux personnalisables, notamment une assurance soins médicaux, soins dentaires, santé mentale, soins de la vue, invalidité de courte et de longue durée, assurance vie et assurance DMA, assurance adoption, de maternité de substitution et de soins médicaux non urgents ainsi que des programmes d'aide aux employés et leur famille.

    Nous proposons également aux employés admissibles différents régimes d'épargne-retraite (y compris des régimes de rente et un programme international d'actionnariat assortie de cotisations patronales de contrepartie) ainsi que des ressources en matière d'éducation et de conseils financiers.

  • Société Financière Manuvie

    Data engineer

    1 week ago

    Société Financière Manuvie Waterloo, ON, Canada

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...

  • Sun Life

    Senior Data Engineer

    3 days ago

    Sun Life Kitchener, Canada Temps plein

    Description · de poste: We are looking for an experienced and high-performing individual to join our Data Engineering team in Corporate IT as a Sr Data Engineer . This senior technical role is responsible for the building, deployment, and support of data integration for BI repo ...

  • Canonical - Jobs

    Python Software Engineer

    3 days ago

    Canonical - Jobs Waterloo, Canada Full time

    Canonical is hiring a Python Software Engineer to join the Certification team, who make the tools which enable us to know that a desktop, laptop, server or IoT device is working properly. We work at the interface of hardware and software, so the ideal candidate is a Python develo ...

  • ApplyBoard

    Data Engineer

    5 hours ago

    ApplyBoard Kitchener, Canada

    The Role: · The data engineering team is an experienced team, responsible for supporting our product development and the entire organization. In addition to building ETL pipelines to automate analytics and building integrations between systems , the team is responsible for buildi ...

  • ApplyBoard

    Data Engineer

    1 week ago

    ApplyBoard Kitchener, Canada

    The Role:The data engineering team is an experienced team, responsible for supporting our product development and the entire organization. In addition to building ETL pipelines to automate analytics and building integrations between systems , the team is responsible for building ...

  • ApplyBoard

    Data Engineer

    3 days ago

    ApplyBoard Kitchener, Canada Full time

    ApplyBoard simplifies the study abroad search, application, and acceptance process by connecting international students, recruitment partners, and educational institutions on one intuitive and personalized platform. ApplyBoard is a mission-driven, hyper-growth organization. It ha ...

  • ApplyBoard

    Data Engineer Data Analytics

    5 days ago

    ApplyBoard Kitchener, ON, Canada

    The data engineering team is an experienced team, responsible for supporting our product development and the entire organization. In addition to building ETL pipelines to automate analytics and building integrations between systems , the team is responsible for building and maint ...

  • Sun Life Financial

    Big Data Engineer

    6 days ago

    Sun Life Financial Waterloo, ON, Canada

    You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Discover how you can make a difference in the lives of individuals, families and c ...

  • TripleLift

    Senior Data Engineer

    3 days ago

    TripleLift Waterloo, Canada

    The Role · TripleLift is seeking a Senior Data Engineer to join the influential Data Engineering team within the Data Platform Engineering organization. This hire will be responsible for expanding and optimizing our distributed computing data pipeline architecture, as well as op ...

  • Sun Life

    Senior Data Engineer

    3 days ago

    Sun Life Waterloo, Canada Full time

    Job Description · : We are currently looking for a Senior Data Engineer with a passion for turning disparate streams of data into organized and actionable analytics services and insights. As a Data Engineer on the Data Engineering and Operations team, you will be joining a grou ...

  • D2L

    Sr. Data Engineer- IT

    6 days ago

    D2L Kitchener, Canada Full time

    D2L is a cloud company that is modernizing education and building the Future of Work. The old models of teaching and learning are in the midst of the largest transformation in history, and D2L is at the heart of that fundamental shift. · New models of teaching and learning enabl ...

  • Sun Life

    Senior Data Engineer

    5 days ago

    Sun Life Waterloo, Canada Temps plein

    Description · de poste: We are currently looking for a Senior Data Engineer with a passion for turning disparate streams of data into organized and actionable analytics services and insights. As a Data Engineer on the Data Engineering and Operations team, you will be joining a ...

  • Index Exchange

    Principal Engineer, Data Streaming

    3 days ago

    Index Exchange Kitchener, Canada

    We shaped the earliest forms of ad tech, and we're looking for technical expertise to help shape its future. Our customers have unique problems that can only be solved at an internet scale, and that's where the technical skills of our team make a real difference. · Our exchange h ...

  • Geosyntec Consultants

    790440 - Early-career Environmental Data Specialist

    5 days ago

    Geosyntec Consultants Waterloo, Canada

    If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking an **Early-Career Environmental Data S ...

  • Geosyntec Consultants

    790465 - Early-career Environmental Data Technician

    5 days ago

    Geosyntec Consultants Waterloo, Canada

    If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking an **Early-Career Environmental Data T ...

  • Geosyntec Consultants, Inc.

    Early-career Environmental Data Technician

    5 days ago

    Geosyntec Consultants, Inc. Waterloo, Canada

    If you're looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking an **Early-Career Environmental Data T ...

  • Geosyntec Consultants, Inc.

    Early-career Environmental Data Specialist

    5 days ago

    Geosyntec Consultants, Inc. Waterloo, Canada

    If you're looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking an **Early-Career Environmental Data S ...

  • opentext

    SQL Database Administrator(Intermediate Experienced)

    4 days ago

    opentext Waterloo, Canada

    **OPENTEXT - THE INFORMATION COMPANY** · As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. · **The Opport ...

  • opentext

    Oracle Database Administrator(Intermediate

    9 hours ago

    opentext Waterloo, Canada

    **OPENTEXT - THE INFORMATION COMPANY** · As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. · **The Opport ...

  • Emonics

    Gcp Sme

    1 week ago

    Emonics Waterloo, Canada

    GCP and GCP functionalities like running DAGs, troubleshooting when there is a failure, console, and all other features present in GCP tool. · - Complex query writing, procedures, routines in Big Query. · - Bigdata testing and tools. · - Any automation experience on tables-to-tab ...