Business Analyst | Excel Spreadsheet Modernization [USDA004009]

ProSidian Consulting is a management and operations consulting services firm providing tailored enterprise solutions across business and technology domains. The Business Analyst will support USDA agriculture and food sector clients by analyzing budget formulation and user-fee billing workflows, gathering requirements, and developing Excel-based modernization solutions. The role also involves collaborating with USDA divisions, addressing spreadsheet issues, and supporting training and documentation.

Responsibilities:

• Analyze workflow for budget formulation and user-fee billing. Collaborate with USDA to gather and translate requirements into Excel-based solutions
• Attention to Detail: Ability to scrutinize complex macros and formulas and identify errors or inefficiencies
• Time Management: Capable of handling multiple spreadsheet modernization tasks across divisions while ensuring timely delivery of updates and fixes
• Collaborative Teamwork: Ability to work closely with USDA’s Cotton & Tobacco divisions to understand specific spreadsheet needs, ensure user satisfaction, and deliver customized solutions
• Adaptability: Flexibility to work with a variety of spreadsheet types and respond to ongoing requirements during modernization and training phases

Requirements:

• Seeking Business Analyst candidates with relevant Agriculture And Food Sector Experience (functional and technical area expertise also ideal) to support professional services engagement for Agriculture And Food Sector Clients such as USDA
• Attention to Detail: Ability to scrutinize complex macros and formulas and identify errors or inefficiencies
• Time Management: Capable of handling multiple spreadsheet modernization tasks across divisions while ensuring timely delivery of updates and fixes
• Collaborative Teamwork: Ability to work closely with USDA's Cotton & Tobacco divisions to understand specific spreadsheet needs, ensure user satisfaction, and deliver customized solutions
• Adaptability: Flexibility to work with a variety of spreadsheet types and respond to ongoing requirements during modernization and training phases
• Experience in Information Technology, Data Science, Financial Analysis, Statistics, Computer Science, or Business Management
• Strong background in financial analysis, data management, or agricultural economics relevant to the USDA AMS Cotton & Tobacco Program
• 1. Professional Certifications such as Microsoft Office Specialist (MOS) | Expert in Excel and CDA
• 1. Advanced Excel Proficiency, including macros, VBA, complex formulas, and data analysis
• 1. Data Analysis Expertise tailored to the financial and agricultural data reporting requirements
• 1. Financial Management Reporting experience, particularly in budget formulation and user-fee analysis
• 1. Training & Documentation expertise for smooth handover of modernized Excel sheets
• 1. Database Integration & Automation to streamline workflows and enhance reporting efficiency
• Bachelor's in Business Analysis, IT. | Bachelor's in Business Analysis or related field. 5+ years of experience
• Microsoft Office Specialist (MOS) | Expert in Excel: Certification that validates advanced Excel skills, including data analysis, automation, and advanced formulas
• Certified Data Analyst (CDA): Ensures proficiency in data analysis and management, relevant for handling the financial and statistical reporting required
• Certified Business Analysis Professional (CBAP): For understanding business needs and translating them into efficient technical solutions
• Lean Six Sigma Certification: To streamline processes, which is critical for modernizing complex, macro-heavy Excel sheets
• Project Management Professional (PMP) Certification: Essential for managing the modernization of Excel spreadsheets and meeting deadlines for different divisions
• Advanced Excel proficiency (data modeling, reporting). Strong analytical and documentation skills
• Excellent oral and written communication skills
• Proficient with Microsoft Office Products (Microsoft Word, Excel, PowerPoint, Publisher, & Adobe)
• Proficiency in project management methodologies and tools
• Exceptional leadership and interpersonal skills for effective team management
• Outstanding time management and prioritization abilities to meet project milestones
• Adaptability to changing project requirements and priorities
• Ability to multi-task and pay close attention to detail
• Excellent analytical, organizational and time management skills
• Strong communication skills, both oral and written
• U.S. Citizenship Required - You must be a United States Citizen
• ability to foster teamwork collaboratively as a participant, and effectively as a team leader
• ability to guide and lead colleagues on projects and initiatives
• understanding and insight into how organizations perform, including business processes, data, systems, and people
• ability to effectively communicate to stakeholders of all levels orally and in writing
• persistent in pursuit of quality and optimal client and company solutions
• ability to quickly understand and transition between different projects, concepts, initiatives, or work streams
• exercises prudence and insight in decision-making process while mindful of other stakeholders and long-term ramifications
• ability to manage projects and activity, and prioritize tasks
• 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