ProSidian Consulting
Certified Data Analyst (CDA) | Excel Spreadsheet Modernization
ProSidian Consulting, Raleigh, North Carolina, United States, 27601
Certified Data Analyst (CDA) | Excel Spreadsheet Modernization
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. Launched by former Big 4 Management Consultants; our multidisciplinary teams bring together the talents of nearly 190 professionals globally to complete a wide variety of engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies. Our solution-centric services are deployed across the enterprise, target drivers of economic profit (growth, margin, and efficiency), and are aligned at the intersections of assets, processes, policies, and people delivering value. ProSidian clients represent a broad spectrum of industries including but not limited to Aerospace And Telecommunications | Consumer Products, Services, And Retail | Development And Sustainability | DOD/Military | Energy, Resources, & Industrials | Financial Services | Government & Public Services | Information Technology, Media, And Telecommunications | Life Sciences & Health Care | Manufacturing And Operations | Nuclear and Environmental | Professional Services, etc. Job Description
ProSidian Seeks a Certified Data Analyst (CDA) | Excel Spreadsheet Modernization - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis Key Personnel | Analyst 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:
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. Launched by former Big 4 Management Consultants; our multidisciplinary teams bring together the talents of nearly 190 professionals globally to complete a wide variety of engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies. Our solution-centric services are deployed across the enterprise, target drivers of economic profit (growth, margin, and efficiency), and are aligned at the intersections of assets, processes, policies, and people delivering value. ProSidian clients represent a broad spectrum of industries including but not limited to Aerospace And Telecommunications | Consumer Products, Services, And Retail | Development And Sustainability | DOD/Military | Energy, Resources, & Industrials | Financial Services | Government & Public Services | Information Technology, Media, And Telecommunications | Life Sciences & Health Care | Manufacturing And Operations | Nuclear and Environmental | Professional Services, etc. Job Description
ProSidian Seeks a Certified Data Analyst (CDA) | Excel Spreadsheet Modernization - DPLH Est.: 2080 Hrs. ST | 0 Hrs. OT on a Exempt [1099] Technical Element Basis Key Personnel | Analyst 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: