Movojobs
Back to results

Added

Closed listing

Aaura Softwares

Data Fabric Architect(Strong Fabric Experience is must)

  • Canada

Contract

This opening has closed.

The original listing is kept below for reference.

Find open jobsMore jobs with this employer
About employer

Job details

Job type
Contract
Posting language
English
Posted

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

Role Summary

You are the end-to-end technical authority for our analytics estate - from Oracle/JD Edwards source systems through ingestion, Lakehouse and semantic layer, to certified Power BI data products. The role spans the full Microsoft Fabric stack and enterprise Power BI architecture, with a hands-on build component alongside the design work.

What You'll Do

  • Own the target-state Fabric architecture: workspace/domain topology, OneLake structure, medallion layering, and Lakehouse vs. Warehouse vs. Eventhouse decisions.
  • Design and build Fabric Data Factory pipelines and Spark notebooks (PySpark/Spark SQL) metadata-driven ingestion, orchestration, Delta table optimisation, error handling and monitoring.
  • Architect ingestion from Oracle / JD Edwards: incremental and CDC extraction, gateway connectivity, reconciliation back to ERP source-of-truth.
  • Architect enterprise semantic models - star schemas, Direct Lake vs. Import vs. Direct Query, advanced DAX, performance tuning at scale.
  • Define Power BI governance: RLS/OLS, Entra ID group strategy, certified datasets, workspace and tenant settings, gateways, licensing.
  • Establish CI/CD via Fabric Git integration and deployment pipelines, own Fabric capacity sizing, monitoring and cost optimization.
  • Set standards, review code and architecture, and mentor engineers, BI developers and analysts.

Must Have

  • Microsoft Fabric, full stack, hands-on: One Lake, Lakehouse/Delta, Warehouse, Data Factory pipelines, Dataflows Gen2, Notebooks, semantic models, Direct Lake.
  • Power BI at architect level (6+ yrs): dimensional modelling, advanced DAX and optimization, RLS/OLS, enterprise governance and ALM.
  • Oracle Database: strong SQL and PL/SQL, query tuning, and proven extraction from large normalized ERP schemas.
  • Advanced SQL, solid Python, Spark tuning, Git-based CI/CD.
  • Azure fundamentals (Entra ID, ADLS Gen2, Key Vault) and Fabric admin/security model.
  • Clear communication with both engineering and business stakeholders; strong documentation discipline.

Good to Have

  • JD Edwards EnterpriseOne functional knowledge - Finance, Distribution and/or Manufacturing; familiarity with F-tables (F0911, F4211, F0411), UDCs, Julian dates and JDE data conventions.
  • Microsoft certifications : DP-600 / DP-700, PL-300.
  • Experience migrating legacy data and analytics platforms to Fabric
About employer
More about this job

Responsibilities

Own the end-to-end Microsoft Fabric and Power BI architecture, including ingestion from Oracle and JD Edwards, Lakehouse and semantic layers, governance, security, and certified data products. Build and optimize pipelines, notebooks, models, and CI/CD processes while setting technical standards, managing capacity and costs, and mentoring engineering and analytics teams.

Requirements

Requires hands-on expertise across the Microsoft Fabric stack and architect-level Power BI experience, including dimensional modeling, advanced DAX, governance, and performance optimization. Also requires strong Oracle SQL and PL/SQL, Python and Spark skills, Git-based CI/CD, Azure fundamentals, and clear communication; JD Edwards knowledge and relevant Microsoft certifications are advantageous.

Skills

  • Microsoft Fabric
  • Power BI
  • Oracle Database
  • JD Edwards
  • SQL
  • PL/SQL
  • Python
  • Apache Spark
  • Data Factory
  • Lakehouse Architecture
  • Delta Lake
  • Semantic Modeling
  • Advanced DAX
  • Data Governance
  • Git-Based CI/CD
  • Azure Entra ID

Visa sponsorship

Not detected in the job text

Categories

  • Data & Analytics
  • Technology
  • Software
  • Engineering

Keywords

  • Microsoft Fabric
  • Power BI
  • OneLake
  • Lakehouse
  • Delta Lake
  • Fabric Data Factory
  • Dataflows Gen2
  • Spark Notebooks
  • PySpark
  • Spark SQL
  • Oracle Database
  • JD Edwards EnterpriseOne
  • PL/SQL
  • Incremental Extraction
  • Change Data Capture
  • Dimensional Modeling
  • Star Schemas
  • Direct Lake
  • DAX
  • Row-Level Security
  • Object-Level Security
  • Microsoft Entra ID
  • Azure Data Lake Storage Gen2
  • Azure Key Vault
  • Git Integration
  • Deployment Pipelines
  • CI/CD
  • DP-600
  • DP-700
  • PL-300

Report this job