Sql developer Jobs in Sainte-Julie, QC

Job Description

Senior: 8+ years

• Strong industry knowledge
  
• Manage complexity
  
• Results-oriented
  

• This mandate is part of the GPAP modernization program at client, specifically the CDAC (Group Insurance Data Counter) project, which aims to integrate data from legacy systems into an Azure environment and expose it via Power BI.
  
• The client is seeking an application solution architect capable of designing the application layer, including data access, documenting architectural decisions, and representing the solutions in internal review committees.
  
• The environment is multi-technology and multi-team: the candidate will need to coordinate their work with development teams, Product Owners, and experts. Business and enterprise architecture bodies, using the BizzDesign tool as a reference.
  
• The group insurance context requires sufficient industry knowledge to communicate with business experts without prior training.
  
• The ideal candidate is a practicing architect capable of producing concrete deliverables (architecture views, design documents, technology recommendations) iteratively, within a project with a defined timeframe and final delivery scheduled for 2027.
  

Analytical and synthesis skills

• Designs the application layer, including data access, within the project framework and produces deliverables related to their area of expertise.
  
• Provides recommendations for technological solutions within the context of an application landscape where multiple technologies coexist.
  
• Considers alignment with targets, initiatives, strategic objectives, and the implementation plan for technological developments.
  
• Ensures the consistency of solutions with the organization's current and future needs, as well as their compatibility with existing solutions. Participates in modeling architectural views within the enterprise repository.
  
• Responsible for the continuous updating of permanent solution documentation.
  
• Analyzes the application and technological impacts of various solutions while adhering to established architectural patterns and frameworks.
  
• Prepares presentations for various review/validation committees.
  
• Works collaboratively with the implementation team to guide their efforts in accordance with the project's target architecture.
  
• Contributes to the design of components (software, data, and infrastructure) that meet the needs and requirements of business projects.
  
• Leverages the Movement's architectural targets and IT foundations, ensuring the compatibility of new elements with existing components.
  
• Designs detailed software architectures and participates in testing and implementation strategies. Coordinate studies, as well as positioning and design phases, and make appropriate technological recommendations.
  
• Develop, implement, and apply conceptual and logical models, as well as design, implementation, and integration strategies.
  
• Ensure cross-functional alignment with stakeholders involved in the projects and provide the necessary support and follow-up.
  

Requirements

REQUIREMENTS

• Experience in application solution architecture with the production of architectural deliverables (documents, views, recommendations) | Required experience | All requirements met
  
• Experience on large-scale, iterative projects | Required experience | All requirements met
  
• Knowledge of Azure storage environments: Data Lake, Blob Storage, Azure Data Factory, Azure SQL Database, Synapse Analytics | List of examples | Sufficient majority required
  
• Knowledge of Power BI (Desktop, Service, Gateway) | Required experience | All prerequisites
  
• Knowledge of operational analytics | Required | All prerequisites
  
• Knowledge of data modeling | Required | All prerequisites
  
• Experience collaborating with architecture, development, product owner, and business experts | Required | All prerequisites
  

DESIRED

• Knowledge of the group insurance or life insurance sector | Required | All prerequisites
  
• Knowledge of ETL processes | Required | All prerequisites
  
• Familiarity with data modeling tools | Required | All prerequisites
  

ASSET

• Proficiency with BizzDesign as an enterprise architecture repository tool | Required | All prerequisites
  
• Previous experience at client or in a large-scale modernization program | Required | All Requirements
  

WHAT WE DON'T WANT

• Data engineer or developer profile without formal architecture experience (no delivered architecture products).
  
• Infrastructure architect profile only, without application or data layer experience.
  
• Candidate without Azure experience: an AWS-only or GCP-only profile is not suitable for the target environment.
  
• Junior or intermediate profile: the client explicitly requires 8+ years of experience.
  
• Candidate without experience working on architecture review or validation committees.