Burlington, VT · On-site +1
$136K - $152K/yr
Non-Union Pay Grade MF: $136,500.00 - $152,967.64 Annually Remote Tier 2: Up to one (1) day remote ... high-level of Excel knowledge (at a minimum, comfort with pivot tables and basic formulas)
Burlington, VT · On-site +1
$136K - $152K/yr
Non-Union Pay Grade MF: $136,500.00 - $152,967.64 Annually Remote Tier 2: Up to one (1) day remote ... high-level of Excel knowledge (at a minimum, comfort with pivot tables and basic formulas)
In a remote Excel Pivot Table role, your daily routine usually involves importing, cleaning, and organizing raw data, then creating and updating pivot tables to generate actionable reports for stakeholders. You’ll be asked to identify trends, automate recurring analyses, and respond to requests from team members or clients who need customized summaries or dashboards. Collaboration is often handled through virtual meetings and project management tools, with clear documentation being key to smooth communication. This role is largely self-directed, requiring proactive problem-solving and the ability to manage deadlines while supporting larger business analytics initiatives.
An Excel Pivot Table Remote job involves working remotely to analyze, summarize, and manipulate data using Excel pivot tables. Professionals in this role typically organize large datasets, create reports, and generate insights for businesses. Common tasks include filtering, grouping, and visualizing data to support decision-making. This position is ideal for individuals with strong Excel skills who can work independently and communicate findings effectively.
To thrive as an Excel Pivot Table Remote professional, you need advanced proficiency in Microsoft Excel, strong analytical skills, and experience managing and interpreting large datasets. Familiarity with data visualization tools, spreadsheet automation, and relevant certifications such as Microsoft Office Specialist (MOS) are highly beneficial. Excellent attention to detail, time management, and clear written communication skills set top candidates apart. These competencies enable efficient, accurate data analysis and reporting while collaborating effectively in a remote team environment.
$136K - $152K/yr
Other
Posted 5 days ago
General Purpose The Director of Budget and Strategic Planning is responsible for overseeing citywide budgeting, capital programs, and external funds procurement and management, and strategic plans to deliver essential services that balance community needs with fiscal realities. Union Affiliation: Non-Union Pay Grade MF: $136,500.00 - $152,967.64 Annually Remote Tier 2: Up to one (1) day remote/week Essential Job Functions Directly supervises Capital Program Director, Grants Director, and Financial and Budget Manager, providing guidance over these programs: capital, grants, philanthropy, and budgeting for the City. Lead, oversee and support the City in the development, preparation, revision, and presentation for approval of the City's Operating (General, Enterprise, and Special Revenue Fund) and Capital Improvement budgets in close coordination with Mayor, Chief Administrative Officer, Department Heads, Capital Program Director, and Financial and Budget Manager
Plan and implement a multi-year budgeting process, utilizing multi-year revenue and expenditure forecast systems and models for both Operating and Capital budgets. Develop standards and procedures to guide the administration, City Council, and departments in Citywide organizational budgeting and strategic planning. Translate City goals and strategic planning initiatives into actionable annual operating and capital budgets.
Provide financial analysis to City leadership, monitoring the financial condition of City's funds and reporting status periodically to Mayor and Board of Finance for budgetary control and to identify trends, variances and opportunities for improvement. Develop and deliver training for creating budgets and financial management and reporting mechanisms for City staff. Work closely with the Mayor, City Council, CAO, and others, help develop and maintain a strategic plan that outlines the community's vision in alignment with its financial resources.
Oversees grant function by providing guidance on how the City plans and coordinates applications, including applying for federal and state grants, negotiating terms and conditions, and ensuring financial and programmatic compliance and timely reporting. Oversees capital program including planning, executing, and monitoring capital projects to ensure they are on time, within budget, and meet quality standards. Non-Essential Job Functions: Performs other duties as required.
Qualifications/Basic Job Requirements Ability to actively support City diversity, equity, and cultural competency efforts within stated job responsibilities and work effectively across diverse cultures and constituencies. Demonstrated commitment to diversity, equity and inclusion as evidenced by ongoing trainings and professional development. Bachelor's Degree in Business, Public Administration or related field.
At least five (5) years of experience as a budget analyst, financial analyst, business accountant, or similar, with experience in government preferred. At least three (3) years of supervisory experience. Demonstrated knowledge of and experience with Uniform Guidance/2 CFR 200.
Comfort navigating & compiling data from multiple software/sources, especially high-level of Excel knowledge (at a minimum, comfort with pivot tables and basic formulas). Advanced financial expertise in budget planning and financial forecasting. Demonstrated leadership, supervisory and planning skills.
Excellent verbal and written communication skills. Strong analytical and problem-solving abilities. Strong ability to establish and maintain effective working relationships with City Officials and Departments, state and other public officials.
Ability to maintain confidentiality and make decisions in accordance with established policies and procedures. Additional Information Promoting a culture that reveres diversity and equity. The City of Burlington is proud to be an equal opportunity employer, and we are strongly committed to creating a dynamic and equitable work-force that mirrors the population and world that we serve.
We do not discriminate on the basis of political or religious affiliation, race, color, national origin, place of birth, ancestry, age, sexual orientation, gender identity, marital status, crime victim status, veteran status, disability, HIV positive status, or genetic information in employment or the provision of services. In addition to being an equal opportunity employer we actively encourage applicants who can contribute to our growing diversity to apply. Applications for our employment opportunities are only accepted online through our Government Jobs website.
For accessibility information or alternative formats, please contact Human Resources Department at 802-540-2505 or careers@burlingtonvt.gov.
Sourced by ZipRecruiter
Public administration
501 - 1,000 Employees
Burlington, VT, US
1865