Database Integration Specialist | Excel Spreadsheet Modernization [USDA009014

Database Integration Specialist | Excel Spreadsheet Modernization (USDA009014)

• Full-time

ProSidian is a Management and Operations Consulting Services Firm focusing on providing value to clients through tailored solutions based on industry-leading practices. ProSidian services focus on the broad spectrum of Enterprise Service Solutions for Risk Management, Compliance, Business Process, IT Effectiveness, Engineering, Environmental, Sustainability, and Human Capital.

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 - located CONUS: Washington, DC, and Reston, Virginia.

JOB OVERVIEW

Provide services and support as a Database Integration Specialist in the Agriculture And Food Industry Sector focusing on IT Effectiveness Solutions for clients such as the United States Department of Agriculture (USDA).

RESPONSIBILITIES AND DUTIES

• 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.

Desired Qualifications:

• 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.
• Strong background in financial analysis, data management, or agricultural economics relevant to the USDA AMS Cotton & Tobacco Program.

Summary of Key Required Skills for Success:

• Professional Certifications such as Microsoft Office Specialist (MOS) | Expert in Excel.
• Advanced Excel Proficiency, including macros, VBA, complex formulas, and data analysis.
• Data Analysis Expertise tailored to the financial and agricultural data reporting requirements.
• Financial Management Reporting experience, particularly in budget formulation and user-fee analysis.
• Training & Documentation expertise for smooth handover of modernized Excel sheets.
• Database Integration & Automation to streamline workflows and enhance reporting efficiency.

Education / Experience Requirements / Qualifications:

• Bachelor’s in Computer Science, IT, or related field.
• 5+ years of experience in database management.

Skills Required:

• Database integration with Excel, data management, SQL expertise.
• Data Analysis Expertise: Ability to perform advanced data analysis using Excel, including data cleaning, transformation, and summarization.
• 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.
• Excellent oral and written communication skills.

CORE COMPETENCIES:

• Teamwork: ability to foster teamwork collaboratively.
• Leadership: ability to guide and lead colleagues on projects and initiatives.
• Business Acumen: understanding of how organizations perform.
• Communication: ability to effectively communicate to stakeholders.
• Motivation: persistent in pursuit of quality and optimal solutions.
• Agility: ability to quickly transition between different projects.
• Judgment: exercises prudence in decision-making.
• Organization: ability to manage projects and prioritize tasks.

OTHER REQUIREMENTS:

• Understanding and proficiency with business tools and technology, including Microsoft Office.
• Commitment to working with diverse teams.
• Willingness to constantly learn and grow.

BENEFITS AND HIGHLIGHTS:

• Competitive Compensation and Group Health Insurance Benefits.
• 401(k) Retirement Savings Plan.
• Vacation and Paid Time Off (PTO) Benefits.
• Performance Incentives.

ADDITIONAL INFORMATION:

• ProSidian Consulting is an equal opportunity employer.
• FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON OR SEND YOUR RESUME TO