P

Prosidian Consulting

Management and operations consulting firm

Certified Data Analyst - Excel Spreadsheet Modernization

Data AnalysisConfirmed live in the last 24 hours
Full-timeMemphis, TN, USANo salary listed

About the Job

Requirements

  • Bachelor’s or Master’s degree in Data Science, Information Technology, or Financial Analysis, or a related field.
  • At least 5 years of experience.
  • Expertise using Visual Basic for Applications (VBA) to create, modify, and troubleshoot macros for automating data entry, reporting, and analysis.
  • Experience with Excel Power Query and Power Pivot for data modeling and analysis.
  • Ability to perform advanced Excel data analysis, including cleaning, transformation, and summarization of financial, agricultural, and budget-template data.
  • Proficiency with PivotTables, macros, VLOOKUP, INDEX/MATCH, complex formulas, and automated reporting.
  • Experience building and modernizing Excel templates with complex formulas, charts, and financial analysis tools.
  • Ability to understand and optimize workflows for budget formulation, financial reporting, user-fee billing, and analysis.
  • Familiarity with USDA reporting requirements, including cotton price statistics, revenue and collection reports, and salary and benefits tracking.
  • Expertise creating user manuals and documentation for updated spreadsheets and systems.
  • Experience delivering basic training sessions to end users on updated or modernized Excel sheets.
  • Experience 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 and discounts data analysis.
  • Experience integrating Excel with databases such as SQL or Access.
  • Ability to manage large datasets and maintain data structures suitable for analysis.
  • Knowledge of financial modeling and cash-flow analysis, and creating reports summarizing agricultural commodity data.
  • Proficiency generating daily, monthly, and annual statistical reports on cotton prices, user fees, and revenue.
  • Ability to manage Excel file versions and track changes across complex spreadsheets.
  • Ability to diagnose and fix errors in formulas, macros, and linked workbooks.
  • Ability to scrutinize complex macros and formulas to identify errors or inefficiencies.
  • Ability to handle multiple spreadsheet modernization tasks across divisions and deliver updates and fixes on time.
  • Ability to work with USDA Cotton and Tobacco divisions to understand spreadsheet needs and deliver customized solutions.
  • Flexibility to work with different spreadsheet types and respond to ongoing modernization and training requirements.
  • Strong oral and written communication skills.
  • Proficiency with Microsoft Office products, including Word, Excel, PowerPoint, and Publisher, and Adobe.
  • Proficiency with project management methodologies and tools.
  • Ability to prioritize tasks and meet project milestones.
  • Ability to multitask and maintain attention to detail.
  • Excellent analytical and organizational skills.
  • Must be a United States citizen.
  • Must not require H-1B or TN visa sponsorship.

Responsibilities

  • Clean, transform, and analyze financial and agricultural data using Excel.
  • Conduct advanced data analysis for USDA Agriculture Marketing Service reporting.
  • Provide Excel spreadsheet modernization services and information technology effectiveness support for the USDA Agriculture Marketing Service Cotton and Tobacco Program.
  • Develop, update, and troubleshoot spreadsheet macros and automated reporting and analysis processes.
  • Integrate databases with Excel to streamline spreadsheet data flows.
  • Prepare and modernize budget, expense, salary, and benefits tracking templates and reports.
  • Generate statistical reporting on cotton prices, user fees, and revenue.
  • Document updated spreadsheet systems and train end users to use modernized Excel sheets.
  • Deliver accurate, documented work products that meet established criteria and delivery schedules.

Desired Qualifications

  • Microsoft Office Specialist certification at the Expert level in Excel.
  • Certified Data Analyst certification.
  • Strong background in financial analysis, data management, or agricultural economics relevant to the USDA Agriculture Marketing Service Cotton and Tobacco Program.
  • Certified Business Analysis Professional certification.
  • Lean Six Sigma certification.
  • Project Management Professional certification.
  • Experience in information technology, data science, financial analysis, statistics, computer science, or business management.

About the Company

Prosidian Consulting

Management and operations consulting firm

ProSidian Consulting is a management and operations consulting firm that helps private companies, Fortune 1000 enterprises, and government agencies solve problems and improve operations through tailored, industry-aligned services. It offers six enterprise practice areas: Risk Management, Energy & Sustainability, Compliance, Business Process, IT Effectiveness, and Human Capital, delivered by multidisciplinary teams across CONUS/OCONUS. The firm follows a structured approach to strategic solutions focused on growth, margin, and efficiency, aligning assets, processes, policies, and people to deliver value. With former Big 4 leadership and a nationwide/overseas footprint, its goal is to translate strategy into execution that boosts clients' return on invested capital and value delivered to customers.

Company size
11-50
Company stage
Not listed
Total funding
Not listed
Headquarters
Charlotte, NC
Founded
2008

Recently Posted Jobs

Explore more opportunities at Prosidian Consulting

See more jobs