Power BI - Database Warehouse Developer

General Description of Role and Responsibilities:

• Data Warehouse Development:
1. Design develop and maintain data warehouse solutions to support the storage integration and retrieval of projectrelated data from disparate sources.
2. Define data modeling strategies data structures and ETL processes to ensure data integrity consistency and quality within the data warehouse environment.
3. Implement data governance policies standards and procedures to enforce data quality security and compliance requirements.
• Power BI Development:
1. Create visually appealing and interactive Power BI dashboards reports and visualizations to present projectrelated data and insights in a meaningful and actionable manner.
2. Collaborate with project stakeholders to gather reporting requirements define KPIs and design data visualizations that address their information needs and support decisionmaking processes.
3. Customize and configure Power BI features functionalities and data connectors to integrate with various data sources and systems.
• Data Analytics and Insights:
1. Perform data analysis trend analysis and predictive modeling using Power BI and other analytical tools to identify patterns trends and opportunities for process improvement and optimization.
2. Conduct adhoc data queries data mining and data profiling activities to extract actionable insights from project data and support project management decisionmaking.
3. Develop datadriven recommendations insights and reports to facilitate strategic planning risk assessment and performance monitoring across water and wastewater projects.
• Database Management and Optimization:
1. Administer and optimize database systems including SQL Server Oracle or other relational database management systems (RDBMS) to ensure data availability performance and scalability.
2. Monitor database performance conduct performance tuning and implement indexing strategies to enhance query performance and optimize data retrieval operations.
3. Implement backup and recovery procedures data security measures and disaster recovery solutions to safeguard project data and ensure business continuity.
• Collaboration and Documentation:
1. Collaborate with crossfunctional teams including project managers data analysts and IT professionals to understand data requirements gather feedback and deliver datadriven solutions that meet project objectives.
2. Document technical specifications data models and solution architectures to ensure clarity consistency and maintainability of data warehouse and Power BI solutions.
3. Provide training and support to endusers on Power BI usage best practices and data visualization techniques to promote selfservice analytics and user adoption.

Qualifications Experience Knowledge and Skills:

• Minimum of 5 years of work experience.
• Wellversed with BItools.
• Oracle Primavera and ERP technical background.
• Technical Back group and Oracle DBA experiences.

Remote Work :

No