Certified Data Analyst, Excel Spreadsheet Modernization

This is a fully remote position, open to applicants in District of Columbia, +2 more states.

📋 Description

• Execute data cleaning, transformation, and analysis of financial and agricultural datasets utilizing Excel.

• Carry out advanced data analysis for USDA AMS reporting purposes.

• Offer Information Technology Center Support as a Data Analyst for clients in the Agriculture and Food sectors.

• Assist the USDA Agriculture Marketing Service Cotton & Tobacco Program.

• Develop, adjust, and troubleshoot VBA macros for automating data entry, reporting, and analysis tasks.

• Employ Power Query and Power Pivot for comprehensive data modeling and analysis.

• Design and enhance Excel templates featuring intricate formulas, charts, and financial analysis tools.

• Streamline workflows related to budget formulation, financial reporting, and user-fee billing and analysis.

• Prepare and refresh reports on budget, expenses, salaries, benefits, revenue, and loan premiums/discounts.

• Integrate Excel with databases and handle large datasets effectively.

• Produce daily, monthly, and annual statistical reports concerning cotton prices, user fees, and revenue.

• Oversee Excel file version control and track changes across various divisions.

• Identify and resolve issues in formulas, macros, and linked workbooks.

• Develop user manuals and documentation for updated spreadsheets and systems.

• Conduct introductory training sessions for end users.

• Collaborate with USDA Cotton & Tobacco divisions to ascertain spreadsheet requirements and provide tailored solutions.

• Ensure that work products are precise, well-documented, compliant, and delivered in accordance with set milestones.

⛳️ Requirements

• Bachelor’s or Master’s degree in Data Science, IT, Financial Analysis, or a related discipline.

• Over 5 years of relevant experience.

• Microsoft Office Specialist (MOS) Expert certification in Excel.

• Certified Data Analyst (CDA) certification.

• Solid background in financial analysis, data management, or agricultural economics pertinent to the USDA AMS Cotton & Tobacco Program.

• Proficiency in VBA for the creation, modification, and troubleshooting of Excel macros.

• Experience with Excel Power Query and Power Pivot.

• Advanced skills in Excel, including PivotTables, macros, VLOOKUP, INDEX/MATCH, intricate formulas, charts, and automated reporting.

• Experience in constructing and modernizing Excel templates.

• Familiarity with budget formulation, financial reporting, and user-fee billing and analysis.

• Knowledge of USDA reporting standards.

• Expertise in producing user manuals and documentation.

• Experience in facilitating training sessions for end users.

• Experience in preparing budget templates, exhibit expense templates, and reports for tracking personnel salaries and benefits.

• Familiarity with integrating Excel with databases like SQL or Access.

• Capability to manage extensive datasets.

• Understanding of financial modeling and cash flow analysis.

• Ability to generate daily, monthly, and annual statistical reports.

• Skills in version control and troubleshooting for Excel files, formulas, macros, and linked workbooks.

• Excellent verbal and written communication abilities.

• Proficient with Microsoft Office products, including Word, Excel, PowerPoint, Publisher, and Adobe.

• Familiarity with project management methodologies and tools.

• U.S. citizenship is required.

• Visa sponsorship is not available; H-1B and TN visas are not supported.

• Subject to background checks and potential drug testing.

• Compliance with regulatory and mandatory training requirements.

🏝️ Benefits

• Competitive compensation package.

• Group health insurance, encompassing medical, dental, and vision coverage.

• Employer covers 50% of employee-only premiums under the Health and Vision Plan.

• 401(k) Retirement Savings Plan featuring before-tax contributions and investment options.

• Vacation/Sick days – 2 weeks.

• 10 Federal Government holidays.

• Pre-Tax Payment Programs.

• Flexible Spending Account (FSA) Plan.

• Discounts and savings plan for purchases.

• Employee & Contractor Referral Bonus Program, offering up to $5k for referrals after the new hire has completed 90 days of employment.

• Performance incentives.

• Opportunities for career advancement and professional development.

• Flexible work arrangements, including remote work options.