Business Analyst | Excel Spreadsheet Modernization [USDA004009]

Business Analyst | Excel Spreadsheet Modernization

ProSidian is seeking a Business Analyst for Excel Spreadsheet Modernization. This is a technical element or contract W-2 (IRS-1099) position and ProSidian reserves the right to convert to a full-time ProSidian employed W-2 position.

Provide services and support as a Information Technology Center Support (Business Analyst) in the Agriculture And Food Industry Sector focusing on IT Effectiveness Solutions for clients such as United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program Generally located in CONUS: Washington, DC, and Reston, Virginia and across the Mid Atlantic Region.

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

Responsibilities and Duties - Business Analyst | Excel Spreadsheet Modernization

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

Additional Competencies Required

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.

Qualifications

Desired qualifications for Business Analyst | Excel Spreadsheet Modernization candidates:

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. No specific licensure required.

Summary of key required skills for success:

1. Professional Certifications such as Microsoft Office Specialist (MOS) | Expert in Excel and CDA.

2. Advanced Excel Proficiency, including macros, VBA, complex formulas, and data analysis.

3. Data Analysis Expertise tailored to the financial and agricultural data reporting requirements.

4. Financial Management Reporting experience, particularly in budget formulation and user-fee analysis.

5. Training & Documentation expertise for smooth handover of modernized Excel sheets.

6. Database Integration & Automation to streamline workflows and enhance reporting efficiency.

Education / Experience Requirements / Qualifications:

Bachelor's in Business Analysis, IT. | Bachelor's in Business Analysis or related field. 5+ years of experience.

Professional Certifications:

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.

Skills Required:

Advanced Excel proficiency (data modeling, reporting). Strong analytical and documentation skills.

Competencies Required:

Excellent oral and written communication skills (This employer participates in the e-Verify program). Proficient with Microsoft Office Products (Microsoft Word, Excel, PowerPoint, Publisher, & Adobe)

Ancillary Details Of The Roles:

Employees are subject to regulatory and mandatory training requirements. These requirements will change for individuals based on their job duties or position assignment.

Standard Skills Required: 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.

EEO Statement: We attract the best people in the industry, supporting their efforts to learn and grow. We strive to create a challenging and progressive work environment. We provide career opportunities spanning various disciplines and geographic locations, with projects that our employees plan, design, build, and operate as diverse as the needs of our clients.

Full Time Regular VISA Sponsorship: No - We will not support sponsorship, i.e., H-1B or TN Visas for this position. U.S. Citizenship Required - You must be a United States Citizen

Background Check And Drug testing: ProSidian reserves the right to require background checks, including criminal, employment, education, licensure, etc. as well as credit and motor vehicle when applicable for certain positions. In addition, ProSidian may conduct drug testing for designated positions.

Other Details:

Work products shall be thorough, accurate, appropriately documented, and comply with established criteria. All employees, in the performance of their respective responsibilities, shall conduct themselves in the highest possible standards of ethical and business conduct. The candidate shall ensure that duties are performed in a competent and professional manner that meets milestones/delivery schedules as outlined.

#TechnicalCrossCuttingJobs #Consulting #ProfessionalAnalyticalSupport #Jugaad

Core 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.
• 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 Highlights

At 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