Senior Data Modeler
- Employer: iA Financial Group
- Office: 988 Broadway West
- Location: Vancouver, British Columbia
- Other Possible Location(s): Oakville, Ontario; Toronto, Ontario
- Job category: Data Analysis / Business Information and Data Science - General / Multiple Disciplines
- Job ID: JR10019999
- Job type: Permanent Job
- Apply before: 2024-05-06
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.
At iA, we invest,
in you.
Our employees are our best investment and we have much to offer them.
Company Overview
About
iA Financial Group is the strength of a company with a human side, with its over 8,000 employees. Together, we have earned the trust of our more than four million clients and 50,000 advisors who have chosen us for their insurance, savings, and wealth management.
With over $200 billion in assets and half a billion invested in technological innovation, we’re a key player in the financial services industry in Canada and the United States. The secret to our success? Investing in you, one person at a time. Because, for over 125 years, we have believed that it’s by supporting our employees and surrounding ourselves with the most reputable leaders in the industry, we will continue to innovate.
At iA, we’re invested in you.
Our commitment to Diversity and Inclusion
At iA Financial Group, we support and celebrate diversity. We strive to provide a workplace that is recognized as inclusive for all, regardless of ethnic origin, nationality, language, religious beliefs, gender, sexual orientation, age, marital status, family situation, or physical or mental disability.
Please note that if you need help or assistance to make the recruitment process more accessible for you, please contact us here. Someone from our team will be happy to assist you.