Water Infrastructure & Municipal Finance Expert (U.S.)
Mercor • Remote • Posted 4 days ago
Education
Any
Type
Pay Rate
$180/task
Posted
4d ago
✅ Applying through this link gives you a verified candidate referral.
Referrals from verified candidates give your profile a visibility boost and help support our platform at no cost to you.
This position is hosted on an external talent platform. Please only apply for this position if it fits your skills and interests.
About this Role
Mercor is seeking a Water Infrastructure & Municipal Finance Expert to support a leading AI research lab on a short-term, high-impact project focused on modeling U.S. water and wastewater capital expenditure (capex). In this role, you will review and validate a live Excel-based financial model projecting national water and wastewater capex for CY2026–2028. The model incorporates federal funding flows, state-level overlays, municipal capital improvement plans (CIPs), EPA needs assessments, and policy-driven scenarios. Your expertise will be critical in ensuring the model’s assumptions, structure, and outputs accurately reflect real-world infrastructure financing dynamics.
Review and validate a complex Excel model forecasting U.S. water and wastewater capex (2026–2028)
Location Requirements
Water Infrastructure & Municipal Finance Expert
short-term, high-impact project
live Excel-based financial model
CY2026–2028
Key Responsibilities
complex Excel model
federal water funding programs
state funding mechanisms
municipal CIP rollups
EPA Clean Watersheds Needs Survey (CWNS)
Drinking Water Infrastructure Needs Survey (DWINSA)
policy scenario modeling
Requirements
5+ years of experience
Municipal water/wastewater utilities
Capital expenditure planning (CIP)
Advanced Excel skills
validate real-world assumptions against modeled outputs
Work Arrangement
Project-based / short-term engagement
Why Join
frontier AI lab
data-driven insights in public infrastructure investment
next-generation economic and policy modeling systems
Mercor is seeking a Water Infrastructure & Municipal Finance Expert to support a leading AI research lab on a short-term, high-impact project focused on modeling U.S. water and wastewater capital expenditure (capex). In this role, you will review and validate a live Excel-based financial model projecting national water and wastewater capex for CY2026–2028. The model incorporates federal funding flows, state-level overlays, municipal capital improvement plans (CIPs), EPA needs assessments, and policy-driven scenarios. Your expertise will be critical in ensuring the model’s assumptions, structure, and outputs accurately reflect real-world infrastructure financing dynamics. Review and validate a complex Excel model forecasting U.S. water and wastewater capex (2026–2028) Assess assumptions tied to federal water funding programs, including: State Revolving Funds (SRF) WIFIA (Water Infrastructure Finance and Innovation Act) IIJA (Infrastructure Investment and Jobs Act) allocations and supplementals Evaluate integration of state funding mechanisms and municipal CIP rollups Cross-check model logic against EPA Clean Watersheds Needs Survey (CWNS) and Drinking Water Infrastructure Needs Survey (DWINSA) extrapolations Provide feedback on policy scenario modeling (e.g., funding changes, allocation shifts, regulatory impacts) Identify inconsistencies, gaps, or unrealistic assumptions in projections Suggest improvements to model structure, clarity, and robustness 5+ years of experience in water infrastructure, municipal finance, or public sector capital planning Direct experience with: Municipal water/wastewater utilities or infrastructure advisory Capital expenditure planning (CIP) or infrastructure investment analysis U.S. federal water funding programs (SRF, WIFIA, IIJA) Strong familiarity with: EPA needs surveys (CWNS, DWINSA) and infrastructure funding flows State-level water financing mechanisms and bond issuance dynamics Advanced Excel skills (required): Comfortable auditing complex formulas, linked sheets, and scenario models Experience working with large-scale financial or infrastructure models Strong analytical judgment and ability to validate real-world assumptions against modeled outputs Excellent written communication skills for structured feedback Work with a frontier AI lab tackling large-scale infrastructure modeling problems Apply your domain expertise to shape data-driven insights in public infrastructure investment Flexible, high-impact consulting engagement with a focused scope Opportunity to contribute to next-generation economic and policy modeling systems We consider all qualified applicants without regard to legally protected characteristics and provide reasonable accommodations upon request.
- Review and validate a complex Excel model forecasting U.S. water and wastewater capex (2026–2028)
- Assess assumptions tied to federal water funding programs, including:
State Revolving Funds (SRF)
WIFIA (Water Infrastructure Finance and Innovation Act)
IIJA (Infrastructure Investment and Jobs Act) allocations and supplementals
- State Revolving Funds (SRF)
- WIFIA (Water Infrastructure Finance and Innovation Act)
- IIJA (Infrastructure Investment and Jobs Act) allocations and supplementals
- Evaluate integration of state funding mechanisms and municipal CIP rollups
- Cross-check model logic against EPA Clean Watersheds Needs Survey (CWNS) and Drinking Water Infrastructure Needs Survey (DWINSA) extrapolations
- Provide feedback on policy scenario modeling (e.g., funding changes, allocation shifts, regulatory impacts)
- Identify inconsistencies, gaps, or unrealistic assumptions in projections
- Suggest improvements to model structure, clarity, and robustness
- State Revolving Funds (SRF)
- WIFIA (Water Infrastructure Finance and Innovation Act)
- IIJA (Infrastructure Investment and Jobs Act) allocations and supplementals
- 5+ years of experience in water infrastructure, municipal finance, or public sector capital planning
- Direct experience with:
Municipal water/wastewater utilities or infrastructure advisory
Capital expenditure planning (CIP) or infrastructure investment analysis
U.S. federal water funding programs (SRF, WIFIA, IIJA)
- Municipal water/wastewater utilities or infrastructure advisory
- Capital expenditure planning (CIP) or infrastructure investment analysis
- U.S. federal water funding programs (SRF, WIFIA, IIJA)
- Strong familiarity with:
EPA needs surveys (CWNS, DWINSA) and infrastructure funding flows
State-level water financing mechanisms and bond issuance dynamics
- EPA needs surveys (CWNS, DWINSA) and infrastructure funding flows
- State-level water financing mechanisms and bond issuance dynamics
- Advanced Excel skills (required):
Comfortable auditing complex formulas, linked sheets, and scenario models
Experience working with large-scale financial or infrastructure models
- Comfortable auditing complex formulas, linked sheets, and scenario models
- Experience working with large-scale financial or infrastructure models
- Strong analytical judgment and ability to validate real-world assumptions against modeled outputs
- Excellent written communication skills for structured feedback
- Municipal water/wastewater utilities or infrastructure advisory
- Capital expenditure planning (CIP) or infrastructure investment analysis
- U.S. federal water funding programs (SRF, WIFIA, IIJA)
- EPA needs surveys (CWNS, DWINSA) and infrastructure funding flows
- State-level water financing mechanisms and bond issuance dynamics
- Comfortable auditing complex formulas, linked sheets, and scenario models
- Experience working with large-scale financial or infrastructure models
- Project-based / short-term engagement (likely a few weeks)
- Work with a frontier AI lab tackling large-scale infrastructure modeling problems
- Apply your domain expertise to shape data-driven insights in public infrastructure investment
- Flexible, high-impact consulting engagement with a focused scope
- Opportunity to contribute to next-generation economic and policy modeling systems
Requirements
- Must be eligible to work in Remote
- Fluent proficiency in English (Written & Verbal)
- Reliable high-speed internet connection
- Bachelor's degree or equivalent professional experience
- Demonstrated expertise in Business
Compensation Analysis
Rare opportunity for top 1% experts. Earn $180/hr contributing to the world's most advanced AI labs. This is one of the few roles where academic precision is valued as highly as commercial output.
Skills & Categories
Explore other opportunities in related specializations:
Related Jobs
Systems & Infrastructure Specialist
micro1 • Business
$70
Finance Expert — AI Financial Model Auditor (Python Required)
alignerr • Business
$110
Finance Expert — AI Analyst Trainer (Python & Modeling)
alignerr • Business
$110
Finance Expert — AI Model Reviewer (Python & Financial Modeling)
alignerr • Business
$110
Browse All Jobs from Mercor
Discover more opportunities on Mercor that match your skills and interests.
View All Mercor Jobs →Community Reviews
Leave your review
Frequently Asked Questions
Is this for freelancers or full-time employees?
Both. Mercor tries to match you with clients who want long-term contractors. Unlike other platforms where you log in and grab small tasks, Mercor matches you with one company for a steady role (e.g., 'Python Tutor for 3 months').
I'm not comfortable on camera. Can I still apply?
No. The application requires a video interview with an AI avatar. The AI asks you questions about your resume, and the video is shared with potential clients to prove your communication skills.
Does it cost money to join?
No. You should never pay to join these platforms. Mercor makes money by charging the client a fee on top of your hourly rate.
Is this traditional consulting?
Not exactly. You act as a "Teacher" for advanced AI. Instead of client deliverables, you are given complex scenarios to evaluate. You grade the AI's logic, correct its hallucinations, and provide expert-level reasoning. Your job is to train the model to think like you do.
Why is the pay so high?
This role requires deep, verified expertise. General knowledge isn't enough; the model is specifically being trained on "edge cases"—the rare, difficult, or highly technical nuances that only a senior professional would know.
What is the workload like?
This is cognitive, deep work. Unlike simple data labeling, you might spend 45-60 minutes on a single task, researching citations or verifying complex calculations. Quality is prioritized over speed.
How soon will I start?
Important: Mercor is a talent marketplace, not a task queue. Applying puts you in a pool of candidates. You will only start working when a specific client (like a major AI lab) selects your profile. This matching process can take weeks.