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 project-related 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 project-related 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 decision-making 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 ad-hoc data queries, data mining, and data profiling activities to extract actionable insights from project data and support project management decision-making.
3. Develop data-driven 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 cross-functional teams, including project managers, data analysts, and IT professionals, to understand data requirements, gather feedback, and deliver data-driven 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 end-users on Power BI usage, best practices, and data visualization techniques to promote self-service analytics and user adoption.