Senior Power BI Developer

Chesapeake Utilities Corp

Newark, DE

JOB DETAILS
SKILLS
Analysis Skills, Asset Management, Best Practices, Business Intelligence, Business Solutions, Capacity Management, Cloud Computing, Coaching, Communication Skills, Computer Science, Cross-Functional, Data Analysis, Data Lake, Data Modeling, Data Processing, Data Quality, Data Science, Data Storage, Database Extract Transform and Load (ETL), Desktop PC, Documentation, Ecosystems, Energy & Utilities, Enterprise Architecture, Finance, Financial Analysis, Forecasting, Geographic Information Systems (GIS), Identify Issues, Information Technology & Information Systems, Leadership, Management Strategy, Mentoring, Microsoft Product Family, Microsoft SQL Server, Microsoft Windows Azure, Operational Audit, Operational Support, Performance Metrics, Performance Modeling, Performance Tuning/Optimization, Power BI, Power Management, Power Outages, Problem Solving Skills, Process Improvement, Quality Metrics, Regulations, Regulatory Compliance, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Snowflake Schema, Star Schema, Statistics, Team Player, Technical Leadership, Thought Leadership, Training Data Sets, Training/Teaching, User Interface/Experience (UI/UX)
LOCATION
Newark, DE
POSTED
30+ days ago

Senior Power BI Developer

Hybrid - Newark, DE

Your role in our success will be:

The Senior Power BI Developer serves as a technical leader responsible for architecting, developing, and optimizing advanced business intelligence solutions that transform complex utility data (e.g., AMI, grid performance, asset health, consumption patterns) into highly actionable insights. This role leads enterprise dashboard initiatives, designs high-performance data models, develops sophisticated DAX calculations, and drives best-practice standards for analytics across the organization. The Senior Power BI Developer partners closely with business leaders, data engineering teams, and operational units to ensure analytics solutions support regulatory compliance, operational efficiency, and long-term strategic decision-making.

What you'll be working on:

Enterprise Dashboard & Report Development

  • Lead the design, development, and deployment of scalable, visually compelling Power BI dashboards for high-impact KPIs (e.g., outage response, load forecasting, grid reliability, revenue protection).
  • Establish visualization standards and mentor analysts on UI/UX best practices.

Advanced Data Modeling & Transformation

  • Architect enterprise-grade semantic models using Power BI, Power Query, and DAX.
  • Integrate and transform data from multiple complex sources including SQL Server, Azure SQL, Snowflake, data lakes, and external utility systems.
  • Ensure data models are optimized for performance, scalability, and governance.

Complex DAX & Advanced Analytics

  • Develop advanced DAX measures, time-intelligence calculations, and custom logic to support deep operational and financial analytics.
  • Provide thought leadership on advanced analytical capabilities, forecasting methodologies, and performance optimization.

Cross-Functional Leadership & Stakeholder Collaboration

  • Partner with operational leaders, IT, and regulatory teams to gather requirements and translate them into technical specifications.
  • Lead BI planning sessions, solution reviews, and user-enablement workshops.
  • Provide training, coaching, and guidance to BI analysts and end users.

Governance, Security & Standards

  • Implement and maintain row-level security (RLS), workspace governance, and data lineage documentation.
  • Drive adoption of Power BI Service / Fabric governance standards, including capacity management and refresh strategy.
  • Ensure all BI solutions adhere to security, compliance, and data-quality standards.

Performance Optimization & Support

  • Diagnose and optimize slow-running reports, storage models, and refresh pipelines.
  • Serve as a senior escalation point for BI troubleshooting and best-practice guidance.
  • Stay current with emerging Power BI and Microsoft Fabric capabilities and introduce enhancements to the BI ecosystem.

Who you are:

  • Bachelor's degree in Data Science, Computer Science, Statistics, Finance, or a related field.
  • 5-7+ years of experience in data analytics, business intelligence, or a related role, preferably within the utility or energy industry.
  • Expert-level proficiency in Power BI Desktop, Power BI Service, Microsoft Fabric, DAX, M Query, and SQL.
  • Strong understanding of enterprise BI architecture, semantic models, and scalable dataset design.
  • Experience managing Power BI Premium, Fabric, or capacity-based environments.
  • Strong knowledge of ETL processes, data warehouse design, star and snowflake schemas, and slowly changing dimensions.
  • Experience working with relational and cloud-based data platforms such as SQL Server, Azure SQL, Snowflake, Synapse, and Data Lake Storage.
  • Exceptional analytical and problem-solving skills with the ability to translate complex data into clear business insights.
  • Strong communication skills and the ability to collaborate effectively with stakeholders at all levels.
  • Experience with Azure Data Factory, Synapse Analytics, Databricks, or other data engineering tools (preferred).
  • Knowledge of utility-sector systems such as AMI, CIS, GIS, outage management, or asset management platforms (preferred).
  • Experience mentoring or leading BI analysts (preferred).
  • Microsoft Power BI Data Analyst or Azure/Fabric certifications (preferred).

What makes us great:

At the heart of our Company is a dedication to delivering energy that drives progress. We put people first, work to keep them safe and build trusting relationships.

What's in it for you? Joining the CUC team will get you:

Competitive base salary

Fantastic opportunities for career growth

Cooperative, supportive and empowered team atmosphere

Annual bonus and salary increase opportunities

Monthly recognition events

Endless wellness initiatives and community events

Robust and customizable benefit packages-choose what works best with your life. Options include generous 401k, medical, dental and life insurance, tuition reimbursement, compensated volunteer hours and MORE!

Paid time off, holidays and a separate bank of sick time

Chesapeake Utilities Corporation is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors. Applicants with a disability that need assistance applying for a position may email careers@chpk.com

About the Company

C

Chesapeake Utilities Corp

Chesapeake Utilities Corporation is a diversified energy company focused on delivering outstanding service and attaining sustainable growth that generates long-term value for our employees, customers, investors, and other stakeholders. Our success in these efforts is due to our employees’ relentless commitment to excellence, our comprehensive strategic planning and our disciplined financial analysis of growth opportunities.  For more than 100 years, the Company has successfully delivered safe, secure, reliable and efficient solutions that are environmentally and economically smart. Chesapeake positions itself for long-term growth that creates superior value.  Chesapeake Utilities Corporation genuinely cares while turning aspirations into reality every day. We make meaningful connections with our peers, customers, communities, shareholders and partners.

We strive to provide operational excellence and positive experiences for our customers and the communities we serve. Chesapeake’s regulated energy businesses include natural gas distribution and transmission operations on the Delmarva Peninsula and in Florida, and electric distribution operations in Florida. Chesapeake’s unregulated energy businesses include its natural gas marketing subsidiary, its propane distribution operations, and its propane wholesale marketing subsidiary.

We have a talented workforce made of experienced professionals with diverse backgrounds who take pride in the work they do at Chesapeake. They are hard working people, who generously get involved in their communities because they care about them. At Chesapeake, we believe our employees make the difference, and we care about every one of them – every day. One way we show gratitude to our employees is through our Chesapeake Cares Program that focuses on employee morale and a satisfying work environment. One day each month we conduct an event focused on employee fun and fellowship. We recognize our employees’ contributions with a rewards and recognition program geared towards continuous growth and career development within the company.

COMPANY SIZE
500 to 999 employees
INDUSTRY
Energy and Utilities
EMPLOYEE BENEFITS
Paid Sick Days, Parking, Performance Bonus, Prescription Drug Coverage, Professional Development, 401K, Stock Options, Employee Referral Program, Flexible Spending Accounts, Employee Events, Retirement / Pension Plans, Tuition Reimbursement, Life Insurance, Merchandise Discounts
FOUNDED
1947
WEBSITE
http://www.chpk.com