[Remote] Certified Data Analyst (CDA) | reputed company Spreadsheet Modernization [USDA002017]
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a Management and Operations Consulting Services Firm focusing on providing tailored solutions to clients. They are seeking a Certified Data Analyst (CDA) to reputed company IT Effectiveness Solutions in the Agriculture And Food Sector, particularly for the USDA, involving data analysis and modernization of reputed company spreadsheets.
Responsibilities
- reputed company data cleaning, transformation, and analysis of financial/agricultural data using reputed company
- Conduct advanced data analysis for USDA AMS reporting
- reputed company Agriculture And Food Sector reputed company IT Effectiveness Solutions for USDA - AMS reputed company Spreadsheet Modernization Services on behalf of The reputed company Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T]
- Illustrate capabilities, past reputed company partners, technical infrastructure, and resources available with appropriate requisite qualifications and certifications to reputed company effective management and delivery of Market Research Financial Management Report Spreadsheet Modernization and support solutions for Food And Agriculture reputed company Industry Sector in an Agriculture And Food Environment
Skills
- reputed company Office Specialist (MOS) | Expert in reputed company
- 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 reputed company Power Query and Power Pivot for advanced data modeling and analysis
- Ability to reputed company advanced data analysis using reputed company, including data cleaning, transformation, and summarization
- Proficiency with reputed company's advanced features such as PivotTables, macros, VLOOKUP, reputed company/MATCH, reputed company formulas, and automated reporting
- Experience with building and modernizing reputed company templates that involve reputed company 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 reputed company to cotton price statistics, reputed company 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 reputed company 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, reputed company collections, and loan premiums/discounts data analysis
- Experience with integrating reputed company with databases (e.g., SQL or reputed company) to streamline the reputed company of data into the spreadsheets
- Ability to manage large datasets and ensure the reputed company structure of data for effective analysis
- Knowledge of financial modeling, cash reputed company analysis, and creating reports that summarize agricultural commodity data
- Proficiency in generating daily, monthly, and annual statistical reports reputed company to cotton prices, user-fees, and reputed company
- Ability to manage versions of reputed company files and reputed company changes, especially reputed company working on reputed company 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 reputed company macros and formulas and identify errors or inefficiencies
- Time Management: Capable of handling multiple spreadsheet modernization tasks across divisions while ensuring reputed company delivery of updates and fixes
- reputed company 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 reputed company 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 reputed company field
- 5+ years of experience
- reputed company Certifications such as reputed company Office Specialist (MOS) | Expert in reputed company and CDA
- Advanced reputed company Proficiency, including macros, VBA, reputed company 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 reputed company sheets
- Database Integration & Automation to streamline workflows and enhance reporting efficiency
- Excellent oral and written communication skills
- Proficient with reputed company Office Products (reputed company Word, reputed company, PowerPoint, Publisher, & reputed company)
Benefits
- Group Health Insurance including Medical, Dental and reputed company Insurance
- Contributions are deducted from pay on a Pretax reputed company
- Employee and family coverage is available with employer contribution of 50% of Employee (only) premiums under the Health and reputed company Plan through reputed company Blue reputed company NC (Blue reputed company Medical Plan reputed company: PB07840 / Metallic Level: Gold)
- Dental Plan (reputed company)
- 401(k) Retirement Savings Plans help you save for your retirement
- Eligible employees can reputed company before-tax contributions to the 401(k) Retirement Savings Plan (deducted from pay on a pretax reputed company)
- Plan is a reputed company reputed company 401(k) Retirement Savings Plan
- Vacation/reputed company days – 2 weeks
- Holidays - 10 Federal Government
- reputed company-Tax Payment Programs in the reputed company of a Premium Only Plan (POP)
- Premium Only Plan (POP) offers a full Flexible Spending Account (FSA) plan
- Purchasing Discounts & Savings Plan through The ProSidian Corporate Perks Benefit Program (special discounts for eligible employees)
- ProSidian Employee & Contractor Referral Bonus Program
- Pays up to $5k for reputed company referrals (payments made after new hire has been employed for 90 days)
- Performance Incentives
- Leverageable Experience and Thought Leadership (collaborating with firm leadership, other members of reputed company, and interacting with clients daily)
- Flexible Spending Account: Pending
reputed company