Database Integration Specialist – Excel Spreadsheet Modernization

This is a fully remote position, open to applicants in District of Columbia, +2 more states.

📋 Description

• Integrate Excel spreadsheets with databases.

• Oversee datasets for financial reporting purposes.

• Ensure that database queries and updates are executed smoothly.

• Offer Information Technology Center Support in the role of Database Integration Specialist.

• Assist clients in the Agriculture and Food Sector, including the USDA and the USDA Agricultural Marketing Service Cotton & Tobacco Program.

• Revamp Excel sheets and templates that involve intricate formulas, charts, and financial analysis tools.

• Conduct data cleaning, transformation, summarization, and advanced analysis.

• Enhance workflows related to budget formulation, financial reporting, and user-fee billing and analysis.

• Facilitate reporting encompassing cotton price statistics, revenue and collection reports, as well as salary/benefits tracking.

• Provide user training and document modernized Excel sheets for handoff.

• Collaborate with USDA Cotton & Tobacco divisions to comprehend spreadsheet requirements and deliver tailored solutions.

• Ensure that deliverables are comprehensive, accurate, well-documented, and compliant with established standards.

• Adhere to project milestones and delivery timelines.

⛳️ Requirements

• Bachelor’s degree in Computer Science, IT, or a related discipline.

• A minimum of 5 years of experience in database management.

• Proven experience in integrating Excel with databases like SQL or Access.

• Experience in managing extensive datasets and structuring data for optimal analysis.

• Background in Information Technology, Data Science, Financial Analysis, Statistics, Computer Science, or Business Management.

• Strong expertise in financial analysis, data management, or agricultural economics pertinent to the USDA AMS Cotton & Tobacco Program.

• Professional certifications such as Microsoft Office Specialist (MOS) Expert in Excel and CDA.

• Advanced proficiency in Excel, including macros, VBA, complex formulas, PivotTables, VLOOKUP, INDEX/MATCH, charts, and automated reporting.

• Expertise in data analysis for financial and agricultural data reporting.

• Experience in financial management reporting, particularly in budget formulation and user-fee analysis.

• Skills in training and documentation.

• Competence in database integration and automation.

• Proficiency in database integration with Excel, data management, and SQL.

• Familiarity with Microsoft Office products: Word, Excel, PowerPoint, Publisher, and Adobe.

• Ideal expertise in Excel, Access, Outlook, PowerPoint, Word, Adobe Acrobat, data analytic tools, and Visio.

• Knowledge of project management methodologies and tools.

• Exceptional oral and written communication abilities.

• United States citizenship is required.

• Visa sponsorship is not available; H-1B and TN visa sponsorship cannot be provided.

• Candidates are subject to background checks and potential drug testing.

• Must comply with regulatory and mandatory training requirements.

🏝️ Benefits

• Competitive Compensation.

• Group health insurance, which includes medical, dental, and vision coverage.

• Employer contribution of 50% towards employee-only premiums under the Health and Vision Plan.

• 401(k) Retirement Savings Plan offering before-tax contributions, investment options, and access to a personal financial planner.

• Vacation and Paid Time Off (PTO) benefits.

• Two weeks of vacation/sick leave.

• 10 federal government holidays.

• Pre-Tax Payment Programs.

• Flexible Spending Account (FSA) Plan.

• Discounts and savings through the ProSidian Corporate Perks Benefit Program.

• Employee & Contractor Referral Bonus Program offering up to $5k after the new hire has completed 90 days of employment.

• Performance incentives.

• Opportunities for professional connections and valuable experience.

• Access to thought leadership opportunities.

• Flexible work arrangements, allowing employees to work remotely.