P

Prosidian Consulting

Management and operations consulting firm

Database Integration Specialist - Excel Spreadsheet Modernization

Data EngineeringConfirmed live in the last 24 hours
Full-timeNo salary listed

About the Job

Requirements

  • Experience integrating Excel with databases such as SQL or Access.
  • Ability to manage large datasets and structure data for analysis.
  • Experience in Information Technology, Data Science, Financial Analysis, Statistics, Computer Science, or Business Management.
  • A bachelor's degree in Computer Science, Information Technology, or a related field.
  • At least 5 years of experience in database management.
  • Proficiency in database integration with Excel, data management, and SQL.
  • Ability to analyze, clean, transform, and summarize financial and agricultural data in Excel, including budget templates.
  • Proficiency with Excel 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 budget formulation, financial reporting, and user-fee billing and analysis workflows.
  • Familiarity with USDA reporting requirements for cotton price statistics, revenue and collection reports, and salary and benefits tracking.
  • Oral and written communication skills.
  • Proficiency with Microsoft Word, Excel, PowerPoint, Publisher, and Adobe products.
  • Proficiency in project management methodologies and tools.
  • Ability to manage multiple tasks and prioritize work to meet project milestones.
  • Ability to adapt to changing project requirements and priorities.
  • Ability to pay close attention to detail and perform analytical and organizational work.
  • Ability to use Microsoft Office tools; advanced Excel, Access, Outlook, PowerPoint, and Word skills are identified as ideal, along with proficiency in Adobe Acrobat, data analytics tools, and Visio.
  • Ability to work with colleagues and lead or guide colleagues on projects and initiatives.

Responsibilities

  • Integrate Excel sheets with databases, manage datasets for financial reporting, and ensure database queries and updates operate seamlessly.
  • Scrutinize complex macros and formulas to identify errors or inefficiencies.
  • Handle spreadsheet modernization tasks across divisions and deliver updates and fixes on time.
  • Work with USDA Cotton & Tobacco divisions to understand spreadsheet needs and deliver customized solutions.
  • Adapt spreadsheet modernization and training work to different spreadsheet types and ongoing requirements.
  • Perform advanced Excel data analysis, including cleaning, transforming, and summarizing financial and agricultural data and budget templates.
  • Build and modernize Excel templates involving complex formulas, charts, and financial analysis tools.
  • Support workflows for budget formulation, financial reporting, and user-fee billing and analysis.
  • Provide training and documentation to support handover of modernized Excel sheets.

Desired Qualifications

  • Professional certifications such as Microsoft Office Specialist (MOS) Expert in Excel and CDA.
  • A strong background in financial analysis, data management, or agricultural economics relevant to the USDA AMS Cotton & Tobacco Program.

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