Structured Approach To Strategic Solutions
Certified Data Analyst, Excel Spreadsheet Modernization
Location
Tennessee
Posted
61 days ago
Salary
0
Seniority
Senior
Job Description
Certified Data Analyst, Excel Spreadsheet Modernization
ProSidian Consulting
• 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
Job 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
- 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
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)
- 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.
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
• Automate data analysis and extraction processes • Collect, clean, and interpret data from multiple sources, ensuring quality, consistency, and reliability • Develop, maintain, and enhance dashboards and reports using tools such as **Looker Studio** or **Power BI** • Create, optimize, and maintain **SQL** queries for data extraction and manipulation • Analyze trends, patterns, and behaviors to generate strategic insights • Support the development of statistical and predictive models to aid decision-making • Collaborate with technology and business teams to gather requirements and develop data-driven solutions • Ensure data governance, security, and best practices in data usage • Work with digital product metrics and business indicators • Perform data modeling • Conduct exploratory data analyses (identifying patterns, outliers, and opportunities) • Integrate data via APIs (Google, Meta, Taboola, and other sources) • Produce and maintain technical documentation • Identify and implement event triggers on websites (tagging) for digital product analytics • Work with **GTM (Google Tag Manager)** at an advanced level • Work with **GA4** at an advanced level • Master Google tools and products such as **AdSense** and **Ad Manager**
• Designing and launching surveys that will be taken by hundreds of thousands of Americans • Managing the fielding of multiple surveys simultaneously to ensure sufficient data collection on time and on budget • Tracking timelines and priorities and liaising between data scientists, engineers, and client-facing stakeholders • Supporting external outreach efforts, including presentations to clients, political partners, and other vendors and consultants • Analyzing data to answer questions from political strategists and clients • Building subject matter context and thinking critically about our data in order to discern real trends versus potential bugs to flag for our machine learning data scientists • Contributing new ideas to the ways we analyze, interpret, and communicate our data
• Performing deep-dive analysis to understand and optimize key levers of our product’s marketing funnel: acquisition, activation, engagement, and retention. • Designing core metrics that serve as North Stars for team efforts and OKRs. • Conducting quarterly prioritized analysis projects targeted at revenue and user growth. • Conducting ad-hoc analyses as defined by cross-functional partners and prioritized weekly. • Managing and maintaining dashboards in Periscope that relate operational performance across company departments and track key company metrics. • Working with product managers and engineers to design data products and run A/B experiments. • Working directly with product and business stakeholders to translate the questions and hypotheses into structured analysis. • Owning data analysis and visualization, and communicating the outcomes/insights to various partners (marketing, data, product, eng) to aid strategic decisions for improvements in experience for users.
Data Analyst
PlentyONEChanneling E-Commercial Excellence - The All-in-One Platform for Next Level E-Commerce Worldwide.
• Design and maintain internal QuickSight dashboards that allow leadership to track company performance in real-time. • Monitor and report on core commercial metrics including MRR/ARR, Net Revenue Retention (NRR), Churn, and CAC/LTV ratios. • Write high-performance SQL in Amazon Athena to join disparate datasets from S3 into clean, analysis-ready tables. • Act as a bridge between technical data and business strategy. You don't just report numbers; you highlight trends, risks, and growth opportunities. • Work with AWS Glue to ensure that internal stakeholders are always looking at "one version of the truth." • Identify drivers within data subsets to build "what-if" scenarios and predictive models for core SaaS metrics (MRR, NRR, LTV), enabling leadership to pinpoint root causes and accurately forecast growth.




