Note: The job is a remote job and is open to candidates in USA. ProSidian Consulting is a Management and Operations Consulting Services Firm focusing on providing tailored solutions to clients. They are seeking a Certified Data Analyst (CDA) to provide data analysis and IT effectiveness solutions specifically for the Agriculture and Food Sector, particularly for the USDA.
Responsibilities
- Perform data cleaning, transformation, and analysis of financial/agricultural data using Excel
- Conduct advanced data analysis for USDA AMS reporting
- Provide Agriculture And Food Sector related IT Effectiveness Solutions for USDA - AMS Excel Spreadsheet Modernization Services on behalf of The United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T]
- Illustrate capabilities, past performance, team partners, technical infrastructure, and resources available with appropriate requisite qualifications and certifications to perform effective management and delivery of Market Research Financial Management Report Spreadsheet Modernization and support solutions for Food And Agriculture Client Industry Sector in an Agriculture And Food Environment
Skills
- Microsoft Office Specialist (MOS) | Expert in Excel
- CDA (Certified Data Analyst)
- 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
- Expertise in using VBA (Visual Basic for Applications) to create, modify, and troubleshoot macros for automating data entry, reporting, and analysis processes
- Experience with Excel Power Query and Power Pivot for advanced data modeling and analysis
- Ability to perform advanced data analysis using Excel, including data cleaning, transformation, and summarization
- Proficiency with Excel's advanced features such as PivotTables, macros, VLOOKUP, INDEX/MATCH, complex formulas, and automated reporting
- Experience with building and modernizing Excel templates that involve complex formulas, charts, and financial analysis tools
- Ability to understand and optimize the workflow, including budget formulation, financial reporting, and user-fee billing and analysis
- Familiarity with the USDA's specific reporting requirements, especially those related to cotton price statistics, revenue and collection reports, and salary/benefits tracking
- Expertise in creating comprehensive user manuals and documentation for updated spreadsheets and systems
- Experience in delivering basic training sessions for end-users, ensuring that they understand how to use the new or modernized Excel sheets effectively
- Strong experience in preparing and modernizing budget templates, exhibit expense templates, and personnel salary and benefits tracking reports
- Familiarity with USDA financial templates for fiscal year reporting, revenue collections, and loan premiums/discounts data analysis
- Experience with integrating Excel with databases (e.g., SQL or Access) to streamline the flow of data into the spreadsheets
- Ability to manage large datasets and ensure the proper structure of data for effective analysis
- Knowledge of financial modeling, cash flow analysis, and creating reports that summarize agricultural commodity data
- Proficiency in generating daily, monthly, and annual statistical reports related to cotton prices, user-fees, and revenue
- Ability to manage versions of Excel files and track changes, especially when working on complex spreadsheets across multiple divisions
- Skills in diagnosing and fixing errors in formulas, macros, and linked workbooks that may disrupt the USDA's workflow
- 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
- Bachelor's or Master's in Data Science, IT, Financial Analysis, or related field
- 5+ years of experience
- Excellent oral and written communication skills
- Proficient with Microsoft Office Products (Microsoft Word, Excel, PowerPoint, Publisher, & Adobe)
- 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
Benefits
- 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 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 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. A wide range of investment options are available with a 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: https://ProSidian.CorporatePerks.com. 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.
- 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: Pending
Company Overview