Madison Energy Infrastructure→
FP&A Business Intelligence Intern – Summer 2026 at Madison… · Tysons…
InternshipHybridFull-timeTysons Corner, VA$42k–$83k/yr
Skills
sqlpythonexcel-based financial analysisdata modelingbusiness intelligence toolsai toolsintellectually curious
Job Description
Summary: Madison Energy Infrastructure is a leading developer and operator of clean energy infrastructure. The FP&A Business Intelligence Intern will support the Finance and Digital teams by structuring data, developing analytical tools, and enhancing business intelligence capabilities using SQL, Python, and AI tools.
Responsibilities:
- Assist with building data models and analytics tables in Snowflake using SQL to organize operational and financial data into structured datasets for analysis and reporting
- Support the creation of business intelligence dashboards and reporting tools that provide visibility into portfolio performance, cash flow, and key operating metrics
- Use Python and SQL to help automate data ingestion, validation, and reporting workflows, improving data quality and reducing manual processes
- Experiment with AI tools (e.g., Claude Code and other LLM-based tools) to prototype internal analytics workflows, automate analysis, and identify opportunities to improve business intelligence capabilities
- Work with FP&A and operations teams to translate operational data into financial insights and support Excel-based forecasting, reporting, and project finance analysis
Required Qualifications:
- Currently pursuing a graduate degree preferred (e.g., data science, computer science, engineering, economics, finance, or a related field); strong undergraduate candidates will also be considered
- Comfortable working with data using SQL and Python, with interest in building analytical workflows and data models
- Strong experience with Excel-based financial analysis and a keen interest in how operational data connects to financial performance; prior coursework or experience in finance, accounting, or financial modeling is a plus
- Curious about applying AI tools (e.g., Claude Code or other LLM-powered tools) to automate analysis and improve business intelligence workflows
- Detail-oriented, intellectually curious, and excited to work with real-world financial and operational data (structured and unstructured) in a collaborative environment
Required Skills: SQL, Python, Excel-based financial analysis
Important Skills: Data modeling, Business intelligence tools
Nice-to-Have Skills: AI tools, Intellectually curious
Internship Start Date: Start in 2026 Summer