Job Title: Creative Community Manager (Social Media & Copywriting) Job Type: Full-Time (Remote with Travel) Location: Remote (Quarterly travel to Cleveland and Toledo may be required) Salary: $6,250 / month About Us We are a fast-paced boutique creative agency managing a diverse portfolio of exciting consumer accounts, including multi-unit franchise and Quick Service Restaurant (QSR) brands. We believe that great brands aren’t just seen; they are felt. Our team is dedicated to building hyper-engaged digital neighborhoods, and we are looking for a collaborative partner to help us scale our client accounts. Role Overview We are seeking a high-energy, creative Community Manager with 3+ years of experience to serve as the digital voice for our clients across primary channels like TikTok, Meta, and LinkedIn. In this role, you won't just moderate comments. You will actively shape the conversation. You must have your finger on the pulse of shifting internet culture, an innate understanding of viral trends (TikTok, Reels, Threads), and a sharp copywriting edge. If you know how to turn a simple customer inquiry into a viral, brand-building moment, we want you on our team. Key Responsibilities • TikTok Channel Management: Own day-to-day community engagement on TikTok—replying to comments, joining trending conversations, and leveraging sounds, duets, and cultural moments to grow reach and engagement for our QSR and franchise brands. • Meta Channel Management: Manage daily community interactions, comments, and direct messages across all Meta platforms, including Instagram, Facebook, and Threads. • LinkedIn Strategy: Foster professional community engagement and network growth on LinkedIn for corporate and B2B accounts. • Multi-Platform Engagement: Maintain a daily presence across additional client channels, including YouTube, Yelp, and Google Business Profile. • Trend Spotting: Monitor social media daily to identify breaking cultural trends, sounds, and memes, translating them into immediate, actionable content ideas for our QSR and franchise accounts. • On-Brand Copywriting: Write punchy, engaging, and culturally relevant copy for captions, community replies, and localized store promotions. • Reputation & Review Management: Maintain a high standard of customer service by swiftly addressing feedback, de-escalating customer complaints, and boosting local store sentiment. • Social Listening & Insights: Use social listening and analytics tools to monitor brand sentiment, track conversations, and surface real-time engagement opportunities. • Performance Reporting: Track engagement KPIs (response time, engagement rate, follower growth, and sentiment) and deliver regular reporting with actionable recommendations. • Cross-Functional Collaboration: Partner directly with our internal creative and account teams to share community insights, feedback, and user-generated content (UGC) that informs future campaigns.Qualifications • Experience: 3+ years of professional social media, community management, or copywriting experience. Agency or hospitality, food, and beverage experience is a massive plus. • Platform Expertise: Proven track record of managing and growing communities specifically on TikTok, Meta networks, and LinkedIn. • Trend Fluent: Deeply embedded in social media platforms. You know what’s trending before it hits the mainstream. • Copywriting Chops: A proven portfolio of creative, witty, or distinct brand writing. You can adapt seamlessly to different brand voices, whether they are playful and irreverent or corporate and professional. • Tools: Familiarity with social media management and listening tools (e.g., Sprout Social, Hootsuite, Later, Brandwatch, or similar) and native platform analytics. • Operational Skills: Comfortable managing high-volume consumer interactions and navigating local review platforms like Yelp or Google Maps. • Travel Flexibility: Willingness and ability to travel to Cleveland or Toledo on a quarterly basis for client or store visits. • Mindset: Highly organized, proactive self-starter who thrives in a collaborative, fast-moving agency environment. Benefits • Starting base salary of $6,250 / month. • Paid Time Off (PTO) and paid holidays. • Remote work flexibility. • Clear pathways for professional growth within a rising agency.

Engagement Overview I am the CEO and principal attorney of a small law practice specializing in campaign finance, lobbying regulation, FARA, nonprofit law, and government ethics. My five-person team — a junior partner, two associates, and an executive assistant — recently integrated into a larger firm. I am looking for an experienced Claude/AI automation builder for a phased engagement to design, build, and deploy a suite of interconnected agents and automations. This brief covers three phases. Phase I (Inbox Triage) is the highest immediate priority and the natural starting point. Phases II and III follow sequentially. Strong candidates will be evaluated on Phase I but should demonstrate familiarity with the full roadmap. This is a paid engagement. Scope, timeline, and rate are open to discussion. Technology Stack Email: Gmail (personal Pro account — not firm infrastructure) AI: Claude (Anthropic) via MCP or API Task and project management: Notion (existing workspace; routing tables, matter tracking, and timesheet structure already in place) Calendar: Google Calendar Internal chat: Google Chat Document storage: Google Drive (primary); local hard drives on iMac and MacBook Pro (secondary) Matter management / DMS: iManage (larger firm system — integration via dedicated ingestion email address) Voice notes: Plaud (AI note-taker) Signing platform: TBD — candidates should ask during scoping Out of scope: Signal and iMessage — encrypted platforms with no API access; manual forwarding convention only Confidentiality Requirements This is a law practice. Attorney-client privilege and work product protection apply to all client communications and matter-related documents. These are not compliance checkboxes — they are professional obligations with real consequences. The successful candidate must: • Execute a non-disclosure agreement prior to engagement • Demonstrate genuine understanding of why data handling matters in a legal context — not just technically, but professionally • Never use client names, email content, routing data, or document content for training, testing, or demonstration purposes • Work exclusively within the client's authenticated accounts — no third-party data stores outside the approved stack • Design systems that minimize data exposure — process and route, do not store unnecessarily Generic proposals that do not address confidentiality specifically will not be considered.   Phase I — Inbox Triage Agent Real-time classification and routing of inbound Gmail, with a daily digest to the executive assistant. Objective The principal attorney's Gmail inbox receives high volumes of email across clients, matters, and categories of widely varying priority. The goal is an agent that processes every inbound message, classifies it, routes it to the correct person automatically, and ensures nothing drops — without overloading the executive assistant with triage work she should not be doing. Two-Stage Routing Logic Stage 1 — Sender Classification Every inbound email is classified against a tiered contact list maintained in a Notion database: MVC: Most Valuable Clients — 5 to 10 contacts. Highest priority. HVP: High Value People — 10 to 20 contacts. Some overlap with MVCs. Principal attorney, unless task-type rule applies All other clients: Roster managed in Notion with assigned attorney(s). Assigned attorney(s) per Notion client record Catch-All: Anyone not in the contact table — prospects, opposing counsel, vendors, bar association, etc. Generate executive assistant daily digest Stage 2 — Task-Type Classification (MVCs only) For MVC contacts, a second classification layer routes based on the nature of the request. Rules are client-specific. Examples: • Scheduling requests → Executive assistant • Contracts and approvals → Designated associate(s) per client record • Strategic and substantive legal matters → Principal attorney Task-type rules are defined per MVC client and must be configurable without developer involvement. Routing Table — Notion All contact and routing data lives in an existing Notion database. The agent reads from it at runtime. Required fields: • Contact name and/or email domain • Tier (MVC / HVP / Standard / Catch-All) • Assigned attorney(s) for Standard clients • Task-type override rules for MVCs The executive assistant must be able to add, edit, and re-tier contacts without touching code. This is a hard requirement. Routing Output Candidates should propose their recommended approach from among the following, based on current Gmail MCP capabilities: • Apply Gmail label and/or forward to assigned attorney's address • Create a pre-addressed draft for principal attorney review before sending • Log routing decision to Notion with email link and recommended assignee Please address this question directly in your proposal — it is a key evaluation criterion. Daily Executive Assistant Digest Once per day at a configurable time, the agent generates a digest delivered to a designated Notion page covering all catch-all emails from the prior 24 hours. Each entry includes: sender, subject, timestamp, and a one-line AI summary of the email's apparent purpose.   Phase II — 5 AM Daily Brief A structured morning brief delivered to Notion each day before 5 AM, aggregating schedule, tasks, workflow status, news, and forward-looking context. Objective The principal attorney starts each day across multiple locations and needs a single, consolidated view of what matters — professional and personal — without opening email. The brief is delivered to a dedicated Notion page and covers the sections below in the following order. Section 1 — Daily Schedule Full calendar for the day pulled from Google Calendar. All events, calls, and commitments in chronological order. Section 2 — Open Projects and Undone Tasks Two sub-sections: (a) MVC high-value work — open projects and incomplete tasks for Most Valuable Clients, filtered to substantive legal work only; and (b) Personal — all open personal projects and tasks without exception. Personal items are comprehensive by design: if it is not surfaced here, it will be forgotten. Source: Notion task and project database. Section 3 — Blocking What is the principal attorney specifically holding up? Items where others in the firm are waiting for a review, decision, approval, or action. Source: Notion matter and task records where assignee or status indicates the ball is in the principal attorney's court. Note to builder: this section requires careful logic design. The agent must infer from status fields and assignee data what is genuinely waiting on the principal attorney versus what is simply unresolved. Work with client during onboarding to define the exact field logic. Section 4 — News Digest Industry News Curated digest of overnight developments in: campaign finance law and FEC activity, election administration, lobbying regulation (federal and state), nonprofit political activity, and government ethics. Format: short summary of each item with a link to the full article. Aim for signal, not volume — 5 to 10 items maximum. US Political News 5 to 10 headlines with links covering: presidential politics, US Senate and House elections, and major gubernatorial races. Stories people are actually talking about, not wire service filler. Section 5 — Firm Workflow Matter-level status summary pulled from Notion, organized by client tier and activity: Status Definition Closed Completed yesterday Moving Action taken yesterday Paused No action yesterday Stuck No action in five or more days Client groupings: MVCs (non-high-value work), Standard clients (all work), and any other open matters. Section 6 — One Month Look Ahead Rolling 30-day forward view pulled from Google Calendar covering: regulatory filing dates and compliance deadlines, matter-level deadlines, client birthdays, holidays, and planned vacations or travel. Anything that requires preparation or awareness in the next 30 days. Section 7 — Personal Financial Summary (If Feasible) Summary of personal financial position pulled from Monarch Money, if an API or MCP connector is available. Candidates should investigate Monarch's API access and address feasibility in their proposal. If not currently feasible, this section is omitted without affecting the rest of the brief. Delivery Notion only — not email. A dedicated page refreshed each morning before 5 AM. Previous day's brief should be archived, not overwritten.   Phase III — Night Maintenance Three nightly agents that run after close of business: timesheet creation, document filing preparation, and Plaud note routing. All outputs are delivered to Notion for principal attorney review. Part 1 — Timesheet Creation Objective Each evening, the agent reviews the day's activity across three sources and populates a timesheet in an existing Notion template for the principal attorney's review and finalization. Sources • Google Calendar — all events and calls attended • Gmail sent items — emails sent that day, grouped by client/matter where inferable • Google Chat — internal messages sent, grouped by thread/matter where inferable Note to builder: Google Chat API access will need to be confirmed alongside Gmail and Calendar MCPs. Confirm availability and any OAuth scope requirements in your proposal. Output: Populated Notion timesheet using existing template structure. Principal attorney reviews each morning, adjusts entries as needed, and finalizes. The agent does not finalize — it drafts. Part 2 — Document Filing Objective Each evening, the agent surfaces documents created or edited that day for the principal attorney's review. The attorney flags finals, and the agent forwards them to the firm's iManage ingestion email address for filing. Sources • Google Drive — documents created or modified that day • Local hard drives — iMac and MacBook Pro Note to builder: local hard drive access requires a locally-running component (daemon, Claude Code instance, or folder-watching script) on each machine. Please address your proposed approach to this in your proposal. Alternative approach for consideration: a designated 'Ready to File' folder on each machine that syncs to Google Drive. The attorney drags filing-ready documents into this folder throughout the day; the agent watches the folder and processes from there. Simpler architecture, device-agnostic, and builds a consistent filing habit. Candidates should evaluate and recommend. Output: A Notion page listing all documents surfaced for that day, with document name, location, and last-modified time. Principal attorney marks finals. Agent forwards marked documents to the iManage ingestion email address. iManage filing is handled by firm IT from that point — no direct iManage API integration required. Part 3 — Plaud Note Routing and Archiving Objective: The principal attorney uses a Plaud AI note-taker on calls and meetings. Each evening, the agent pulls new Plaud summaries, routes them to the appropriate team members, archives a copy to Notion tagged to the relevant client matter, and deletes the underlying audio and transcript from Plaud's platform and the local device. Prerequisite — Plaud API Plaud API or webhook access is a prerequisite for this part. Candidates must investigate and confirm availability before scoping. If Plaud does not currently support programmatic access, this part will require a manual export step as a workaround — please address both scenarios in your proposal. Routing Logic: Similar in structure to Phase I inbox triage routing (MVC/HVP/Standard tiers with task-type overrides) but with distinct rules to be defined with the client during onboarding. Do not assume inbox triage rules apply directly. Archiving: One copy of each Plaud summary is saved to Notion as a note, tagged to the relevant client matter. Tagging logic to be defined during onboarding. Deletion: After successful routing and archiving, the agent deletes: (a) the audio and transcript from Plaud's platform via API, and (b) any local copies on the principal attorney's devices. Local deletion requires the same locally-running component described in Part 2. Candidates may propose a unified local agent that handles both Part 2 and Part 3 local operations.   What I'm Looking For Strong candidates will have: • Demonstrated experience building Claude-based automations or agents — not general AI experience • Hands-on experience with Gmail MCP, Google Calendar MCP, and Notion MCP (or equivalent API integrations) • Ability to build systems that non-technical users can maintain — editability and simplicity are as important as technical sophistication • Comfort with phased delivery — Phase I first, Phases II and III following sequentially based on performance • Experience with professional services clients (legal, financial, consulting) is a meaningful plus • Willingness to execute an NDA and work within a legally sensitive environment What to Include in Your Proposal Please address the following specifically. Proposals that do not engage with these questions will not be considered. • Your proposed technical architecture for Phase I — how you would connect Gmail, Claude, and Notion • Your answer to the Gmail MCP routing output question in Phase I (labeling vs. drafts vs. Notion logging) — what is actually supported and what do you recommend • Your assessment of Plaud API availability and your proposed approach for Phase III Part 3 • Your assessment of Monarch Money API feasibility for the Phase II financial summary section • Your proposed approach to local hard drive access for Phase III Parts 2 and 3 — daemon, sync folder, or other • A comparable project you have delivered — describe the client type, the stack, and what made it work • Your estimated timeline and rate for Phase I, and a rough order-of-magnitude estimate for Phases II and III • Confirmation that you are willing to execute an NDA prior to engagement I am looking for someone who has read this brief carefully and has a specific, informed point of view on how to build it. This is phase one of a longer automation roadmap and the right candidate will be a long-term partner, not a one-time contractor.

We are seeking an elite, independent Bubble.io expert to take over, optimize, and finalize a multi-portal educational therapy and CRM application (LJL Platform) that is currently 70% complete. We have successfully recovered 100% master admin ownership of our Bubble repository from our previous developer. We are avoiding traditional coding agencies. We want a highly precise, transparent independent freelancer who excels at database architecture, conditional logic, and clean third-party API configurations. You will be handed a completely pre-written, itemized 30+ feature specification list covering our exact operations, removing all discovery lag. This project is structured into two fixed-price delivery phases: PHASE 1: PLATFORM AUDIT & DIAGNOSTIC ENGINE (Fixed Budget: $2,500) Verify the current database health and build out our core educational logic: • EF Assessment Module: Build a framework to host diagnostic testing fields using standard jsPsych data hooks for intra-student benchmarking (tracking raw accuracy and reaction speed over time). • Conditional Logic Pathing: Code backend workflows that evaluate test scores to automatically flag and assign customized student learning paths from our library. • Clinical Validation Portal: Design a secure, native dashboard for our chief administrator (April) to review telemetry data and manually approve/override student placements with a single click. • Gatekeeper Business Rules: Enforce a strict database rule verifying if a minimum $110 qualifying assessment fee has been paid before unlocking specific enrollment tracks. PHASE 2: COMMUNICATIONS, CRM & MARKETING AUTOMATION (Fixed Budget: $5,000) Connect our external pipelines and optimize our daily scheduling/business operations: • Lead Ingestion & Twilio Drips: Connect webhook receivers from incoming web intake forms to instantly generate CRM lead records and trigger 4-tier automated text sequences via Twilio. • Operational Variable Quoting: Program a live multi-variable pricing matrix that calculates custom client quotes based on situational variables (number of residents, pets/shedding habits, learning tracks, and timeline urgency). • Local SEO & Web Syncing: Securely configure API components (Google LSA, Meta Graph) to seamlessly cross-post client reviews and milestone updates back to our marketing site. • Core Operational Rescheduling: Clean up scheduling engine rules to enforce strict business policies (6-hour cancellation windows, credit/no-credit rules, and tutor payment tracking logs). *WHAT IS EXCLUDED:* We are NOT building a custom LMS, custom gamification engines, or automated Gusto payroll integrations. We are keeping the app lean and utilizing external software for those tasks to protect our timeline. Requirements: • Expert-level mastery of Bubble.io database normalization, privacy rules, and the API Connector. • No agencies. Individual freelancers only. • Ability to log in, complete a 48-hour codebase audit, and provide weekly functioning milestone updates. To Apply: 1. Confirm you are an independent freelancer. 2. Share a quick summary of a "rescue project" you successfully took over and finished on Bubble. 3. Confirm your availability to begin an immediate audit and stay aligned with our fixed milestones. CRITICAL RESCUE REQUIREMENT (Verification & Completion): Because our relationship with the previous developer was frozen abruptly, we do not know exactly which parts of the existing 70% build are fully functional or where the database logic might be broken. Your contract will begin with a paid, mandatory 48-hour Codebase & Database Audit milestone. As the incoming developer, you are responsible for testing the existing portals (Admins, Tutors, Parents), identifying any broken workflows, and fixing them. Your final project delivery must ensure that the entire unified platform—both the existing core infrastructure and the new Phase 1/Phase 2 modules—functions flawlessly together. You are not just adding features; you are completing the system. SEE ATTACHED PDF FILE (LJL APP MASTER RFP) FOR COMPLETE PROPOSAL DETAILS

Job Description: I am an e-commerce seller with my own online store, Amazon presence, and influencer partnerships. I’m expanding by introducing our consumer wellness product to local physical retail stores across the US. I’m looking for a reliable and professional Outreach Specialist for phone-based outreach (starting as a trial project with potential for long-term collaboration). What You Will Do: Receive targeted lists of US retail store contacts (sourced from public directories like Yelp and Google Maps). Make outbound calls to introduce our product and offer free samples shipped from California. Use a shared Google Sheet to track every call result clearly (connected, wrong number, interested, not interested, etc.). When you reach the right person, politely request basic store information (shipping address, contact email) so we can send samples for them to evaluate. Goal: Secure stores willing to receive and test the product, potentially leading to future shelf placement. You will be provided with a ready-to-use call script, product information sheet, and clear guidelines. This is not high-pressure sales — it’s professional outreach focused on offering free samples. Requirements: Clear, professional, and friendly English communication skills Experience with outbound calling or customer outreach (preferred but not mandatory) Reliable internet, quiet workspace, and attention to detail Comfortable working independently and updating tracking sheets accurately Phone Setup: We can use a VoIP solution (I can provide access or you can use your preferred tool). Compensation (Hybrid Model): $5 per hour (tracked via Upwork Time Tracker) +$3 per successful sample request (store agrees to receive free samples and provides shipping + contact details) This combines stable pay with performance incentives. Volume is flexible — you can work 15–30 hours per week depending on your availability. We can adjust rates after the initial trial based on results. Next Steps: The exact nature of the product (a consumer wellness item) will be shared privately with serious candidates only. If you’re interested, please apply and tell me briefly: Any previous experience with phone outreach or customer service How many hours per week you can commit Whether you have used any VoIP calling tools before Looking forward to working with someone reliable and communicative. This is a great opportunity to grow together as we expand the business.

We are launching an aggressive summer marketing push for a new construction residential community in Southern Oregon. Homes are selling. We are under construction. The summer buying season is now. We need someone who can start today, work through the holiday weekend, and hit the ground running with zero ramp-up time. We are a new construction community with five floor plans from $382,900. We have a strong brand identity, completed marketing materials, an active website, and a clear vision. What we need is someone to run with it — executing campaigns, producing content, updating assets, managing platforms, and keeping every channel active and current throughout the summer buying season. This is not a strategy role. This is an execution role. If you need hand-holding or extensive briefing sessions, this is not the right fit. If you can read a brand guide, absorb context quickly, and start producing within hours, keep reading. What You Will Be Doing Website Management → Update and maintain the community website as inventory, construction stages, and availability change → Add new pages and sections based on completed designs and copy we provide → Keep floor plan status, model home hours, and pricing current in real time → Implement new sections including process page, buyer guide, agent resources, and pre-sale benefits Social Media — Active Daily Management → Create and schedule content across Facebook and Instagram → Shoot or source content, write captions, manage hashtags, engage with comments → Build and manage Facebook/Meta ad campaigns targeting our local and regional market → Reels, Stories, static posts, carousels — all formats, daily cadence → Construction progress updates, model home content, lifestyle and community content Email Marketing → Build and manage email list of leads captured from sign-in sheets, website, and social → Write and send regular campaigns — new homes, construction updates, open house announcements → Set up automated sequences for new inquiries → Platform TBD — MailChimp, Klaviyo, or similar Graphic Design and Content Production → Adapt existing brand assets (flyers, posters, sign templates) for new uses and new channels → Produce social media graphics, email headers, story templates, and digital ads → Work within established brand guidelines — specific typography and color palette provided → Basic photo editing and image optimization for web and print use Photo and Video Production Coordination → Schedule and coordinate on-site photo and video sessions with our talent → Write shot lists and creative briefs so talent arrives knowing exactly what we need → Manage logistics: timing around construction schedules, natural light, and site access → Review raw footage and photography, select hero assets, and brief the edit → Direct short-form video content for Reels — construction walkthroughs, model home tours, lifestyle content → Ensure all photo and video output meets brand standards before publishing or submitting to print vendors Signage Content Production → Produce print-ready artwork for highway signs, directional signs, lot signs, and model home signage → Adapt campaign concepts across multiple sign formats maintaining legibility for highway speed → Prepare files to print vendor specs — correct dimensions, bleed, color mode, and resolution → Manage revisions and version control as messaging evolves through the campaign → Coordinate with local or online print vendors for fabrication and delivery Contact List Compilation → Research and compile targeted outreach lists — real estate agents, relocation specialists, mortgage brokers, property managers, and rental property owners in our target market → Build lists for direct mail, email outreach, and agent co-op campaigns → Organize and maintain the master lead database in a clean, usable format → Identify media contacts, community organizations, and local influencers for PR and partnership outreach Digital Advertising → Set up, manage, and optimize Facebook/Instagram ad campaigns → Google Ads or Google Business Profile updates as needed → Track performance, report results, adjust based on data Lead Management Support → Maintain and organize the lead database from model home sign-in sheets, website inquiries, and social → Support follow-up sequencing — ensuring leads are contacted, tracked, and nurtured → Coordinate with the listing agent on lead handoffs and scheduling Print Production Coordination → Manage file preparation and vendor coordination for highway signs, posters, flyers, and signage → Obtain print quotes, place orders, confirm specs, and track delivery Content Writing → Write social captions, email copy, ad copy, website copy updates, and short-form content → Maintain the brand voice — editorial, warm, confident, not salesy → Adapt existing long-form copy for different formats and platforms MLS and Listing Support → Update MLS listing descriptions, photos, and status as needed → Ensure all listings are current and consistent across platforms What We Are Looking For Non-Negotiable → Available to start immediately — this weekend if possible → Strong written English — you will be writing copy that represents this brand publicly → Proven experience with CMS website management — WordPress, Wix, or similar platforms → Hands-on Facebook/Instagram Ads experience — not just posting, but running campaigns → Graphic design ability — Canva Pro minimum, Adobe Creative Suite preferred → Ability to absorb brand guidelines and apply them consistently without constant oversight → High output capacity — this is 2–4 weeks of concentrated, focused effort → Self-directed — you manage your own time, hit deadlines, and flag issues without being chased → Experience producing print-ready files for signage or large-format print — correct specs, bleed, color mode → Competence building and managing contact and outreach lists — organized, accurate, usable Strongly Preferred → Real estate marketing experience — new construction builder marketing is a plus → Email marketing platform experience (MailChimp, Klaviyo, ActiveCampaign, or similar) → Video editing for Reels and short-form social content — CapCut, Premiere, or similar → Experience coordinating photo and video shoots — writing shot lists, managing logistics, directing on set → Experience working with small business owners who move fast and have high standards → Portfolio that includes real estate, home building, or luxury/lifestyle brands → Familiarity with Oregon or Pacific Northwest markets What this person looks like: You are not a generalist who dabbles in everything. You are someone who has actually run marketing for a builder, a developer, a real estate team, or a comparable brand and has the output to show for it. You move fast, you read context well, you ask smart questions and few of them, and you produce work that is ready to publish — not work that needs three rounds of revision before it can go live. This Is Not For You If: → You need a detailed brief before every task → You produce one piece of content at a time → You require weekends off during a launch campaign → You are primarily a strategist who delegates execution → Your Canva portfolio looks like every other real estate marketing template on the internet → You have never managed a paid social campaign from setup to optimization

I need to add a new field to an existing report using I-Net Clear Reports Designer. I have the SQL and have tried to add it myself, but am having issues both connecting to the database locally as well as adjusting the SQL for the report. This should be a very quick task (i.e. an hour?) for someone with experience/knowledge. I'd be very interested in learning more about how this all works inside the report so I'm hoping someone can explain it to me as well.

AI-Powered HR Manager: Build It, Automate It, Hand It Off ----------------------------------------------------------------------- WHAT THIS IS We're a multi-location retail business and we need one sharp HR person to build our entire people operation from scratch and run it lean using AI. You'll get access to a Claude team account and the tools you need to move fast. In return, we expect you to work smarter than a traditional HR person, not harder. The hours are lower because the tools are better. The output standard is high because you'll have everything you need to meet it. Job descriptions, some policies, and KPI frameworks are already partially built. Your job is to take what exists, sharpen it, fill the gaps, automate everything you can, and deliver a system that runs with minimal intervention from anyone. We are investing in the right person and the right tools. We expect 10x the value of a traditional HR hire in half the hours. ----------------------------------------------------------------------- WHAT WE'RE GIVING YOU - Claude team account: use it for drafting, research, screening, template generation, policy writing, everything - Existing job descriptions, partial policies, and KPI frameworks to build on. You are not starting from zero - Direct owner access for fast decisions, no bureaucracy, no approval chains - A custom internal HR portal where your content lives and gets automated going forward - Clear scope, clear milestones, and clear payment triggers with no ambiguity about what done looks like ----------------------------------------------------------------------- THE ENGAGEMENT: TWO PHASES PHASE 1 - Build the Foundation + Make 5 Hires 4-6 weeks | Project-based | Milestone payments - Audit all existing job descriptions, policies, and salary ranges: benchmark against current market data, flag gaps, and finalize with owner before any offer goes out - Build and complete KPI frameworks for every role (managers and associates) so every hire knows exactly what success looks like from Day 1 - Post, source, screen, and close 5 management hires across our 3 locations (see below) - Build full HR infrastructure: employee handbook, onboarding checklists per role, offer letter templates, and compliance docs, all using AI where possible - Set up ATS with automated screening, self-book interview scheduling, and AI-assisted candidate filtering - Migrate payroll to Gusto and/or Paychex, live and running before Phase 2 starts - Feed all content into our internal HR portal so the AI layer can maintain and automate it going forward - Deliver a clean handoff guide so routine HR runs without you PHASE 2 - Run HR + Payroll Ongoing 2-4 hrs/week | Ongoing Upwork contract | Paid weekly or bi-weekly - Process weekly payroll across all locations: accurate, on time, every time, automated as far as the platform allows - Handle ongoing hiring as new roles open, staggered, not all at once - Own all employee HR questions: the owner is never the first call - Keep compliance current: local labor law updates annually and you stay ahead of them - Continuously improve and automate, always reducing manual work over time - Update HR portal content as policies and roles evolve ----------------------------------------------------------------------- PHASE 1 MILESTONES & PAYMENT SCHEDULE All Phase 1 payments are milestone-triggered. No milestone, no payment. M1 - Compensation and KPI audit complete across all roles, owner sign-off received M2 - All 5 manager job posts live, ATS configured, active pipeline running M3 - All 5 manager offers accepted, start dates set M4 - Full HR infrastructure delivered: handbook, onboarding, templates, compliance, portal content M5 - Payroll migrated, first clean payroll run complete in Gusto/Paychex Phase 2: Ongoing HR and payroll, 8-12 hrs/week ----------------------------------------------------------------------- PHASE 1 HIRING SCOPE: 5 ROLES Managers come first. Associates are hired in waves underneath them. You manage the sequencing so payroll ramps up at a pace that makes sense. Role Store Manager Assistant Store Manager Laundromat Manager (24/7 operation) Compensation for all roles is competitive. Details are available during the interview process. Your M1 deliverable includes validating and finalizing all comp ranges before any offer goes out. ----------------------------------------------------------------------- KPIs ARE A CORE DELIVERABLE Before the first hire is made, you will build out KPI frameworks for every role. We have some frameworks started. Your job is to complete them, make them measurable, and make sure every person we hire knows exactly what success looks like from Day 1. - Store managers: sales targets, shrink rate, labor cost percentage, customer satisfaction, team retention, etc - Assistant managers: shift performance, task completion, team development metrics - Location manager (24/7): uptime, cleanliness scores, incident reports, revenue per shift - Associates: productivity targets, attendance, cross-training progress These KPIs feed into our internal system and become how we manage and evaluate performance going forward. Build them right the first time and you will be responsible fully yo track these. ----------------------------------------------------------------------- HOW WE EXPECT YOU TO USE AI You'll have a Claude team account from Day 1. We expect you to use it actively. The reason the hours for this role are lean is because AI handles a significant portion of the drafting, research, and routine work. That is the deal. - Use Claude to draft job descriptions, policies, onboarding docs, offer letters, and KPI frameworks - Use AI screening tools or Claude to filter applications before you spend time on them - Use AI to research compliance updates, benchmark salaries, and generate first drafts of any HR document - Use automation wherever the payroll platform or ATS allows and document what you've automated so it stays automated - Feed everything into our internal HR portal so the AI layer can maintain it going forward If you are not comfortable using AI as a core part of your workflow, this role is not for you. ----------------------------------------------------------------------- WHO WE'RE LOOKING FOR Must Have: - 3+ years HR experience in retail, hourly, or multi-location environments - Full-cycle recruiting: you have sourced, screened, and closed management and hourly roles end to end - Payroll management experience: you have run payroll, not just supported someone who did - Hands-on Gusto and/or Paychex experience - Genuine comfort with AI tools: you use them daily and you are not learning on the job here - Knowledge of local labor law in your operating jurisdiction, including wage ordinances, paid leave requirements, and scheduling laws - Ability to build HR infrastructure from scratch and hand it off clean Strong Bonus: - Experience migrating between payroll platforms - Has built KPI frameworks for hourly retail or service roles - Multi-location or franchise HR background - Experience building automated HR systems that reduced manual work measurably ----------------------------------------------------------------------- CONTRACT TERMS This is an Upwork contract. Here is exactly what that means: Contract Type : Upwork hourly contract, all work tracked and paid through Upwork Phase 1 : Project-based with milestone payments (see above), rate set at contract start Phase 2 : Ongoing hourly contract, 8-12 hrs/week, paid weekly or bi-weekly through Upwork Communication : Weekly check-in with owner, more frequent during Phase 1. Available for any additional meetings or calls the owner requests. ----------------------------------------------------------------------- AI TOOLS AND CONFIDENTIALITY POLICY This is a strict requirement, not a suggestion. By accepting this contract you agree to the following: AI Tools You May Use: - You will use only AI tools we provide or approve in writing. This currently means Claude via our team account, and any other tool we explicitly authorize. - You may not use personal AI accounts, free-tier tools, or any external AI platform to process, draft, or analyze any of our HR data, employee information, or business content. - All AI usage must happen within our provided accounts and systems so data stays within our environment at all times. - If you want to use a tool not on our approved list, you ask first. No exceptions. Confidentiality: - Everything you access, create, or learn in this role is strictly confidential: employee records, compensation data, business operations, HR policies, KPIs, candidate information, and all other business information. - You may not share, export, copy, or use any of our data, documents, or systems outside the scope of this contract and our approved tools. - All work product created under this contract belongs to us. You retain no rights to any documents, templates, systems, or processes you build. - You may not use our business information, processes, or data to benefit any other client, employer, or personal project, during or after this engagement. - Upon contract end, all access is revoked immediately. Any copies of our data or documents in your possession must be deleted and confirmed in writing. Violation of any of the above is grounds for immediate contract termination and may result in legal action. This is standard for any serious HR engagement. ----------------------------------------------------------------------- HOW TO APPLY In your Upwork proposal, answer these three questions. Keep each answer to 3-5 sentences. We are looking for substance, not length. 1. Tell us about one HR system you built from scratch. What did it include, how did you use AI in building it, and what does it look like today? 2. How have you used AI tools specifically in HR or payroll work? Give one concrete example with a real outcome. 3. Describe a payroll migration or complex payroll situation you owned end to end. What platform, how many employees, and what was hard about it? Proposals without clear answers to all three will not be reviewed. Generic cover letters will be skipped. ----------------------------------------------------------------------- We are an equal opportunity employer. This is an independent contractor engagement via Upwork. All applicable local, state, and federal labor law compliance is a core responsibility of this role.

Freelance Multimedia Journalist / On-Camera Field Reporter Location: Twin Cities, Minnesota Engagement: Freelance, assignment-based Coverage area: Minneapolis, St. Paul, and the surrounding Twin Cities metro Role Overview We are seeking freelance journalists based in the Twin Cities who can report, appear on camera, conduct interviews, and operate their own camera and audio equipment. This is an assignment-based role for journalists who are comfortable working independently in the field. Assignments may include gathering public comments for upcoming videos, conducting scheduled interviews, reporting from relevant locations, capturing supporting footage, and presenting short on-camera segments. The ideal freelancer can manage the full field-reporting process without a separate camera operator. This includes approaching sources, conducting interviews, recording clean video and audio, appearing on camera when required, and delivering organized footage to the production team. Responsibilities Travel throughout Minneapolis, St. Paul, and the surrounding metro area for assigned stories. Gather public comments and street interviews related to videos in development. Conduct interviews with community members, local organizations, experts, business owners, public officials, and other relevant sources. Present short introductions, explanations, transitions, or reporter-led segments on camera. Operate a camera or professional smartphone production setup independently. Set up and monitor microphones, tripods, portable lighting, and other basic field-production equipment. Capture clean interviews, establishing shots, location footage, and supporting B-roll. Work from approved research, assignment briefs, interview questions, talking points, or scripts. Ask relevant follow-up questions and identify strong, usable responses. Confirm names, titles, locations, and other important details before leaving an assignment. Follow consent, release, privacy, editorial, and safety procedures. Label, organize, and upload footage promptly. Provide notes identifying the strongest quotes, key moments, source details, and any concerns the producer or editor should know about. Represent the publication professionally when working with members of the public and interview subjects. Required Experience and Skills Must be based in the Twin Cities area. Professional experience in journalism, reporting, interviewing, documentary work, or news-related video production. Strong on-camera communication skills. Comfortable approaching people and gathering comments in public settings. Ability to conduct clear, professional, and respectful interviews. Experience operating a camera or high-quality smartphone video setup. Working knowledge of field audio, microphones, framing, exposure, lighting, and basic shot composition. Ability to work independently as a one-person reporting and production unit. Strong news judgment and attention to accuracy, fairness, and context. Reliable transportation and the ability to travel throughout the Twin Cities metro. Ability to meet agreed deadlines and deliver complete, organized production materials. Preferred Experience Previous work as a freelance journalist, multimedia journalist, video journalist, field reporter, correspondent, documentary interviewer, or field producer. Familiarity with Minneapolis, St. Paul, and surrounding communities. Experience producing content for digital news, social platforms, documentaries, or short-form video. Experience gathering man-on-the-street interviews or public reactions. Experience interviewing public officials, experts, advocates, or community leaders. Basic editing skills. Familiarity with appearance releases, recording consent, and location permissions. Access to professional or prosumer camera, microphone, tripod, and portable lighting equipment. Assignment Structure This is a freelance, project-based position rather than a full-time staff role. Freelancers may be contacted for assignments based on location, availability, subject matter, and production needs. The scope, deadline, expected deliverables, usage, and compensation will be agreed upon before each assignment. Assignments may include: Gathering public comments for a video scheduled for release. Conducting a scheduled interview with a local source. Recording an on-location reporter segment. Attending a public meeting, event, press conference, or community gathering. Capturing footage from a location relevant to a story. Producing a complete field package that includes interviews, reporter segments, and B-roll. Freelancers will generally receive approved research, an assignment brief, suggested questions, and production guidance. They should also be able to use their journalistic judgment in the field and ask appropriate follow-up questions. Application Materials Please submit: A résumé or brief professional biography. Links to reporting, interviews, on-camera work, or self-shot field footage. A description of your journalism and field-production experience. Your general availability. Your typical freelance day rate, half-day rate, or assignment rate. A list of the camera, audio, and lighting equipment you use. The areas of the Twin Cities metro you are available to cover.

WHO WE ARE AND WHAT WE’RE LOOKING FOR 6AM is redefining how communities engage, communicate, connect, and experience their cities. We’re rapidly growing our digital products and expanding our team across current and future markets. 6AM is for deadline-driven performers who thrive off an adaptable work environment and see the direct impact of their work. Join us as we build upon our growing network of cities, continuing our vision of establishing the most relevant modern local media brand. This position is a 6 month extending contract with the potential for permanent conversion. A commitment of 20-30 hours per week is required. If converted to full-time, additional benefits such as health insurance, unlimited sick and vacation time, and a WiFi stipend is included. WHAT YOU’LL BE DOING Your core responsibility as a Revenue Operations Manager will be to support the Revenue Team and Executive Leadership through scalable data management, software optimization, process efficiency, and B2B marketing support as it relates to driving increased ad sales revenue and renewal rates. The Revenue Operations Manager will report directly to the Revenue Leadership Team and will ensure that sales, client success, finance, and marketing have strong and consistent cross-department communication and coordination. - Process Improvement – Own process building and improvements in current workflows with a goal of improving efficiency and visibility. - KPI / Data management – Architect data sets based on defined KPIs and share with applicable team members on a set frequency via easily consumable insights. KPIs will include data points from revenue data, performance analytics, and goal attainment. Maintain our centralized data warehouse as the source of truth across revenue systems. - Data Infrastructure & Custom Tooling – Manage and maintain our Supabase data warehouse and its integrations across AdOrbit, HubSpot, Sailthru/Marigold, and other systems available via API. Use AI-assisted development practices to build, troubleshoot, and extend custom reporting, automation, and data pipeline tooling. Complex technical escalations are supported by our VP of Engineering. - Tech stack management – Lead any change in the tech stack for the Revenue Team and represent the Revenue Team for any company-wide tech stack change. Stay current on features and updates across our revenue tech stack — including HubSpot, AdOrbit, ZoomInfo, Sailthru/Marigold, PandaDoc, Vercel, and Supabase — and manage software and integrations as needed. - Cross-Functional Coordination – Partner with the Product Operations Manager, Editorial Operations Manager, and other team leads to maintain shared data infrastructure standards, coordinate on Supabase data architecture, and ensure consistent reporting frameworks across revenue and product functions. - Revenue forecasting – Manage revenue forecast to ensure predictable growth and attainable revenue targets. - Visualization Dashboards – Create and manage individual and team dashboards for Revenue Team Directors and Executive Leadership, leveraging both software tools and custom-built reporting based on defined KPIs. - Commissions/Quotas – Assist with monthly commissions calculations and annual quota setting process. - Enablement – Help with the onboarding of new revenue team members, including leading the creation of training materials to ensure successful adoption of any new software, data analysis or program initiatives. Facilitate onboarding regarding processes and data analysis. - Prospecting Materials – Support the organization of templates, branded content examples, and display examples for easy access by team members. - Sales and Fulfillment Materials – Own the creation of standardized proposal templates, advertising agreements, and materials needed to facilitate fulfillment. - Sales Marketing – Support the Growth Team with sales marketing emails, list building, and revenue tracking. WE’D BE FIRED UP IF YOU HAVE SOME OF THESE TRAITS - We are looking for team members with a strong and diverse knowledge of software implementation, integrations, and data management, and a track record of success in digital media. - Experience: 4+ years in project management, operations, data management, or similar role; experience in digital media preferred. - Data-driven: Robust analytical skills, both quantitative and qualitative, with the ability to interpret and synthesize financial data and present in an accurate, concise, digestible, and actionable manner. - Software knowledge: High level of proficiency with HubSpot, PandaDoc, ZoomInfo, Sailthru/Marigold, AdOrbit, Google Workspace, and Zapier. Familiarity with data visualization tools and ad inventory management workflows. - Technical Fluency: Comfortable working within existing codebases and extending custom tooling using AI-assisted development practices. Working knowledge of Git for version control, Vercel for deployments, Supabase (PostgreSQL) for data management, and API-based integrations. No formal development background required — but curiosity, resourcefulness, and a "build it if it doesn't exist" mindset are a must. - Communication Expert: Know how to support various personalities across several job functions and divisions of the company. - Personal Drive: Driven, confident, adaptable, passionate, and spirited. - Contributor: Make and justify recommendations, and share ideas to support business goals. - Adaptable: Willing to learn, handle criticism, market feedback, and differing opinions in startup culture. - Team Player: Outgoing individual who portrays enthusiasm while learning and working with others. WE’RE PUTTING OURSELVES ON THE LINE - Competitive salary - Premium health insurance - 100% remote work - 401k, complemented by a 4% company match - Phone stipend - WiFi stipend - Unlimited sick and vacation time - Two additional weeks of paid time off post maternity leave - New Parent Wellness Stipend - Mental Health Benefits - Virtual company-sponsored social events - Paid time off to volunteer in our communities - A commitment to an open, inclusive, and diverse work culture -Access to cutting-edge tools and technology as we lead the future of local media -Career development support, including reimbursement for learning and growth opportunities EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER All applicants are considered for all positions without regard to race, religion, color, sex, gender, sexual orientation, pregnancy, age, national origin, ancestry, physical/mental disability, severe/morbid obesity, medical condition, military/veteran status, genetic information, marital status, ethnicity, alienage or any other protected classification, in accordance with applicable federal, state, and local laws. We promote diversity of thought, culture, and background, which connects the entire 6AM family. Equal access to programs, services, and employment is available to all qualified persons. Those applicants requiring an accommodation to complete the application and/or interview process should contact a management representative. 6AM City is proud to be an Equal Opportunity Employer.

We're faceless.media. We build, host, and maintain done-for-you websites for local service businesses and keep them ranking on Google. We've already pre-built thousands of sites — so this isn't an experiment, and the owner is never the test case. Here's what makes this different: we've already built a website for every contact on your list. Your job isn't to find leads or explain a complicated product. It's to call the business, show them the site we already made for them, and close. The Opportunity & Compensation This is 100% commission with a recurring revenue share — and the recurring part is the whole point. It's a monthly product, so you don't get one check and start over — you get paid every single month that client stays active. Close once, earn for as long as they're on. Generous, uncapped commission. Strong closers build a stacking, residual income stream, not a one-off payday. Think of it like planting an orchard: a one-time sale is one apple; recurring commission is the tree — plant a few a week and a year later it drops fruit every month whether you show up or not. We handle 100% of fulfillment (build, host, maintain, rank). You focus on one thing: closing. No Prospecting. No Lead-Gen. Just Closing. We provide the list. Every contact already has a website built and waiting — you're not cold-prospecting from scratch. The product sells itself: they see their finished site for free, before paying a dime (it's a test drive, not a pitch). Stupidly easy yes: it costs the customer about $8 a day, with no contracts, cancel anytime, and a 90-day prove-it trial. You Get Our Full Sales Training Platform You're never winging it. Every rep gets access to the Sales Academy — a complete, on-demand training platform that takes you from day one to closing: A structured video course (7 modules) covering mindset, the product, the pitch, objections, and closing — short, punchy lessons you can binge before your first call. Word-for-word scripts for the opener, the pitch, and the close. A Sales Toolkit: step-by-step call flow (Open → Connect → Discover → Present → Demo → Close), an objection quick-reference for every common pushback, and a live commission calculator. No website, SEO, or tech knowledge required — the platform teaches you everything you need to sound like an expert. Experienced closers ramp fast; hungry up-and-comers get a proven system to follow. Our Sales Method (Your Playbook) No spammy, high-pressure tactics. You lead with something we've already built and sell the result, not the website. Work the list we give you — local service businesses (plumbers, roofers, HVAC, electricians, landscapers, remodelers) that already have a site built and a strong Google presence. Open with value, not a pitch: "Hi [Name], it's [You] with LocalSitesBuilder — I saw your great Google reviews, that's actually why I'm calling. Got 30 seconds?" Sell the result, not the thing: nobody wants "a website." They want more calls, more booked jobs, more money. Frame it as a 24/7 employee for about $8 a day that never sleeps. Deliver the gift: "Our team already built you a site — done-for-you, your reviews and services on it, ready to show up on Google." Walk them through the free preview: "Let me show you exactly what we made you — no card, no commitment." Present the price with confidence: about $8 a day. Say it, then go quiet, and anchor it against the value of one new job. Close with the 90-day trial: "No contracts, cancel anytime — just give us a quarter to prove it." Hold the price & book the next step — never end a call on "maybe." Responsibilities Cold-call the provided list of businesses (each already has a site built for them) at high volume. Take owners through the preview walkthrough → close, using the method from our training platform. Handle objections with our framework ("I already have a website," "too busy," "too expensive," "just email me"). Keep clean notes on every contact and signed account, and follow up relentlessly (most yeses land on touch 2–5). Hit daily/weekly targets for dials, walkthroughs, and closes. Required Skills & Experience Excellent spoken and written English with a warm, consultative phone style (no aggressive, low-trust tactics). Comfortable making high-volume outbound calls every day and the discipline to work a list consistently. Coachable — willing to go through our training platform and run our scripts and method as written. B2B / phone / agency / SaaS closing experience is a strong plus; product/tech knowledge is not required — our platform teaches all of it. Reliable computer, headset, quiet space, stable internet, and ability to work CST hours. How to Apply (The Filter Test) To prove you read this, begin your proposal with the exact phrase: "We already built it." Proposals without it will be hidden. Then include: A brief summary of your closing experience — or, if you're newer, why you'll outwork everyone on the phone. Confirm you're comfortable with a 100% commission + recurring revenue share paid on closed, paying clients. Confirm you can work CST hours. Confirm you're comfortable cold-calling a provided list at volume. In 1–2 lines, how would you open the call? (Optional, moves you to the top) a 60–90 second voice or Loom sample of you pitching anything. We give you the list, the product, and the full training platform to close it. We're looking for a true closer who wants to build a recurring income stream. Let's plant the orchard.