Senior Analyst

About Us

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, Asset Management, 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.

Key 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

What You Bring

• 4+ years in a finance, accounting, or data analysis role
• 3+ year exposure to solar or energy data (nice to have, not required)
• 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

Benefits

• PTO and company holidays
• Medical, dental, vision
• Employer-paid short-term disability, long-term disability, life insurance
• 401(k) and company match
• Professional development stipend
• Strong culture of collaboration, performance, and personal growth