We are building a small Turo rental fleet near the Portland/Vancouver area and need a detail-oriented vehicle title, lien, and auction eligibility researcher to screen cars before we bid or buy. The role is to help us avoid vehicles that cannot be safely purchased, titled, insured, registered, or listed on Turo. Responsibilities include: * Reviewing auction/private-party vehicle listings. * Extracting VIN, year, make, model, trim, mileage, title status, seller notes, and key risks. * Checking VIN history using tools such as NMVTIS reports, NICB VINCheck, NHTSA recall lookup, Carfax/AutoCheck when available, and other vehicle-history databases. * Identifying title brands and red flags such as salvage, rebuilt, reconstructed, total loss, flood, lemon/buyback, theft recovery, TMU, odometer discrepancy, lien, delayed title, POA, LTA, bill of sale only, affidavit of sale, or title transfer concerns. * Confirming whether a vehicle appears eligible for Turo based on title, age, mileage, registration, insurance, recall, and safety considerations. * Creating a one-page summary per vehicle with a recommendation: PASS, INVESTIGATE, or BID-ELIGIBLE. * Maintaining a Google Sheet or Airtable checklist for all vehicles reviewed. Ideal background: * DMV/title clerk experience * Used-car dealership title/admin experience * Auto auction paperwork experience * Vehicle history research * Insurance total-loss/salvage claims experience * Fleet administration * Paralegal or lien/title research experience This is not academic research. This is practical vehicle title, lien, VIN, and eligibility research for auction vehicle purchases. Trial project: Please quote your cost to screen 10 vehicles and produce a summary for each one. Required output per vehicle: * VIN * Year/make/model/trim * Mileage * Title status * Brand history * Lien risk * Recall status * Theft/salvage check * Turo eligibility concern * Registration/title-transfer concern * Insurance concern * Final recommendation: PASS / INVESTIGATE / BID-ELIGIBLE Please include in your proposal: 1. Your experience with vehicle titles, DMV paperwork, auto auctions, VIN reports, liens, or dealership administration. 2. Which tools/databases you have used: NMVTIS, Carfax, AutoCheck, NICB, NHTSA, DMV records, auction reports, etc. 3. How you would evaluate a vehicle listed as “clean title” if a history report shows prior total loss or salvage activity. 4. Your price/time estimate for screening 10 vehicles.

Title: Environmental Reporter / Researcher —Texas Landowner Toolkit pdf/booklet Overview: I run a law firm and just launced a Texas-focused public-information website about how the data-center boom affects landowners — their water, air, property value, and quiet enjoyment of their land. We're looking for a sharp environmental reporter or research-writer to produce original, rigorously sourced, Texas-specific material for residents: explainers, a community resource toolkit, and reported pieces featuring real Texas landowners and facilities. This is to address the concerning and rising trend of AI datacenters being built here in Texas which are greatly affecting property rights, enviromental, health, energy and water. This is original journalism/research, not SEO filler. I have begun to already generate routine articles in-house. What we need from you is the work a person does that software can't: real reporting, primary-source digging, fact-checking, and clear writing that a worried landowner or citizen can actually use. Start with a paid trial project (details below). Strong work leads to an ongoing part-time engagement (~[5–10] hrs/week). What you'd produce (trial project): One flagship "Texas Landowner's Data Center Toolkit" (~2,500–3,500 words / structured sections) modeled on community toolkits but framed for individual landowners. Our angle (important — please align your pitch to it) --We are NOT anti-AI and NOT an activist/“stop data centers” campaign. Our thesis: data centers will be built, but a project doesn't get to harm its neighbors for free. We advocate for fair, just compensation and accountability for landowners harmed in their land, water, air, and quiet enjoyment. --Tone: factual, calm, credible, useful. Not alarmist, not partisan. Sourcing & accuracy standards (non-negotiable) --Every factual claim and figure must trace to a named primary source (peer-reviewed study, government/agency data, court filing, named interview). No invented numbers, no unsourced stats. --Original wording only. Link out to sources; never copy or republish third-party text, images, or PDFs. --This site is sponsored by a Texas attorney, so content is informational only — no legal advice, no outcome promises — and is reviewed before publishing under Texas attorney-advertising guidelines we provide. You don't need to be a lawyer, but you must be comfortable writing within that review. You're a great fit if you have --A journalism, environmental-science, or policy background, with published clips (environment, energy, local government, or investigative beats preferred). --Comfort with public-records / FOIA requests (if necessary) and reading permits or technical documents. --Familiarity with Texas (TCEQ, groundwater conservation districts, the DFW/Central Texas/West Texas data-center map) is a strong plus. --Clean, plain-English writing for a general audience. Thank you and please let me know if you have any questions. jimmy

We’re a growing, multi-location tax & accounting firm headquartered in Basalt, Colorado. We need an experienced HR consultant to audit our inherited employee handbook, tell us what we don’t know we’re missing, and rebuild it for the states we actually operate in today — with California in the mix. The backstory: our current handbook came to us through our first acquisition. It was originally drafted by an Oregon labor attorney when the firm was Oregon-based. Since then we’ve moved our center of gravity to Colorado, expanded across multiple states, and added a tax practice that carries heavier federal compliance exposure. The handbook still carries Oregon-specific language and has essentially no California content. This is a gap analysis and modernization job — not a proofread. Our current footprint: • Colorado — 2 employees (operational center of gravity) with another starting July 6 • California — 1 new hire starting July 6 • Michigan — 1 new hire starting July 6 • Pennsylvania — 1 employee • North Carolina — 1 employee departing imminently (likely coming off the list) • One additional hire is being recruited; their state is not yet known, so the handbook needs to flex as the footprint moves. The work is scoped in two waves: Wave 1 — hard deadline Thursday, July 2 (evening). A prioritized gap-analysis memo (what’s out of date, what’s missing, what’s a live risk vs. a wording fix, and what needs licensed counsel) plus a clean “day-one packet” of the core policies our new California and Michigan hires must receive and acknowledge on July 6. Wave 2 — follow-on. The deeper state-by-state rewrite, state addenda, full Oregon cleanup, brand-voice integration, and alignment with our data-security obligations. Two things make this firm-specific: • Privacy & data security. As a tax firm we have FTC Safeguards Rule and IRS data-security obligations and an existing draft WISP/incident-response plan. We need the handbook validated against those obligations (confidentiality, acceptable use, remote-work security) and we need you to independently flag where it’s silent on what a tax/accounting firm should address. • Brand alignment. The handbook should reflect our mission, vision, and values. These exist in rough form and we’ll share them in a short intake call — expect to sharpen our voice with us, not inherit polished source material. Honesty about the consultant-vs-attorney line. We are not asking you to “certify” legal compliance, and we don’t want anyone who claims they can. We want a strong consultant who can do a real gap analysis, write compliant policy language, and clearly flag anything that needs a licensed employment attorney in a given state. We are separately retaining California counsel for the load-bearing calls; you’d draft your best version and coordinate with them on the items that carry real risk. You’re a strong fit if you have: • Hands-on experience building or rebuilding multi-state employee handbooks, including California (this is a hard requirement, not a bonus). • Working fluency in the consultant-vs-attorney line — you know what you can responsibly deliver and what you escalate. • Bonus: experience with professional-services or accounting/financial firms and their data-security obligations (GLBA / FTC Safeguards / IRS WISP). • Availability to deliver a Wave-1 product by Thursday, July 2, with an intake call in the next day or two. To apply, please answer in your proposal (generic proposals will be passed over): Q1. Describe a multi-state handbook you rebuilt that included California. What specific California provisions did you have to add or change? Q2. How do you decide what you’ll draft yourself versus what you flag for licensed counsel? Give a real example. Q3. Have you worked with firms that have data-security obligations (GLBA / FTC Safeguards / IRS WISP)? What did you do? Q4. Given an Oregon-coded inherited handbook and CA + MI hires starting in days, what would you prioritize in the first five days? Q5. Confirm you can deliver a Wave-1 product by Thursday, July 2, and that you’re available for an intake call in the next 48 hours.

Project Description We are looking for a highly proactive digital advertising and AI operations specialist to help us grow and operationalize a niche healthcare directory and AI-powered marketing platform serving specialized providers across the United States and Canada. This is not a basic virtual assistant role. This is not a task-only ad management role. We are looking for someone with a digital advertising first background who can work with our emerging AI operating system to help build, improve, and automate the systems behind provider profile promotion, Meta ad campaigns, creative production, client reporting, AI chat summaries, and recurring revenue growth. The right person will help us turn our current ideas, workflows, campaigns, reporting, and AI tools into a more scalable operating system. We are looking for a go-getter who can think, build, test, recommend, improve, and help us move faster. What We Are Building We operate a specialized healthcare directory with provider profiles, membership tiers, local awareness campaigns, and a developing AI operating system. Our growth model includes: Provider directory profiles Profile upgrades Localized Meta ad campaigns Advanced profile-promotion campaigns AI Chat Assistants on provider profile pages Monthly transparent performance reports Archived AI chat summaries Website chatbot upgrade opportunities Workflow automation AI-assisted reporting Future operating-system tools for participating providers We need someone who can work with our team and AI OS architect to help build the operational layer around this business. What You Will Help With Digital Advertising & Campaign Support You will help build and improve repeatable Meta ad campaign workflows. This may include: Creating Meta/Facebook/Instagram traffic campaigns Helping structure profile-promotion campaigns Developing ad creative concepts and variations Writing or improving ad copy Helping organize campaign naming conventions Helping create UTM structures Reviewing campaign performance Identifying opportunities to improve campaign results Helping standardize how campaigns are launched and reported The goal is to make campaigns easier to launch, manage, measure, and scale across many participating providers. Creative & Video Support You should be comfortable helping with simple creative production and short-form content. This may include: Editing short videos for Facebook/Instagram ads Repurposing provider-submitted video content Creating social-ready video clips Adding captions, light branding, and simple visual polish Creating Canva or CapCut templates Helping create reusable creative formats Testing new messaging angles Thinking creatively about how to educate patients in a simple, trustworthy way You do not need to be a Hollywood-level video editor, but you should be capable of producing clean, usable digital ad creative. AI OS Workflow Development You will work with our developing AI operating system and our technical AI architect to help improve workflows. This may include: Identifying tasks that can be automated Helping design campaign setup workflows Helping design monthly reporting workflows Helping design client communication workflows Helping organize archived AI chat summaries Helping document repeatable processes Helping test AI-assisted workflows Helping identify what the OS should do next We are not looking for someone who waits to be told every step. We want someone who can look at a process and say: “This can be improved.” “This can be automated.” “This should be templated.” “This should be reported differently.” “This would help us move more clients to the next level.” Reporting & Client Transparency A major part of the role will be helping us build impressive monthly reports for participating providers. Reports may include: Campaign creative used that month Campaign messaging promoted Profile visits Phone clicks Website clicks Contact actions Other micro-conversions AI Chat Assistant activity Archived chat transcript summaries Common patient questions Common patient concerns Conversion improvement recommendations Suggested next steps We want our monthly reporting to feel much more transparent and useful than a standard digital marketing report. The right person will help us create reports that providers actually value. Growth & Upgrade Path Support We are building a product ladder that moves providers from basic directory visibility into deeper AI-powered services. You will help us improve the workflows that move clients from: Basic profile visibility To promoted profile campaigns To advanced profile campaigns To website AI Chat Assistant adoption To deeper AI operating system adoption This role requires someone who understands that campaigns, reporting, creative, automation, and client communication all work together to create recurring revenue growth. Who We Are Looking For We are looking for someone entrepreneurial, proactive, and curious. The ideal candidate: Has a strong digital advertising background Has experience with Meta/Facebook/Instagram ads Understands funnels, conversion paths, and client reporting Can think strategically about how to grow recurring revenue Has basic video editing or short-form creative experience Is comfortable using AI tools Is interested in workflow automation Can document processes clearly Can make recommendations without waiting to be told Is comfortable working with a developing AI operating system Likes building systems, not just completing tasks Can work independently and bring ideas to the table We do not need a pure software developer. We do not need someone who only follows instructions. We need a digital growth operator who can help us build the machine. Helpful Experience Experience with any of the following would be helpful: Meta Ads Manager Facebook/Instagram traffic campaigns Facebook/Instagram lead generation campaigns Google Analytics 4 Google Tag Manager Looker Studio GoHighLevel or similar CRM platforms Zapier, Make, n8n, or similar automation tools Canva CapCut Descript Adobe Premiere ChatGPT, Claude, or other AI tools AI workflow design CRM workflows Local business marketing Healthcare, wellness, or professional services marketing Directory or membership platform marketing SEO/GEO workflows Client reporting dashboards You do not need to know all of these, but you should be comfortable learning and experimenting. Initial Project Focus The first phase will likely focus on helping us build a repeatable workflow for profile-promotion campaigns. This may include: Reviewing our current workflow Helping define a repeatable Meta campaign structure Creating reusable creative templates Creating reusable reporting templates Helping map how the AI OS can assist with campaign setup and reporting Helping design the monthly report structure Identifying areas where the process can be automated Documenting the workflow so it can be repeated across many providers We will likely use one provider profile as the initial test case before expanding the workflow across more participating providers. What Success Looks Like Success in this role means: Campaign workflows become easier to launch Creative production becomes more repeatable Reporting becomes more transparent and impressive AI-assisted workflows become more useful Manual tasks become systematized Processes are clearly documented Upgrade opportunities become easier to identify Clients receive better insight into performance The business becomes less dependent on one-off manual execution The system improves every month Important Note This role is for someone who wants to help build and improve a growing system. We are not looking for a passive contractor who waits for a checklist. We are looking for someone who can bring ideas, spot gaps, improve workflows, and help turn a niche healthcare directory and AI-powered marketing platform into a scalable growth engine. How to Apply Please include a short response answering the following: What is your experience with Meta/Facebook/Instagram advertising? What is your experience with AI tools or workflow automation? What is your experience with video editing or ad creative? What is an example of a campaign, workflow, system, or process you helped improve? Why does this type of entrepreneurial digital advertising and AI operations role interest you? Please do not send a generic cover letter. We are looking for someone who can think, build, and help us grow.

Overview We are an early-stage Delaware Manager-Managed LLC preparing for a $500,000 angel investment round and are looking for an experienced U.S. startup attorney to review, revise, and finalize our investment documents. This is NOT a blank-slate drafting project. We have already prepared concise business-first drafts that clearly capture the commercial terms. We are looking for an attorney to convert these into legally binding, Delaware-compliant documents suitable for execution. Our goal is to keep the documentation straightforward, founder-friendly, and investor-friendly while ensuring compliance with Delaware law and applicable securities regulations. ⸻ Scope of Work Review, revise, and finalize the following documents: 1. Amended & Restated Operating Agreement Estimated Length: 15–20 pages The Operating Agreement includes: * Manager-managed governance * Membership interests * Initial financing authority * Equity incentive pool * Admission of investors * Passive investor rights * Distribution policy * Voting * Transfer restrictions * Tag-along / Drag-along * Dissolution * Standard miscellaneous provisions ⸻ 2. Subscription Agreement Estimated Length: 5–7 pages Includes: * Purchase of Membership Interests * Company representations * Investor representations * Securities acknowledgements * Operating Agreement joinder * Closing provisions ⸻ 3. Accredited Investor Questionnaire Estimated Length: 3–4 pages Standard questionnaire for Regulation D compliance. ⸻ Total Estimated Package Approximately 25–30 pages of documents. The documents are intentionally concise and business-focused. We are looking for an attorney to strengthen the legal language while preserving the commercial terms—not to redesign the transaction from scratch. ⸻ Responsibilities * Review existing drafts * Revise and strengthen legal language * Ensure compliance with Delaware LLC law * Ensure compliance with applicable federal and state securities laws (including Regulation D exemptions, as applicable) * Recommend any additional provisions necessary for enforceability * Preserve the agreed business terms wherever possible * Prepare execution-ready versions in Microsoft Word * Provide redlined versions showing substantive changes ⸻ Company Structure * Delaware Manager-Managed LLC * Three founding managers * Passive angel investors * Up to $500,000 financing round * Membership Interest issuance (not SAFE) * Equity Incentive Pool * Future financing flexibility built into the Operating Agreement ⸻ Ideal Experience We are looking for attorneys with significant experience representing: * Delaware LLC startups * Venture-backed startups * Founder-side transactions * Angel financings * Membership interest offerings * Operating agreements * Subscription agreements Healthcare startup experience is a plus but not required. ⸻ Deliverables Final attorney-reviewed versions of: * Operating Agreement * Subscription Agreement * Accredited Investor Questionnaire Plus: * Clean execution-ready Word versions * Redlined versions showing substantive changes * Brief explanation of recommended legal changes * Identification of any material legal or business concerns ⸻ Budget Fixed-price preferred. Please include: * Your fixed-fee estimate * Estimated turnaround time * Brief description of similar startup financing work * Whether you are licensed in Delaware or regularly represent Delaware entities ⸻ To Apply Please answer the following: 1. How many Delaware LLC Operating Agreements have you drafted or reviewed? 2. Have you represented founders raising angel capital? 3. Have you prepared Subscription Agreements for LLC Membership Interests? 4. Have you worked with Regulation D private offerings? 5. What is your estimated turnaround time? 6. What is your fixed-fee estimate for reviewing and finalizing these documents? ⸻ Important We are looking for licensed U.S. attorneys only. No agencies, document preparation services, or non-attorney applicants, please. Please do not apply unless you are licensed to practice law in at least one U.S. jurisdiction and have meaningful experience representing Delaware startups. ⸻ About Healthcraft Healthcraft is a technology-enabled health and wellness company building a scalable direct-to-consumer platform focused on modern wellness solutions. We value practical, business-minded legal advice and are looking for an attorney who can become a long-term legal partner as the company grows. If this engagement is a good fit, we anticipate ongoing legal work, including commercial agreements, employment and contractor agreements, privacy and compliance matters, fundraising, intellectual property, and general corporate counsel.

Only freelancers located in the U.S. may apply. Summary We are a growing digital marketing agency hiring multiple paid ads strategists to take on a range of ongoing work across our client base. This is long-term work, not a one-off project. We are intentionally flexible: if you want to stay a freelancer, we have steady, ongoing work for you. If you want to grow into a full-time, embedded part of our team (and eventually a manager role as we scale), that path is open too. We are looking for several strong people to start projects with, so whether you can give us 20 hours a week or want a full plate, we want to hear from you. If you are a strategic thinker with hands-on Meta (Facebook & Instagram) advertising experience, can execute with minimal handholding, and are genuinely comfortable talking directly with clients, this role is for you. Please Read Before Applying We are an agency ourselves, and we use Upwork the same way you do. We are looking for individual freelancers who want to be part of our team long-term, not agencies looking to place or subcontract their other people onto our accounts. If your goal is to get on a call and upsell us your team or your agency's services, please do not apply. We are hiring people, not vendors. What Makes This Role Different Client communication is a core part of this job, not a side task. You will be on calls, in messages, and writing updates that clients actually read. We are not looking for someone who only wants to live inside Ads Manager and hand off the talking to someone else. If communicating with clients energizes you, you will thrive here. If it drains you, this is not the right fit. Key Responsibilities Develop and implement Meta ad strategies aligned with each client's business goals. Communicate directly with clients: lead check-ins, answer questions, set expectations, and explain performance in plain language. Create ad creatives using provided brand materials, or collaborate with AI tools like ChatGPT to brainstorm compelling copy and visuals. Build and launch campaigns in Meta Ads Manager. Monitor and optimize performance, adjusting audiences, budgets, and creatives based on results. Deliver weekly performance reports with clear, strategic insights. Complete assigned checklists for campaign maintenance and tracking. Follow up on lead generation processes and ensure clean tracking via tools like Zapier or email notifications. Participate in regular strategy planning sessions for internal and client campaigns. Support new campaign onboarding and make sure new workflows run properly. What to Expect Work is assigned weekly. Your responsibilities may shift depending on current priorities. Some weeks lean strategy, others focus on launching, optimizing, or building new creative. You are expected to own the paid ad ecosystem for your accounts. We provide context and direction, and you run with it. Strong performers get more accounts, more responsibility, and a real path toward full-time and management. Ideal Candidate Strong experience running and optimizing Meta ad campaigns (Facebook & Instagram). A confident, clear communicator who is comfortable being client-facing. This is non-negotiable. Looking for a long-term home, not a quick gig. Confident in ad creative strategy, not just execution. Able to handle reporting and performance analysis. Comfortable with project tools like ClickUp. Organized, proactive, and able to self-manage and pivot priorities week to week. Big Plus (not required, but boosts your chances) Google Ads experience. If you run both Meta and Google well, you move to the front of the line. That said, if you are a Meta expert with no Google experience, we still want you to apply. Familiarity with Zapier, Google Sheets, and basic automations. Experience assisting with onboarding workflows. Copywriting or creative direction experience. Solid understanding of performance marketing and KPIs. Time Commitment Flexible. As little as ~20 hours per week up to full-time, depending on your availability and how the work goes. We are hiring more than one person, so part-time freelancers and full-time-track candidates are both welcome. To Apply Please include: A short paragraph about your Meta Ads experience (and Google Ads, if you have it). Examples, if available, of ad campaigns you have worked on. A sentence on how you typically communicate with clients. Your general weekly availability and hourly rate. Screening questions: What is your plan to ensure lead forms are generating quality leads? If you had $100 to spend daily for a SaaS company, what would you do with this budget? How do you develop naming conventions, and how does this funnel down to your UTMs? How do you re-target leads?

We are looking for a true Microsoft Outlook, Microsoft Teams, and connected files expert to help our team use these tools seamlessly and professionally. This is not a basic IT support role. We need someone with deep, hands-on expertise in Microsoft 365, especially Outlook, Teams, OneDrive, SharePoint, file sharing, permissions, folders, calendars, contacts, meeting workflows, and connected file systems. The right person should be able to: * Teach our team how to use Outlook, Teams, and connected files efficiently * Set up clean workflows for email, calendars, meetings, file sharing, and collaboration * Troubleshoot recurring issues on a weekly basis * Help organize Teams channels, shared files, folders, and permissions * Explain best practices clearly to non-technical users * Create simple instructions, checklists, or screen-share walkthroughs when needed * Improve how our team communicates, stores files, shares documents, and collaborates * Identify problems quickly and provide practical fixes We need someone who is patient, highly knowledgeable, responsive, and able to explain things clearly. You should be comfortable instructing others, not just fixing problems yourself. **Requirements:** * Expert-level knowledge of Microsoft Outlook * Expert-level knowledge of Microsoft Teams * Strong experience with OneDrive, SharePoint, shared folders, permissions, and connected files * Ability to troubleshoot Microsoft 365 issues quickly * Ability to train and guide users clearly * Excellent communication skills * Availability for regular weekly troubleshooting and support Please do not apply unless you are a true expert in Outlook, Teams, and Microsoft 365 connected file workflows. When applying, please include: 1. Your specific experience with Outlook, Teams, OneDrive, SharePoint, and Microsoft 365 2. Examples of problems you have solved for businesses or teams 3. How you would help a small business create a seamless Outlook/Teams/files workflow 4. Your availability for weekly support 5. Your hourly rate We are looking for someone reliable, practical, and highly skilled who can become our go-to expert for Microsoft Outlook, Teams, and connected files.

We're an established premium men's grooming brand rebuilding our content library. We have professionally drafted, well-structured articles on men's skincare and grooming, and we need a genuine subject-matter expert to make them accurate, authoritative, and trustworthy before they go live. This is not a copyediting or proofreading job. The drafts are already clean and readable. What we need is your expertise: adding real practitioner insight, verifying every health-related claim, and lending your professional credentials as the named expert reviewer on each page. Scope: 8 hub articles (roughly 1,200–2,000 words each) covering men's skincare routines, shaving, acne, anti-aging, sun protection, hair/scalp, and body care. We expect to start with 1–2 as a paid trial, then continue with the rest if it's a good fit. What you'll do on each article: Fill in marked [EXPERT] spots with specific, first-hand insight only a practitioner would know. Verify or correct every marked [VERIFY] health/skincare claim against current dermatological consensus; flag anything that can't be supported. Confirm marked [PRODUCT FACT] details against the product pages we provide. Add your name, credentials, and a short bio as the page's expert reviewer. Your value is your background for accuracy and expertise input. These are health-adjacent pages, so getting the facts right is the entire point. Requirements: A verifiable credential or demonstrable expertise in skincare/grooming — e.g., Dermatologist, licensed esthetician, dermatology-adjacent professional, cosmetic chemist, or a writer/editor with a substantial, verifiable track record in the men's grooming/skincare niche. Willingness to be named publicly as the expert reviewer, with your real credentials, on the published pages. Ability to distinguish supported claims from marketing fluff and to flag/cut anything that isn't accurate. Native or fluent English. Comfortable working in Google Docs or Markdown with inline editorial markers. Who this is NOT for: general copyeditors, proofreaders, or generalist content writers without specific skincare/grooming subject expertise. Please don't apply if you can't be named with relevant credentials. To apply: In your first line, tell us your specific credential or niche background, and link to one example of skincare/grooming content you've written or reviewed. Applications that skip this will be passed over.

# **Contract Position: Market Expansion & Regulatory Program Manager (Solar Financing & Incentives)** **Location:** Remote (U.S.) **Engagement Type:** Independent Contractor **Hours:** Approximately 20 hours per week ## **About Participate Energy** Our company is expanding its solar lease program across multiple U.S. states. We are seeking a highly analytical and organized professional to lead regulatory, policy, and market expansion research efforts that support the company's growth strategy. This individual will work closely with executive leadership, legal counsel, and operations teams to identify requirements, assess risks, and operationalize market-entry initiatives. ## **Position Overview** The Market Expansion & Regulatory Program Manager will be responsible for researching and evaluating state-level requirements related to solar financing products, consumer protection regulations, licensing and registration requirements, incentive programs, and related compliance considerations. The individual will synthesize complex regulatory information into actionable recommendations, facilitate executive decision-making, and drive implementation of approved initiatives across the organization. And stay up to date on regulations of existing markets to ensure our programs are compliant and our customers can fully benefits from available state incentives. This role is ideal for someone who enjoys independent research, navigating government and regulatory websites, coordinating cross-functional stakeholders, and translating policy requirements into operational processes. ## **Key Responsibilities** ### Regulatory & Market Expansion Research * Research and analyze state-specific requirements related to: * Solar financing and prepaid solar lease products * Consumer lending and consumer protection regulations * Licensing, registration, and disclosure requirements * Solar, energy, and utility-related regulations * Other regulatory considerations affecting market entry * Monitor regulatory developments and identify emerging risks or opportunities. * Develop state-by-state market entry assessments and recommendations. * Conduct thorough research using state agency websites, utility commission resources, attorney general guidance, and other authoritative sources. ### Incentive Program Research & Development * Identify and evaluate state, utility, and local incentive programs relevant to Participate Energy's products. * Assess program eligibility, requirements, economics, and implementation considerations. * Develop business cases and recommendations for participation in incentive programs. * Maintain an inventory of available incentives and regulatory opportunities across target markets. ### Program Management & Operationalization * Lead cross-functional efforts to operationalize approved market expansion and incentive initiatives. * Coordinate with legal, operations, finance, product, and executive teams to implement requirements. * Develop implementation plans, timelines, decision logs, and tracking tools. * Drive accountability and follow-through across stakeholders. * Maintain documentation, policies, procedures, and market-entry playbooks. ### Executive Support & Decision Facilitation * Prepare executive-ready research summaries, presentations, and recommendations. * Clearly communicate regulatory risks, assumptions, and tradeoffs. * Facilitate decision-making by presenting findings in a concise and actionable manner. * Support executive leadership in evaluating new state expansion opportunities. ## **Qualifications** ### Required * 3+ years of experience in program management, policy research, regulatory analysis, compliance, consulting, business operations, or related fields. * Demonstrated ability to conduct comprehensive research using government, regulatory, and public-sector resources. * Strong project and program management skills, with the ability to manage multiple initiatives simultaneously. * Exceptional analytical and critical thinking abilities. * Excellent written and verbal communication skills. * Experience preparing executive-level reports, presentations, and recommendations. * Ability to work independently with limited supervision. * Strong organizational skills and attention to detail. ### Preferred * Experience researching energy, solar, utility, financial services, consumer finance, or regulatory matters. * Familiarity with state regulatory agencies, public utility commissions, attorney general offices, and consumer protection frameworks. * Experience supporting multi-state market expansion initiatives. * Consulting, policy, compliance, legal operations, or regulatory affairs experience. * PMP certification or equivalent program management experience. ### Important Note A law degree is **not required**. However, the successful candidate must be comfortable working closely with legal counsel and translating legal and regulatory requirements into practical business and operational recommendations. ## **What Success Looks Like** * High-quality, actionable state market-entry analyses. * Well-documented regulatory and compliance requirements for expansion states. * Identification and implementation of valuable incentive opportunities. * Efficient cross-functional execution of approved initiatives. * Clear and timely recommendations that enable executive decision-making. ## **Why Join Participate Energy** This role offers a unique opportunity to directly influence the expansion strategy of an innovative clean energy company. The successful candidate will work closely with executive leadership and have meaningful ownership over market-entry and growth initiatives across the United States. --- **Expected Commitment:** Approximately 20 hours per week, with flexibility based on project needs. **Compensation:** Competitive hourly rate based on experience.

DESCRIPTION; I'm building a data infrastructure product for ontology-driven AI context: object types, properties, and relationships materialized ahead of query time, so AI systems retrieve connected context fast instead of rebuilding it from raw sources on every request. I need experienced eyes on the ingestion foundation before anything gets built on top of it. The deliverables are fixed (below); hours are flexible — propose what you think the work honestly takes. Rate: my budget is $50–75/hr. That's a hard ceiling — proposals above that range can't be afforded and won't be considered, regardless of quality __________________________________________________________________________ WHO SHOULD APPLY A data engineer / data infrastructure engineer who understands what an ontology and a knowledge graph are and why they matter for AI systems — connected entities and relationships as first-class context, not just tables. You don't need graph database experience; you need to get why pre-materialized, relationship-aware data beats rebuilding context from raw sources on every query. If that framing clicks for you, you're the right kind of applicant. __________________________________________________________________________ THE PRODUCT, HIGH LEVEL: The platform deploys on a client's own infrastructure — we never see their data. Clients connect their data sources, define an ontology (object types, properties, relationships), and the platform materializes it across tiered storage. Later phases add a binary serve layer, SSD/RAM caching, and GPU-parallel query execution so AI systems and data applications retrieve connected context at very low latency. Target customers: companies running AI on complex connected data (security operations, healthcare, financial services) where privacy demands private deployment and speed matters. Storage note: the current prototype uses Iceberg on GCS for development convenience, but the architecture is intentionally built for any S3-compatible storage (on-prem S3, private cloud VPC, MinIO, etc.). Portability is a design requirement, not an afterthought — the platform must never be tied to a single cloud provider. __________________________________________________________________________ WHAT EXISTS TODAY: A working Python prototype: FastAPI, PyIceberg, PyArrow, Postgres, Supabase (metadata + sync ledger), GCS as the Iceberg warehouse. Architecture and design docs are provided for orientation. The cold path is functional and tested: a 31-test production suite ran against live infrastructure at 1M–5M row scale — core correctness, concurrency, failure injection (kill mid-sync, storage outages, lease expiry), idempotency/replay, rollback, a 50-sync soak, and audit checks. All passing, with a written sign-off document you'll receive. That's exactly why I'm hiring you: tests confirm behavior I anticipated. You're here for what I didn't anticipate — structural weaknesses, hidden risks, and edge cases that a test suite written by the same mind that wrote the pipeline can't catch. I'm strong on product and systems design, not low-level data engineering. The codebase is AI-assisted, and I want a professional to find what that typically accumulates. This is a prototype built from the ground up — no live client today. The goal: ensure the ingestion foundation is genuinely solid (data coming in from source correctly, at scale, repeatedly) so a scoped MVP pilot and beta release won't break under real usage. You are validating the foundation before anything gets built on top. __________________________________________________________________________ YOUR SCOPE — THE COLD PATH, END TO END Data source → validation → identity merge → materialized ontology in Iceberg on S3-compatible storage. The data connectors are in scope — they ARE Milestone 1. The platform supports exactly three ways data comes in, and your job includes confirming each one is genuinely production-grade, not just demo-grade: Postgres — full refresh and incremental watermark sync S3-compatible object storage (CSV) — currently GCS via S3 interop, but must work against any S3-compatible store (on-prem, MinIO, private VPC) Manual CSV upload — primarily for testing/onboarding For each connector, production-grade means: real error handling (bad credentials, unreachable source, permission failures, malformed/garbage data, schema drift), clear failure messages that tell a user what broke, no silent partial ingests, and sane retry/recovery behavior. If a connector swallows errors, loses rows quietly, or fails confusingly — that's exactly the finding I'm paying for. No other connectors are planned for this milestone. Three connectors that work correctly under stress beats ten that mostly work. Focus areas across the pipeline: Connectors — production-readiness and error handling as described above Identity & matching — entities staying consistent across syncs (PK merge, fingerprint mode, composite keys) Sync semantics — full refresh vs incremental watermark sync, replay idempotency, delete behavior Relationships — FK→PK edge materialization, rebuild triggers, orphan handling, stable node identity Versioning & audit — Iceberg snapshots, rollback, schema change lineage, sync ledger completeness Reliability — failure modes, partial writes, lock/lease behavior, silent wrong-data risks Code structure — dead code, duplication, coupling, fragility; source-specific logic must stay contained in each connector and never leak into the shared pipeline Explicitly out of scope: GPU execution, query kernels, binary serve formats, caching layers, query-time serving, and any new connector types — all future phases. Your scope ends at correct, versioned, audited data in Iceberg. __________________________________________________________________________ DELIVERABLES (in priority order) Prioritized written assessment — what's pilot-ready as-is, what must be fixed before a real pilot customer (with specific recommendations), and what the existing test suite missed (edge cases, risks, gaps). Active code changes — implement fixes for the highest-priority issues you find, directly in the repo. You'll have full repo access. I'm open to architecture changes and refinements as long as they're clearly explained with reasoning. A change log that teaches — for every change: what you changed, why it mattered, what it fixes or prevents, and what to watch for going forward. This isn't paperwork — I'm making a local engineering hire for the next milestone, and your write-ups become the onboarding record. Everyone who touches this codebase after you should learn from what you found. Fixes go deepest-risk-first. What you get from me: repo access, architecture/design docs, the test suite + sign-off report, and async availability for questions. __________________________________________________________________________ ***REQUIRED EXPERIENCE: 1)Production Python data pipelines 2)Apache Iceberg, Delta Lake, or Hudi (or strong Parquet/data-lake work) 3)Postgres 4)Merge/upsert, idempotency, watermark/CDC patterns Building or hardening data connectors that real users depend on************* __________________________________________________________________________ WHERE THIS CAN GO: This starts as a fixed-scope review. Separately, I plan to make my first part-time/full-time engineering hire locally (Dallas) to build Milestone 2 and beyond — SSD caching, serve layers, containerization, and microservices as the platform scales. For the right freelancer, there's opportunity to stay engaged on recurring scoped work — reviewing the foundation as it evolves and working in conjunction with that future hire. Not required, not promised — but the door is open if the work is strong. __________________________________________________________________________ *********HOW TO APPLY — READ CAREFULLY***** Answer this one question in your proposal, briefly and in your own words: "You're building a pipeline that ingests from Postgres and S3-compatible storage and materializes a connected ontology (entities + relationships) into Iceberg. How do you design the sync process to be reliable and idempotent — especially around watermarking, commits, and failure handling between steps?" Include your proposed hour estimate for the deliverables above. Get creative — attachments and notes welcome. Note on AI-generated proposals: I use AI heavily myself — but if your proposal or screening answer is clearly AI-generated boilerplate, you will be automatically rejected without consideration. I'm hiring your judgment and experience, not your ability to paste a prompt. Short, direct, human answers. __________________________________________________________________________ A NOTE ON TECHNOLOGY BOUNDARIES: ***QUICK EXAMPLE*** FastAPI and Iceberg are what the platform uses today, not permanent decisions. As the product scales, we may want to run FastAPI alongside a second framework, replace it entirely, or eventually move away from Iceberg toward a custom storage format optimized for the GPU serve layer. Those should be engineering decisions made on merit, not decisions we're forced into because the current code makes swapping painful. What I need confirmed: is the codebase modular enough that a change like that stays contained? Core business logic (validate, merge, materialize, version) should never be tangled directly with infrastructure. API routes should be thin entry points that hand off to service logic, not where business logic lives. Iceberg writes should be isolated behind a single abstraction. If those boundaries are clean, replacing or extending a technology layer is a focused engineering effort. If they're not, it touches everything and becomes a mess under deadline pressure with a full team. Flag anywhere that boundary is broken. That's a priority finding. __________________________________________________________________________ FINAL REMARKS: NDA & IP protections This engagement requires signing an NDA and IP assignments agreement before work begins; standard protections given you'll have full repo access to a pre-launch product. Documents are provided on day one; nothing unusual in them. If that's a dealbreaker, please don't apply.