RQ11487 – Software Developer – ETL – Senior

Interested in this role?Maarut • Toronto, Ontario
Apply Now

Website Maarut

Maarut Inc is a Canadian company helping organizations fulfill staffing solutions based on current, future and ongoing needs of market. Check out the new job openings https://careers.maarutinc.com/jobs/Careers Register …

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.

Apply Now Opens the employer application page in a new tab.