Back to results

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
  • 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.

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

Report this job