Analyst/Associate Consultant

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 processesUnder the guidance of project managers, work independently and have the ability to switch between projects quickly to meet milestones and deliverablesUtilize public speaking and technical writing skills to produce, edit and present reports, proposals, and presentations in a clear and succinct mannerSupport senior staff in business development and marketing activitiesCollaborate 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 templatesExperience analyzing and conducting QA/QC on large data setsCritical 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 deliverablesAbility to communicate effectively through writing, speaking, and visual presentationWilling 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. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role. 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 benefitsHealth Savings AccountMedical and Dependent Care Flexible Spending AccountsVision InsuranceCompany paid Life and Disability InsuranceEmployee Assistance ProgramDiscretionary paid time off programEducation Reimbursement Program401(k) with company contributionsLong-Term care benefitsPet insuranceHybrid 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 Allison Harllee, Human Resources Manager at 704-269-2536. To learn more about Raftelis and apply, please visit www.raftelis.com.