Jobs
>
Vancouver

    Senior Data Modeler - Vancouver, Canada - iA Financial Group

    Default job background
    Permanent
    Description

    Description

    Sector: Dealer Services Working Conditions: Working from home, with availability to go into the office for key moments Location: Vancouver would be preferred but open to candidates in Oakville or Toronto Status: Permanent

    Are you someone who lives and breathes all things Data and loves executing strategic initiatives? iA Dealer Services has set some exciting strategic objectives for their Business for the next few years, and we are looking for a Senior Data Modeler to drive our technology roadmap and maintain existing eco-systems in an Agile environment. By closely collaborating with business stakeholders and analysts, you will ensure that our data meets business requirements and aligns with our organization's strategic goals.

    If you thrive in a continuous learning environment, love collaboration and solving complex problems, let's connect

    What Will I Be Doing:

  • Create and refine data models to accurately represent the organization's data assets and inter-relationships, based on a clear understanding of business requirements
  • Develop and maintain conceptual, logical, and physical data models on Power Designer
  • Conduct data discovery and trace data lineage
  • Write complex SQL queries for intricate data analysis, profiling, and retrieval
  • Develop and maintain technical documentation including database designs, data flow charts, system architecture diagrams, data lineage, metadata, and other relevant details
  • Manage and update a data dictionary (on Collibra), source inventories, and reference/master data sets
  • Design and implementation of schemas, tables, views, indexes, stored procedures, and other database objects.
  • Enforce data quality and governance to ensure data accuracy, reliability, and compliance
  • Integrate diverse data sources ensuring that data can be combined and accessed effectively
  • Collaborate with data governance teams to uphold data quality, security and compliance standards within the Data Lakehouse environment.
  • Provide technical guidance, and support to team members, fostering a culture of continuous learning and innovation
  • What Tools will I Be Working with:

  • MS cloud technologies (ADF, Azure)
  • Snowflake Data Warehousing
  • Power Designer
  • Collibra
  • MDM tools such as IBM infosphere and/or Ataccama
  • Power BI
  • What we are Looking For:

  • Bachelor's or Master's degree in computer science
  • Minimum of 7 years of experience in data modeling, including experience with relational, star and snowflake schemas
  • Strong expertise in database design, data architecture, ETL/ELT and data warehousing (Snowflake)
  • Proficiency in Microsoft SQL Server and other databases
  • Experience with Azure Cloud, Snowflake
  • Familiarity with data integration, ETL, visualization tools
  • Proficient with Data Modelling Tools
  • Strong understanding of data governance, data quality and security best practices, alongside strong analytical and problem-solving skills, with the ability to troubleshoot complex issues
  • Ability to work collaboratively in a team environment and strong customer focus, as well as working in a fast-paced environment and manage multiple tasks simultaneously
  • Excellent verbal and written communication skills to work effectively with cross-functional teams.
  • Property and Casualty insurance background is considered an asset
  • What iA Offers:

  • A competitive compensation plan that also includes an annual bonus for all permanent employees
  • We value and encourage our employees to have a good work life balance and so on top of vacation we offer Personal Leave Days
  • To encourage an active and healthy lifestyle, we have a generous Wellness plan that covers physical activity and wellness expenses.
  • A medical and dental plan for our employees and their dependents as well as a Health Spending Account to cover costs not covered by our plan
  • A Defined Benefit Pension plan to take care of you in retirement.
  • A home office equipment program to ensure that you have the best working environment.
  • Participation in our Share Purchase Plan with matching contributions from iA
  • Your development and continuous improvement are important to us We offer an Education Assistance Program to ensure you have the tools and knowledge to grow your career here at iA.
  • Compensation

    The typical hiring range for this position is from $100,000 to $110,000 annually; the base pay offered may vary depending on skills, job-related knowledge, experience, and internal equity. All permanent employees of iA are also entitled to an annual bonus.

    At iA, we are committed to a fair, market-based and equitable compensation structure. Our market data is refreshed on an annual basis to reflect the most current market conditions.


  • Epsilon Solutions

    Data Modeler

    16 hours ago


    Epsilon Solutions Vancouver, Canada

    **Data Modeler** · **Working location: Remote but in PST hours** · **T4 only** · **6-12 Months** · JD · - Data modeling - 4/5 · SQL - 3.5/5 · ETL - 3.5/5 · Data mapping, analysis & profiling - 3.5/5 · Integration & data architecture - 3/5 · Azure Knowledge - 3/5 · Design and deve ...

  • TEEMA - Eagle

    Data Modeler

    12 hours ago


    TEEMA - Eagle British Columbia, Canada Full time, contract

    Contract to hire FULLY Remote anywhere in Canada · Summary: · As an Intermediate Data Moodeler, you will play a pivotal role in the design, translation, and implementation of data modeling solutions. We are looking for a FHIR expert with a passion for standards improvement, proce ...

  • Hi Neighbor

    Database Analyst

    1 day ago


    Hi Neighbor Vancouver, Canada

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years · - Experience: 2 years to less than 3 years · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, constru ...


  • UBC Faculty of Forestry Vancouver, Canada InternshipSHIP

    **Project Abstract**: · The transition towards a hydrogen-based energy system is pivotal for achieving decarbonization goals. However, this transition is encumbered by significant challenges, particularly in terms of making hydrogen both accessible and affordable at a scale compa ...

  • ABOMIS INNOVATIONS INC.

    Database Analyst

    16 hours ago


    ABOMIS INNOVATIONS INC. Vancouver, Canada

    Education: Bachelor's degree · - Experience: 2 years to less than 3 years · - Computer science · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · ...

  • Fobi AI

    BI Analyst

    16 hours ago


    Fobi AI Vancouver, Canada

    **About the Company**: · Founded in 2017, Fobi is a leading AI and data intelligence company that mainly provides wallet pass and data intelligence solutions. Fobi works with some of the largest global organizations across retail & CPG, insurance, sports & entertainment, casino g ...

  • Industrial Pixel Visual Effects

    3D Modeling

    16 hours ago


    Industrial Pixel Visual Effects Vancouver, Canada

    **Applicants will be given priority who have experience**: · - 3D digital modeler with organic and hard surface modeling experience · - Practical understanding of anatomy · - Experience with PHOTOGRAMMETRY software, 3D scanners, LiDAR and/or scanned data · - Experience with photo ...


  • BCLC Vancouver, Canada

    **Employment Information**: · **Job Type**:Permanent, Full Time · **Salary Range**:$66, $83, $104,430.00 · **Expected Salary**:Our typical hiring range will be +/- 10% of the midpoint listed above. Factors influencing this decision include qualifications and market conditions for ...

  • Samsung Electronics

    Data Scientist

    1 day ago


    Samsung Electronics Vancouver, Canada

    Position Summary · Inspire the World, Create the Future · Samsung Research Vancouver team handles a large volume of data generated by Samsung's Cloud Services and mobile devices. The team is responsible for turning this data into actionable insights that allow our stakeholders to ...


  • EY Vancouver, Canada

    At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build ...

  • British Columbia Securities Commission

    Database Specialist

    16 hours ago


    British Columbia Securities Commission Vancouver, Canada

    **Company Overview**: · Centrally located in downtown Vancouver, the British Columbia Securities Commission (BCSC) strives to make the investment markets benefit the public - enabling people to achieve their financial goals, enterprises to grow, and British Columbia to thrive. · ...

  • ICBC

    Analytics Advisor

    1 day ago


    ICBC North Vancouver, Canada

    At ICBC, it's our job to make sure the car insurance system works for all British Columbians, today and in the future. If you want · to make the most of your skills and expertise while growing your career, we want you. A career at ICBC is an opportunity to be · part of a talented ...

  • Arcurve Inc.

    Data Scientist Intern

    16 hours ago


    Arcurve Inc. Vancouver, Canada

    Arcurve is one of North America's leading full-service technology, advisory and software development companies. In 2006, we began with a belief that there was a better way to deliver professional services in the technology industry. Since then, we have completed more than 800 pro ...

  • Michael Smith Health Research BC

    Evaluation Analyst

    16 hours ago


    Michael Smith Health Research BC Vancouver, Canada

    Salary: · **Michael Smith Health Research BC** · Michael Smith Health Research BC, funded by the Government of British Columbia, is BC's health research agency. We strengthen the province's health research system by supporting the people, institutions and activities that generate ...


  • EY Vancouver, Canada

    At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build ...

  • Electronic Arts

    Character Artist

    16 hours ago


    Electronic Arts Vancouver, Canada

    EA SPORTS is one of the leading sports entertainment brands in the world, with top-selling videogame franchises, award-winning interactive technology, fan programs, and cross-platform digital experiences. EA SPORTS creates connected experiences that ignite the emotion of sport th ...


  • Best Buy Vancouver, Canada

    Are you passionate about innovation, growth, working with the latest tech stacks, and directly impacting customers and business users? If yes, then Best Buy Canada's tech team is one you should explore · As a Reltio technical specialist, you will have the ability to empower and i ...


  • First Nations Health Authority Metro Vancouver Regional District, Canada

    **FNHA Overview**: · **About us** · The First Nations Health Authority is a diverse and transformational health organization of professional, innovative, and dedicated team members and leaders. · The first of its kind in Canada, FNHA works as a health-and-wellness partner with BC ...

  • Core6 Environmental Ltd.

    Hydrogeologist

    1 day ago


    Core6 Environmental Ltd. Vancouver, Canada

    **Core6 Environmental** is currently looking for a full-time, permanent **Hydrogeologist** to join our team in the Vancouver/Lower Mainland region of British Columbia. We are an energetic and exciting consulting firm that provides a range of environmental services. We are known f ...


  • STEMCELL Technologies Vancouver, Canada

    **Job Description Summary**: · STEMCELL Technologies Inc. and the Centre for Heart Lung Innovation (UBC and St. Paul's Hospital) are working together on a grant-sponsored postdoctoral award opportunity and looking for a highly motivated Postdoctoral Fellow to fulfill a fixed term ...