Azure Data Engineer - ADF/PostgreSQL/Power BI
Posted Today by Creative Global Consulting
Negotiable
Undetermined
Remote
Remote
Summary: The Azure Data Engineer role focuses on expert-level data engineering to support enterprise value realization through Azure-based data architecture, integration, and analytics. The position involves designing and implementing Medallion Architecture pipelines in Azure Data Factory, optimizing PostgreSQL data models, and delivering actionable insights through Power BI dashboards. The role requires extensive experience and proficiency in Azure and related technologies. This is a remote position with a contract duration of over 12 months.
Key Responsibilities:
- Architect and implement ADF pipelines connecting varied internal and external data sources
- Design and configure network connections within ADF
- Build and support data and technical integration elements under an enterprise value realization framework
- Work with third-party tools and platforms; understand and extend existing data models
- Write and optimize complex SQL queries in PostgreSQL
- Develop custom tables, views, stored procedures, and functions for reporting support
- Connect Power BI to PostgreSQL; build and manage data models and relationships
- Develop interactive Power BI dashboards with drilldowns, bookmarks, and custom filters
- Collect, clean, and validate data from multiple source systems; ensure accuracy, completeness, and consistency
Key Skills:
- 12+ years of overall experience; expert-level proficiency required
- Azure deep platform expertise, mandatory
- Azure Data Factory (ADF) linking diverse data sources inside and outside network boundaries, creating network connections, mandatory
- Medallion Architecture design and implementation, mandatory
- PostgreSQL query design, optimization, custom tables/views/procedures/functions
- Power BI dashboard and report development, data modeling, custom filters/drilldowns/bookmarks
- Application architecture and integration
- API design and consumption
- Data analysis extraction, aggregation, transformation of large datasets
Salary (Rate): £44.00 hourly
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
Azure Data Engineer - ADF/PostgreSQL/Power BI
Client: Deloitte
POP: 12+ months
Location: Remote
SCOPE
Expert-level data engineering role supporting enterprise value realization through Azure-based data architecture, integration, and analytics. You'll design and implement Medallion Architecture pipelines in Azure Data Factory, build and optimize PostgreSQL data models, and deliver Power BI dashboards that translate complex datasets into actionable business insights.
REQUIRED SKILLS
- 12+ years of overall experience; expert-level proficiency required
- Azure deep platform expertise, mandatory
- Azure Data Factory (ADF) linking diverse data sources inside and outside network boundaries, creating network connections, mandatory
- Medallion Architecture design and implementation, mandatory
- PostgreSQL query design, optimization, custom tables/views/procedures/functions
- Power BI dashboard and report development, data modeling, custom filters/drilldowns/bookmarks
- Application architecture and integration
- API design and consumption
- Data analysis extraction, aggregation, transformation of large datasets
TASKS
- Architect and implement ADF pipelines connecting varied internal and external data sources
- Design and configure network connections within ADF
- Build and support data and technical integration elements under an enterprise value realization framework
- Work with third-party tools and platforms; understand and extend existing data models
- Write and optimize complex SQL queries in PostgreSQL
- Develop custom tables, views, stored procedures, and functions for reporting support
- Connect Power BI to PostgreSQL; build and manage data models and relationships
- Develop interactive Power BI dashboards with drilldowns, bookmarks, and custom filters
- Collect, clean, and validate data from multiple source systems; ensure accuracy, completeness, and consistency