BI Data Engineer / Analyst
- Montreal, QC, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English · French
- Posted
Original job description
English section of this bilingual listing.
Compétences recherchées :
- Azure Synapse Analytics, ADLS Gen2, Azure Functions, Azure Storage.
- PySpark, Spark, SQL, langage R.
- Terraform, Azure DevOps, Git, YAML.
We are looking for a BI Data Engineer / Analyst to support data integration, analytics, and Business Intelligence projects within a Microsoft Azure environment.
Key Responsibilities:
- Design and optimize ETL/ELT pipelines using Azure Synapse and PySpark.
- Develop and maintain Medallion Data Architecture (Bronze, Silver, Gold).
- Automate Azure infrastructure using Terraform (IaC).
- Build interactive dashboards with Power BI and Power Query.
- Ensure data quality, security, and governance.
- Manage access controls (RBAC, ABAC, PBAC) and secrets using Azure Key Vault.
- Implement CI/CD pipelines using Azure DevOps and Git.
- Gather business requirements and prepare technical documentation.
Required Skills:
- Azure Synapse Analytics, ADLS Gen2, Azure Functions, Azure Storage.
- PySpark, Spark, SQL, R programming.
- Terraform, Azure DevOps, Git, YAML.
- Power BI, Power Query, and data modeling.
- Azure Monitor, Log Analytics, Entra ID, and Azure vNet.
- Knowledge of disaster recovery, replication, and RTO/RPO concepts.
- Strong analytical, communication, and problem-solving skills.
- Detail-oriented, independent, and organized.
Work Model: Hybrid – 2 days onsite and 3 days remote.
Read the full bilingual original
Ingénieur / Analyste de données BI | BI Data Engineer / Analyst
FRANÇAIS
Nous recherchons un(e) Ingénieur / Analyste de données BI pour accompagner des projets de valorisation des données, d'intégration et de Business Intelligence dans un environnement Microsoft Azure.
Responsabilités :
- Concevoir et optimiser des pipelines ETL/ELT avec Azure Synapse et PySpark.
- Développer et maintenir une architecture de données Medallion (Bronze, Silver, Gold).
- Automatiser les infrastructures Azure avec Terraform (IaC).
- Développer des tableaux de bord interactifs avec Power BI et Power Query.
- Assurer la qualité, la sécurité et la gouvernance des données.
- Gérer les accès (RBAC, ABAC, PBAC) et les secrets avec Azure Key Vault.
- Mettre en place des pipelines CI/CD avec Azure DevOps et Git.
- Participer à l'analyse des besoins métiers et à la rédaction des spécifications techniques.
Compétences recherchées :
- Azure Synapse Analytics, ADLS Gen2, Azure Functions, Azure Storage.
- PySpark, Spark, SQL, langage R.
- Terraform, Azure DevOps, Git, YAML.
- Power BI, Power Query et modélisation de données.
- Azure Monitor, Log Analytics, Entra ID et Azure vNet.
- Connaissances en résilience, réplication et reprise après sinistre (RTO/RPO).
- Bonnes capacités d'analyse, de communication et de vulgarisation.
- Rigueur, autonomie et souci du détail.
Mode de travail : Hybride – 2 jours au bureau et 3 jours en télétravail.
ENGLISH
We are looking for a BI Data Engineer / Analyst to support data integration, analytics, and Business Intelligence projects within a Microsoft Azure environment.
Key Responsibilities:
- Design and optimize ETL/ELT pipelines using Azure Synapse and PySpark.
- Develop and maintain Medallion Data Architecture (Bronze, Silver, Gold).
- Automate Azure infrastructure using Terraform (IaC).
- Build interactive dashboards with Power BI and Power Query.
- Ensure data quality, security, and governance.
- Manage access controls (RBAC, ABAC, PBAC) and secrets using Azure Key Vault.
- Implement CI/CD pipelines using Azure DevOps and Git.
- Gather business requirements and prepare technical documentation.
Required Skills:
- Azure Synapse Analytics, ADLS Gen2, Azure Functions, Azure Storage.
- PySpark, Spark, SQL, R programming.
- Terraform, Azure DevOps, Git, YAML.
- Power BI, Power Query, and data modeling.
- Azure Monitor, Log Analytics, Entra ID, and Azure vNet.
- Knowledge of disaster recovery, replication, and RTO/RPO concepts.
- Strong analytical, communication, and problem-solving skills.
- Detail-oriented, independent, and organized.
Work Model: Hybrid – 2 days onsite and 3 days remote.
More about this job
Responsibilities
Design and optimize ETL/ELT pipelines, maintain a Medallion data architecture, and automate Azure infrastructure. Build Power BI dashboards, support data quality and governance, manage access and secrets, implement CI/CD, and document business and technical requirements.
Requirements
The role requires experience with Azure data services, PySpark, Spark, SQL, R, Terraform, Azure DevOps, Git, Power BI, and data modeling. Candidates should understand access controls, monitoring, networking, resilience, replication, and disaster recovery, and demonstrate strong analytical, communication, organizational, and problem-solving skills.
Skills
- Azure Synapse Analytics
- ADLS Gen2
- Azure Functions
- Azure Storage
- PySpark
- Spark
- SQL
- R Programming
- Terraform
- Azure DevOps
- Git
- Power BI
- Power Query
- Data Modeling
- Data Governance
- Disaster Recovery
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Engineering
- Finance & Accounting
Keywords
- Microsoft Azure
- Azure Synapse Analytics
- ADLS Gen2
- Azure Functions
- Azure Storage
- ETL/ELT
- PySpark
- Spark
- SQL
- R Programming
- Medallion Architecture
- Bronze-Silver-Gold Layers
- Terraform
- Infrastructure as Code
- Power BI
- Power Query
- Data Modeling
- Data Quality
- Data Security
- Data Governance
- RBAC
- ABAC
- PBAC
- Azure Key Vault
- CI/CD
- Azure DevOps
- Git
- YAML
- Azure Monitor
- Log Analytics