RQ11487 - Software Developer - ETL - Senior
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Posting language
- English
- Posted
Original job description
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
- Azure
Databricks
- Orchestration
& Ingestion:
- Proficiency
using Data Factory within Fabric to build complex, scalable data
pipelines.
- 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.
- Designing
efficient Direct Lake semantic models in Power BI using Silver/Gold layer
models to ensure high-speed reporting directly from OneLake.
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
- Azure
Databricks
- Orchestration
& Ingestion:
- Proficiency
using Data Factory within Fabric to build complex, scalable data
pipelines.
- 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.
- Designing
efficient Direct Lake semantic models in Power BI using Silver/Gold layer
models to ensure high-speed reporting directly from OneLake.
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.
More about this job
Responsibilities
Design and develop semantic models and Power BI reports to meet business KPIs and reporting requirements. Troubleshoot technical issues and collaborate with data analysts to implement scalable OLAP analytical solutions.
Requirements
Requires 6+ years of experience with Azure technologies including Databricks, DataLake Gen 2, and Power BI development. Proficiency in CI/CD, PySpark, and data modeling techniques like Star Schema or Snowflake is mandatory.
Skills
- Azure Databricks
- Azure DataLake Gen 2
- Power BI
- Semantic Modeling
- Azure DevOps
- CI/CD
- PySpark
- Microsoft Fabric
- Star Schema
- Snowflake
- Data Factory
- Direct Lake
- SQL
- Data Architecture
- Data Governance
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Software
- Technology
- Engineering
Keywords
- Azure
- Databricks
- DataLake Gen 2
- Power BI
- Semantic Modeling
- Azure DevOps
- CI/CD
- PySpark
- Microsoft Fabric
- Star Schema
- Snowflake
- Data Factory
- Direct Lake
- OneLake
- ETL
- Data Architecture
- Lakehouse
- Warehouse
- Medallion Architecture
- Data Governance
- Data Lineage
- SQL
- OLAP
- KPIs
- Reporting