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
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)