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
Application Review
Spark Hire Intro Video (3–5 minutes)
Technical Interview
Technical Assessment
Final Interview
Offer & Onboarding
What Happens After You Apply
After submitting your application, you'll receive an email invitation from
Spark Hire
to record a short
3–5 minute Intro Video
. This is the first step in our hiring process and can be completed whenever it's convenient for you.
Instead of multiple screening calls, you'll have one opportunity to introduce yourself, discuss your experience with Power BI, SQL, Python, GIS, and Azure technologies, and explain how you've transformed complex datasets into actionable dashboards and reporting solutions. You'll also have the opportunity to highlight your analytical thinking, technical problem-solving skills, and experience building scalable business intelligence solutions. Your video will be reviewed by the hiring team before moving forward to the technical interview.
You can record your video as many times as you'd like before submitting it—only your final version will be reviewed.
Please keep an eye on both your
inbox
and
spam folder
for your Spark Hire invitation after applying.
Apply Now
If you're passionate about business intelligence, geospatial analytics, and building data solutions that drive smarter infrastructure decisions, we'd love to hear from you. Apply today and help transform complex data into meaningful insights that create real-world impact.
Requirements

📌 Data Analyst - Water Infrastructure (México)
🏢 Reconocida empresa
📍 México