Nasscomm

Data Specialist- (Azure Data Factory + PostgreSQL + Power BI)

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Specialist (Azure Data Factory + PostgreSQL + Power BI) on a 5-month remote contract, offering competitive pay. Candidates must possess strong skills in Azure Data Factory, PostgreSQL, SQL development, and Power BI, with experience in large datasets.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
May 2, 2026
🕒 - Duration
3 to 6 months
-
🏝️ - Location
Remote
-
📄 - Contract
Fixed Term
-
🔒 - Security
Unknown
-
📍 - Location detailed
United States
-
🧠 - Skills detailed
#Databases #Indexing #MySQL #Azure Data Factory #Data Engineering #Data Integration #Data Pipeline #Microsoft Power BI #Visualization #Data Layers #ADF (Azure Data Factory) #SQL (Structured Query Language) #SQL Server #BI (Business Intelligence) #Azure #Datasets #Data Analysis #PostgreSQL #"ETL (Extract #Transform #Load)" #SQL Queries
Role description
Position: Data Specialist (Azure Data Factory + PostgreSQL + Power BI) Location: Remote 100% Duration: 5 Months Contract Role Overview We are seeking a highly hands-on Data Specialist who combines the skills of a Data Engineer and Data Analyst. This role focuses on building data pipelines, analyzing large datasets, and generating actionable insights while working within enterprise data programs. The ideal candidate will be a self-driven individual contributor capable of working independently in a fast-paced environment, with strong expertise in Azure data tools, relational databases, and visualization. Key Responsibilities • Design, develop, and maintain data pipelines using Azure Data Factory (ADF) • Integrate and extract data from external and internal data sources (including cross-network and firewall environments) • Work extensively with PostgreSQL and other relational databases (MySQL, SQL Server) • Build and manage data layers (Medallion Architecture): • Raw / Staging Layer • Transformation Layer • Serving / Analytics Layer • Write, optimize, and tune complex SQL queries and stored procedures • Handle large-scale datasets (TB-level data, millions of rows) • Improve performance using: • Query tuning • Indexing strategies • Materialized views • Develop interactive dashboards and reports using Power BI • Create complex filters (date ranges, business units, industries, etc.) • Deliver dynamic, business-ready insights • Analyze datasets and derive data-driven insights • Collaborate with third-party data providers and internal stakeholders • Troubleshoot data pipeline, connectivity, and infrastructure issues independently Mandatory Skills • Strong hands-on experience with: • Azure Data Factory (ADF) – pipeline creation, integration, orchestration • PostgreSQL (must-have) • SQL development (advanced queries, stored procedures, performance tuning) • Power BI (advanced dashboards, filters, reporting) • Experience working with relational databases • Ability to work with large datasets (1TB+, millions of records) • Strong understanding of data pipeline architecture and ETL processes • Experience handling external data integrations across networks • Excellent problem-solving and troubleshooting skills • Strong communication skills (working with global teams, especially Europe)