Data Engineer – Microsoft Fabric & Azure (Remote, Pakistan · UK hours)

Company Description

Amesium Analytics is a UK-based Microsoft data consultancy, part of Amesium Ltd, delivering Microsoft Fabric, Azure, Databricks and Power BI solutions for UK organisations. Our engagements are principal-led: our UK-based Principal Consultant (10+ years across energy, drinks, housebuilding, public sector and retail) owns the client relationship, architecture and standards, supported by a small team of skilled data engineers delivering against a statement of work with clear milestones, sign-offs and handover. We work differently from a big consultancy: one principal leads every project end to end.

Alongside data platforms, we build web and mobile apps on Azure that read from and act on our clients' data.

What We Build

Our projects follow a modern Microsoft data architecture, from source to dashboard:

- Sources: ERP and CRM systems, SQL databases, files and REST APIs

- Ingestion: Azure Data Factory, Fabric Data Pipelines and API ingestion

- Store and shape: Fabric Lakehouse and Warehouse, OneLake, Databricks, PySpark and Delta

- Model: semantic models, business logic and KPIs

- Use: Power BI reports, dashboards and self-service analytics

Across the stack: security, governance, data quality, Azure DevOps CI/CD and documentation. We also run platform health checks (architecture, pipelines, data quality, cost and security) and migrations to Fabric.

Role Description

We're building our delivery team and are looking for experienced Microsoft Fabric / Azure Data Engineers to work alongside our Principal Consultant on live UK client projects. You'll be part of a small team (Principal + 1–2 engineers) delivering end-to-end data platforms, from health checks and architecture plans through to build, reporting and handover.

This is a hands-on, coding-heavy delivery role, not a support desk. You'll own pieces of the build from start to finish, work to the Principal Consultant's architecture and engineering standards, and see your work go into production. All code lives in Azure DevOps with CI/CD from day one. The Principal Consultant manages the client; you focus on high-quality delivery.

Key Responsibilities

- Build, schedule and monitor pipelines in Fabric Data Factory, Azure Data Factory and Azure Synapse

- Build medallion (bronze / silver / gold) layers in Fabric Lakehouse and Warehouse (OneLake)

- Develop PySpark and Spark SQL notebooks to clean, join and transform data (Databricks a plus)

- Write efficient T-SQL: views, stored procedures and incremental loads

- Design dimensional (Kimball / star schema) models and Power BI semantic models

- Build and support Power BI reports and dashboards, and write and optimise DAX

- Put data quality checks, logging and alerting in place

- Support platform health checks and migrations to Fabric (e.g. from Synapse, SQL Server or on-premise SSIS)

- Investigate and fix performance issues in pipelines, SQL and Power BI models

- Work in Azure DevOps: Git branching, pull requests, boards and CI/CD releases

- Write documentation, runbooks and handover notes clients can use after handover

- Join daily stand-ups and client calls in English during UK hours

Required Skills

- 3–5 years' experience in data engineering, with at least 2 years on Azure or Microsoft Fabric

- At least one Microsoft data engineering certification, such as:

- DP-700: Microsoft Certified: Fabric Data Engineer Associate

- DP-600: Microsoft Certified: Fabric Analytics Engineer Associate

- DP-203: Microsoft Certified: Azure Data Engineer Associate

No certification? You can still apply with proven hands-on experience – share real pipelines, models or a GitHub portfolio, and complete a short practical task.

- Microsoft Fabric (Lakehouse, Warehouse, Pipelines, Notebooks)

- Hands-on Azure Data Factory or Fabric pipelines (and/or Azure Synapse)

- Strong SQL and Python (PySpark)

- Data modelling: star schema, facts, dimensions, slowly changing dimensions; ETL/ELT and data warehousing

- Git and CI/CD, ideally in Azure DevOps

- Clear written and spoken English, comfortable on calls with UK clients

- Committed to UK hours every weekday, with at least 2 monitors, reliable high-speed internet and a backup power supply (UPS or generator)

Nice to Have

- Databricks and Delta Lake

- Power BI and DAX

- Data governance with Microsoft Purview

- Infrastructure as code (Bicep or Terraform)

- Experience with Synapse-to-Fabric migrations

- Previous experience with UK, European or US clients

- Azure app or API work (Azure SQL, PostgreSQL, Azure Functions)

What We Offer

- PKR 3,00,000 per month, fixed and paid on time every month

- Fully remote, with no commute

- Real UK client projects on Microsoft Fabric, the newest Microsoft data platform

- Direct mentoring from a senior Principal Consultant, not a long chain of managers

- Ownership of real deliverables in a small team where your work is seen and valued

- Support towards a Microsoft certification if you don't hold one yet

- Long-term potential as our client work grows

Engagement Details

- Location: Remote – Pakistan

- Type: Full-time contract

- Pay: PKR 3,00,000 per month, fixed, paid monthly

- Hours: Monday to Friday, 9:00am–5:00pm UK time (2:00pm–10:00pm PKT in winter, 1:00pm–9:00pm PKT in summer)

- Experience: 3–5 years, at least 2 on Azure or Microsoft Fabric

- Your CV may be shared (with your consent) with UK clients before you join a project

- Confidentiality / NDA required for client work

How to Apply

Apply through LinkedIn with your CV. Please include:

- Your Microsoft certification(s), with your Microsoft Learn credential link – or work examples / portfolio if you don't have one

- A short note on one data project you're proud of: the stack you used and your part in it

- Confirmation that you can work 9:00am–5:00pm UK time

- Your notice period

Our process: a short screening call, a practical task (about 2 hours), then a technical interview with our Principal Consultant.