New York
Job DescriptionAbout Us Madison Energy Infrastructure is one of the largest, and fastest-growing, commercial and industrial 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. 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-serviceWhat 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/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., • 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$90,000 - $120,000 a yearThe actual salary offered may vary depending on job-related factors including, but not limited to knowledge, skills, experience and location.How We WorkAt Madison Energy Infrastructure, we believe in the power of clean energy infrastructure to drive real impact—for our customers, our partners, and the communities we serve. We've quickly emerged as a preeminent developer, investor, and operator of distributed generation, helping organizations across sectors meet their energy goals with certainty, speed, and trust. Our robust portfolio consists of over half a gigawatt of clean energy infrastructure projects across more than 25 states.We're building a team that thrives on ownership and ambition. As we expand into direct, end-to-end services for Fortune 500 companies, public entities, and nonprofits alike, we rely on collaborative thinkers who bring structure to complexity, energy to execution, and curiosity to every challenge.Our environment is fast-paced and outcome-oriented—but grounded in the belief that how we work together matters as much as what we deliver. If you're excited to shape the future of clean energy and be part of a high-performance, high-integrity team, we'd love to meet you.Madison Energy Infrastructure is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status.