Database Analyst, Finance Transformation (Contract 9-12 Months)
About the role
Definity is the parent company to some of Canada’s most long-standing and innovative insurance brands, including Economical Insurance, Sonnet Insurance, Family Insurance Solutions, and Petline Insurance. Our ambition is to be one of Canada’s leading and most innovative property and casualty insurers. We can’t do that without our people, so we embrace and encourage a culture that’s collaborative, ambitious, rewarding, and empowering.
We offer a flexible, hybrid work experience where employees work from the office and virtually depending on the type of work they are doing and who they are working with. Bring your true self and be a part of our journey. It’s better here.
Database Analyst, Finance Transformation
What can you expect in this role?
In your role as a key member of the finance transformation team, reporting to the Senior Manager of Finance Transformation, your responsibilities will extend across a range of functions, emphasizing both finance and data science expertise.
Your work will involve extensive collaboration with various teams such as Finance, Enterprise Project Management Office (EPMO), Technology Solutions (TS), Enterprise Change Enablement (ECE), Human Resources (HR), Enterprise Data Governance (EDO), vendor partners, and other business units. This collaboration is critical for streamlining processes and fostering a unified approach to finance modernization and data-driven decision-making.
In the realm of data analytics, you will leverage your expertise in data modeling, analysis and visualization to support and enhance business processes, working closely with finance teams and stakeholders to improve financial reporting and operational efficiency. You'll be responsible for managing financial data analytical workspace, including data extractions, development and execution of data models and pipelines, reconciliations, and thorough analyses utilizing Oracle Cloud Data Platform, Oracle Analytics Cloud, Google Cloud Analytics Workspace and data modelling tools. These activities are crucial for maintaining data accuracy, quality and integrity within Oracle, essential for the financial close process and reporting.
You will apply data analytical methodologies to analyze complex datasets, focusing on the interpretation of financial data to inform tactical and strategic decisions. This will include developing an understanding of data lineage, and quality verifying data segmentation and patterns, and using Python and SQL. Your work will support monthly reconciliations to the general ledger, accruals, reporting and audit requests.
In addition to these responsibilities, you will support updating process documentation and standard operating procedures will be key in enhancing the organization's understanding and use of financial systems and data analytics tools to support continuous improvement objectives.
What do you bring to the role?
- Leveraging deep understanding of complex financial datasets and systems to extract actionable insights and manage intricate financial data architectures, using advanced data analysis to support key financial decision-making in Google Cloud Analytical Space combined with data modelling tools
- Translating business needs into data-driven solutions within financial products, conducting comprehensive product analysis to drive product strategy and development, and aligning product features with financial goals.
- Executing and enhancing data models for financial data management to ensure quality and integrity, supporting financial close reconciliation, reporting, and analysis.
- Identifying and implementing process improvements to enhance financial operations efficiency, coordinating master data management, and the month-end cycle for accurate reporting.
- Supporting complex projects at the intersection of finance, data systems, and business needs, supporting initiatives for financial system enhancements and operational improvements, ensuring alignment with organizational goals.
- Acting as a liaison support between finance, technology, and business units, effectively communicating data insights to stakeholders.
- Assisting in change leadership during finance modernization and continuous improvement journeys, ensuring smooth adaptation to new processes and systems.
- Tracking and reporting on performance metrics and objectives to ensure results-oriented delivery in line with financial and regulatory requirements.
- You will provide support for change leadership and assistance during the transitional phases after program deployment and steady state.
In this role, you will excel in core areas of data analytics, modelling and reporting but also extend your expertise into finance master data management.
What do you bring to the role?
- Strong Analytical and Problem-Solving Skills: Proficiency in dissecting complex data sets and systems to provide insightful solutions. A creative approach to problem-solving that allows for innovative solutions in data analytics and financial management.
- Team-Oriented Approach: Ability to work collaboratively with diverse teams across the organization. Foster a team environment that encourages shared goals, mutual support, and cooperative problem-solving.
- Advanced Technical Proficiency: Skilled in finance data management tools such as Python, SQL, and Oracle, with a commitment to staying abreast of new technologies and continuously enhancing technical skills.
- Effective Communication Skills: Exceptional ability to articulate complex data insights clearly to both technical and non-technical stakeholders. This includes creating compelling presentations and reports.
- Strategic Thinking and Business Acumen: A strong understanding of the broader business context and financial strategies, aligning data analytics and product decisions with the organization’s goals.
- Detail-Driven Focus: A meticulous approach to work, ensuring high standards of accuracy and quality in data management and analysis.
- Adaptability and Continuous Learning: Being adaptable in a rapidly evolving finance and technology landscape and committed to continuous learning and self-improvement.
- Leadership and Influence: Demonstrated ability to lead initiatives, inspire team members, and influence decision-making processes at all organizational levels.
- Risk Management and Compliance Awareness: Awareness and understanding of the regulatory environment and compliance requirements relevant to financial data, ensuring strict adherence to these standards.
Requirements:
- University Degree or college diploma in data science or information systems, or a related discipline
- Extensive experience using Python including a strong grasp of object-oriented programming (OOP) fundamentals
- Deep understanding of advanced SQL techniques and data modeling
- Extensive experience in product analytics, projects, and working with developers and engineers on robust data pipeline
- Experience working with various levels of business stakeholders, from executives to engineering and business teams.
- Experience creating data product strategies, building data products, and continued iteration after launch
- Experience in cloud-based ERP systems and implementation of ERP systems would be advantageous
- Experience in utilizing Google Cloud products and services to configure an analytical workspace tailored for finance. This includes leveraging cloud-based tools for data storage, analysis, and visualization to enhance financial data management and reporting capabilities.
- Master data cleansing and coordination experience
- Data visualization experience
- Business process experience with exposure to MS Visio
- Strong communication to effectively communicate and lead cross functional sessions
- Financial accounting and reporting exposure with data analysis would beneficial
- Experience in the insurance industry is an asset, but not required
We also take potential into consideration. If you don’t have this exact experience, but you know you have what it takes, be sure to give us more insight through your application and cover letter.
High degree of proficiency with English required to service customers, both internal to the company and external, across Canada.
Salary Range is $76,200 - $127,000
Actual salary for the role may vary depending on work location of the successful candidate and other factors including but not limited to, skills, education, experience, working conditions and the local labour market.
We also take potential into consideration. If you don’t have this exact experience, but you know you have what it takes, be sure to give us more insight through your application and cover letter.
Our inclusive work environment welcomes diversity and supports accessibility. If you require accommodation at any time during the recruitment process, please let us know by contacting: accessibility@definity.com .
Background checks
This role requires successful clearance of a background check (including criminal checks and leadership references).
#LI-Hybrid
About Definity
Definity Financial Corporation is the parent company to some of Canada’s most long-standing and innovative property and casualty insurance brands and companies, including Economical Insurance, Sonnet Insurance, Family Insurance Solutions, and Petline Insurance. We focus on making insurance better for our customers, our employees, our broker partners, and our communities.
Our promise to employees is to provide a workplace that’s collaborative, ambitious, rewarding, and empowering. Our inclusive environment provides the space to innovate with colleagues and implement even better ways of doing things. We invest in our employees’ growth and development and help them thrive. With our flexible, hybrid work arrangements, total rewards packages, company share ownership program, and emphasis on work-life balance, it’s better here.
If you’re looking for a career where your perspective and expertise are valued, you’ll find it here at Definity.
La Société financière Definity est la société mère de compagnies d’assurance de dommages parmi les plus établies et innovatrices au Canada, soit Assurance Economical, Sonnet Assurance, Family Insurance Solutions et la Compagnie d’assurance Petline. Definity est dévouée à faire évoluer l’assurance pour sa clientèle, ses équipes, son réseau de courtage et ses communautés.
Nous promettons de fournir un environnement de travail collaboratif, ambitieux, valorisant et stimulant. Notre environnement inclusif vous permet d’innover avec vos collègues et de mettre en œuvre de meilleures façons de travailler. Nous investissons dans la croissance et le perfectionnement de nos gens et les aidons à s’épanouir. Grâce à nos options flexibles de travail hybride, notre programme de rémunération globale, notre régime d’actionnariat et l’accent sur l’équilibre travail-famille, vous évoluerez avec nous.
Si vous souhaitez une carrière où votre point de vue sera reconnu, ne cherchez pas plus loin que Definity.
Database Analyst, Finance Transformation (Contract 9-12 Months)
About the role
Definity is the parent company to some of Canada’s most long-standing and innovative insurance brands, including Economical Insurance, Sonnet Insurance, Family Insurance Solutions, and Petline Insurance. Our ambition is to be one of Canada’s leading and most innovative property and casualty insurers. We can’t do that without our people, so we embrace and encourage a culture that’s collaborative, ambitious, rewarding, and empowering.
We offer a flexible, hybrid work experience where employees work from the office and virtually depending on the type of work they are doing and who they are working with. Bring your true self and be a part of our journey. It’s better here.
Database Analyst, Finance Transformation
What can you expect in this role?
In your role as a key member of the finance transformation team, reporting to the Senior Manager of Finance Transformation, your responsibilities will extend across a range of functions, emphasizing both finance and data science expertise.
Your work will involve extensive collaboration with various teams such as Finance, Enterprise Project Management Office (EPMO), Technology Solutions (TS), Enterprise Change Enablement (ECE), Human Resources (HR), Enterprise Data Governance (EDO), vendor partners, and other business units. This collaboration is critical for streamlining processes and fostering a unified approach to finance modernization and data-driven decision-making.
In the realm of data analytics, you will leverage your expertise in data modeling, analysis and visualization to support and enhance business processes, working closely with finance teams and stakeholders to improve financial reporting and operational efficiency. You'll be responsible for managing financial data analytical workspace, including data extractions, development and execution of data models and pipelines, reconciliations, and thorough analyses utilizing Oracle Cloud Data Platform, Oracle Analytics Cloud, Google Cloud Analytics Workspace and data modelling tools. These activities are crucial for maintaining data accuracy, quality and integrity within Oracle, essential for the financial close process and reporting.
You will apply data analytical methodologies to analyze complex datasets, focusing on the interpretation of financial data to inform tactical and strategic decisions. This will include developing an understanding of data lineage, and quality verifying data segmentation and patterns, and using Python and SQL. Your work will support monthly reconciliations to the general ledger, accruals, reporting and audit requests.
In addition to these responsibilities, you will support updating process documentation and standard operating procedures will be key in enhancing the organization's understanding and use of financial systems and data analytics tools to support continuous improvement objectives.
What do you bring to the role?
- Leveraging deep understanding of complex financial datasets and systems to extract actionable insights and manage intricate financial data architectures, using advanced data analysis to support key financial decision-making in Google Cloud Analytical Space combined with data modelling tools
- Translating business needs into data-driven solutions within financial products, conducting comprehensive product analysis to drive product strategy and development, and aligning product features with financial goals.
- Executing and enhancing data models for financial data management to ensure quality and integrity, supporting financial close reconciliation, reporting, and analysis.
- Identifying and implementing process improvements to enhance financial operations efficiency, coordinating master data management, and the month-end cycle for accurate reporting.
- Supporting complex projects at the intersection of finance, data systems, and business needs, supporting initiatives for financial system enhancements and operational improvements, ensuring alignment with organizational goals.
- Acting as a liaison support between finance, technology, and business units, effectively communicating data insights to stakeholders.
- Assisting in change leadership during finance modernization and continuous improvement journeys, ensuring smooth adaptation to new processes and systems.
- Tracking and reporting on performance metrics and objectives to ensure results-oriented delivery in line with financial and regulatory requirements.
- You will provide support for change leadership and assistance during the transitional phases after program deployment and steady state.
In this role, you will excel in core areas of data analytics, modelling and reporting but also extend your expertise into finance master data management.
What do you bring to the role?
- Strong Analytical and Problem-Solving Skills: Proficiency in dissecting complex data sets and systems to provide insightful solutions. A creative approach to problem-solving that allows for innovative solutions in data analytics and financial management.
- Team-Oriented Approach: Ability to work collaboratively with diverse teams across the organization. Foster a team environment that encourages shared goals, mutual support, and cooperative problem-solving.
- Advanced Technical Proficiency: Skilled in finance data management tools such as Python, SQL, and Oracle, with a commitment to staying abreast of new technologies and continuously enhancing technical skills.
- Effective Communication Skills: Exceptional ability to articulate complex data insights clearly to both technical and non-technical stakeholders. This includes creating compelling presentations and reports.
- Strategic Thinking and Business Acumen: A strong understanding of the broader business context and financial strategies, aligning data analytics and product decisions with the organization’s goals.
- Detail-Driven Focus: A meticulous approach to work, ensuring high standards of accuracy and quality in data management and analysis.
- Adaptability and Continuous Learning: Being adaptable in a rapidly evolving finance and technology landscape and committed to continuous learning and self-improvement.
- Leadership and Influence: Demonstrated ability to lead initiatives, inspire team members, and influence decision-making processes at all organizational levels.
- Risk Management and Compliance Awareness: Awareness and understanding of the regulatory environment and compliance requirements relevant to financial data, ensuring strict adherence to these standards.
Requirements:
- University Degree or college diploma in data science or information systems, or a related discipline
- Extensive experience using Python including a strong grasp of object-oriented programming (OOP) fundamentals
- Deep understanding of advanced SQL techniques and data modeling
- Extensive experience in product analytics, projects, and working with developers and engineers on robust data pipeline
- Experience working with various levels of business stakeholders, from executives to engineering and business teams.
- Experience creating data product strategies, building data products, and continued iteration after launch
- Experience in cloud-based ERP systems and implementation of ERP systems would be advantageous
- Experience in utilizing Google Cloud products and services to configure an analytical workspace tailored for finance. This includes leveraging cloud-based tools for data storage, analysis, and visualization to enhance financial data management and reporting capabilities.
- Master data cleansing and coordination experience
- Data visualization experience
- Business process experience with exposure to MS Visio
- Strong communication to effectively communicate and lead cross functional sessions
- Financial accounting and reporting exposure with data analysis would beneficial
- Experience in the insurance industry is an asset, but not required
We also take potential into consideration. If you don’t have this exact experience, but you know you have what it takes, be sure to give us more insight through your application and cover letter.
High degree of proficiency with English required to service customers, both internal to the company and external, across Canada.
Salary Range is $76,200 - $127,000
Actual salary for the role may vary depending on work location of the successful candidate and other factors including but not limited to, skills, education, experience, working conditions and the local labour market.
We also take potential into consideration. If you don’t have this exact experience, but you know you have what it takes, be sure to give us more insight through your application and cover letter.
Our inclusive work environment welcomes diversity and supports accessibility. If you require accommodation at any time during the recruitment process, please let us know by contacting: accessibility@definity.com .
Background checks
This role requires successful clearance of a background check (including criminal checks and leadership references).
#LI-Hybrid
About Definity
Definity Financial Corporation is the parent company to some of Canada’s most long-standing and innovative property and casualty insurance brands and companies, including Economical Insurance, Sonnet Insurance, Family Insurance Solutions, and Petline Insurance. We focus on making insurance better for our customers, our employees, our broker partners, and our communities.
Our promise to employees is to provide a workplace that’s collaborative, ambitious, rewarding, and empowering. Our inclusive environment provides the space to innovate with colleagues and implement even better ways of doing things. We invest in our employees’ growth and development and help them thrive. With our flexible, hybrid work arrangements, total rewards packages, company share ownership program, and emphasis on work-life balance, it’s better here.
If you’re looking for a career where your perspective and expertise are valued, you’ll find it here at Definity.
La Société financière Definity est la société mère de compagnies d’assurance de dommages parmi les plus établies et innovatrices au Canada, soit Assurance Economical, Sonnet Assurance, Family Insurance Solutions et la Compagnie d’assurance Petline. Definity est dévouée à faire évoluer l’assurance pour sa clientèle, ses équipes, son réseau de courtage et ses communautés.
Nous promettons de fournir un environnement de travail collaboratif, ambitieux, valorisant et stimulant. Notre environnement inclusif vous permet d’innover avec vos collègues et de mettre en œuvre de meilleures façons de travailler. Nous investissons dans la croissance et le perfectionnement de nos gens et les aidons à s’épanouir. Grâce à nos options flexibles de travail hybride, notre programme de rémunération globale, notre régime d’actionnariat et l’accent sur l’équilibre travail-famille, vous évoluerez avec nous.
Si vous souhaitez une carrière où votre point de vue sera reconnu, ne cherchez pas plus loin que Definity.