Senior Analyst

Madison Energy Infrastructure•Charlottesville, VA

6d•$90,000 - $120,000

About The Position

Madison Energy Infrastructure is one of the largest and fastest-growing commercial solar asset owners in the country. We manage hundreds of distributed generation sites across the U.S., with production data flowing in hourly and financial outcomes tied directly to the accuracy of our reporting. We believe great asset management starts with great data. Not dashboards for dashboards’ sake — but accurate, timely, decision-ready information that operations, finance, and leadership can trust. We’re scaling fast. That means complexity, volume, and real responsibility. We need people who can keep up — and raise the bar while they’re at it. About You You are disciplined, data-oriented, and dependable. You know the Excel shortcuts, you build pivot tables in your sleep, and you are curious enough to see whether Claude can generate a report faster than you can and disciplined enough to validate every number it produces. You take full ownership of your work. You are fluent in SQL, with working knowledge of Python and or R, and you are comfortable using code when it is the right tool for the job. You understand the expectations of a corporate environment where accuracy, responsiveness, and follow through matter and you perform well under that pressure. You are comfortable operating in Snowflake, PowerBI, Salesforce, and Excel, and you know where logic belongs. You manage multiple requests, communicate priorities clearly, and close the loop. You want to be in a growth environment. You want responsibility, high standards, and the opportunity to earn trust by delivering consistently. And yes you probably enjoy the quiet satisfaction of a clean model, a reconciled dataset, and a report that holds up when it really counts. The Role As a Senior Data Analyst, you will be responsible for the daily-critical reporting and analytical backbone of our asset management operation. This is not a passive reporting role. You will own production analysis, financial views, and data automation workflows that the business relies on every day. If something breaks, you’ll find it. If something doesn’t make sense, you’ll dig in. If a better system is needed, you’ll help build it. You’ll work closely with Asset Management, Finance, and our Senior Manager of Data Analytics to ensure that what we see, what we bill, and what we report is correct.

Requirements

4+ years in a finance, accounting, or data analysis role
2+ years hands-on experience with Salesforce (reporting, dashboards, data structure)
2+ years working directly in Snowflake or DataBricks
10+ years of Excel experience
2+ years building reports and models in PowerBI
1+ year working with Microsoft PowerApps / Power Automate
Strong skills in SQL, Python, and/or R
Background in statistics and analytical thinking
Obsessive attention to detail — your outputs don’t need rework
Ability to manage complex workflows and multiple priorities without dropping balls
Comfortable in a fast-moving, scaling environment
Proactive, helpful, and willing to dig in
Strong desire to learn and get better
Professional experience with Zoom, Slack, Outlook, Teams, Adobe, etc.
Ability to write clear, professional emails — correct grammar, no spelling mistakes, clean formatting

Nice To Haves

3+ year exposure to solar or energy data (nice to have, not required)

Responsibilities

Own daily, weekly, and monthly production reporting across a large and growing solar portfolio (AlsoEnergy → Snowflake → PowerBI)
Ensure production, financial, and site-level data is accurate, reconciled, and dependable
Turn around one-off reporting requests quickly and accurately , understanding the context behind the data
Maintain and tweak the PowerBI dashboards that answer real business questions
Use Snowflake as the system of calculation and truth , not Excel hacks
Manage and maintain data automation workflows , including: Microsoft PowerApps / Power Automate flows Salesforce syncs and reporting layers
Identify data integrity issues proactively (communications loss, missing data, inconsistencies)
Support Asset Management and Finance with clean, reliable analysis for decision-making
Communicate clearly about priorities, timelines, and tradeoffs when multiple requests are in flight
Continuously improve reporting systems so recurring questions become self-service