Power BI - Database Warehouse Developer

Are you ready to elevate your career with a global leader in construction consulting? Hill International is seeking talented and motivated professionals to join our team! With projects spanning various sectors and locations, Hill International offers a dynamic and stimulating work environment where innovation, collaboration, and excellence are our core values.

Hill International provides comprehensive program, project, and construction management services for clients across diverse sectors undertaking major construction projects worldwide. Our expertise includes cost engineering and estimating, quality assurance, inspection, scheduling, risk management, and claims avoidance. To learn more about Hill International, please visit our website at www.hillintl.com.

We are committed to delivering exceptional project management services and solutions globally. Whether you are an experienced project manager, engineer, or a recent graduate eager to launch your career in the construction industry, we have opportunities that will both challenge and inspire you.

Join us and be part of a team that's shaping the future of the construction industry!

Job Overview:

We are seeking a talented and experienced Power BI / Database Warehouse Developer to join our water and wastewater projects team. The successful candidate will be responsible for developing and maintaining data warehouse solutions, designing and implementing Power BI dashboards and reports, and providing data analytics support to drive informed decision-making and enhance project performance.

General Description of Role and Responsibilities:

Data Warehouse Development:

a. Design, develop, and maintain data warehouse solutions to support the storage, integration, and retrieval of project-related data from disparate sources.

b. Define data modeling strategies, data structures, and ETL processes to ensure data integrity, consistency, and quality within the data warehouse environment.

c. Implement data governance policies, standards, and procedures to enforce data quality, security, and compliance requirements.

Power BI Development:

a. Create visually appealing and interactive Power BI dashboards, reports, and visualizations to present project-related data and insights in a meaningful and actionable manner.

b. Collaborate with project stakeholders to gather reporting requirements, define KPIs, and design data visualizations that address their information needs and support decision-making processes.

c. Customize and configure Power BI features, functionalities, and data connectors to integrate with various data sources and systems.

Data Analytics and Insights:

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

b. Conduct ad-hoc data queries, data mining, and data profiling activities to extract actionable insights from project data and support project management decision-making.

c. 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:

a. Administer and optimize database systems, including SQL Server, Oracle, or other relational database management systems (RDBMS), to ensure data availability, performance, and scalability.

b. Monitor database performance, conduct performance tuning, and implement indexing strategies to enhance query performance and optimize data retrieval operations.

c. Implement backup and recovery procedures, data security measures, and disaster recovery solutions to safeguard project data and ensure business continuity.

Collaboration and Documentation:

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

b. Document technical specifications, data models, and solution architectures to ensure clarity, consistency, and maintainability of data warehouse and Power BI solutions.

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

Qualifications, Experience, Knowledge and Skills:

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