Senior Data Modeler

4 weeks ago

Vancouver, Canada iA Financial Group Full time

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.

  • Senior Data Modeler

    6 days ago

    Vancouver, British Columbia, Canada iA Financial Group Full time

    Other Possible Location(s): Oakville, Ontario; Toronto, OntarioJob category: Data Analysis / Business Information and Data Science - General / Multiple DisciplinesSector: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...

  • Senior Data Modeler

    4 weeks ago

    Vancouver, Canada iA Financial Group Full time

    Other Possible Location(s): Oakville, Ontario; Toronto, OntarioJob category: Data Analysis / Business Information and Data Science - General / Multiple DisciplinesSector: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...

  • Senior Data Modeler

    4 weeks ago

    Vancouver, Canada iA Financial Group Full time

    Other Possible Location(s): Oakville, Ontario; Toronto, OntarioJob category: Data Analysis / Business Information and Data Science - General / Multiple DisciplinesSector: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...

  • Senior Data Modeler

    3 weeks ago

    Vancouver, Canada iA Financial Group Full time

    Other Possible Location(s): Oakville, Ontario; Toronto, OntarioJob category: Data Analysis / Business Information and Data Science - General / Multiple DisciplinesSector: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...

  • Senior Data Modeler

    3 weeks ago

    Vancouver, Canada iA Financial Group Full time

    Other Possible Location(s): Oakville, Ontario; Toronto, OntarioJob category: Data Analysis / Business Information and Data Science - General / Multiple DisciplinesSector: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...

  • Senior Data Modeler

    4 weeks ago

    Vancouver, Canada iA Financial Group Full time

    Other Possible Location(s): Oakville, Ontario; Toronto, OntarioJob category: Data Analysis / Business Information and Data Science - General / Multiple DisciplinesSector: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...

  • Data Modeler

    2 months ago

    Vancouver, Canada Epsilon Solutions Full time

    **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 develop data models: The data modeler is responsible for designing and developing data models that...

  • Data Modeler

    2 months ago

    Vancouver, Canada Best Buy Full time

    Data Modeler Are you looking to challenge yourself in a role where you are showcasing your data modeling and designing skills while influencing leaders? As a data modeler, you will help shape how data is stored, used, and manipulated in our cloud data warehouse to help the business make informed and data-driven decisions. You will be responsible for the...

  • Data Modeler

    1 day ago

    Vancouver, Canada Best Buy Full time

    Data Modeler Are you looking to challenge yourself in a role where you are showcasing your data modeling and designing skills while influencing leaders? As a data modeler, you will help shape how data is stored, used, and manipulated in our cloud data warehouse to help the business make informed and data-driven decisions. You will be responsible for the...

  • Data Modeler

    6 days ago

    Vancouver, British Columbia, Canada Best Buy Full time

    Data ModelerAre you looking to challenge yourself in a role where you are showcasing your data modeling and designing skills while influencing leaders?As a data modeler, you will help shape how data is stored, used, and manipulated in our cloud data warehouse to help the business make informed and data-driven decisions. You will be responsible for the...

  • Data Modeler

    1 week ago

    Vancouver, Canada TEEMA - Eagle Full time

    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, process simplification, and HL7 v2 to FHIR mapping. You will collaborate closely...

  • Junior/Senior Geological Modeller

    3 weeks ago

    Vancouver, British Columbia, Canada SRK Consulting Full time

    Junior/Senior Geological Modeller Vancouver, BC, CanadaSRK Consulting is an independent, international consulting practice, providing globally integrated consulting services to the international mining and metals sector. We are seeking a Junior/Senior Geological Modeller. Description of Responsibilities:The successful candidates will consult on projects for...

  • Junior/Senior Geological Modeller

    4 weeks ago

    Vancouver, British Columbia, Canada SRK Consulting Full time

    Junior/Senior Geological Modeller Vancouver, BC, CanadaSRK Consulting is an independent, international consulting practice, providing globally integrated consulting services to the international mining and metals sector. We are seeking a Junior/Senior Geological Modeller. Description of Responsibilities:The successful candidates will consult on projects for...

  • Junior/Senior Geological Modeller

    3 weeks ago

    Vancouver, British Columbia, Canada SRK Consulting (UK) Ltd Full time

    SRK Consulting is an independent, international consulting practice, providing globally integrated consulting services to the international mining and metals sector. We are seeking a Junior/Senior Geological Modeller. Description of Responsibilities: The successful candidates will consult on projects for North American and international clients....

  • Junior/Senior Geological Modeller

    4 weeks ago

    Vancouver, British Columbia, Canada SRK Consulting (UK) Ltd Full time

    SRK Consulting is an independent, international consulting practice, providing globally integrated consulting services to the international mining and metals sector. We are seeking a Junior/Senior Geological Modeller. Description of Responsibilities: The successful candidates will consult on projects for North American and international clients....

  • SafetyCLI: Senior Data Engineer

    6 days ago

    Vancouver, British Columbia, Canada DATA MART Consulting GmbH Full time

    We are on the lookout for a talented Senior Data Engineer to contribute significantly to our advanced data collection, processing, and analysis system which is based on a Python/Django/Postgres stack. Responsibilities: – Work in tandem with the Lead System Architect to develop robust data ingestion, processing, and vulnerability review components, with...

  • SafetyCLI: Senior Data Engineer

    2 weeks ago

    Vancouver, Canada DATA MART Consulting GmbH Full time

    We are on the lookout for a talented Senior Data Engineer to contribute significantly to our advanced data collection, processing, and analysis system which is based on a Python/Django/Postgres stack. Responsibilities: – Work in tandem with the Lead System Architect to develop robust data ingestion, processing, and vulnerability review components, with...

  • SafetyCLI: Senior Data Engineer

    2 weeks ago

    Vancouver, Canada DATA MART Consulting GmbH Full time

    We are on the lookout for a talented Senior Data Engineer to contribute significantly to our advanced data collection, processing, and analysis system which is based on a Python/Django/Postgres stack. Responsibilities: – Work in tandem with the Lead System Architect to develop robust data ingestion, processing, and vulnerability review components, with...

  • Data Modeller, Business Intelligence

    4 weeks ago

    Vancouver, Canada Clio Full time

    -Clio is more than just a tech company-we are a global leader that is transforming the legal experience for all by bettering the lives of legal professionals while increasing access to justice Summary: We are currently looking for a new Data Modeller to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations. What your...

  • Data Modeller, Business Intelligence

    9 hours ago

    Vancouver, Canada Clio Full time

    -Clio is more than just a tech company-we are a global leader that is transforming the legal experience for all by bettering the lives of legal professionals while increasing access to justice Summary: We are currently looking for a new Data Modeller to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations. What your...