Job Description

ProSidian Seeks a Financial Analyst | Excel Spreadsheet Modernization [USDA005010] - 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 Financial Analyst 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 (Financial 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.

RESPONSIBILITIES AND DUTIES- Financial Analyst | Excel Spreadsheet Modernization [USDA005010]

Modernize budget templates, perform financial modeling, and prepare cotton price statistics and fiscal year data reports.

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.

Qualifications

Desired Qualifications For Financial Analyst | Excel Spreadsheet Modernization [USDA005010](USDA005010) Candidates:

Bachelor's/Master's in Financial Analysis or related field..  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.

Financial Management Reporting Expertise:

-- 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, revenue collections, and loan premiums/discounts data analysis.

 No specific licensure required. and Desired Skills:  No specific licensure required.

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/Master’s in Financial Analysis or related field. | Bachelor’s/Master’s in Financial Analysis or related field. 5+ years of experience.

Skills Required

Financial modeling, cash flow analysis, advanced Excel 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 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

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

ProSidian Seeks a Training Specialist | Excel Spreadsheet Modernization [USDA008013] - 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 Training 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 (Training 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- Training Specialist | Excel Spreadsheet Modernization [USDA008013]

Develop training materials, conduct training sessions, and provide ongoing support for end-users of modernized Excel templates.

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.

Qualifications

Desired Qualifications For Training Specialist | Excel Spreadsheet Modernization [USDA008013](USDA008013) Candidates:

Microsoft Office Specialist (MOS) | Expert in Excel: Certification that validates advanced Excel skills, including data analysis, automation, and advanced formulas.  Experience in training development and delivery..  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.     

 Training & Documentation Skills:

-- 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 Excel sheets effectively.  No specific licensure required. and Desired Skills:  No specific licensure required.

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 Education, IT, or related field. | Bachelor’s in IT, Education, or related field. 3+ years of experience.

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

Training development, Excel expertise, strong communication skills.

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

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

ProSidian Seeks a Business Analyst | Excel Spreadsheet Modernization [USDA004009] - 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 Business Analyst 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 (Business 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.

RESPONSIBILITIES AND DUTIES- Business Analyst | Excel Spreadsheet Modernization [USDA004009]

Analyze workflow for budget formulation and user-fee billing. Collaborate with USDA to gather and translate requirements into Excel-based solutions.

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.

Qualifications

Desired Qualifications For Business Analyst | Excel Spreadsheet Modernization [USDA004009](USDA004009) Candidates:

Certified Business Analysis Professional (CBAP): For understanding business needs and translating them into efficient technical solutions.  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:  CBAP (Certified Business Analysis Professional).

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 Business Analysis, IT. | Bachelor’s in Business Analysis or related field. 5+ years of experience.

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

Advanced Excel proficiency (data modeling, reporting). Strong analytical and documentation 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 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

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

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.

Qualifications

Desired Qualifications For Excel Specialist | Excel Spreadsheet Modernization [USDA003008](USDA003008) Candidates:

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.

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.

TECHNICAL SKILLSET ATTRIBUTES:

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.

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. 

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.  No specific licensure required. and Desired Skills:  Certified Data Analyst (CDA), 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. | Bachelor’s in IT, Computer Science, or related field. 3+ years of experience.

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

Advanced Excel proficiency (PivotTables, Power Query, VBA). Strong data analysis and reporting skills.

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

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

ProSidian Seeks a Project Manager | Excel Spreadsheet Modernization [USDA007012] - 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 Project Manager 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 (Project Manager) 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- Project Manager | Excel Spreadsheet Modernization [USDA007012]

Oversee modernization of Excel spreadsheets, coordinate tasks and manage deadlines across multiple divisions.

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.

Qualifications

Desired Qualifications For Project Manager | Excel Spreadsheet Modernization [USDA007012](USDA007012) Candidates:

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.  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:  Project Management Professional (PMP).

Education / Experience Requirements / Qualifications

Bachelor’s/Master’s in Project Management or related field. | Bachelor’s/Master’s in Project Management or related field. PMP certification required.

Skills Required

Project management, Excel proficiency, strong coordination 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 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

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

ProSidian Seeks a Excel Automation Specialist | Excel Spreadsheet Modernization [USDA006011] - 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 Automation 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 Automation 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 Automation Specialist | Excel Spreadsheet Modernization [USDA006011]

Create, modify, and troubleshoot Excel macros. Implement Power Query and Power Pivot for advanced data analysis.

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.

Qualifications

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

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

ProSidian Seeks a Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA001016] - 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: 541611 - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis located CONUS: Memphis, TN Across The South East 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.

JOB OVERVIEW

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: Memphis, TN and across the South East Region.

RESPONSIBILITIES AND DUTIES- Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA001016]

Perform data cleaning, transformation, and analysis of financial/agricultural data using Excel. Conduct advanced data analysis for USDA AMS reporting.  Provide Agriculture And Food Sector related IT Effectiveness Solutions for USDA - AMS Excel Spreadsheet Modernization Services on behalf of The United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T].  These services are considered part of the ProSidian Food And Agriculture  Sector Group with overall focuses being Food And Agriculture (FAS) Sector Group: Enhancing the provision of ecosystem-related services that support production, improve manufacturing, strengthen distribution, provide food security, maintain the environment under NAICS Code: 541611 - Administrative Management and General Management Consulting Services for The USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T] with service(s) also characterized as Market Research Financial Management Report Spreadsheet Modernization  To be successful, our Engagement Team can Illustrate capabilities, past performance, team partners, technical infrastructure, and resources available with appropriate requisite qualifications and certifications to perform effective management and delivery of Market Research Financial Management Report Spreadsheet Modernization and support solutions for Food And Agriculture  Client Industry Sector in an Agriculture And Food Environ.

USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program:  The Cotton and Tobacco Program, headquartered in Memphis, TN [3275 Appling Road Memphis, TN 38133], is one of the commodity programs within AMS.  C&T facilitates marketing by providing standardization, grading, and market news services for cotton, cotton-related products, and tobacco while also administering the Cotton Research and Promotion program.  C&T maintains a viable and valuable relationship with all segments of the U.S. cotton and tobacco industries. C&T consists of seven Divisions/Staffs including:  Grading, Standardization & Engineering, Quality Assurance, Market News, Research & Promotion, MRP Laboratory and Scientific IT Support Division, and an Administrative Staff.  The Grading and Quality Assurance Divisions provide user-fee-funded services in 10 regional cotton classing offices that serve all cotton-producing states in the U.S.  The Program also maintains one tobacco operations office based in Raleigh, NC [1306 Annapolis Drive, Room 205 Raleigh, NC 27608-0001]

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.

Qualifications

Desired Qualifications For Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA001016] (USDA001016) 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.
-- Experience with Excel Power Query and Power Pivot for advanced data modeling and analysis.

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.

Training & Documentation Skills:
-- 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 Excel sheets effectively.

Financial Management Reporting Expertise:
-- 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, revenue collections, and loan premiums/discounts data analysis.

TECHNICAL SKILLSET ATTRIBUTES:
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.

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.

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.

No specific licensure required. and Desired Skills:  Certified Data Analyst (CDA), Microsoft Office Specialist (MOS) | Expert in Excel.

EDUCATION / EXPERIENCE REQUIREMENTS / QUALIFICATIONS
Bachelor’s or Master’s in Data Science, IT, Financial Analysis. | Bachelor’s or Master’s in Data Science, IT, Financial Analysis, or related field. 5+ years of experience.
 

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.

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 #Excel #ExcelSpreadsheetModernization

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

ProSidian Seeks a Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA002017] - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis Key Personnel | Analyst 5 Labor Category - High Level Exempt [1099] Professional aligned under services related to NAICS: 541611 - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis located CONUS: Raleigh, NC Across The South East 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.

JOB OVERVIEW

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: Raleigh, NC and across the South East Region.

RESPONSIBILITIES AND DUTIES- Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA002017]

Perform data cleaning, transformation, and analysis of financial/agricultural data using Excel. Conduct advanced data analysis for USDA AMS reporting.  Provide Agriculture And Food Sector related IT Effectiveness Solutions for USDA - AMS Excel Spreadsheet Modernization Services on behalf of The United States Department of Agriculture (USDA) | USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T].  These services are considered part of the ProSidian Food And Agriculture  Sector Group with overall focuses being Food And Agriculture (FAS) Sector Group: Enhancing the provision of ecosystem-related services that support production, improve manufacturing, strengthen distribution, provide food security, maintain the environment under NAICS Code: 541611 - Administrative Management and General Management Consulting Services for The USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program [AMS | C&T] with service(s) also characterized as Market Research Financial Management Report Spreadsheet Modernization  To be successful, our Engagement Team can Illustrate capabilities, past performance, team partners, technical infrastructure, and resources available with appropriate requisite qualifications and certifications to perform effective management and delivery of Market Research Financial Management Report Spreadsheet Modernization and support solutions for Food And Agriculture  Client Industry Sector in an Agriculture And Food Environment 

USDA Agriculture Marketing Service (AMS) Cotton & Tobacco (C&T) Program:  The Cotton and Tobacco Program, headquartered in Memphis, TN [3275 Appling Road Memphis, TN 38133], is one of the commodity programs within AMS.  C&T facilitates marketing by providing standardization, grading, and market news services for cotton, cotton-related products, and tobacco while also administering the Cotton Research and Promotion program.  C&T maintains a viable and valuable relationship with all segments of the U.S. cotton and tobacco industries. C&T consists of seven Divisions/Staffs including:  Grading, Standardization & Engineering, Quality Assurance, Market News, Research & Promotion, MRP Laboratory and Scientific IT Support Division, and an Administrative Staff.  The Grading and Quality Assurance Divisions provide user-fee-funded services in 10 regional cotton classing offices that serve all cotton-producing states in the U.S.  The Program also maintains one tobacco operations office based in Raleigh, NC [1306 Annapolis Drive, Room 205 Raleigh, NC 27608-0001]

Qualifications

Desired Qualifications For Certified Data Analyst (CDA) | Excel Spreadsheet Modernization [USDA001016] (USDA001016) 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.
-- Experience with Excel Power Query and Power Pivot for advanced data modeling and analysis.

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.

Training & Documentation Skills:
-- 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 Excel sheets effectively.

Financial Management Reporting Expertise:
-- 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, revenue collections, and loan premiums/discounts data analysis.

TECHNICAL SKILLSET ATTRIBUTES:
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.

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.

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.
 No specific licensure required. and Desired Skills:  Certified Data Analyst (CDA), Microsoft Office Specialist (MOS) | Expert in Excel.

EDUCATION / EXPERIENCE REQUIREMENTS / QUALIFICATIONS
Bachelor’s or Master’s in Data Science, IT, Financial Analysis. | Bachelor’s or Master’s in Data Science, IT, Financial Analysis, or related field. 5+ years of experience.
 

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.

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 #Excel #ExcelSpreadsheetModernization

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

ProSidian Seeks a Database Integration Specialist | Excel Spreadsheet Modernization [USDA009014] - 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 Database Integration 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 (Database Integration 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- Database Integration Specialist | Excel Spreadsheet Modernization [USDA009014]

Integrate Excel sheets with databases, manage datasets for financial reporting, and ensure database queries and updates are seamless.

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.

Qualifications

Desired Qualifications For Database Integration Specialist | Excel Spreadsheet Modernization [USDA009014](USDA009014) Candidates:

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.

Experience with SQL/Access and large datasets. 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:  No specific licensure required.

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 Computer Science, IT, or related field. | Bachelor’s in Computer Science or related field. 5+ years of experience in database management.

Skills Required

Database integration with Excel, data management, SQL expertise.

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

See more jobs at ProSidian Consulting, LLC

Apply for this job

Job Description

ProSidian Seeks a Quality Assurance Specialist | Excel Spreadsheet Modernization [USDA010015] - 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: **** - 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 Quality Assurance 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 (Quality Assurance 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- Quality Assurance Specialist | Excel Spreadsheet Modernization [USDA010015]

Conduct testing of Excel spreadsheets, resolve errors in macros/formulas, and maintain version control.

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.

Qualifications

Desired Qualifications For Quality Assurance Specialist | Excel Spreadsheet Modernization [USDA010015](USDA010015) Candidates:

Quality assurance and testing experience..  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:  No specific licensure required.

Education / Experience Requirements / Qualifications

Bachelor’s in IT, Computer Science, or related field. | Bachelor’s in IT or related field. 3+ years of experience in QA and version control.

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

Quality assurance in Excel, testing macros/formulas, version control.

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

See more jobs at ProSidian Consulting, LLC

Apply for this job

See more jobs at ReSource Pro

Apply for this job

See more jobs at ReSource Pro

Apply for this job

See more jobs at iManage

Apply for this job

Apply for this job

See more jobs at Zealogics.com

Apply for this job

Apply for this job