Hybrid Data Analyst – Finance 365

at MDD Forensic Accountants

• Job title: Data Analyst – Finance 365
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: CA$80,000 - CA$83,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: Azure, ETL, Informatica, SQL, SSIS, Tableau
• Location requirements: Hybrid, Home, Canada

About the role

• Data Analyst supporting financial data analysis and reporting at Davies North America. Collaborating to transform data for analytics, optimizing operations in insurance and regulated sectors.

Responsibilities

• **Imagine being part of a team that’s not just shaping the future but actively driving it. At **Davies North America**, we’re at the forefront of innovation and excellence, blending cutting-edge technology with top-tier professional services. As a vital part of the global Davies Group, we help businesses navigate risk, optimize operations, and spearhead transformation in the insurance and regulated sectors.
• **
• **We're on the lookout for a full time **Data Analyst**. We are seeking a detail-oriented **Data Analyst** with strong financial domain knowledge and hands-on SQL expertise to support data analysis, reporting, and data integration initiatives. This role plays a critical part in translating financial and operational data from source systems into standardized, trusted data models used for analytics, reporting, and decision-making.
• **
• Analyze financial and operational data from multiple source systems (e.g., GL, AP, AR, billing, policy, or transaction systems)**
• Write and optimize SQL queries to extract, transform, and validate data**
• Develop and maintain source-to-target mappings for data warehouses, data lakes, or analytics platforms**
• Partner with finance, accounting, and business stakeholders to understand data requirements and definitions**
• Validate data accuracy, completeness, and reconciliation between source systems and target models**
• Support financial reporting, KPI development, and ad-hoc analysis**
• Document data definitions, business rules, transformations, and assumptions**
• Assist in data quality initiatives, issue resolution, and root-cause analysis**
• Collaborate with data engineers, architects, and BI developers during implementations and enhancements******

Requirements

• Bachelor degree in computer science or related field.
• 3+ years of experience in a data analyst or financial data analyst role
• Solid understanding of financial data structures (GL, chart of accounts, transactions, balances)
• Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions
• Experience supporting data integration, migrations, or M&A system consolidation
• Knowledge of ETL/ELT tools (e.g., Fabric, Informatica, SSIS, Azure Data Factory, or similar)
• Experience with BI Tools (PowerBI, SSRS, Tableau, etc.)
• Familiarity with data governance, data quality, or financial controls
• Excellent written and verbal communication skills, demonstrated through the preparation of reports and presentations for diverse audiences.
• Familiarity with data warehouses, dimensional models, or canonical data models
• Ability to clearly document and communicate technical and business concepts
• Strong Analytical, problem solving, and attend to detail skills. ******

Benefits

• **Davies is dedicated to fostering a diverse and inclusive workplace that embraces a wide range of perspectives and experiences. We believe that diversity of thought is essential for innovation and creativity, and we actively promote an environment where all voices are valued and heard.****