Data Engineer – BI Developer

This is a fully remote position, open to applicants in Burundi, +1 more country.

📋 Description

• Develop intricate, high-performance T-SQL and SQL queries for data transformation, reporting layers, and stored procedures.

• Transition legacy SSIS packages to contemporary Microsoft Fabric equivalents while ensuring data integrity, performance, and maintainability.

• Design, create, and enhance ETL/ELT pipelines utilizing Microsoft Fabric and Azure Data Services.

• Construct, sustain, and refine Power BI reports and dashboards, encompassing semantic model design, DAX measures, and data modeling.

• Collaborate with client stakeholders to gather requirements, document data flows, and convert business needs into scalable technical solutions.

• Develop and oversee data models within Azure Synapse Analytics, Fabric Warehouses, or SQL Server environments.

• Monitor, troubleshoot, and optimize pipeline performance, data quality, and query execution across production and development environments.

• Engage in architecture discussions and contribute to solution design decisions for new client engagements.

• Document technical designs, pipeline logic, and data definitions for both technical and non-technical audiences.

⛳️ Requirements

• Over 5 years of experience in data engineering, BI development, or related roles.

• Proficient in SQL, T-SQL, SSIS, and similar technologies.

• Demonstrated experience in migrating SSIS packages to cloud-native ETL/ELT solutions; experience with Microsoft Fabric or Azure Data Factory is highly preferred.

• Strong practical experience with Microsoft Fabric, including Lakehouses, Data Warehouses, Pipelines, Dataflows Gen2, and Notebooks.

• Expertise in Power BI: report and dashboard development, DAX, data modeling, Power Query (M), and report publishing/workspace management.

• Hands-on experience with Azure Data Factory, Azure Data Lake Storage, Azure SQL Database, and/or Azure Synapse Analytics.

• Solid understanding of data warehouse concepts: dimensional modeling, star/snowflake schemas, and slowly changing dimensions.

• Experience working in Agile/Scrum delivery environments with multiple concurrent workstreams.

• Background in a client-facing consulting or professional services environment.

• Experience with Salesforce data integrations or Salesforce API consumption (REST/SOAP) is a plus.

• Familiarity with Python or PySpark for data transformation within Fabric Notebooks or Azure Databricks is advantageous.

• Exposure to machine learning workflows or Azure Machine Learning is a plus.

• Microsoft certifications DP-700, PL-300, DP-203, or equivalent are beneficial.

🏝️ Benefits

• Exceptional work environment recognized by Great Place To Work.

• Option for remote work.