Data Analyst - Water Infrastructure

Pavago; Philippines; Remote; PHP 600,000 - 900,000; Full time

Job summary

Pavago is seeking a Business Intelligence Developer (Power BI & GIS) to build advanced analytics solutions, dashboards, and reporting systems for utility and infrastructure data. The role is remote with US business hours.

You will transform time-series, geospatial, and asset data into Power BI dashboards, automate reporting, and collaborate with product and engineering teams to deliver scalable reporting solutions.

Qualifications

• Advanced proficiency with Power BI.
• Experience with time-series data and geospatial data.
• Proven dashboard development and automated reporting experience.
• Experience integrating GIS data into BI.
• Strong analytical and problem‑solving skills.
• Ability to translate complex concepts into clear reporting.

Responsibilities

• Design and develop advanced Power BI dashboards and reports.
• Build scalable data models for large datasets.
• Transform time-series, geospatial, and asset data into visualizations.
• Develop automated reporting solutions that support decisions.
• Optimize dashboard performance and usability.
• Collaborate with product, engineering, and business teams.
• Test and deploy dashboard updates.

Skills

Power BI

Esri GIS

SQL

Python

APIs

Tools

Power BI

Esri GIS

SQL

Python

REST APIs

Job description

Business Intelligence Developer (Power BI & GIS) – Remote

Position Type: Full-Time, Remote
Working Hours: U.S. Business Hours

About the Role

At Pavago, one of our clients is hiring a Business Intelligence Developer to build advanced analytics solutions, dashboards, and reporting systems that help utility organizations make smarter infrastructure decisions.

This is a highly technical role focused on transforming time-series, geospatial, and asset data into scalable Power BI dashboards, automated reporting systems, and actionable business insights. You’ll work with modern Microsoft technologies, GIS platforms, and cloud infrastructure to deliver solutions that improve operational visibility and decision-making.

If you’re passionate about data visualization, geospatial analytics, and solving complex business problems through data, this role is a strong fit.

What You’ll Own

Business Intelligence & Dashboard Development

• Design and develop advanced Power BI dashboards and reports.
• Build scalable data models for large operational datasets.
• Transform complex time-series, geospatial, and asset data into meaningful visualizations.
• Develop automated reporting solutions that support business decision-making.
• Optimize dashboard performance, usability, and reliability.

Data Modeling & Analytics

• Build robust data models using:
• SQL
• Python
• Power BI
• Analyze complex operational datasets and generate actionable insights.
• Ensure data accuracy, consistency, and reporting integrity.
• Support advanced analytics across multiple business functions.

GIS & Geospatial Analytics

• Develop reporting solutions using Esri GIS.
• Integrate geospatial datasets into Power BI reporting.
• Create visualizations that support infrastructure planning and asset management.
• Help simplify complex utility and engineering concepts into user-friendly reporting.

Azure & System Integrations

• Develop cloud-based reporting solutions using:
• Microsoft Azure
• Microsoft Fabric
• Build integrations using APIs and cloud services.
• Maintain scalable reporting infrastructure.
• Support automation and data synchronization across business systems.

Collaboration & Product Development

• Collaborate with product, engineering, and business teams.
• Translate technical requirements into scalable reporting solutions.
• Contribute to continuous improvement of reporting platforms.
• Support UI and reporting enhancements using design specifications.

What Success Looks Like

• High-quality dashboards are delivered on schedule.
• Reporting systems remain reliable and scalable.
• Backlog tickets and feature requests are resolved efficiently.
• Stakeholders confidently use reporting to support decision-making.
• Existing systems are continuously improved to meet evolving client needs.
• Complex infrastructure data becomes easy to understand and act upon.

What Makes You a Strong Fit

• You enjoy solving complex analytical problems.
• You’re comfortable working with large, structured datasets.
• You can simplify technical information into meaningful business insights.
• You enjoy combining geospatial analytics with business intelligence.
• You’re curious, detail-oriented, and continuously looking for better solutions.
• You’re motivated by building products that create measurable real-world impact.

Required Experience & Skills

Experience

• Advanced proficiency with Power BI.
• Strong experience using:
• SQL
• Python
• Business Intelligence tools
• Proven experience developing dashboards and automated reporting solutions.
• Experience working with:
• Time-series data
• Geospatial data
• Asset management datasets
• Strong analytical and problem-solving skills.
• Ability to translate complex technical concepts into clear reporting solutions.

Nice to Have

• Experience with Esri GIS (strongly preferred).
• Familiarity with:
• Microsoft Azure
• Microsoft Fabric
• API integrations
• Experience within:
• Water infrastructure
• Utilities
• Engineering
• Experience with:
• React
• Blazor
• Interest in using data to improve public infrastructure and utility operations.

Tech Stack

• Power BI
• Esri GIS
• Microsoft Azure
• Microsoft Fabric
• SQL
• Python
• Reporting Hub
• IconMaps
• Figma
• ClickUp
• REST APIs

What a Typical Day Looks Like

• Build and optimize Power BI dashboards.
• Analyze time-series and geospatial datasets.
• Develop SQL queries and Python scripts for reporting.
• Integrate GIS data into business intelligence solutions.
• Collaborate with engineering and product teams.
• Resolve feature requests and improve reporting systems.
• Test and deploy dashboard updates.
• Continuously improve data quality, automation, and performance.

In short: You’ll transform complex infrastructure and geospatial data into intuitive dashboards and reporting solutions that help utility organizations make better operational and investment decisions.

Key Metrics for Success (KPIs)

• Number of dashboards successfully delivered.
• Feature requests and backlog items completed.
• On-time project delivery.
• Dashboard performance and reliability.
• Stakeholder adoption and satisfaction.
• Reporting accuracy and usability.
• Continuous improvement of reporting systems.

Why This Role Stands Out

• Work on meaningful projects that support critical public infrastructure.
• Combine business intelligence, GIS, cloud technologies, and advanced analytics.
• Opportunity to work with modern Microsoft technologies and geospatial platforms.
• Direct impact on how cities and utility organizations make infrastructure decisions.
• Career progression into:
• Senior BI Developer
• Data Analytics Lead
• Solutions Architect
• Data Engineering Manager

Interview Process

1. Application Review
2. Spark Hire Intro Video (3–5 minutes)
3. Technical Interview
4. Technical Assessment
5. Final Interview
6. Offer & Onboarding