Business Analyst | Excel Spreadsheet Modernization [USDA004009]

Summary

ProSidian Consulting is a Management and Operations Consulting Services Firm that focuses on providing tailored solutions to clients across various sectors. They are seeking a Business Analyst with expertise in Excel Spreadsheet Modernization to support the Agriculture and Food Sector, particularly for clients such as the USDA. The role involves analyzing workflows, collaborating with clients to gather requirements, and delivering Excel-based solutions.

Responsibilities

• Analyze workflow for budget formulation and user-fee billing
• Collaborate with USDA to gather and translate requirements into Excel-based solutions

Skills

• Certified Business Analysis Professional (CBAP): For understanding business needs and translating them into efficient technical solutions
• 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
• Professional Certifications such as Microsoft Office Specialist (MOS) | Expert in Excel and CDA
• Advanced Excel Proficiency, including macros, VBA, complex formulas, and data analysis
• Data Analysis Expertise tailored to the financial and agricultural data reporting requirements
• Financial Management Reporting experience, particularly in budget formulation and user-fee analysis
• Training & Documentation expertise for smooth handover of modernized Excel sheets
• 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

Qualifications

Must Haves

• Certified Business Analysis Professional (CBAP): For understanding business needs and translating them into efficient technical solutions
• 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
• Professional Certifications such as Microsoft Office Specialist (MOS) | Expert in Excel and CDA
• Advanced Excel Proficiency, including macros, VBA, complex formulas, and data analysis
• Data Analysis Expertise tailored to the financial and agricultural data reporting requirements
• Financial Management Reporting experience, particularly in budget formulation and user-fee analysis
• Training & Documentation expertise for smooth handover of modernized Excel sheets
• 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

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 of 50% of Employee (only) premiums under the Health and Vision Plan through Blue Cross Blue Shield NC (Blue Options Medical Plan Code: PB07840 / Metallic Level: Gold - - bcbsnc.com‎) and Dental Plan (Ameritas - www.ameritas.com).
• 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.
• The Plan is a Safe Harbor 401(k) Retirement Savings Plan.
• Vacation/Sick days – 2 weeks
• Holidays - 10 Federal Government
• 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.
• Pre-Tax Employee Benefit Plan
• Purchasing Discounts & Savings Plan through The ProSidian Corporate Perks Benefit Program - Helping You Do More With Less (special discounts for eligible employees on products and services you buy on a daily basis).
• ProSidian Employee & Contractor Referral Bonus Program (pay up to $5k for all referrals; payments made after new hire has been employed for 90 days).
• Performance Incentives
• Security Clearance (Due to the nature of our management and operations consulting engagements...)