Data Solution Architect

GFT Technologies SE

Toronto

Presencial

CAD 110 000 - 120 000

Tempo integral

Há 3 dias
Torna-te num dos primeiros candidatos

Uma candidatura completa num minuto

Currículo e carta de apresentação personalizados, prontos a enviar.

Ultrapassa os filtros ATS

Resumo da oferta

GFT Technologies SE in Toronto, ON, is seeking a Data Solution Architect to lead modernization of Guidewire operational reporting. You will design and implement cloud-based data pipelines on Azure Databricks, convert Oracle SQL to Spark SQL, and build analytics models in Microsoft Fabric and Power BI.

The ideal candidate has hands-on experience with Databricks, DAB, Python, SQL, and data governance, and can partner with business and technology teams in an Agile environment to deliver scalable,

Qualificações

  • Experience with cloud-based data engineering and modern analytics platforms.
  • Strong SQL and Python development skills.
  • Hands-on experience with Azure Databricks and Spark SQL.
  • Experience migrating legacy reports to modern cloud analytics.
  • Familiarity with Power BI and Microsoft Fabric.
  • Knowledge of data governance and data modeling principles.

Responsabilidades

  • Lead modernization of Guidewire operational reports from Actuate BIRT to the target analytics platform.
  • Design, develop, and implement cloud-based data pipelines using Databricks and DAB.
  • Translate legacy Oracle SQL queries to optimized Spark SQL for Databricks.
  • Transform business logic from BIRT reports into reusable data pipelines for Gold Data Products.
  • Develop and maintain analytics layer within Microsoft Fabric, including Lakehouse, Semantic Models, and Power BI reports.
  • Establish and promote a modern data architecture for governance, performance, and scalability.
  • Collaborate with stakeholders to ensure alignment between existing reports and new analytics solutions.
  • Support testing, validation, and deployment with a focus on data quality.

Conhecimentos

Azure Databricks
Spark SQL
Python
SQL
Microsoft Fabric
Power BI

Ferramentas

Informatica PowerCenter
Power BI

Descrição da oferta de emprego

Data Solution Architect

Toronto, ON, CA, M5J 2M4

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.
Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

Senior Apps Architect - AI-Driven Data Pipelines Databricks
Senior Apps Architect - AI-Driven Data Pipelines Databricks

Source Code • Toronto

Presencial
CAD 151 536 - 181 843
Senior Data Warehouse/BI Architect
Senior Data Warehouse/BI Architect

Altea Healthcare • Burnaby

Híbrido
CAD 126 000 - 154 000
Competitive pay
Startup stock options
Business Intelligence Architect Developer
Business Intelligence Architect Developer

EXL • Canadá

Presencial
CAD 80 000 - 110 000
Senior Databricks Data Engineer
Senior Databricks Data Engineer

Raise - find a more meaningful working experience • Toronto

Híbrido
CAD 100 000 - 167 000
Reporting Data Analyst (Hybrid)
Reporting Data Analyst (Hybrid)

SIRITECH SOLUTIONS CORP • Ottawa

Híbrido
CAD 120 000 - 160 000
Senior BI & Data Solutions Architect
Senior BI & Data Solutions Architect

GuruLink • Toronto

Teletrabalho
CAD 120 000 - 160 000
Principal Data Engineer – Databricks
Principal Data Engineer – Databricks

Astra-North Infoteck Inc. • Toronto

Presencial
CAD 140 000 - 190 000
Intermediate Software Developer
Intermediate Software Developer

Hirematic Talent Solutions • Toronto

Presencial
CAD 55 000 - 62 000
Data & Reporting Analyst - SQL (Power BI and Tableau)
Data & Reporting Analyst - SQL (Power BI and Tableau)

Astra-North Infoteck Inc. • Toronto

Híbrido
CAD 70 000 - 90 000
Data Engineer
Data Engineer

Spectraforce • Toronto

Híbrido
CAD 80 000 - 110 000