ADF PostgreSQL

Job Title: ADF PostgreSQL

Location: Remote

Long Term Contract

• Expertise in Azure

• Expertise in Azure Data factory, linking with various data sources, within and outside the network structure.  Should be capable of creating network connections in ADF

• Expertise in Medallion Architecture

• Work to support enterprise value realization framework activities to help:

o Data and technical integration elements

o Detailed designs and implementations

• Work with third party tools and platforms and understand existing data model

• Design, write, and optimize SQL queries in PostgreSQL

• Extract, aggregate and transform large data sets

• Create custom tables, views, procedures, and functions to support reporting

• Develop Power BI dashboards and reports that present datasets in clear, intuitive, and interactive way

• Connect Power BI to PostgreSQL to build and manage data models and relationships

• Implement custom filters, drilldowns, and bookmarks to enhance user experience

• Collect, clean, and validate data from multiple source tables and ensure accuracy, completeness, and consistency are maintained