PowerBI Developer

At TRC, we don’t just fill roles—we help build careers. We are partnered with a premier energy infrastructure leader that powers much of the Eastern Seaboard and is currently undergoing a major digital transformation. This organization is moving away from manual spreadsheet-driven reporting and toward a modern, automated analytics ecosystem powered by Google Cloud Platform and enterprise data integration.

This is an exciting opportunity to help shape that transformation by building the reporting and data infrastructure that drives compliance, operational visibility, and strategic decision-making.

Summary

We are seeking a skilled Power BI Developer to support a large-scale analytics modernization initiative within a critical infrastructure environment. This role will focus on replacing manual reporting processes with automated, enterprise-grade Power BI solutions while integrating key data sources such as PI Historian, Oracle, and GCP platforms like BigQuery and Cloud SQL.

The ideal candidate will bring strong Power BI expertise, hands-on GCP experience, and the ability to design scalable reporting solutions that support compliance, inventory tracking, and operational trend analysis.

Responsibilities

• Convert manual spreadsheet-driven reporting processes into automated Power BI dashboards


• Develop reporting for standard deviation analysis, gain/loss patterns, and operational trends


• Build and maintain ETL/ELT pipelines using GCP tools including BigQuery, Cloud SQL, and Dataflow


• Integrate enterprise data sources such as Oracle and PI Historian for real-time analytics


• Deliver standardized reporting designed for compliance, audits, and operational reviews


• Create scalable dashboards and reporting solutions for business stakeholders


• Write and optimize complex SQL queries for data extraction and transformation


• Collaborate with business users and technical teams to improve reporting processes and data quality


• Ensure data integrity, governance, and reporting accuracy across platforms


• Requirements


• 3–6 years of dedicated experience in Power BI development


• Expert-level proficiency in Power BI, including DAX, Power Query, and Power BI Service


• Hands-on experience with Google Cloud Platform, specifically BigQuery


• Strong SQL skills with the ability to write complex queries and transformations


• Experience building ETL/ELT pipelines in cloud-based environments


• Experience integrating enterprise data sources such as Oracle and PI Historian preferred


• Strong analytical and problem-solving skills


• Excellent communication and stakeholder collaboration abilities


• Bachelor’s degree in Computer Science, Data Analytics, or a related field preferred


• TRC is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected status.