Opens an external site
- Employment type
- Full-time
- Apply by
- Dec 1, 2026
- Posting language
- English
Job summary
Lead the modernization of Guidewire operational reports by migrating legacy Actuate BIRT reports to a modern analytics platform using Microsoft Azure Databricks and Microsoft Fabric. Design and implement scalable cloud-based data pipelines while ensuring data quality, governance, and functional alignment with business stakeholders.
Job details
A major Canadian financial services organization offering a wide range of insurance, investment, and financial planning solutions is currently seeking an experienced BI Architect to support its technology initiatives. This initiative focuses on modernizing Guidewire operational reporting. The existing reports were developed using Actuate BIRT and must be migrated to a modern analytics platform. As part of this transformation, operational reporting will be delivered directly from the enterprise data platform built on Microsoft Azure Databricks, which is refreshed in near real-time. Reports and dashboards will be developed and consumed through Microsoft Fabric and Power BI. Responsibilities Lead the modernization of Guidewire operational reports from Actuate BIRT to the client's target analytics platform based on Microsoft Azure Databricks and Microsoft Fabric. Design, develop, and implement cloud-based data pipelines leveraging Databricks Asset Bundles (DAB), Python Wheel components, and data ingestion, transformation, and publishing processes. Analyze and convert legacy Oracle SQL queries and stored procedures into optimized Spark SQL implementations for the Databricks ecosystem. Transform business logic historically embedded within BIRT reports into reusable data pipelines supporting certified Gold Data Products. Develop and maintain the analytics layer within Microsoft Fabric, including: Fabric Lakehouse OneLake Shortcuts Semantic Models Data security and access control Power BI reports and dashboards Establish and promote a modern data architecture that supports reusability, governance, performance, scalability, and standardization of analytical assets. Collaborate closely with business and technology stakeholders to ensure functional alignment between existing Guidewire reports and newly developed analytical solutions. Support testing, validation, and deployment activities while ensuring data quality and reporting accuracy. Contribute to best practices, documentation, and continuous improvement initiatives related to data engineering and analytics delivery. Required Skills and Experience Experience with Informatica PowerCenter Experience with LLM applied to SDLC Strong experience with Azure Databricks, Spark SQL, and cloud-native data engineering. Experience designing and implementing modern data pipelines and ETL/ELT processes. Proficiency in Python and SQL development. Experience with Microsoft Fabric, including Lakehouse, Semantic Models, and Power BI. Strong understanding of data modeling, analytics architecture, and data governance principles. Experience migrating legacy reporting solutions to modern cloud-based analytical platforms. Ability to collaborate effectively with business and technical teams in an Agile environment. Experience with Guidewire reporting environments is considered a strong asset. Nice-to-Have Experience with Actuate BIRT reporting. Knowledge of the insurance industry. Experience working with Oracle databases and report modernization initiatives. Familiarity with DevOps and CI/CD practices in Databricks environments. The salary range offered for this position is $110K to $120K.
What you’ll do
Lead the modernization of Guidewire operational reports by migrating legacy Actuate BIRT reports to a modern analytics platform using Microsoft Azure Databricks and Microsoft Fabric. Design and implement scalable cloud-based data pipelines while ensuring data quality, governance, and functional alignment with business stakeholders.
Requirements
Requires strong experience with Azure Databricks, Spark SQL, Python, and cloud-native data engineering processes. Candidates should have a solid understanding of data modeling, analytics architecture, and experience migrating legacy reporting solutions.
Listed skills
- Power BI · Preferred
- Python · Preferred
- SQL · Preferred
- Oracle · Preferred
- Agile · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Azure Databricks
- Spark SQL
- Microsoft Fabric
- Power BI
- Python
- SQL
- Data Engineering
- ETL/ELT
- Data Modeling
- Data Governance
- Informatica PowerCenter
- Guidewire
- Actuate BIRT
- Oracle
- Cloud Architecture
- Agile
- SQL (Programming Language)
- Business Intelligence
- Extract Transform Load (ETL)
- Oracle Databases
- Dashboard
- Operational Reporting
- Agile Methodology
- Governance
- Access Controls
- Solutions Support
- Investments
- Continuous Improvement Process
- Data Pipelines
- DevOps
- Financial Services
- Data Quality
- CI/CD
- Collaboration
- Python (Programming Language)
- Microsoft Azure
- Stored Procedure
- Scalability
- Systems Development Life Cycle
- Financial Planning
- Textiles
- Reporting Solutions
- Databricks
- Data Ingestion
- Cloud-Native Computing
- Business Logic
- Data Architecture
- Informatica Powercenter
- Insurance Industry
- Oracle SQL Developer
Job areas
- Data & Analytics
- Technology
- Software
- Finance & Accounting
- Engineering
- Data Solutions Architect
- Data Architect
- Database Designers and Administrators
- Database Architects
More jobs from GFT Technologies
Architecte de solution BI
- On-site
- Toronto, ON
- Posted Nov 17, 2026
Client Partner
- On-site
- Toronto, ON
- Posted Nov 12, 2026
Opportunités Salesforce - Architectes, Développeurs, Tech Leads, Analystes d'Affaires/Fonctionnel
- On-site
- Québec, QC
- Posted Nov 11, 2026
Guidewire Developer
- On-site
- Toronto, ON
- Posted Sep 19, 2026
