ProSidian Consulting, LLC
Excel Specialist | Excel Spreadsheet Modernization [USDA003008]
ProSidian Consulting, LLC, Washington, District of Columbia, us, 20022
Excel Specialist | Excel Spreadsheet Modernization [USDA003008]
Full-time
ProSidian is a Management and Operations Consulting Services Firm focusing on providing value to clients through tailored solutions based on industry-leading practices. ProSidian services focus on the broad spectrum of Enterprise Service Solutions for Risk Management | Compliance | Business Process | IT Effectiveness | Engineering | Environmental | Sustainability | and Human Capital. We help forward-thinking clients solve problems and improve operations.
ProSidian Seeks a Excel Specialist | Excel Spreadsheet Modernization [USDA003008] - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis Engagement Team | Analyst 5 Labor Category - High Level Exempt [1099] Professional aligned under services related to NAICS: 541620 - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis 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 Excel Specialist 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.
JOB OVERVIEW
Provide services and support as a Information Technology Center Support (Excel Specialist) 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.
RESPONSIBILITIES AND DUTIES
- Excel Specialist | Excel Spreadsheet Modernization [USDA003008]
Develop and modernize Excel templates, troubleshoot complex workbooks, and automate reporting processes using VBA.
ADDITIONAL COMPETENCIES REQUIRED:
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 Excel Specialist | Excel Spreadsheet Modernization [USDA003008]
Microsoft Office Specialist (MOS) | Expert in Excel.
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.
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.
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.
Database Integration & Management:
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.
Financial and Statistical Reporting:
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.
Version Control & Troubleshooting:
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.
Education / Experience Requirements / Qualifications
Bachelor’s in IT, Computer Science, or related field. 3+ years of experience.
Professional Certifications:
Microsoft Office Specialist (MOS) | Expert in Excel.
Certified Data Analyst (CDA).
Certified Business Analysis Professional (CBAP).
Lean Six Sigma Certification.
Project Management Professional (PMP) Certification.
Skills Required
Advanced Excel proficiency (PivotTables, Power Query, VBA).
Strong data analysis and reporting skills.
Business Process Understanding:
Ability to understand and optimize the workflow, including budget formulation, financial reporting, and user-fee billing and analysis.
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.
BENEFITS AND HIGHLIGHTS
At ProSidian, we invest in our employees to help them stay healthy and achieve work-life balance. Our team members receive a comprehensive benefits package that includes Competitive Compensation, Group Health Insurance Health Benefits, 401(k) Retirement Savings Plan Contributions, Vacation and Paid Time off (PTO) Benefits, Pre-Tax Payment Programs, Purchasing Discounts & Savings Plans, a ProSidian Employee & Contractor Referral Bonus Program, Performance Incentives, etc.
ADDITIONAL INFORMATION -
See Below Instructions On The Best Way To Apply
ProSidian Consulting is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status, or any other protected factor.
FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON http://www.ProSidian.com/ OR SEND YOUR RESUME’S, BIOS, AND SALARY EXPECTATION / RATES TO CAREERS @ PROSIDIAN.COM.
#J-18808-Ljbffr
Full-time
ProSidian is a Management and Operations Consulting Services Firm focusing on providing value to clients through tailored solutions based on industry-leading practices. ProSidian services focus on the broad spectrum of Enterprise Service Solutions for Risk Management | Compliance | Business Process | IT Effectiveness | Engineering | Environmental | Sustainability | and Human Capital. We help forward-thinking clients solve problems and improve operations.
ProSidian Seeks a Excel Specialist | Excel Spreadsheet Modernization [USDA003008] - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis Engagement Team | Analyst 5 Labor Category - High Level Exempt [1099] Professional aligned under services related to NAICS: 541620 - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis 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 Excel Specialist 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.
JOB OVERVIEW
Provide services and support as a Information Technology Center Support (Excel Specialist) 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.
RESPONSIBILITIES AND DUTIES
- Excel Specialist | Excel Spreadsheet Modernization [USDA003008]
Develop and modernize Excel templates, troubleshoot complex workbooks, and automate reporting processes using VBA.
ADDITIONAL COMPETENCIES REQUIRED:
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 Excel Specialist | Excel Spreadsheet Modernization [USDA003008]
Microsoft Office Specialist (MOS) | Expert in Excel.
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.
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.
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.
Database Integration & Management:
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.
Financial and Statistical Reporting:
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.
Version Control & Troubleshooting:
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.
Education / Experience Requirements / Qualifications
Bachelor’s in IT, Computer Science, or related field. 3+ years of experience.
Professional Certifications:
Microsoft Office Specialist (MOS) | Expert in Excel.
Certified Data Analyst (CDA).
Certified Business Analysis Professional (CBAP).
Lean Six Sigma Certification.
Project Management Professional (PMP) Certification.
Skills Required
Advanced Excel proficiency (PivotTables, Power Query, VBA).
Strong data analysis and reporting skills.
Business Process Understanding:
Ability to understand and optimize the workflow, including budget formulation, financial reporting, and user-fee billing and analysis.
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.
BENEFITS AND HIGHLIGHTS
At ProSidian, we invest in our employees to help them stay healthy and achieve work-life balance. Our team members receive a comprehensive benefits package that includes Competitive Compensation, Group Health Insurance Health Benefits, 401(k) Retirement Savings Plan Contributions, Vacation and Paid Time off (PTO) Benefits, Pre-Tax Payment Programs, Purchasing Discounts & Savings Plans, a ProSidian Employee & Contractor Referral Bonus Program, Performance Incentives, etc.
ADDITIONAL INFORMATION -
See Below Instructions On The Best Way To Apply
ProSidian Consulting is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status, or any other protected factor.
FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON http://www.ProSidian.com/ OR SEND YOUR RESUME’S, BIOS, AND SALARY EXPECTATION / RATES TO CAREERS @ PROSIDIAN.COM.
#J-18808-Ljbffr