We are seeking a highly skilled and efficient Freelance Data Analyst for a short-term project focused on Excel-based data analysis. The ideal candidate will have a strong background in data analytics, with an emphasis on extracting insights and trends from complex datasets using Microsoft Excel. Responsibilities: Collect, process, and clean data from various sources to prepare it for analysis. Utilize advanced Excel functions and formulas to analyze large datasets. Create and maintain complex spreadsheets and databases. Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality. Interpret data, analyze results using statistical techniques, and provide ongoing reports. Identify, analyze, and interpret trends or patterns in complex data sets. Work closely with management to prioritize business and information needs. Present data through reports and visualization to assist in decision-making processes. Requirements: Proven working experience as a data analyst, particularly with Excel. Basic Knowledge of statistics for analyzing datasets Adept at queries, report writing, and presenting findings.

We are seeking an experienced analyst to consolidate estimates from various sources into a comprehensive report. The ideal candidate will have strong analytical skills and the ability to work with large datasets. You will be responsible for ensuring data accuracy and providing insights to support business decisions. Familiarity with financial analysis and economics is essential.

Title: Compensation & Market Intelligence Analyst – Account Analyst (Los Angeles, CA) Project Overview We are seeking an experienced Compensation Analyst, HR Consultant, Talent Intelligence Consultant, or Market Research Professional to conduct a comprehensive labor market analysis for an Account Analyst position located in Los Angeles, California. The objective is to determine current market compensation, identify competing employers, evaluate talent availability, and provide actionable recommendations for recruiting and compensation strategy. Deliverables Compensation Analysis Base salary ranges (25th, 50th, 75th, and 90th percentile) Total compensation analysis Bonus and incentive trends Benefits benchmarking Geographic differentials within Los Angeles County and Southern California Competitive Market Assessment Top 15–25 employers hiring comparable talent Competitor compensation estimates Current job openings and hiring trends Talent demand analysis Candidate supply assessment Comparable Position Analysis Research and benchmark similar roles including: Account Analyst Financial Analyst Revenue Analyst Client Services Analyst Business Analyst Account Management Analyst Sales Operations Analyst Customer Success Analyst Compensation Analyst (where applicable) Recruiting Intelligence Recommended salary range for attracting top 25% talent Recommended salary range for attracting average talent Time-to-fill expectations Candidate availability Key qualifications employers are requesting Skills currently commanding premium compensation Executive Summary Provide a concise executive report outlining: Market competitiveness Recruiting risks Compensation recommendations Hiring strategy recommendations Required Experience Compensation analysis Salary benchmarking HR consulting Talent intelligence Workforce planning Labor market research Recruiting analytics Preferred Tools & Sources Please indicate which data sources you utilize, such as: Mercer Radford Salary.com Payscale LinkedIn Talent Insights Indeed Glassdoor BLS Lightcast / EMSI Proprietary compensation databases Project Budget Please provide: Fixed-price proposal Estimated timeline Sample reports (redacted if necessary) Description of methodology Deliverable Format Executive PowerPoint or PDF report Supporting spreadsheet with compensation data Summary recommendations suitable for executive leadership review

Provide hourly Rate and References. Need 15-20 hours per week to fulfill the following work: Must be and expert in Quickbooks, Excel, Sales Force (SFDC)/Field Service Lightning. WHEN YOU SUBMIT FOR THIS ROLE - SEND RELATIVE EXPERIENCE ON THESE ITEMS ONLY. AND A RESUME. THANK YOU. Monthly Responsibilities • Checking Invoice Coding vs Salesforce (Regions, Reps, & Service Lines) • Sanitizing Invoice Data so that Quote Numbers and Reps are included on all possible revenue transactions (Accruals) • Sales By Rep Detail Report • Quickbooks Invoice Data Upload for Salesforce (Sent to Greg Monthly) • Regional Dashboard Update – More for reference as questions comes up and the data is useful for historical reporting at a more detailed level • Labor Utilization Report (ADP vs FSL) • Monthly Labor Stats Report • Regional Labor Cost Reclass Entry • Expense Reports for Department Heads (Sales and Engineering Meetings , IT & HR Reports) • Regional Operations P&L Reports and Meeting • Backlog/Forecast Variance Check vs Invoice Data (See where Reps missed their forecast) • NEW Maintenance / Capex / Inventory Budget Meeting – Request from Ian for Maintenance Department Leadership Other Responsibilities • Weekly Labor Utilization Report • Adhoc Historical Reporting o Happens every month but for different reasons. Last month was Propane Reporting and Historical Service Line match with Salesforce (2022 – 2023) • Adhoc Quote and/ or Job Margin Analysis • Customer Sales with Class + State (couple times a year for Lu) • Rate Sheet Analysis – Pricebook Compare File • Format Ratesheets for upload into Salesforce Potential Project Work • ERP Implementation Support – I have deep understanding of Envent’s Invoice and expense data. I have a lot of insight on what is possible, what needs work, and what can be slightly adjusted for a successful ERP implementation. I also have deep knowledge of FSL, Salesforce and ADP data. • Rate Sheet process improvements – Having a base Rate Sheet so that all future analysis and discounts can be graded against the Base Rate Sheet, whether that Street Rates or not • Quote Margin Tool – I have a process that I believed can be incorporated into Salesforce quotes at scale to have an estimated or expected margin for the quote/ job. I had a meeting with Greg and he agrees it is possible. • Ensure that all Rate Sheets are current and up to date in Salesforce. Assist in creating and organizing Rate Sheets for new/existing customers. • Interact with vendors, customers and other stakeholders. • Develop market intelligence, assisting in the determination of addressable market size and opportunities for growth. • Work with the sales team to review new business development opportunities, ensuring profitable projects are pursued. QUALIFICATIONS BS Degree in Finance, Accounting or Business Key Performance Metrics Data Accuracy: Invoice coding and Salesforce alignment accuracy Forecast Accuracy: Variance between forecast, backlog, and invoiced revenue Labor Visibility: Timeliness and accuracy of labor utilization reporting Margin Improvement: Contribution to job, quote, and contract margin expansion Pricing Discipline: Adoption and consistency of rate sheets and pricing standards Contract Uplift: Identified and realized rate improvements in customer contracts Reporting Timeliness: On-time delivery of monthly and weekly reporting

PROFILE SOUGHT: - MBA + business development-related or C-level experience in midmarket manufacturing with strong global business experience - Management consulting in corporate strategy, or private equity operating roles - Thinks in frameworks and key principles + no-nonsense pragmatically-oriented thinker - Acute ability to capture the gist of a situation and to develop logical strategies - Works fast, comfortable reviewing long documents without getting lost in details - Data-driven, always analyzes and makes recommendations linked to real facts and figures, and develops what-if scenarios that quantify the potential impact of recommendations - Realistic, with a constructive can-do solution-oriented attitude but also, at the same time, in an objective manner, recognizing risks and suggesting de-risking options - Flexible and agile, able and willing to turn around a document review as quickly as WITHIN 1 HOUR when we are under pressure and extremely tight deadlines (in which case we expect a quick review and quick-fixes, of course, not a detailed one), or to dig deep into data and (re)develop a document for hours or days, if need be, or to advise and guide a junior analyst and provide feedback and next-steps iteratively. - 100% confidentiality, working under NDA TASKS AND DELIVERABLES: Annotated deck Slide-by-slide comments and suggestions Debrief call if needed FIRST PROJECT: We've produced a 36-slide strategic review for a mid-sized B2B industrial manufacturer looking for a new perspective on its business (trends, current situation, projections and recommendations). This is a small company (~$10M). What we need you to do: Flag issues Highlight key ideas Add your own observations, interpretations and insights Propose alternative frameworks and ways to structure the argument, sequencing, narrative, visualizations Provide slide-by-slide comments and recommendations, and overall comments and recommendations on how to improve our document.

Senior Manufacturing Planning Analyst (Excel + NetSuite/MRP) Job Description TOTB Consult is seeking an experienced Manufacturing Planning Analyst to support a strategic assessment for a global manufacturing client. This engagement will focus on analyzing an existing Excel-based production planning and forecasting workbook, documenting the underlying business logic, and identifying opportunities to align current-state planning capabilities with NetSuite ERP/MRP functionality. This is not a spreadsheet cleanup project. We are looking for someone who can think beyond formulas and understand the manufacturing planning processes, decision logic, and operational workflows embedded within the workbook. The selected consultant will work closely with the Principal Consultant to evaluate the client’s current planning environment and contribute to a future-state planning and automation roadmap. Responsibilities • Analyze a complex Excel workbook used for production planning and forecasting. • Document business rules, formulas, assumptions, workflows, and dependencies embedded within the workbook. • Identify manual activities, operational risks, and single points of failure. • Assess current-state planning capabilities and determine opportunities to leverage NetSuite ERP/MRP functionality. • Assist in mapping planning processes, information flows, and business requirements. • Identify gaps between current-state planning processes and future-state ERP capabilities. • Provide recommendations that support a phased planning transformation roadmap. • Participate in review sessions with the Principal Consultant as needed. Required Qualifications • Advanced Microsoft Excel expertise, including complex formulas, PivotTables, Power Query, and workbook analysis. • Experience supporting manufacturing, supply chain, production planning, inventory planning, or demand forecasting. • Experience documenting business processes and translating operational workflows into functional requirements. • Strong analytical and problem-solving skills. • Excellent written documentation skills. Preferred Qualifications • Experience with NetSuite ERP or NetSuite Advanced Manufacturing. • Experience with other ERP/MRP platforms (SAP, Oracle, Dynamics, Epicor, Infor, etc.). • Experience supporting ERP implementations or digital transformation initiatives. • Familiarity with manufacturing planning concepts such as demand planning, capacity planning, inventory management, supplier planning, and production scheduling. • Experience creating process maps, gap analysis, and transformation roadmaps. Deliverables The selected consultant will support the development of: • Current-State Planning Assessment • Planning Logic Documentation • Business Process Maps • Operational Dependency Assessment • Gap Analysis • ERP/MRP Capability Mapping • Recommendations supporting a future-state planning roadmap We are seeking the best fit for this engagement. Candidates with strong manufacturing planning and ERP experience are encouraged to apply. Compensation will be based on experience and demonstrated expertise.

About the Role: Boxplot is looking for a versatile, senior-level Data Professional to join our hands-on consulting team. This is a high-impact role where you will dive into diverse client ecosystems, solving complex problems across multiple industries. We aren't looking for someone to just "run queries"—we need a strategic thinker who can bridge the gap between sophisticated data engineering and clear business storytelling. As a remote-first firm, we value radical transparency, high-level ownership, and the ability to work autonomously. What You’ll Do: - Build production-ready dashboards and Python/Pandas analysis pipelines that drive real business decisions. - Translate vague business questions into structured technical workflows. - Act as a lead on client engagements, eventually taking full ownership of communication and project management. - Maintain high-quality, extensive technical documentation to ensure project continuity and client success. - Leverage tools like n8n and APIs to streamline workflows and integrate emerging AI technologies. - Manage and peer-review work from specialized contractors to ensure Boxplot’s quality standards are met. Technical Requirements: We are looking for a "hit-the-ground-running" expert. You should have 5+ years of experience (minimum 3) in a data-heavy role. - Advanced proficiency in SQL, Python, and Pandas. - Ability to create advanced, insight-driven dashboards in Tableau (Power BI is a plus). - Familiarity with Azure, AWS, or Microsoft Fabric is highly preferred. - Previous experience in a client-facing or agency environment is a significant advantage. More About the Role and Our Culture To thrive here, you should identify with the following: - You enjoy switching gears between projects and stay calm in a fast-paced environment. - You have a "figure it out" mentality and don't require constant hand-holding to deliver high-quality code. - You understand that in a remote environment, visibility is key. You are proactive about sharing daily progress and keeping stakeholders in the loop. - You can explain complex technical concepts to non-technical clients with ease and grace. Compensation & Benefits: - Flexibility: We offer a very high degree of autonomy. As long as you are meeting deadlines and are available during US-based timezones, you control your schedule and location. - Benefits: 401k (4% match), disability insurance, workers' comp, and a generous, flexible PTO/sick day policy. - Health Insurance: While we do not offer a group plan, we provide a negotiable stipend to help cover your Marketplace insurance costs. Interview Process: 1. Introductory Call (30 min): A vibe check to discuss your background and our culture. 2. Technical Deep Dive (30-60 min): A practical review of your technical skills and problem-solving approach. Benefits: 401(k) 401(k) matching Flexible schedule Paid time off

We are looking for a part-time Financial Analyst to help screen and analyze lower-middle-market acquisition opportunities. This role is for someone who understands financial statements, business quality, deal screening, and investment analysis. You will help review incoming deal flow, evaluate opportunities against our investment criteria, use AI tools to move faster, and prepare concise investment summaries and memos. What You’ll Do Review CIMs, teasers, financials, and seller-provided materials Screen deals based on industry, size, margin profile, customer concentration, growth, valuation, and fit with our criteria Use AI tools to quickly summarize materials, compare opportunities, and rank deals Build simple financial summaries and valuation snapshots Identify key risks, red flags, and follow-up questions Prepare short investment memos for deals worth further review Help keep the pipeline organized and prioritized Ideal Candidate Background in finance, investment banking, private equity, M&A, corporate finance, or deal analysis Strong understanding of EBITDA, margins, working capital, valuation, and business quality Comfortable reviewing CIMs, financial statements, and business profiles Able to think critically and identify what matters quickly Comfortable using AI tools like ChatGPT, Claude, Perplexity, or similar tools to improve speed and quality Clear writer who can summarize complex information in a simple, practical way Self-starter who can work independently with minimal supervision Time Commitment This is a part-time role, around 5 to 10 hours per week to start. Workload may increase over time if there is a strong fit. To Apply Please send: A short summary of your finance or deal analysis experience An example of an investment memo, company analysis, or financial analysis you have prepared The AI tools you currently use and how you use them in your workflow Your hourly rate and weekly availability We are looking for someone practical, detail-oriented, and fast. This is not a theoretical finance role. The goal is to help us quickly separate real opportunities from noise and focus only on deals that are worth serious attention.

Department: People & Culture / Human Resources Engagement type: Fixed-term contractor (full-time, 8-12 weeks) Location: Remote About the Role We are undertaking a span-of-control and spans-and-layers review to ensure our organization is structured for efficiency, accountability, and growth — the right ratio of team members to managers, the right number of management layers, and minimal redundancy. We are looking for a detail-oriented HR Data Analyst to help us gather, clean, and structure the people data that powers this analysis. This is a hands-on, fast-moving engagement. You will be the data backbone of the project, partnering closely with HR leaders to turn varied inputs into a clean, analysis-ready dataset and clear, decision-ready views. What You’ll Do • Consolidate HR data from multiple sources (HRIS, org charts, headcount, job architecture, reporting relationships) into a single, reliable dataset. • Calculate and report span of control (direct reports per manager) and layers (levels between the top of the org and the front line); flag outliers — over-extended managers, single-report managers, and excess layers. • Build and maintain clean reporting structures, manager-to-IC ratios, and supporting views and dashboards. • Validate data accuracy, reconcile discrepancies, and document assumptions and methodology. • Support scenario modeling and “what-if” comparisons as leadership tests organizational design options. • Prepare clear summaries and visuals that make findings easy for HR and business leaders to act on. What You’ll Bring • 3+ years in HR data / people analytics, HR operations, or a comparable analytical role. • Strong Excel skills (pivot tables, lookups, large-dataset cleanup); experience with HRIS data is essential. • Familiarity with organizational design concepts — span of control, spans and layers, reporting hierarchies, and job leveling. • Comfort working with sensitive, confidential people data with discretion and accuracy. • Self-directed, fast, and able to deliver under a tight timeline with minimal ramp-up. • Bonus: experience with org-design or workforce-planning projects; familiarity with Power BI, Visio, or org-charting tools. Engagement Details • Duration: Approximately 60 days, with potential to extend based on project needs. • Start: As soon as possible. Completion of a criminal background check is required before you can start work.