PostgreSQL

PostgreSQL

Posted 1 day ago by 1766054305

Negotiable
Outside
Remote
USA

Summary: The PostgreSQL position focuses on data architecture, modeling, and analysis, requiring expertise in SQL query optimization and Power BI dashboard development. The role involves creating custom tables and functions to enhance data reporting and visualization. The individual will work remotely and is expected to support enterprise data integration activities. The position is classified as outside IR35.

Key Responsibilities:

  • Support enterprise value realization framework activities related to data and technical integration
  • 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 for clear and interactive data presentation
  • Connect Power BI to PostgreSQL to manage data models and relationships
  • Implement custom filters, drilldowns, and bookmarks to enhance user experience
  • Collect, clean, and validate data from multiple source tables

Key Skills:

  • PostgreSQL
  • Data Analysis
  • Data Architecture
  • Data Modeling
  • SQL
  • Dashboard
  • Reporting
  • Microsoft Power BI
  • Software Architecture
  • User Experience

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

PostgreSQL

Introduction:

The PostgreSQL position involves working with data architecture, data modeling, and data analysis within the team. The individual will be responsible for designing, optimizing SQL queries in PostgreSQL, creating custom tables, views, and functions, as well as developing Power BI dashboards and reports for effective data visualization.

Responsibilities:

  • Support enterprise value realization framework activities related to data and technical integration
  • 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 for clear and interactive data presentation
  • Connect Power BI to PostgreSQL to manage data models and relationships
  • Implement custom filters, drilldowns, and bookmarks to enhance user experience
  • Collect, clean, and validate data from multiple source tables

Requirements:

Required Skills:

  • PostgreSQL
  • Data Analysis
  • Data Architecture
  • Data Modeling
  • SQL
  • Dashboard
  • Reporting
  • Microsoft Power BI
  • Software Architecture
  • User Experience