Connexion

BI Developer

Maarut

Montreal
Compétences recherchées — Connectez-vous et téléversez votre CV pour comparer avec votre profil
SQL Azure Git +14 autres

Détails du poste

  • Lieu de travail : Montreal
  • Type de poste : Permanent à temps plein

Description du poste

As part of the PAPM Modernization program, the project to set up the Group Insurance Data Counter (CDAC) was launched to meet the operational analytics needs of the business sectors.

This project aims to integrate data from several legacy systems and the new group insurance system into a cloud computing environment supported by the Movement Data Platform based on Azure technologies and to make them available via a data counter under PowerBi.

The project is conducted in iterative delivery mode, allowing for the delivery of value to users with each iteration.

We are looking for a Senior Developer to support the project until the final delivery scheduled for 2027.

Responsabilités

  • Support project managers in the identification and application of solutions.
  • Analyze system components, functional and non-functional specifications, change requests or technical problems encountered.
  • ETL analysis and development
  • Configure Data Ingestion Pipelines from Source Systems to the Appropriate Data Lakes
  • Participation in the valorization of the data and the configuration of the data counter (configuration of dimensions/facts) according to the established data model
  • Participate in loading data into tables
  • Processing and documentation
  • Data profiling (tools, approaches)
  • Perform unit tests
  • Participate in production releases
  • Provide technical support to operations following production launches and follow up on problems with project managers.
  • Ensure and update various databases and recommend any improvements to optimize their quality and efficiency.

Exigences

Fonctionnalités / Exigences

Features/Requirements

  • Resourcefulness and autonomy
  • Strong propensity for teamwork and task sharing
  • Ability to work in an environment with standardized processes
  • Pleasant personality
  • Hands-on experience as a developer in large companies;
  • Excellent knowledge of ETL
  • Functional knowledge
  • Knowledge of relational, dimensional models
  • Excellent knowledge of unit testing - TDD, user interface testing, automated testing, and continuous integration approaches
  • Knowledge of source code management and deployment platforms such as GitHub/GitHub Action, Concourse
  • Experience in data projects
  • Knowledge of Azure data storage environments (DataStorage, DataLake, Blob Storage, Azure Datafactory, Azure SQL Database, Synapse Analytics)
  • Knowledge of Power BI (Desktop, Service and gateway components, etc.)
  • Knowledge of architecture patterns/principles: Object-oriented, Cloud computing (IaaS – CaaS – PaaS – SaaS – iPaaS), Domain Driven Design DDD (asset), Application resilience, Events
  • Asset: Knowledge of security principles/protocols such as SSO, Auth0, SAML, OpenID, JWT, oAuth2, ABAC/RBAC

Number of years of experience:

  • Senior: 8+ years old

Skills / assets required:

  • Have a good knowledge of the sector
  • Managing complexity
  • Be results-oriented
  • Demonstrate analysis and synthesis