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
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