Lead Engineer Software - Data Modelling

Our vision for the future is based on the idea that transforming financial lives starts by giving our people the freedom to transform their own. We have a flexible work environment, and fluid career paths. We not only encourage but celebrate internal mobility. We also recognize the importance of purpose, well-being, and work-life balance. Within Empower and our communities, we work hard to create a welcoming and inclusive environment, and our associates dedicate thousands of hours to volunteering for causes that matter most to them.

Chart your own path and grow your career while helping more customers achieve financial freedom. Empower Yourself.

Canada Life is an insurance and financial services company with its headquarters in Winnipeg, Manitoba. we provide a wide range of insurance and wealth management products for individuals, families, and business owners from coast to coast. Canada Life is focused on improving the financial, physical and mental well-being of Canadians and believes in good corporate governance. Our Technology team is a strategic partner in our business – with an ambition to be a forward-thinking, agile technology organization delivering secure, resilient, and leading solutions that support Canada Life and the well-being of millions of Canadians.

Lead Data Modeller will take end-to-end ownership of the design, development, and maintenance of data models that underpin our enterprise data platform, with a particular focus on Databricks and the Nova platform. This role is critical in ensuring that our data assets are structured, governed, and optimised to support business intelligence, analytics, and reporting requirements.

We are seeking an experienced professional who is comfortable working closely with data engineers, architects, and business stakeholders to translate business requirements into robust, scalable, and well-documented data models. You will be responsible for both logical and physical data modelling and will act as the subject matter expert and owner for all data models within your domain.

What Youll Do

• Take full ownership of the data modelling lifecycle, from requirements gathering through to deployment and ongoing maintenance.
• Design, develop, and maintain logical and physical data models, primarily using Databricks and the Nova platform.
• Ensure data models are aligned with business requirements, data governance standards, and best practices.
• Collaborate with data engineers, architects, and business stakeholders to understand data requirements and translate them into effective data structures.
• Document data models, definitions, and metadata to ensure clarity and consistency across the organisation.
• Review and optimise existing data models for performance, scalability, and maintainability.
• Lead model validation and quality assurance activities, ensuring models are accurate and fit for purpose.
• Provide guidance and support to project teams and business users on data modelling best practices.
• Act as the primary point of contact and subject matter expert for all matters relating to data models within your area of responsibility.
• Champion data model governance and ensure models are maintained in line with organisational standards and policies.
• Support the integration of new data sources and the evolution of the enterprise data platform.
  
  

Essential

Knowledge / Experience / Skills

• Extensive experience in data modelling, including both logical and physical modelling, ideally within Databricks and/or similar cloud-based platforms.
• Demonstrable experience of owning and maintaining enterprise data models, including responsibility for model governance and documentation.
• Strong understanding of data warehousing, lakehouse architectures, and modern data platforms.
• Ability to translate complex business requirements into scalable and efficient data models.
• Proficient in data modelling tools and techniques, with hands-on experience in Databricks and the Nova platform (or similar).
• Excellent communication skills, with the ability to work collaboratively across technical and business teams.
• Experience in data governance, metadata management, and data quality assurance.
• Strong analytical and problem-solving skills.
• Desirable
• Experience working in regulated industries such as insurance or financial services.
• Familiarity with reporting requirements such as IFRS and Solvency II.
• Experience with data visualisation tools and supporting analytics/reporting teams.
• Knowledge of automation tools and scripting for data model management.
• Experience working in Agile product teams and using tools such as JIRA/Confluence.
  
  

We are an equal opportunity employer with a commitment to diversity. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to age, race, color, national origin, ancestry, sex, sexual orientation, gender, gender identity, gender expression, marital status, pregnancy, religion, physical or mental disability, military or veteran status, genetic information, or any other status protected by applicable state or local law.

---