Budget Execution Reporting Support Specialist [PR0060]

Company DescriptionProSidian is a Management and Operations Consulting Services Firm focusing on providing value to clients through tailored solutions based on industry-leading practices. ProSidian services focus on the broad spectrum of Risk Management, Compliance, Business Process, IT Effectiveness, Energy & Sustainability, and Talent Management. We help forward-thinking clients solve problems and improve operations.Launched by former Big 4 Management Consultants; our multidisciplinary teams bring together the talents of nearly 190 professionals nationally to complete a wide variety of engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies of all sizes. Our Services are deployed across the enterprise, target drivers of economic profit (growth, margin, and efficiency), and are aligned at the intersections of assets, processes, policies and people delivering value.ProSidian clients represent a broad spectrum of industries to include but are not limited to Energy, Manufacturing, Chemical, Retail, Healthcare, Telecommunications, Hospitality, Pharmaceuticals, Banking & Financial Services, Transportation, Federal and State Government Agencies. Learn More About ProSidian Consulting at DescriptionProSidian Seeks a Budget Execution Reporting Support Specialist (Full-Time) in The Hanford Eastern Washington (Tri-Cities - Kennewick | Pasco | Richland) Area. to support an engagement for the US Dept. of Energy (DOE) Hanford.ProSidian Team Members work to provide General Support Services Contractor (GSSC) assistance to support DOE Hanford [which consists of Richland Operations Office (RL), and Office of River Protection (ORP)] in support of the Govt’s operations, personnel management, and general administration of regional operations at the Hanford Site in Richland, Washington. ProSidian's work includes supporting requirements for consulting, acquisition support, program/project mgmt., operational/administrative business support, and environmental consulting support. It is also ProSidian's duty to adhere to regulations covering the responsibility to protect classified matter (including documents, material and special nuclear material) in connection with the performance of work under this contract.BUD Budgetary Support 1572458979017 Candidates shall work to support requirements as a Budget Execution Reporting Support Specialist and provide Budget Execution Reporting Support on behalf of The United States Department of Energy (DOE), Richland Operations Office (RL), Budget Division (BUD).The Budget Execution Reporting Support Specialist shall provide support to RL BUD, which supports RL and the Office of River Protection (ORP), in the following areas:Serve as the focal point for collecting and reporting budgetary data for monthly, quarterly, semiannual, annual, and ad hoc reporting to Hanford, HQ DOE, and other stakeholders. This includes information communicated via Microsoft PowerPoint, Excel, Power Query, Power Pivot, Power BI, SharePoint, Teams, Outlook, Word, and other DOE-approved systems. Secure approval from appropriate DOE officials before releasing.Retrieve data and information and prepare presentations in PowerPoint, Power BI, Word, or other identified software. Coordinate with others to provide inputs. Secure approval from appropriate DOE officials before releasing.Maintains a repository of budget historical data (e.g., monthly, quarterly, annual), simplifies uploading process and access to informationFacilitate usage, and provide training, for Power Query, Power Pivot, Power BI, SharePoint, and Teams to business team members and other key individualsCoordinate with Information Technology (IT) departments to facilitate user permissionsRetrieve data from various sources, including DOE’s iManage Data Warehouse (IDW) thru iPortal and various Excel (or other) files from DOE employees and contractorsCreate and maintain customized reports using Business Intelligence (BI) software available on iPortalUse Excel, Power Query, Power Pivot and Power BI extensively to build and maintain dimension and fact tables, relationships between tables, and overall data schema. This includes tables external to data in IDW, such as spend plans and budget targets (also known as ceilings and allocations).Build and maintain queries to retrieve data and easily prepare it for use, otherwise known as extract, transform, and load (ETL)Create and maintain power pivot tables and charts, which sit on top of the entire data model rather than a single table or range.Create and maintain calculated columns and even more flexible measures using data analysis expressions (DAX)Create and maintain visually appealing analytical information, including pivot tables, pivot charts, and dashboardsCoordinate with Information Technology (IT) departments to facilitate user permissions and streamlined services#RichlandWAJobs #HanfordWAJobs #TriCitiesJobs #TriCitiesWAJobs #KennewickWAJobs #YakimaWAJobs #PascoWAJobs ‎#BentonCounty‎WAJobs #FranklinCountyWA‎Jobs #BudgetReportingQualificationsThe Budget Execution Reporting Support Specialist shall have consecutive employment in a position with comparable responsibilities within the past five (5) years, Must be able to use a computer to communicate via email; and proficient in Microsoft Office Products (Word/Excel/Power point) and related tools and technology required for the position. Work products shall be thorough, accurate, appropriately documented, and comply with established criteria. Work products shall be thorough, accurate, appropriately documented, and comply with established criteria.The Budget Execution Reporting Support Specialist shall demonstrate: Skill levels identified below are defined as: a) Basic: Active involvement involving manipulation of data and presentation of information for at least 6-months; b) Intermediate: Active involvement involving manipulation of data and presentation of information for at least 12-months; c) Advanced: Professional involvement involving manipulation of data and presentation of information for at least 36-monthsThe Budget Execution Reporting Support Specialist shall demonstrate:High school degree or higher educationSkill levels identified below are defined as: a) Basic: Active involvement involving manipulation of data and presentation of information for at least 6-months; b) Intermediate: Active involvement involving manipulation of data and presentation of information for at least 12-months; c) Advanced: Professional involvement involving manipulation of data and presentation of information for at least 36-monthsAdvanced skill level in ExcelIntermediate skill level with Power Query, Power Pivot, and Power BI, including the extensive use of DAX languageIntermediate skill level PowerPointIntermediate skill level with WordIntermediate experience in data mining from large data warehouse(s)Basic skill level in OutlookBasic skill level in SharePoint,Excellent reading, writing, and speaking communications skillsAbility to perform multiple tasks with dynamic priorities independentlyExperience of maintaining databases in Microsoft Access or similar software preferredExperience with Teams preferredKnowledge of Federal Government and DOE budget execution principles and budget/financial systems preferredKnowledge of Hanford Site mission, activities and priorities preferredMust be a U.S. Citizen. TRAVEL: Travel as coordinated with the technical point of contact and approved in writing by the Contracting Officer in advance, is allowed, in accordance with Federal Travel Regulations.LOCATION: Work shall be conducted at the Department of Energy - Richland Operations Office, The Hanford Site, and Richland, WA.Additional InformationCORE COMPETENCIES* Teamwork – ability to foster teamwork collaboratively as a participant, and effectively as a team leader* Leadership – ability to guide and lead colleagues on projects and initiatives* Business Acumen – understanding and insight into how organizations perform, including business processes, data, systems, and people* Communication – ability to effectively communicate to stakeholders of all levels orally and in writing* Motivation – persistent in pursuit of quality and optimal client and company solutions* Agility – ability to quickly understand and transition between different projects, concepts, initiatives, or work streams* Judgment – exercises prudence and insight in decision-making process while mindful of other stakeholders and long-term ramifications* Organization – ability to manage projects and activity, and prioritize tasks------------ ------------ ------------OTHER REQUIREMENTS* Business Tools – understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint and Word, and proficient with Adobe Acrobat, data analytic tools, and Visio with the ability to quickly learn other tools as necessary.* Business Tools – understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint and Word, and proficient with Adobe Acrobat, data analytic tools, and Visio with the ability to quickly learn other tools as necessary.* Commitment - to work with smart, interesting people with diverse backgrounds to solve the biggest challenges across private, public and social sectors* Curiosity – the ideal candidate exhibits an inquisitive nature and the ability to question the status quo among a community of people they enjoy and teams that work well together* Humility – exhibits grace in success and failure while doing meaningful work where skills have impact and make a difference* Willingness - to constantly learn, share, and grow and to view the world as their classroom------------ ------------ ------------BENEFITS AND HIGHLIGHTSAt ProSidian, we invest in our employees to help them stay healthy and achieve work-life balance. Our team members receive a comprehensive benefits package that includes Competitive Compensation, Group Health Insurance Health Benefits, 401(k) Retirement Savings Plan Contributions, Vacation and Paid Time off (PTO) Benefits, Pre-Tax Payment Programs, Purchasing Discounts & Savings Plans, a ProSidian Employee & Contractor Referral Bonus Program, Performance Incentives, etc. Our comprehensive benefits package includes a medical, dental and vision plan. Our growing list of benefits currently include the following:* Competitive Compensation: Pay range begins in the competitive ranges with full Gold Level (Tier 1) Group Medical Benefits, Pretax Employee Benefit Plan, plus performance incentives* Group Health Insurance Health Benefits: Group Health Insurance Including Medical, Dental And Vision Insurance: Contributions are deducted from pay on a Pretax basis - Employee and family coverage is available with employer contribution to Employee (only) premiums under the Health Plan.* 401(k) Retirement Savings Plan: 401(k) Retirement Savings Plans help you save for your retirement. Eligible employees can make before-tax contributions to the 401(k) Retirement Savings Plan to help you save for retirement. Contributions are deducted from pay on a pretax basis - wide range of investment options available with personal financial planner available to assist you. The Plan is a Safe Harbor 401(k) Retirement Savings Plan.* Vacation And Paid Time Off (PTO) Benefits: The flexibility of Paid Time Off (PTO) lets you set your own priorities. Eligible employees use PTO for vacation, a parent-teacher conference, a doctor’s appointment, or any number of events in your life. Currently these benefits include Vacation/Sick days – 2 weeks | Holidays - 10 Federal Government.* Pre-Tax Payment Programs: Pre-Tax Payment Programs currently exist in the form of a Premium Only Plan (POP). These Plans offer a full Flexible Spending Account (FSA) Plan and a tax benefit for eligible employees.* Purchasing Discounts & Savings Plans: We want you to achieve financial success. We offer a Purchasing Discounts & Savings Plan through The ProSidian Corporate Perks Benefit Program - Helping You Do More With Less: This provides special discounts for eligible employees on products and services you buy on a daily basis.* Security Clearance: Due to the nature of our management and operations consulting engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies of all sizes; oftentimes there are Security Clearance requirements for Engagement Teams handling sensitive Engagements in the Federal Marketplace. A Security Clearance is a valued asset in your professional portfolio and adds to your credentials based on past, present, and future work.* Leverageable Experience and Thought Leadership: By collaborating with firm leadership, other members of the team, as well as Fellows and collaborating partners in what is a flat organization, you'll make valuable professional connections, interact with clients daily, gain leverageable Experience, and contribute to Thought Leadership while you build a basket of marketable experiences.* ProSidian Employee & Contractor Referral Bonus Program: ProSidian Consulting will pay up to $5k for all referrals (payments made after new hire has been employed for 90 days) for candidates submitted through our Employee Referral Program.* Performance Incentives: Due to the nature of our management and operations consulting engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies of all sizes there are performance incentives associated with each new client that each employee works to pursue and support.* Flexible Spending Account: A special account you put money into that you use to pay for certain out-of-pocket health care costs. You don't pay taxes on this money. A flexible spending account, also known as a flexible spending arrangement, is one of a number of tax-advantaged financial accounts, resulting in payroll tax savings.------------ ------------ ------------ADDITIONAL INFORMATION - See Below Instructions On The Best Way To ApplyProSidian Consulting is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status, or any other protected factor. All your information will be kept confidential according to EEO guidelines.ProSidian Consulting has made a pledge to the Hiring Our Heroes Program of the U.S. Chamber of Commerce Foundation and the “I Hire Military” Initiative of The North Carolina Military Business Center (NCMBC) for the State of North Carolina. All applicants are encouraged to apply regardless of Veteran Status.Furthermore, we believe in "HONOR ABOVE ALL" - be successful while doing things with the right way. The pride comes out of the challenge; the reward is excellence in the work. FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON OR SEND YOUR RESUME’S, BIOS, AND SALARY EXPECTATION / RATES TO CAREERS @ PROSIDIAN.COM. ONLY CANDIDATES WITH REQUIRED CRITERIA ARE CONSIDERED. Be sure to place the job reference code in the subject line of your email. Be sure to include your name, address, telephone number, total compensation package, employment history, and educational credentials.SummaryType: Full-timeFunction: AnalystExperience level: Mid-Senior LevelIndustry: Government Administration