ProSidian Consulting logo
ProSidian Consulting

Structured Approach To Strategic Solutions

Certified Data Analyst, Excel Spreadsheet Modernization

Data AnalystData AnalystFull TimeRemoteSeniorTeam 11-50H1B No SponsorCompany SiteLinkedIn

Location

Tennessee

Posted

61 days ago

Salary

0

Seniority

Senior

Bachelor Degree5 yrs expEnglishVBA

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 Categories

Related Job Pages

More Data Analyst Jobs

Clicksoft logo

Data Analyst

Clicksoft

Digital solutions for innovative ideas.

Data Analyst61 days ago
Full TimeRemoteTeam 11-50Since 2001H1B No Sponsor

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

Brazil
R$0 - R$10K / month
Job Closed
Full TimeRemoteTeam 11-50H1B No Sponsor

• 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

United States
$70K - $100K / year
Full TimeRemoteTeam 11-50H1B No Sponsor

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

California
PlentyONE logo

Data Analyst

PlentyONE

Channeling E-Commercial Excellence - The All-in-One Platform for Next Level E-Commerce Worldwide.

Data Analyst62 days ago
Full TimeRemoteTeam 201-500Since 2006H1B No Sponsor

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

Germany
Job Closed