Power BI - Database Warehouse Developer

• Data Warehouse Development:
• Design, develop, and maintain data warehouse solutions to support the storage, integration, and retrieval of project-related data from disparate sources.
• Define data modeling strategies, data structures, and ETL processes to ensure data integrity, consistency, and quality within the data warehouse environment.
• Implement data governance policies, standards, and procedures to enforce data quality, security, and compliance requirements.
• Power BI Development:
• Create visually appealing and interactive Power BI dashboards, reports, and visualizations to present project-related data and insights in a meaningful and actionable manner.
• Collaborate with project stakeholders to gather reporting requirements, define KPIs, and design data visualizations that address their information needs and support decision-making processes.
• Customize and configure Power BI features, functionalities, and data connectors to integrate with various data sources and systems.
• Data Analytics and Insights:
• 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.
• Conduct ad-hoc data queries, data mining, and data profiling activities to extract actionable insights from project data and support project management decision-making.
• 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:
• Administer and optimize database systems, including SQL Server, Oracle, or other relational database management systems (RDBMS), to ensure data availability, performance, and scalability.
• Monitor database performance, conduct performance tuning, and implement indexing strategies to enhance query performance and optimize data retrieval operations.
• Implement backup and recovery procedures, data security measures, and disaster recovery solutions to safeguard project data and ensure business continuity.
• Collaboration and Documentation:
• 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.
• Document technical specifications, data models, and solution architectures to ensure clarity, consistency, and maintainability of data warehouse and Power BI solutions.
• 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.

• Minimum of 5 + years of work experience.
• Well-versed with BI-tools.
• Oracle Primavera and ERP technical background.
• Technical Back group and Oracle DBA experiences.

Hill International