The Role
Develops ETL pipelines, semantic data models, and Power BI reports using Azure and Microsoft Fabric. Transforms raw data through Bronze, Silver, and Gold layers; builds scalable ingestion and orchestration workflows; designs Direct Lake models, operational reports, and dashboards; writes optimized PySpark and SQL; troubleshoots data applications; and supports OLAP, data governance, security, and lineage requirements.
Summary Generated by Built In
Responsibilities:
- Analyze
data and design semantic models
- Transform
raw data into silver/gold data for reporting consumption.
- Design,
develop, and release deploy Power BI reports and dashboards meeting KPIs
including accuracy, reliability and performance.
- Review
business requirements (and related materials) to use as input for
design/development of reports
- Design
technical systems specifications to translate into working, tested
applications. This includes developing detailed programming
specifications, writing and/or generating code, compiling data-driven
programs, maintaining, and conducting unit tests.
- Resolves
and troubleshoots technical problems which arise during the use and
operation of software packages, including technical assistance in
implementation, conversion and migrations.
- Provide
specialized skills for developing data access queries
- Works
in conjunction with data analysts for developing dashboards and other end
user reporting products
- Supports
Client’s wide-ranging business information requirements, implementing and
supporting OLAP analytical software solutions
- Develops
and supports customized query applications which analyze key business data
Requirements
Experience and Skill Set Requirements:
Must Haves:
- 6+
years experience as Azure technologies including
- Azure
Databricks
- Azure
DataLake Gen 2.
- Power
BI development and semantic modeling
- Azure
DevOps CI/CD
- PySpark
- Microsoft
Fabric
- Star
Schema or Snowflake data modeling experience
- Orchestration
& Ingestion:
- Proficiency
using Data Factory within Fabric to build complex, scalable data
pipelines.
- Business
Intelligence:
- Designing
efficient Direct Lake semantic models in Power BI using Silver/Gold layer
models to ensure high-speed reporting directly from OneLake.
- Use
of semantic models to design and develop Power BI reports and dashboards.
Develop operational and analytical PowerBI reports/paginated reports.
Skill Set Requirements:
Mandatory Skills and Experience:
- 6+
years experience as Azure technologies including
- Azure
Databricks
- Azure
DataLake Gen 2.
- Power
BI development and semantic modeling
- Azure
DevOps CI/CD
- PySpark
- Microsoft
Fabric
- Star
Schema or Snowflake data modeling experience
- Orchestration
& Ingestion:
- Proficiency
using Data Factory within Fabric to build complex, scalable data
pipelines.
- Business
Intelligence:
- Designing
efficient Direct Lake semantic models in Power BI using Silver/Gold layer
models to ensure high-speed reporting directly from OneLake.
- Use
of semantic models to design and develop Power BI reports and dashboards.
Develop operational and analytical PowerBI reports/paginated reports.
Desirable Skills and Experience:
- Experience
in Azure Data Factory (ADF) v2
- Data
Architecture & Engineering: Competency in building Lakehouses and Warehouses, writing optimized PySpark or SQL pipelines,
and implementing Medallion architecture (Bronze/Silver/Gold layers).
- Data
Governance: Data security (row-level/column-level), and data lineage
tracking.
Skills Required
- 6+ years of experience with Azure technologies
- Azure Databricks experience
- Azure Data Lake Gen2 experience
- Power BI development and semantic modeling experience
- Azure DevOps CI/CD experience
- PySpark experience
- Microsoft Fabric experience
- Star Schema or Snowflake data modeling experience
- Proficiency using Data Factory within Fabric to build complex, scalable data pipelines
- Experience designing Direct Lake semantic models in Power BI using Silver and Gold layer models
- Experience developing operational, analytical, and paginated Power BI reports
- Azure Data Factory v2 experience
- Experience building Lakehouses and Warehouses
- Experience writing optimized PySpark or SQL pipelines
- Experience implementing Bronze, Silver, and Gold Medallion architecture
- Experience with row-level and column-level data security
- Experience with data lineage tracking
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Maarut Inc. is a Canadian company specializing in IT services, technology staffing, and software development, dedicated to assisting businesses with digital transformation and solving business challenges through technology.
