Data Engineer SQL

3 weeks ago


Toronto ON, Canada S I Systems Full time

Senior Data Architect to enable a data platform for all wealth applications at a large financial bank - BNSJP00033938
Our client is looking for a Senior Data Architect to enable a data platform for all wealth applications at a large financial bank - BNSJP00033938
Contract Duration: 6 months, possibility of extension
IWM Advisor & Client Solutions The Data Product Owner – Business Platforms & Experience contributes to the overall success of International Wealth Management organization (IWM) strategy, by enabling a common data platform for all wealth applications, and International Wealth Management in resolving complex business and data issues.
Project:
This is a demanding hands-on role which requires the incumbent to be knowledgeable of the data architecture, managing highly complex projects, specific to data, and has in-depth experience collaborating with multi-jurisdictional teams. Additionally, should be highly analytical and have a good understanding of databases, technical architecture, and query tools, with previous experience in wealth management or capital markets or related domains.
This role will be focused on acceleration of IWM’s data & analytics transformation, particularly on implementing a Wealth Data Hub; build a data platform that consolidates information structured by relevant domains such as clients, portfolio, and performance, enabling Advisor and Client experience across IWM.
Support the definition of the International Wealth Management data hub strategy and roadmap to drive specific operational data capabilities.
Work collectively with the Business Platforms and Experience team to articulate business requirements into system requirements for new enhancements or projects.
Collaborate with head office and in-country business partners to Document, analyze, research, and define user and system requirements and features relating to strategic data projects/initiatives. Develop and deliver Business Requirements Documents, source-to-target data mapping, data specifications, User stories, as required.
Document data transformation and cleansing rules for data migration. Previous expertise with Data warehousing projects.
Provide expertise on systems gap analysis and potential risks/issues on projects, enhancements, and initiatives.
Acts as a liaison between business and IT to provide technical solutions to meet user needs. Present recommendations with technology teams, collaborating on system design, and understanding process, database structures, and Data Model.
Responsible for reviewing and analyzing end-to-end testing results for data projects.
Manage communications and status reporting of ongoing initiatives, including summarizing project risks and options and facilitating prompt decisions when needed.
Provide expertise on relational and dimensional data modelling.
Provide the team expertise on data models such as star and snowflake schemas.
Proficiency in SQL is a must have.
10+ years of experience in big data analysis, data engineering , or data architecture field
~8-10 years in experience in relational databases and SQL ; Hands on experience in big data tools and technologies, as well as data visualization and reporting tools such as PowerBI .
~ Strong knowledge of data governance , data quality , and data security best practices.
~ Experience in working with cloud-based data platforms, preferably Google Cloud Platform .

Full proficiency in Spanish
Relevant working experience in the financial sector, Wealth Management, or capital markets experience, in data projects.
Post-Secondary education and Advanced degree preferred but not mandatory in data analytics.
Has led/managed a team of Data analysts / Data engineers in his recent position.
1st – HM – 30 -45 mins – MS Teams Video – experience on the resume 2nd – Director +VP – 30 – 45 mins – MS Teams Video
#


  • Data Engineer

    7 days ago


    Mississauga, ON, Canada Synechron Full time

    Role: Python Data Engineer(Databricks/Pyspark, SQL, Azure) Mississauga, ON (hybrid/3 days in a week) Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation and...

  • Sr Data Engineer

    5 days ago


    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Sr Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA).Data Engineer Responsibilities-Create and...

  • Sr Data Engineer

    5 days ago


    Toronto, Canada NTT DATA Services Full time

    Req ID: 276517  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Sr Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA). Data Engineer...

  • Senior Data Engineer

    37 minutes ago


    Toronto, Canada NTT DATA Services Full time

    Req ID: 276510 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Senior Data Engineer to join our hybrid team.Data Engineer Responsibilities- (Informatica, Snowflake,...

  • Data Engineer

    1 day ago


    Toronto, ON, Canada Organigram Inc Full time

    Description:We are seeking a skilled and experienced Data Engineer to join our team. The ideal candidate will have expertise in SQL Server, Azure Data Factory, and data ingestion architecture within the Azure Cloud environment. Additionally, familiarity with Dynamics 365 and experience in IoT (Internet of Things) would be highly...

  • Data Engineer

    2 days ago


    Toronto, ON, Canada Organigram Inc Full time

    Description: We are seeking a skilled and experienced Data Engineer to join our team. The ideal candidate will have expertise in SQL Server, Azure Data Factory, and data ingestion architecture within the Azure Cloud environment. Additionally, familiarity with Dynamics 365 and experience in IoT (Internet of Things) would be highly beneficial. ...

  • Data Engineer

    1 week ago


    Toronto, ON, Canada hireVouch Full time

    Our client is a Canadian-based international real estate investor, developer, and property manager. They are growing their team and looking for a passionate Data Engineer to join.The Data Engineer will be responsible for building, processing, reviewing, and managing data alongside support from a data scientist. Enhance your skills working with ETL pipelines,...

  • Data Engineer

    1 week ago


    Toronto, ON, Canada hireVouch Full time

    Our client is a Canadian-based international real estate investor, developer, and property manager. They are growing their team and looking for a passionate Data Engineer to join.The Data Engineer will be responsible for building, processing, reviewing, and managing data alongside support from a data scientist. Enhance your skills working with ETL pipelines,...


  • Brantford, ON, Canada Brant Community Healthcare System Full time

    Exceptional Care–Exceptional PeopleThe Brant Community Healthcare System is a two site Community Hospital located in Brantford and Paris, Ontario. The Brantford General is an acute care hospital. The Willett in Paris is an urgent care centre and has transitional care beds.By choosing to work at Brant Community Healthcare System (BCHS), you are joining an...


  • Brantford, ON, Canada Brant Community Healthcare System Full time

    Exceptional Care–Exceptional PeopleThe Brant Community Healthcare System is a two site Community Hospital located in Brantford and Paris, Ontario. The Brantford General is an acute care hospital. The Willett in Paris is an urgent care centre and has transitional care beds.By choosing to work at Brant Community Healthcare System (BCHS), you are joining an...

  • Data Engineer BI

    4 weeks ago


    Toronto, ON, Canada Prodigy Labs Full time

    Data Engineer with Databricks & Spark Experience We are looking for a data engineer who has strong experience in building scalable and reliable data pipelines using Databricks and Spark. You will be working with various data sources and formats, and transforming them into valuable insights for our business. Design, develop, and maintain data pipelines...

  • Data Engineer

    7 days ago


    Toronto, ON, Canada hireVouch Full time

    Our client is a Canadian-based international real estate investor, developer, and property manager. They are growing their team and looking for a passionate Data Engineer to join. The Data Engineer will be responsible for building, processing, reviewing, and managing data alongside support from a data scientist. Enhance your skills working with ETL...


  • Brantford, ON, Canada Brant Community Healthcare System Full time

    Exceptional Care–Exceptional People The Brant Community Healthcare System is a two site Community Hospital located in Brantford and Paris, Ontario. The Brantford General is an acute care hospital. The Willett in Paris is an urgent care centre and has transitional care beds. By choosing to work at Brant Community Healthcare System (BCHS), you are...

  • Data Scientist

    1 month ago


    Toronto, ON, Canada ProViso Staffing Full time

    Story Behind the Need • Business group: Small Business & Channel Analytics – team works in customer onboarding, using proprietary technology building to assess necessary stages that customers are onboarded safely and securely, a lot of work is focused on channel expansion, data and analytics to see how that funnel is behaving • Project: Initiative...

  • Azure Data Engineer

    7 days ago


    Toronto, ON, Canada BetasharpInc Full time

    Position: Azure Data Engineer (Synapse Specialist)Location: Toronto, ON (Hybrid)Duration: Long Term Contract Responsibilities: 10+ years of experience in Azure data platforms developmentStrong experience in Azure Synapse, Azure Data Bricks, Data Factory, ADLSStrong experience in implementation of Data lake, Delta lake, Datawarehouse architectureIngest,...

  • Azure Data Engineer

    7 days ago


    Toronto, ON, Canada BetasharpInc Full time

    Position: Azure Data Engineer (Synapse Specialist)Location: Toronto, ON (Hybrid)Duration: Long Term Contract Responsibilities: 10+ years of experience in Azure data platforms developmentStrong experience in Azure Synapse, Azure Data Bricks, Data Factory, ADLSStrong experience in implementation of Data lake, Delta lake, Datawarehouse architectureIngest,...


  • Oakville, ON, Canada Sagen Full time

    In collaboration with the Manager, Data Operations , the Senior Data Engineer is responsible for the data, architecture, and model of our Enterprise Data & Analytics environment. This role will maintain the current data warehouse solution and be an active participant in decommissioning legacy solutions. Plan, coordinate, develop and support data model...

  • Data Engineer/MLOps

    7 days ago


    Toronto, ON, Canada COGNITO INC Full time

    We have multiple roles for Data Engineer. 1. Data Engineer ML, 2. GCP Data Engineer. Please see the description below. Data Engineer/MLOps Location: Toronto, ON Job Description: Mandate Skills: MLOPS, Azure Data bricks, Visualization Experience, SQL, Python Job Description: Minimum 5 years of experience in Data Engineering role that involves...

  • Azure Data Engineer

    7 days ago


    Toronto, ON, Canada BetasharpInc Full time

    Position: Azure Data Engineer (Synapse Specialist) Location: Toronto, ON (Hybrid) Duration: Long Term Contract Responsibilities: 10+ years of experience in Azure data platforms development Strong experience in Azure Synapse, Azure Data Bricks, Data Factory, ADLS Strong experience in implementation of Data lake, Delta lake, Datawarehouse architecture ...

  • Senior Data Analyst

    9 hours ago


    Toronto, ON, Canada Resonaite Full time

    The ideal candidate will use their passion for big data and analytics to provide insights to the business covering a range of topics. They will be responsible for conducting both recurring and ad hoc analysis for business users.Location: Mainly remote, team meetings in person - TorontoDuration: 6 months + 6 months extensionResponsibilitiesSupport existing...