Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA001006]

Certified Data Analyst (CDA) | Excel Spreadsheet ModernizationProSidian Seeks a Certified Data Analyst (CDA) | Excel Spreadsheet Modernization - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt (1099) Technical Element Basis Key Personnel | Analyst 4 Labor Category - High Level Exempt (1099) Professional aligned under services related to NAICS: located CONUS: Washington, DC, and Reston, Virginia Across The Mid Atlantic Region supporting responsible for overseeing farming, ranching, and forestry industries, as well as regulating aspects of food quality and safety and nutrition labeling.Seeking Certified Data Analyst (CDA) candidates with relevant Agriculture And Food Sector Experience (functional and technical area expertise also ideal) to support professional services engagement for Agriculture And Food Sector Clients such as USDA. This as 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 (Data Analyst) in the Agriculture And Food Industry Sector focussing on IT Effectiveness Solutions for clients such as United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program (AMS | C&T) Generally Located In CONUS: Washington, DC, and Reston, Virginia and across the Mid Atlantic Region.Perform data cleaning, transformation, and analysis of financial/agricultural data using Excel. Conduct advanced data analysis for USDA AMS reporting.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.Desired Qualifications For Certified Data Analyst (CDA) | Excel Spreadsheet Modernization Candidates: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.Excel Automation: Expertise in using VBA (Visual Basic for Applications) to create, modify, and troubleshoot macros for automating data entry, reporting, and analysis processes.Advanced Excel Skills: Proficiency with Excel's advanced features such as PivotTables, macros, VLOOKUP, INDEX/MATCH, complex formulas, and automated reporting.Business Process Understanding: Ability to understand and optimize the workflow, including budget formulation, financial reporting, and user-fee billing and analysis.Training & Documentation Skills: Expertise in creating comprehensive user manuals and documentation for updated spreadsheets and systems.Financial Management Reporting Expertise: Strong experience in preparing and modernizing budget templates, exhibit expense templates, and personnel salary and benefits tracking reports.Technical Skillset Attributes: Expertise in using VBA (Visual Basic for Applications) to create, modify, and troubleshoot macros for automating data entry, reporting, and analysis processes.Database Integration & Management: Experience with integrating Excel with databases (e.g., SQL or Access) to streamline the flow of data into the spreadsheets.Financial and Statistical Reporting: Knowledge of financial modeling, cash flow analysis, and creating reports that summarize agricultural commodity data.Version Control & Troubleshooting: Ability to manage versions of Excel files and track changes, especially when working on complex spreadsheets across multiple divisions.Skills Required: Advanced Excel proficiency (PivotTables, Power Query, VBA). Strong data analysis and reporting 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 CitizenBackground 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.Core Competencies:Teamwork – ability to foster teamwork collaboratively as a participant, and effectively as a team leaderLeadership – ability to guide and lead colleagues on projects and initiativesBusiness Acumen – understanding and insight into how organizations perform, including business processes, data, systems, and peopleCommunication – ability to effectively communicate to stakeholders of all levels orally and in writingMotivation – persistent in pursuit of quality and optimal client and company solutionsAgility – ability to quickly understand and transition between different projects, concepts, initiatives, or work streamsJudgment – exercises prudence and insight in decision-making process while mindful of other stakeholders and long-term ramificationsOrganization – ability to manage projects and activity, and prioritize tasksOther 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 sectorsCuriosity – 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 togetherHumility – exhibits grace in success and failure while doing meaningful work where skills have impact and make a differenceWillingness - to constantly learn, share, and grow and to view the world as their classroomBenefits And Highlights:Competitive Compensation: Pay range begins in the competitive ranges with full Gold Level (Tier 1) Group Medical Benefits, Pretax Employee Benefit Plan, plus performance incentivesGroup 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 - 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