Desired Qualifications For Excel Automation Specialist | Excel Spreadsheet Modernization [USDA006011] (USDA006011) Candidates:
Excel Automation:
-- 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.
Certified Business Analysis Professional (CBAP): For understanding business needs and translating them into efficient technical solutions. Microsoft Office Specialist (MOS) | Expert in Excel, experience in VBA.. 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. and Desired Skills: Microsoft Office Specialist (MOS) | Expert in Excel.
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 IT, Computer Science, or related field. | Bachelor’s in IT or related field. 5+ years of experience in VBA/Excel automation.
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
VBA expertise, advanced Excel automation, Power Pivot/Power Query proficiency.
FUNCTIONAL SKILLSET ATTRIBUTES:
Data Analysis Expertise: Ability to perform advanced data analysis using Excel, including data cleaning, transformation, and summarization. This includes strong experience with financial data, agricultural data, and budget templates.
Advanced Excel Skills:
-- 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.
Business Process Understanding:
-- 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.
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