AnalystAssociate Consultant Finance

Raftelis; Charlotte (NC); Hybrid; USD 63,000 - 89,000; Full time

Benefits offered by this job

Hybrid work arrangement (3 days in the

Competitive compensation

Job summary

Raftelis, a public sector-focused consulting firm, seeks an Analyst/Associate Consultant to deliver financial planning, cost-of-service, rate design, and bond feasibility studies for municipal utilities.

You will mine data, build Excel-based models, validate usage data, and communicate results clearly, with opportunities to contribute to business development. Hybrid work: 3 days in-office, 2 days remote.

Qualifications

• Bachelor's degree in finance, accounting, economics, mathematics, or related field.
• Advanced proficiency in MS Excel including dashboards, scenario analysis, and formulas.
• Strong MS Word and PowerPoint skills; ability to create templates.

Responsibilities

• Data mine and aggregate project data from multiple sources and develop Excel-based financial models.
• Validate customer usage data and provide insights on usage patterns and demand.
• Work with project managers, switch between projects to meet milestones and deliverables.
• Produce, edit, and present reports, proposals, and presentations clearly.

Skills

Excel advanced functions

MS Word

Power BI

Data QA/QC

Strong communication

Education

Bachelor's degree (finance, accounting, economics, math)

Tools

Power BI

Job description

Company Description:

Raftelis partners with local governments and utilities to solve their most complex challenges. Over the last year, we've worked with more than 700 organizations across the full spectrum of management consulting, from finance and strategic planning to technology, communications, organizational assessment, and executive recruitment.

We're proud to share that Raftelis has been certified as a Great Place to Work®! 93% of our employees say it is a great place to work, compared to 57% of employees at a typical US-based company. As one of our employees said, “at Raftelis, we maintain a great balance between hard work and allowing staff to focus on their lives outside of work. We also have a strong culture where people genuinely care about each other, and leadership is committed to doing what's best for both our employees and the firm”.

Job Summary:

Working within a team, the Analyst/Associate Consultant will be responsible for providing exceptional client service in the public municipal utilities industry (water, wastewater, and stormwater) through various multi-discipline projects, such as financial planning, cost of service rate and fee setting, bond feasibility studies, and miscellaneous financial-related projects.

Primary Responsibilities:

• Data mine and aggregate project data from multiple sources and develop Excel-based financial models to support analysis of a variety of financial and management studies including projects related to financial planning. This includes projecting utility revenues and expenditures, developing revenue requirements, cost allocation and rate and fee design to support utility's operations.


• Validate customer usage data and provide insightful feedback on usage patterns and demand to support informed decision‑making processes


• Under the guidance of project managers, work independently and have the ability to switch between projects quickly to meet milestones and deliverables


• Utilize public speaking and technical writing skills to produce, edit and present reports, proposals, and presentations in a clear and succinct manner


• Support senior staff in business development and marketing activities


• Collaborate with clients to collect data and insight, and effectively communicate results and scenarios

Requirements:

• Bachelor's degree (finance, accounting, economics, mathematics, or other related fields)


• Demonstrate advanced proficiency and extensive experience in MS Excel, showcasing expertise in advanced user functions such as creating dashboards, conducting scenario analysis, and utilizing financial excel formulas.


• Strong proficiency with MS Word, PowerPoint, and Power BI - ability to create report templates, modify report templates


• Experience analyzing and conducting QA/QC on large data sets


• Critical thinking skills – ability to formulate multiple solutions to problems, test hypothesis and develop solutions based on analysis.


• Ability to work under multiple project managers with competing deadlines and deliverables


• Ability to communicate effectively through writing, speaking, and visual presentation


• Willing and able to travel overnight as needed

Preferences:

• Master's degree (finance, accounting, economics, mathematics, or other related fields) or equivalent experience.

Studies have shown that women and people of color are less likely to apply for jobs unless they believe they can perform every job description task. We are most interested in finding the best candidate for the job, and that candidate may come from a less traditional background. We will consider any equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications.

Rewards:

Working for a values-based organization focused on growth with an exceptional reputation in its industry, employees receive competitive compensation and excellent benefits that include:

• 100% company-paid employee medical (HSA plan) and 50% company-paid dependent medical coverage and dental benefits


• Health Savings Account


• Medical and Dependent Care Flexible Spending Accounts


• Vision Insurance


• Company paid Life and Disability Insurance


• Employee Assistance Program


• Discretionary paid time off program


• Education Reimbursement Program


• 401(k) with company contributions


• Long-Term care benefits


• Pet insurance


• Hybrid working arrangement (3 days in the office and 2 days remote)

The salary range for an Analyst is $63k to $73k. The salary range for an Associate Consultant is $73k to $89k. Compensation depends on education, experience, and location.

Additional Information:

To qualify, applicants must be legally authorized to work in the United States, and should not require, now or in the future, sponsorship for employment visa status. Raftelis uses E-VERIFY. Raftelis is committed to providing equal employment opportunities and our sincere belief in the dignity of each employee, it is our policy to prohibit harassment based on race, national origin, color, age, sex, marital status, domestic partner status, sexual preference, medical condition, disability, religion, or veteran status.

Raftelis is committed to providing reasonable accommodation for individuals with disabilities in employment. To request an accommodation to participate in the job application or interview process, contact Lisa Wilson, Director of Human Resources at 704-910-8961.