Certified Data Analyst, Excel Spreadsheet Modernization

Emploi pas sur LinkedIn

🕒 il y a 2 mois

🎸 Tennessee – Distant

🎸 Tennessee – Remote

⏰ Temps Plein

🟡 Intermédiaire

🟠 Senior

📉 Analyste de Données

Postuler Maintenant

Trouver des Emplois à Distance Similaires

Recevoir des emails pour des emplois à distance

📊 Vérifiez votre score de CV pour ce poste

Améliorez vos chances d'obtenir un entretien en vérifiant votre score de CV avant de postuler.

Télécharger le CV

ProSidian Consulting

Site WebLinkedInTous les Emplois

11 - 50 employés

⚡ Énergie

🏢 Entreprise

Consulting • Energy • Enterprise

ProSidian Consulting est un cabinet de conseil en gestion et opérations intégré, reconnu pour sa solide pratique nationale dans des domaines tels que la gestion des risques, la conformité, les processus d'affaires, l'efficacité informatique, l'énergie et la durabilité, ainsi que le capital humain. L'entreprise a été fondée par d'anciens consultants en gestion des Big 4 et emploie une équipe multidisciplinaire de près de 190 professionnels. ProSidian Consulting offre des solutions sur mesure et stratégiques aux entreprises privées et aux agences gouvernementales dans divers secteurs, y compris la fabrication, les services bancaires et financiers, les produits de consommation et la distribution, l'énergie et les services publics, ainsi que les agences gouvernementales fédérales, étatiques et locales. Leur approche se concentre sur l'alignement des stratégies aux intersections des actifs, des processus, des politiques et des personnes pour garantir des résultats durables et rentables.

Description

• 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 • Support professional services engagement for Agriculture And Food Sector Clients such as USDA • Collaborate closely with USDA’s Cotton & Tobacco divisions to understand specific spreadsheet needs, ensure user satisfaction, and deliver customized solutions • Manage multiple spreadsheet modernization tasks across divisions while ensuring timely delivery of updates and fixes • Create, modify, and troubleshoot macros for automating processes • Prepare and modernize budgeting and reporting templates • Ensure thorough, accurate, appropriately documented work products • Conduct background checks and drug testing for compliance

🎯 Exigences

• 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 • 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 • Ability to perform advanced data analysis using Excel, including data cleaning, transformation, and summarization • Proficiency with Excel’s advanced features such as PivotTables, macros, VLOOKUP, INDEX/MATCH, complex formulas, and automated reporting • Familiarity with the USDA's specific reporting requirements, especially those related to cotton price statistics, revenue and collection reports, and salary/benefits tracking • 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 • Strong experience in preparing and modernizing budget templates, exhibit expense templates, and personnel salary and benefits tracking reports • Knowledge of financial modeling, cash flow analysis, and creating reports that summarize agricultural commodity data • Ability to manage versions of Excel files and track changes, especially when working on complex spreadsheets across multiple divisions

🏖️ Avantages

• Competitive Compensation: Pay range begins in the competitive ranges with full Gold Level (Tier 1) Group Medical Benefits, Pretax Employee Benefit Plan, plus performance incentives • Group Health Insurance Including Medical, Dental And Vision Insurance: Contributions are deducted from pay on a Pretax basis - Employee and family coverage is available with employer contribution of 50% of Employee (only) premiums under the Health and Vision Plan through Blue Cross Blue Shield NC (Blue Options Medical Plan Code: PB07840 / Metallic Level: Gold) • 401(k) Retirement Savings Plans help you save for your retirement. Eligible employees can make before-tax contributions to the 401(k) Retirement Savings Plan to help you save for retirement • The flexibility of Paid Time Off (PTO) lets you set your own priorities. Eligible employees use PTO for vacation, a parent-teacher conference, a doctor’s appointment, or any number of events in your life. Currently these benefits include Vacation/Sick days – 2 weeks | Holidays - 10 Federal Government. • These Plans offer a full Flexible Spending Account (FSA) Plan and a tax benefit for eligible employees. • We offer a Purchasing Discounts & Savings Plan through The ProSidian Corporate Perks Benefit Program - Helping You Do More With Less. • A Security Clearance is a valued asset in your professional portfolio and adds to your credentials based on past, present, and future work. • ProSidian Employee & Contractor Referral Bonus Program: ProSidian Consulting will pay up to $5k for all referrals (payments made after new hire has been employed for 90 days) for candidates submitted through our Employee Referral Program. • There are performance incentives associated with each new client that each employee works to pursue and support.