Azure Data Engineer With Power BI Experience - Remote

Azure Data Engineer With Power BI Experience - Remote

Posted 1 day ago by The Dignify Solutions, LLC

Negotiable
Undetermined
Remote
Remote

Summary: The Azure Data Engineer role focuses on designing and implementing scalable ETL/ELT pipelines using Azure Data Factory, alongside developing high-performance Power BI dashboards and analytical reports. The position requires expertise in data integration frameworks, data governance, and advanced SQL development. The role is remote, catering to professionals with a strong background in Azure data platforms and Power BI. Candidates should be prepared to manage complex data architectures and optimize data pipelines for enterprise-level reporting.

Key Responsibilities:

  • Design and implement scalable ETL/ELT pipelines using Azure Data Factory.
  • Build automated data ingestion pipelines from multiple enterprise systems, APIs, and data lakes.
  • Implement incremental loads, CDC frameworks, and automated data orchestration workflows.
  • Develop reusable data integration frameworks to standardize ingestion patterns.
  • Develop high-performance Power BI dashboards and analytical reports for business and executive leadership.
  • Build complex DAX calculations, measures, and KPIs.
  • Manage Power BI Service workspace architecture and deployment pipelines.
  • Implement Power BI data governance and best practices.
  • Design enterprise data warehouse and data mart architectures.
  • Implement dimensional modeling (Star/Snowflake schema).
  • Develop advanced SQL queries, stored procedures, and functions.

Key Skills:

  • Power BI Desktop development
  • Power BI Service administration
  • Advanced DAX development
  • Power BI data modeling
  • Dataset optimization
  • Power BI gateways
  • Power BI deployment pipelines
  • Power BI REST API integration
  • Azure Data Factory pipeline development
  • Data orchestration and scheduling
  • Azure Data Lake
  • Azure Synapse
  • Azure Storage
  • Advanced SQL and T-SQL
  • Stored procedures and functions
  • Query optimization
  • Data warehousing design

Salary (Rate): £50 hourly

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Key Responsibilities

  • Design and implement scalable ETL/ELT pipelines using Azure Data Factory.
  • Build automated data ingestion pipelines from multiple enterprise systems, APIs, and data lakes.
  • Implement incremental loads, CDC frameworks, and automated data orchestration workflows.
  • Develop reusable data integration frameworks to standardize ingestion patterns.
  • Develop high-performance Power BI dashboards and analytical reports for business and executive leadership.
  • Build complex DAX calculations, measures, and KPIs.
  • Manage Power BI Service workspace architecture and deployment pipelines.
  • Implement Power BI data governance and best practices.
  • Design enterprise data warehouse and data mart architectures.
  • Implement dimensional modeling (Star/Snowflake schema).
  • Develop advanced SQL queries, stored procedures, and functions.

Azure Data Platform Development

  • Azure Data Factory
  • Azure Data Lake Storage
  • Azure SQL Database
  • Azure Synapse Analytics
  • Azure DevOps
  • Monitor and optimize data pipelines and Power BI datasets.
  • Ensure high-performance reporting for large enterprise datasets.
  • Troubleshoot Power BI refresh failures and query performance issues.

Required Technical Skills

  • Power BI Desktop development
  • Power BI Service administration
  • Advanced DAX development
  • Power BI data modeling
  • Dataset optimization
  • Power BI gateways
  • Power BI deployment pipelines
  • Power BI REST API integration
  • Azure Data Factory pipeline development
  • Data orchestration and scheduling
  • Azure Data Lake
  • Azure Synapse
  • Azure Storage
  • Advanced SQL and T-SQL
  • Stored procedures and functions
  • Query optimization
  • Data warehousing design

Preferred Experience

  • Experience building enterprise BI platforms serving 500+ users
  • Experience with Power BI governance frameworks
  • Experience integrating Power BI with Azure Synapse or Databricks
  • Experience building self-service BI platforms
  • Microsoft Power BI Data Analyst (PL-300)
  • Microsoft Azure Data Engineer (DP-203)