Certified Data Analyst

Job not on LinkedIn

March 25

Apply Now

Receive Emails with Similar Jobs

ProSidian Consulting

WebsiteLinkedInAll Job Openings

Consulting • Energy • Enterprise

ProSidian Consulting is an integrated management and operations consulting firm known for its strong national practice in areas such as Risk Management, Compliance, Business Process, IT Effectiveness, Energy and Sustainability, and Human Capital. The company was established by former Big 4 management consultants and employs a multidisciplinary team of nearly 190 professionals. ProSidian Consulting provides tailored and strategic solutions to private companies and government agencies across various industries, including Manufacturing, Banking & Financial Services, Consumer Products & Retail, Energy & Utilities, and Federal, State & Local Government Agencies. Their approach focuses on aligning strategies at the intersections of assets, processes, policies, and people to deliver sustainable and profitable returns.

11 - 50 employees

⚡ Energy

🏢 Enterprise

📋 Description

• Provide services and support as an Information Technology Center Support (Data Analyst) in the Agriculture and Food Industry Sector focusing on IT Effectiveness Solutions for clients such as United States Department of Agriculture (USDA) • 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 on behalf of The United States Department of Agriculture (USDA) • 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 • Flexibility to work with a variety of spreadsheet types and respond to ongoing requirements during modernization and training phases.

🎯 Requirements

• 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 • Strong experience in preparing and modernizing budget templates, exhibit expense templates, and personnel salary and benefits tracking reports.

🏖️ Benefits

• 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 - - bcbsnc.com‎) and Dental Plan (Ameritas - www.ameritas.com). • 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. Contributions are deducted from pay on a pretax basis. A wide range of investment options are available with a personal financial planner available to assist you. The Plan is a Safe Harbor 401(k) Retirement Savings Plan. • Vacation/Sick days – 2 weeks | Holidays - 10 Federal Government. • Pre-Tax Payment Programs currently exist in the form of a Premium Only Plan (POP). These Plans offer a full Flexible Spending Account (FSA) Plan and a tax benefit for eligible employees. • We want you to achieve financial success. We offer a Purchasing Discounts & Savings Plan through The ProSidian Corporate Perks Benefit Program - Helping You Do More With Less: https://ProSidian.CorporatePerks.com. This provides special discounts for eligible employees on products and services you buy on a daily basis.