Azure Data Architect / ADF PostgreSQL Consultant | (GC)(USC) | Remote

Summary: The ADF PostgreSQL Consultant role focuses on designing and implementing data solutions on the Azure platform, specifically utilizing Azure Data Factory and PostgreSQL. The consultant will be responsible for developing data pipelines, managing network connectivity, and creating data models and reports using Power BI. This position requires collaboration with third-party platforms and participation in application architecture discussions. The role is fully remote, catering to candidates with relevant experience in data architecture and integration.

Key Responsibilities:

• Design and implement data solutions on Azure platform.
• Develop and manage Azure Data Factory pipelines connecting to multiple internal and external data sources.
• Create and manage network connectivity within ADF environments.
• Design and implement Medallion Architecture-based data platforms.
• Support enterprise value realization initiatives with data and technical integration solutions.
• Work with third-party platforms and understand existing data models.
• Design, write, optimize, and troubleshoot PostgreSQL queries.
• Extract, transform, and aggregate large datasets.
• Create custom tables, views, stored procedures, and functions.
• Develop Power BI dashboards and interactive reports.
• Build and maintain Power BI data models connected to PostgreSQL.
• Implement drilldowns, filters, bookmarks, and advanced reporting features.
• Perform data validation, cleansing, and quality assurance across multiple data sources.
• Participate in application architecture, integration, and API design discussions.

Key Skills:

• Azure
• Azure Data Factory (ADF)
• Medallion Architecture
• PostgreSQL
• Power BI
• Application Architecture
• Application Integration
• APIs
• Data Analysis

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT