Financial Planning & Budgeting Consultant (hybrid)

If you're excited about this role but don’t meet every qualification, we still encourage you to apply! At Grange, we value growth and are committed to supporting continuous learning and skill development as you advance in your career with us. Summary: This role is a key member of the FP&A team responsible for providing insight into operational and financial business performance for company leadership through analysis of results verses budget, forecast and historical performance. This individual will be a thought leader to continuously improve the finance function and its value to the organization. What You’ll Be Doing: Develop and drive annual and quarterly planning and forecasting process including coordination and consolidation of company income statement. Collaborate with cross-functional teams and build relationships with key stakeholders (business unit and enterprise leadership). Lead the development of actionable reports through collaboration with business units. This includes the creation of reports for distribution in support of monthly variance reporting of actual results versus budget and research and resolution of business unit inquiries. Using PeopleSoft/Hyperion, manage the inventory of reports and continually elevate quality and efficiency through the coordination of all “power” report users. Prepares and presents complex financial data for internal stakeholders as well as external regulatory agencies and other entities. This includes a variety of reports detailing the status of revenue, loss and expenses including unit and activity costs. Identities trends, highlights variances and recommend adjustments in programs and processes to management as they relate to financial targets. Recommends and takes ownership of new financial analysis techniques and measurements for internal reporting purposes. Leads the development of efficient analytical and planning models that capture key financial data. Prepares a variety of reports analyzing and detailing premiums, losses, and expenses. Performs in-depth financial analysis including reviews of the impact of variances from plan. Assesses the need to develop corrective action plans. Support finance business partners with data needed to monitor and analyze monthly budget variances. Proactively work to improve/translate data from accounting function to finance application. Lead initiative to continuously mature financial approach to answer questions to enable business decision-making. Design, maintain and continually improve forecast models for current and future years including user-based testing. Leverage competitive financial statement / annual report research for benchmarking financial performance metrics and indicators. Provide analysis to support the development of the company’s strategic plan. Perform ad hoc expense analysis to provide insights that will help shape expense management practices. May supervise/lead Analysts on special projects/studies. What You’ll Bring To The Company: Individual should have 8+ years’ experience in full-time financial or analytical position with strong knowledge of how finance and accounting interact in a corporate environment. Preferably with an undergraduate degree in finance, accounting, economics, or related field. Must be a self-starter with demonstrated problem solving skills, highly analytical critical thinker, intellectually curious, with decision-making skills. Has enthusiasm for collaboration and building strong, trusting relationships with colleagues across all levels and areas of the company. Illustrates strong management skills with ability to drive project from inception to delivery and be a catalyst for change. Must have high level of proficiency with Microsoft Office suite (Excel and Power Point required). Preferred: Hands-on experience with Hyperion planning application. People soft/back-end development curiosity Accounting/finance knowledge Plays well outside of set routine Passion for learning new skills, and ability to adapt in a fast-paced environment About Us:Grange Insurance Company, with $3.4 billion in assets and more than $1.61 billion in annual revenue, is an insurance provider founded in 1935 and based in Columbus, Ohio. Through its network of independent agents, Grange offers auto, home and business insurance protection. Grange Insurance Company and its affiliates serve policyholders in Georgia, Illinois, Indiana, Iowa, Kentucky, Michigan, Minnesota, Ohio, Pennsylvania, South Carolina, Tennessee, Virginia and Wisconsin and holds an A.M. Best rating of A (Excellent).Grange understands that life requires flexibility. We promote geographical diversity, allowing hybrid and remote options and flexibility in work hours (role dependent). In addition to competitive traditional benefits, Grange has also created unique benefits based on associate feedback, including a cultural appreciation holiday, family formation benefits, compassionate care leave and expanded categories of bereavement leave. Who We Are:Grange values all the things that make us unique as human beings. We are committed to creating and supporting a workforce that reflects the richness of our differences by welcoming all backgrounds, viewpoints and lived experiences. To foster an inclusive environment, we are intentional in bringing those differences together for the good of our enterprise, associates, agents, customers and community.Our Associate Resource Groups help cultivate an inclusive workplace while providing professional and personal growth opportunities. Open to all associates, these voluntary groups celebrate shared experiences and perspectives across ethnicity and race, nationality, generation, gender identity and sexual orientation. Our groups include the Multicultural Professional Network, Pride Partnership & Allies, Women's Group and Young Professionals.Established in 2016, our Inclusive Culture Council advances professional development, networking, business value and community outreach.Together, we create opportunities to learn from one another, encourage innovation and build a culture where everyone can contribute and grow. Our commitment to inclusion is grounded in our core values: Be One Team, Deliver Excellence, Communicate Openly, Do the Right Thing and Solve Creatively for Tomorrow.Equal Opportunity Employer We are committed to maintaining a discrimination-free workplace in all aspects, terms and conditions of employment and welcome the unique contributions that you bring from education, opinions, culture, beliefs, race, color, religion, age, sex, national origin, handicap, disability, sexual orientation, gender identity or expression, ancestry, pregnancy, veteran status, and citizenship.Job SummaryRequisition Number: FINAN004716Job Category: Financial Planning \& AnalysisSchedule: Full-Time