Power BI & Data Analytics Engineer

Pavago; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Pavago is seeking a Power BI & Data Analytics Engineer to transform engineering specifications into interactive dashboards, automated reports, and data-driven insights for municipal water utilities.

You will build scalable Power BI solutions, data models, and reporting that connect multiple systems, with GIS integration and Azure-based pipelines to support real-time decision making. Collaborate with engineers to deliver actionable visuals that help clients optimize infrastructure.

Qualifications

• Advanced experience developing dashboards and reports with Power BI.
• Strong SQL querying, transforming, and modeling skills.
• Python for reporting, automation, or data processing.
• Hands-on experience with Esri GIS.
• Familiarity with Microsoft Azure and Azure Fabric.
• Experience with API integrations.
• Solid data modeling and BI best practices knowledge.
• Experience with time-series, geospatial, or asset management data.
• Strong analytical and problem-solving skills.
• Excellent written and verbal English communication.

Responsibilities

• Build and maintain Power BI dashboards and automated reports from specifications.
• Create scalable data models using SQL, Python, and Power BI.
• Integrate Esri GIS data and geospatial assets into dashboards.
• Develop APIs and cloud solutions using Azure to support reporting pipelines.
• Collaborate with engineers to translate requirements into actionable dashboards and improve systems.

Skills

Power BI

SQL

Python

Data Modeling

BI Best Practices

Time-series Data

Geospatial Data

Analytical Thinking

English Communication

Tools

Esri GIS

Azure

Azure Fabric

API Integrations

Job description

Power BI & Data Analytics Engineer

Position Type: Full-Time, Remote

Working Hours: U.S. Business Hours

About the Role

We are looking for a skilled Power BI & Data Analytics Engineer to transform engineering specifications into interactive dashboards, automated reports, and data-driven insights.

Our engineering team designs the logic, calculations, and reporting requirements behind each dashboard. Your role is to bring those specifications to life by building scalable Power BI solutions that utility clients rely on every day.

You'll work at the intersection of engineering and software-connecting data from multiple systems, building robust data models, and creating reporting solutions that help municipal water utilities better understand and manage their infrastructure.

If you enjoy solving complex data challenges, building high-quality reporting systems, and turning technical requirements into intuitive visualizations, we'd love to hear from you.

Responsibilities

Dashboard Development

• Build and maintain interactive dashboards and automated reports using Power BI. Convert engineering specifications into accurate, user-friendly reporting solutions. Design dashboards that present complex operational and infrastructure data in a clear and actionable format. Continuously improve existing dashboards based on client and internal feedback.

Data Modeling & Analytics

• Build scalable data models using SQL, Power BI, and Python. Transform large volumes of time-series, asset, and operational data into meaningful insights. Ensure data accuracy, consistency, and reporting reliability. Optimize dashboard performance and reporting efficiency.

GIS & Data Integration

• Integrate Esri GIS data into reporting solutions and visualizations. Combine geospatial, operational, and asset management data into unified dashboards. Develop mapping visualizations that support infrastructure planning and operational decision-making.

Cloud & API Development

• Work with Microsoft Azure and Azure Fabric to support reporting and data solutions. Develop and maintain API integrations that connect multiple business systems. Support automated data pipelines and reporting workflows.

Collaboration & Continuous Improvement

• Work closely with engineers to understand reporting requirements and technical calculations. Learn complex water utility concepts and translate them into easy-to-understand dashboards. Recommend improvements to reporting systems, data models, and development processes. Contribute to the ongoing evolution of the company’s reporting platform.

What Makes You a Strong Fit

You enjoy transforming complex technical data into meaningful business insights. You can quickly understand engineering concepts and convert them into reporting solutions. You are highly analytical and detail-oriented. You enjoy solving complex data problems through automation and visualization. You take ownership of your work and continuously look for ways to improve systems. You thrive in collaborative, fast-moving technical environments.

Required Experience & Skills

Must-Have

• Advanced experience developing dashboards and reports using Power BI.
• Strong proficiency in SQL for querying, transforming, and modeling data.
• Experience using Python for reporting, automation, or data processing.
• Hands-on experience with Esri GIS.
• Familiarity with Microsoft Azure and Azure Fabric.
• Experience working with API integrations.
• Strong understanding of data modeling and business intelligence best practices.
• Experience working with complex datasets such as time-series, geospatial, or asset management data.
• Strong analytical and problem-solving skills.
• Excellent written and verbal English communication skills.

Nice-to-Have

• Experience working within the water utility, engineering, infrastructure, environmental, or asset management industries.
• Experience developing frontend applications using React or Blazor.
• Familiarity with Reporting Hub, IconMaps, Figma, or ClickUp.
• Experience building automated reporting platforms for enterprise clients.

What Does a Typical Day Look Like

Your day begins by reviewing engineering specifications and project priorities before building new Power BI dashboards and reporting features.

You'll write SQL queries, create data models, integrate GIS and API data, automate reporting workflows with Python, and ensure dashboards accurately represent complex engineering calculations.

Throughout the day, you'll collaborate with engineers to clarify reporting requirements, troubleshoot data issues, optimize dashboard performance, and contribute ideas that improve the company's reporting platform.

By the end of the day, you've delivered reporting solutions that help municipal utility clients make smarter infrastructure decisions using real-time operational data.