Freelance SQL programmer jobs, employment

We are looking for a skilled backend developer to join our team for exciting projects. The ideal candidate will work on server-side logic, integration with front-end components, and database management. You should have experience with various backend technologies and frameworks. If you are passionate about building robust systems and delivering high-quality code, we want to hear from you. Please apply with your portfolio and relevant experience.

# Project: GLM Modelling and Cluster Analysis of Fishing Distance Data in RStudio

## Project objective

I have a dataset containing information on individual fishers, their fishing distance, vessel characteristics, fishing practices, technology use, economic characteristics, and regulatory awareness.

I need someone to conduct statistical modelling and cluster analysis in RStudio, provide all R scripts, and clearly document the complete analytical process.

## Description of the data

“Mean_distance” is the response variable. It is calculated as the geodesic distance for each individual fisher.

“ID” represents each unique fisher ID.

The following variables are the explanatory variables collected in the dataset:

* ID
* Fishing.experience
* vessel.length
* AIS
* VMS
* navigation.apps
* target.sharks
* Top.species.group
* subsidy
* Income.per.trip
* cost.per.trip
* communication.with.fishers
* reg.awareness
* Bycatch
* gear.type
* Site

## Tasks to be completed

### 1. Data preparation and explanatory variable assessment

Review the complete dataset and determine which explanatory variables should be included or excluded from the analysis.

For every explanatory variable, provide a clear rationale explaining:

* Why the variable should be included or excluded.
* Whether the variable is continuous, categorical, binary, or ordinal.
* Whether any recoding or transformation is required.
* Whether the variable contains missing values, unusual values, or data-entry problems.
* Whether the variable has sufficient variation to be included in the analysis.

Conduct collinearity tests using GVIF or anything supportive to assess relationships among the explanatory variables.

Clearly report:

* The GVIF results.
* The criteria used to identify problematic collinearity.
* Which variables were retained or removed.
* The statistical and conceptual rationale for each decision.

Do not exclude variables only through an automatic statistical procedure. Decisions should also consider the ecological and conceptual relevance of the variables.

### 2. Selection of the most appropriate GLM

Identify which type of GLM is best fitted to understand the relationship between “Mean_distance” and the explanatory variables.

The analysis should:

* Examine the distribution of “Mean_distance”.
* Consider that “Mean_distance” contains positive geodesic distance values.
* Compare appropriate GLM distributions and link functions where necessary.
* Explain why the final GLM distribution and link function were selected.
* Check whether continuous explanatory variables meet the assumption of a linear relationship on the model scale.
* Assess model assumptions and model fit using suitable diagnostic tests and diagnostic plots.
* Clearly report any problems related to dispersion, residual patterns, influential observations, or model misspecification.
* Revise the model where necessary based on the diagnostic results.

Provide a clear written rationale for the selected GLM.

### 3. Candidate model selection and model averaging

Develop a scientifically justified set of candidate models using the retained explanatory variables.

Complete the following analyses:

* Model selection using an AICc difference of less than 2.
* Identification of the top models.
* Adjusted model average effect for the explanatory variables.
* Relative variable importance of each variable.
* Model-averaged coefficients.
* Adjusted standard errors.
* Confidence intervals.
* Direction and magnitude of each effect.

Clearly explain:

* How the candidate models were constructed.
* Which model was treated as the global model.
* The criteria used for selecting the top models.
* Whether full averaging or conditional averaging was used.
* How adjusted model average effect was calculated.
* How relative variable importance was calculated.
* How categorical variables and their reference categories were handled.

Provide a final table containing, where applicable:

* Variable name.
* Model-averaged estimate.
* Adjusted standard error.
* Confidence interval.
* Relative variable importance.
* Direction of the relationship.
* Statistical interpretation.

### 4. Graphs explaining the model results

Create publication-quality graphs that best explain the relationship between “Mean_distance” and the explanatory variables.

The graphs should be based on the final model or adjusted model average effect wherever appropriate, rather than only showing raw descriptive relationships.

The figures should include:

* Predicted “Mean_distance” across important continuous explanatory variables.
* Predicted “Mean_distance” for important categorical explanatory variables.
* Confidence intervals around model predictions.
* Clear labels, legends, units, and reference categories.
* Separate graphs or interaction graphs where relationships differ across “Site” or other relevant variables.
* Diagnostic plots needed to demonstrate the adequacy of the selected model.

All graphs should be suitable for use in an academic paper.

Provide each graph in:

* High-resolution image format.
* Editable format where possible.
* The R script used to generate it.

### 5. Cluster analysis

Conduct a cluster analysis to determine which variables collectively form clusters among the fishers.

“Mean_distance” must be included as an active variable in the cluster analysis.

The cluster analysis should:

* Identify the appropriate cluster analysis method for a dataset containing continuous and categorical variables.
* Explain why the selected method is suitable.
* Prepare and format the variables appropriately.
* Standardise continuous variables where required.
* Include “Mean_distance” as an active variable.
* Determine the appropriate number of clusters.
* Explain the statistical criteria used to select the number of clusters.
* Identify which variables contribute most strongly to the formation of the clusters.
* Describe the characteristics of each cluster.
* Report the number of fishers in each cluster.
* Examine how “Mean_distance” differs among the clusters.
* Create suitable cluster visualisations and variable contribution plots.
* Produce a cluster profile table summarising the main characteristics of each cluster.

The interpretation should explain what each cluster represents in practical terms and which combination of variables distinguishes one cluster from another.

### 6. Methods and results writing

Write complete Methods and Results sections explaining exactly what was done.

These should be written separately for:

#### A. Modelling

Provide:

* A Methods section describing data preparation, explanatory variable assessment, GVIF, GLM selection, diagnostics, candidate model selection, adjusted model average effect, relative variable importance, and graph generation.
* A Results section reporting the model diagnostics, top models, important explanatory variables, model-averaged effects, relative variable importance, and predicted relationships.

#### B. Cluster analysis

Provide:

* A Methods section describing data preparation, selection of the cluster analysis method, treatment of continuous and categorical variables, inclusion of “Mean_distance” as an active variable, selection of the number of clusters, and cluster interpretation.
* A Results section describing the final clusters, important contributing variables, cluster sizes, fishing-distance patterns, and the characteristics of each cluster.

The writing should:

* Be suitable for an academic journal article.
* Clearly distinguish descriptive results from adjusted model results.
* Avoid claiming causation when the analysis only demonstrates statistical relationships.
* Use consistent terminology throughout.
* Include the relevant statistical values.
* Correspond exactly with the final R analysis and outputs.

## Required deliverables

The final submission must include:

1. The cleaned dataset used for the final analysis.
2. A table explaining the inclusion or exclusion of every explanatory variable.
3. GVIF or other relevant collinearity results.
4. The final global model.
5. Complete GLM diagnostic results and plots.
6. The candidate model selection table.
7. The top model table based on an AICc difference of less than 2.
8. Adjusted model average effect results.
9. Relative variable importance results.
10. A final model-averaged coefficient table.
11. Publication-quality graphs of the main relationships.
12. Complete cluster analysis results.
13. Cluster visualisation plots.
14. Variable contribution plots.
15. A cluster profile table.
16. Separate Methods and Results sections for modelling.
17. Separate Methods and Results sections for cluster analysis.
18. All R scripts required to reproduce the analysis.
19. A README file explaining the order in which the R scripts should be run.
20. A short explanation of the main analytical decisions and any limitations of the data.

## RStudio and reproducibility requirements

The complete analysis must be conducted in RStudio.

Please provide:

* All R scripts.
* Clearly named and organised script files.
* Comments explaining every important step in the scripts.
* A list of all R packages used.
* The R and package versions used for the analysis.
* A reproducible folder structure for data, scripts, tables, figures, and results.
* A fixed random seed for any analysis involving random procedures.
* Scripts that can run from beginning to end without requiring manual modification.
* Export commands for all tables, graphs, model outputs, and cluster results.

The results presented in the written Methods and Results sections must exactly match the results produced by the final R scripts.

DATA INFRASTRUCTURE ENGINEER: PROJECT APPLICATION CASE STUDY

Contract project | Remote, global hours OK with EST overlap | Milestone-based pay (you propose the structure)

THE TASK

Read this whole document, then record a 3-8 minute Loom explaining how you would solve our problem: the architecture you'd build, what you'd keep vs replace, your migration plan, and your price, broken into milestones.
Your Loom is the application.

IMPORTANT NOTE

We will predominantly use your Loom and case-study answer to grade your application.
We expect a lot of applicants and need to separate engineers who have actually done this from people who talk about tools (or let AI talk for them).
We also know some companies use "sample tasks" to farm free consulting. Stay at whiteboard level: no schemas, no code, no documents. If we want to use your specific ideas beyond hiring you, we will ask permission and pay you for your time!

OUR BUSINESS

RoofIgnite is a performance marketing agency for US roofing, HVAC, and home-services companies. We generate appointments for our clients through Meta ads and automated follow-up, and we spend about $100,000/month on our own client acquisition ads on top of that.
We scaled from $100k/month to $300k/month in revenue in the last 12 months, and we're building toward $1M/month. Every system described below was built in-house while scaling that fast, and each one works. The problem is what happens when you put them all together.

HOW OUR DATA WORKS TODAY

Read this like a map. You'll get a live walkthrough of everything, with our founder Oscar, before starting anything.

1. THE CRM (GOHIGHLEVEL)

Lead and client contact records live in GoHighLevel. Webhooks and automations fire at each pipeline stage and feed almost everything downstream.

2. THE SALES TRACKER (GOOGLE SHEET)

Every lead we've ever generated, from first touch through dials, qualification, and close. GoHighLevel webhooks hit a Google Apps Script that writes each event to the lead's row, matched by contact ID. Ad attribution data comes in from two attribution platforms via API (we're offboarding one of them). There's a log tab recording every webhook received, for error tracing. Errors are rare these days. Separate tabs exist per niche; we'd rather have one table with a niche tag. A few sheet-native dashboards exist that nobody monitors anymore.

3. CREATIVE INTELLIGENCE (PYTHON + CRON ON A VPS)

A nightly pipeline that connects the Meta Ads API, attribution, and the sales tracker: per-ad lead counts and qualified status, winner/loser creative rankings (with manual exclusions, because raw numbers sometimes lie), a Drive archive of every ad creative with visual descriptions and audio transcripts, and a library of sales-call transcripts. All of it feeds an AI copywriting workflow: pick winning ads and strong calls as training context, generate new briefs and scripts. This is the engine behind that $100k/month in ad spend. It works; its data could be cleaner.

4. THE CLOSE-TO-ONBOARDING HANDOFF (CUSTOM AUTOMATIONS)

When a closer closes a deal, an internal tool generates a Stripe payment link tagged with the CRM contact ID. On payment, our internal dashboard receives webhooks and automations create the client's row in our client tracking sheet, a row in our account operations sheet, and a ClickUp onboarding task. Custom-built, not Zapier. Mostly smooth, occasional edge cases.

5. THE CLIENT TRACKING SHEET (GOOGLE SHEET, ~85 COLUMNS)

Every client record after the close: statuses, team assignments, cycle and billing-relevant fields. Created automatically during onboarding, updated by the team, and read by several dashboards. Some of its columns are not native: they sync IN from Airtable (below).

6. THE ACCOUNT OPERATIONS SHEET (GOOGLE SHEET, MULTIPLE POD TABS)

Per-account campaign and billing-cycle data (cycle dates, budgets, results), maintained by our account pods, one tab per pod.

7. AIRTABLE BASE #1 (OPERATIONS)

One table mirrors the client tracking sheet through a TWO-WAY sync (sheet wins conflicts; rows matched by a permanent numeric Client ID; if you delete a sheet row it respawns, real deletes go through an admin tool). A second table mirrors the account operations pod tabs. Airtable exists for exactly one reason: linked records and rollups across tables (cycles billed, fees collected), which Google Sheets can't do. Those computed columns then sync BACK to the sheet. Yes, you read that right.

8. AIRTABLE BASE #2 (FINANCE)

Expense projections plus employee records synced from the BambooHR API (hire/termination dates, division, role, pay group, pay amounts, active status). Payroll runs through QuickBooks for Canadian employees and Wise for US and Philippines contractors. The person who runs payroll currently visits about five different places to do it.

9. FOUR DASHBOARDS ON TOP

A leadership dashboard for client status review and admin operations (reads from Airtable, writes to both Airtable and the sheets).
A finance dashboard: real-time revenue vs projections, client books and team loading, churn and LTV analysis. Built because QuickBooks alone gave no clarity.
A team command center: client success and media buyers see their accounts, per-client detail (ad account data, contract, running copy), and a billing tracker that pings our billing VA on Slack and bills through an internal Stripe tool.
A marketing dashboard: month-over-month ad and sales performance (our own attribution, replacing a paid platform), ad editing pushed through the Meta API, the AI copywriting workflow, and commission tracking.
Each dashboard is hand-wired to specific sheets, tabs, and column positions. Every new feature means another wire.

THE ACTUAL PROBLEM

Our record-keeping layer is Google Sheets and Airtable playing database, stitched together by two-way syncs with conflict rules.
Exactly one person (the founder) can explain how all of it connects. He recorded a video walkthrough for a team member because nobody else could hold the map in their head.
Answering "how many active clients do we have and what state is each one in?" means opening several tools and trusting none of them completely.
Data hygiene fights us: duplicate records, IDs pasted into wrong columns, statuses that disagree between systems.
Everything publishes straight to production. No staging, no branches. One bad change can touch everything.
We want to launch a client-facing portal, and we won't do it on top of this.

THE GOAL

One central, queryable database holding our record-keeping data: leads, clients, cycles, billing, finance/employees. The sheets either retire or become disposable views of it.
The operational tools keep working through the migration. They run the business; downtime is not an option.
Real engineering hygiene around it: staging vs production, version control, backups, access control.
Documented handoff. Our internal team uses AI coding tools daily and will maintain and extend what you build, and build clean dashboards on top. You do it right ONCE and hand it off. This is not a permanent staff-augmentation seat, and we both benefit from that.
On the stack: we've been advised toward SQL (Postgres), and a peer agency at $1M/month runs their version of this on Supabase. But we are not engineers and we are not prescribing the solution. Telling us what you'd build and WHY, in terms we can follow, is most of the interview.

YOUR LOOM (3-8 MINUTES)

The architecture you'd build, named concretely (database, sync approach, hosting), and why it fits a business like ours.
What you'd keep from the current setup and what you'd kill. Not everything here is broken; knowing the difference is the skill.
Your migration order, and how you keep a 40-person team operating mid-migration.
Your phase plan: milestones, what ships at each one, and the price per milestone (or your hourly rate and estimated hours per phase). We pay as milestones ship; we will not fund one large lump sum up front.
One real project where you consolidated multi-system data into a single source of truth: what the mess looked like, what you built, and whether it's still running today.

HOW TO SUBMIT (IN YOUR UPWORK PROPOSAL)

Inform on 1-2 other businesses you've helped with similar cases.
Your Loom link.
Your proposed milestone and payment structure, and when you can start.
We review on a rolling basis and we intend to move in days. If your plan is right and your price is fair, the first milestone (a paid architecture/discovery phase) starts almost immediately.

PAYMENT

Milestone-based, pay-as-we-go through Upwork. The budget listed on this post is a placeholder; you propose the numbers, and we fund milestone by milestone as work ships. We're looking for an expert who does this right one time and hands it off clean, and we'll pay properly for exactly that.

I have a complete Next.js SaaS application already built and ready in a zip file. I need an experienced developer to deploy it and get it live at a domain of which I've already purchased. All code is already written, I just need an experienced developer to launch and "iron out" any kinks to their best ability.
What I need done:
Unzip the codebase and initialize a git repository
Set up the Supabase project — run 2 SQL migrations and create 2 storage buckets
Configure Stripe — set up 6 subscription prices (3 monthly, 3 annual), 3 credit pack products, and webhook endpoint
Set up Resend sending domain for transactional emails
Configure all environment variables from the provided .env.example file
Deploy to Vercel and connect the domain
Test everything end to end and fix any issues that come up

What I will provide:
Complete zip file with all 16 stages of the codebase
README.md with setup instructions
All API keys for Supabase, Stripe, Anthropic, and Vercel, four design mockup files showing exactly how the app should look, logo file full product specification document

Accounts already created:
Supabase
Vercel
Stripe
Anthropic Console
Domain purchased

Budget: $750 budget, absolutely willing to pay more if need be, eager to launch.
Timeline: 1-2 weeks, since code is already written it should not take a very long time, just looking for deployment.
Payment: Split into 2 milestones — half when running locally, half when live at the specified domain
Please only apply if you have experience with Next.js, Supabase, Stripe integrations, and Vercel deployments. Share examples of similar projects you have deployed.

I need a developer to extract the complete public archive of court rulings from a government portal in Guatemala (Constitutional Court) and deliver it as structured data plus the original PDFs, with monthly updates afterward.
The portal is ASP.NET, search-only with no full index, so guaranteeing complete coverage is the core of the job. I need a verifiable completeness process: a manifest and gap report showing the full range tested, every hit and miss, and a reason for each gap, so nothing is silently skipped. Case numbers (expedientes) run sequentially by year, which is likely the cleanest way to sweep everything.
Deliverables: original PDFs named by case number (Exp. NNNN-YYYY.pdf), OCR only where a document has no text layer (most already carry text), plain text plus structured JSON/CSV, and the five portal sections each kept separate (Sentencias, Autos, Estándares Internacionales, Doctrina Legal, Resoluciones de Interés). Delivery by Google Drive as a managed service run on your side. Then recurring updates of only new documents, priced daily, weekly and monthly.
Timeline: complete historical set by the second week of August, first batch as soon as available.
Respectful scraping only, no aggressive evasion. The data is public.

Remote | Part-Time | Long-Term | Contract-to-Hire

PrimECS is a U.S.-based engineering, surveying, and construction company looking for an experienced AI Automation Engineer to build our internal AI-powered operating system.

Your mission is simple:
Use AI and automation to eliminate repetitive work, improve decision-making, and make every employee more productive.

This is not an IT support role.

Responsibilities
• Build AI-powered business workflows and automations
• Integrate Microsoft 365, Google Workspace, QuickBooks, ClickUp, and other systems
• Develop AI assistants for proposals, finance, operations, and project management
• Build dashboards and reporting tools
• Automate repetitive administrative and engineering workflows
• Document and improve business processes
• Train staff on AI tools and best practices

Required Skills
• ChatGPT/OpenAI API, Claude, Gemini
• Python
• Make.com, n8n, Zapier, or Power Automate
• APIs and system integrations
• SQL or databases
• Microsoft 365 and Google Workspace
• Excellent problem-solving skills
Experience supporting engineering, construction, consulting, or project-based businesses is a plus.

Success Measures
• Automate at least 15 recurring workflows within six months
• Reduce reporting and administrative work by at least 50%
• Build a searchable AI knowledge base
• Demonstrate measurable time savings across the company

• Describe the most advanced AI automation you have built.
• What AI tools and automation platforms do you use regularly?
• If hired tomorrow, what are the first five business processes you would automate in our company, and why?
• Include a link to your GitHub profile and/or website
• Describe your recent experience with similar projects

Project: Premium One-Page Tutoring Flyer in Photoshop

I need a designer to create a polished one-page flyer for an in-person computer science tutoring and software project mentorship service in Manhattan.

The flyer will be posted in cafés, school- and university-adjacent locations, libraries, coworking spaces, and neighborhood bulletin boards. It should feel professional, modern, credible, and high-end. It should not look like a generic homework-help flyer, kids’ coding camp ad, tear-off-tab notice, or stock-photo business flyer.

The audience is students and serious project builders who need hands-on help with real programming projects. Scheduling and payment are handled through Wyzant.

Please use the exact copy below. You may adjust hierarchy, spacing, typography, and line breaks, but do not rewrite the text.

Flyer copy:

COMPUTER SCIENCE PROJECT RESCUE

Java • C++ • C# • JavaScript/TypeScript • Angular • Node.js
HTML/CSS • SQL/Databases • APIs • Git/GitHub • Linux/Hosting

Bring the laptop, code, assignment, capstone, app, game, website, or portfolio project.
We work directly in the actual development environment.

$125/hr
Manhattan in-person sessions at home, campus, or agreed public location.
90-min minimum.

Book through Wyzant for secure scheduling and payment.

[QR CODE]

Design requirements:

The final deliverable must be a layered Adobe Photoshop PSD file, not a flattened design. The QR code will be provided and must be placed in its own clearly named layer or layer group so it can be replaced later if needed.

Please keep the file cleanly organized, with reasonably named layer groups such as title, technology line, description, pricing, location, Wyzant CTA, QR code, background, and decorative elements.

Do not use AI-generated images, AI-generated poster layouts, or AI-generated text effects as the basis of the design. I am looking for a deliberately designed Photoshop layout with editable text, separate design elements, and cleanly organized layers. Template-based or flattened artwork is not suitable for this project because I need to be able to edit and replace elements later.

The flyer should be designed for professional printing at final US Letter size, 8.5" x 11". Please include a standard 0.125" bleed on all sides, so the full artwork size is 8.75" x 11.25". The design may use full-bleed background color or graphics, but all important text and the QR code must stay inside a safe margin. Do not include crop marks in the print-ready PDF.

The visual hierarchy should make the message immediately clear: headline first, then technology line, project description, price/location, Wyzant booking instruction, and QR code.

Preferred style:

Professional, modern, technical, clean, high-contrast, and uncluttered. Subtle code/editor motifs are fine. Avoid cartoon imagery, childish coding-camp styling, classroom stock photos, handshake/business stock photos, excessive icons, and tear-off tabs.

I am open to different visual directions, including minimal premium tech, bold project-rescue, or academic/professional hybrid. The key is that the flyer should look serious enough for university-adjacent locations, coworking spaces, cafés, and neighborhood boards.

Required deliverables:

Layered Adobe Photoshop PSD file with organized, clearly named layer groups
QR code on its own clearly named layer or layer group
Print-ready PDF with 0.125" bleed and no crop marks
PNG or JPG preview for review

Please include a brief note about your approach and show examples of clean flyer, poster, or information-design work if available.

• Can you deliver a clean layered Photoshop PSD, not only a flattened image or Canva file?
• Will the QR code be placed on its own named layer or layer group so it can be replaced later?
• Briefly describe the visual direction you would take for this flyer.
• Please link to 2–3 flyer, poster, or information-design examples with strong typography and clean layout.
• Have you personally designed the portfolio samples you are submitting, and can you provide a layered PSD with editable text and organized layer groups?

We are looking for a skilled Data Analyst to help us turn raw data into meaningful insights that support better business decisions.

The ideal candidate should be experienced in collecting, cleaning, analyzing, and visualizing data using modern analytics tools. You will work with datasets from multiple sources, identify trends and patterns, create clear reports and dashboards, and provide actionable recommendations based on your findings.

Responsibilities include analyzing business data, building interactive dashboards, preparing reports, validating data accuracy, and presenting insights in a clear and organized format.

Experience with Excel, SQL, Power BI, Tableau, Python, or similar data analysis tools is highly preferred. Strong analytical thinking, attention to detail, and the ability to communicate findings effectively are essential.

If you have a proven track record of delivering accurate analysis and helping businesses make data-driven decisions, we'd love to hear from you. Please include examples of similar data analysis projects you have completed.

Senior Presales Engineer – Data Security / DSPM (LATAM, Remote)

We're looking for a Senior Presales / Sales Engineer with hands-on experience in data security, data governance, and sensitive data management to help commercial team in Latin America.

---


Our platform supports 30+ native integrations covering the full enterprise storage landscape:

- File Servers & NAS: Windows File Server, NetApp (FPolicy/ONTAP), Hitachi, Huawei OceanStor, Dell EMC Isilon/PowerScale, QNAP, Synology
- Databases: PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle
- Cloud Storage: AWS S3, Azure Blob Storage, Google Cloud Storage
- SaaS & Collaboration: Salesforce, Box, SharePoint/OneDrive, Microsoft 365
- Identity & Directory: Active Directory, Azure AD/Entra ID, NTFS/RBAC permissions
- Security & Compliance: DLP, DAM (Database Activity Monitoring), sensitivity labeling, data classification

So good knowledge of multiple integrations needed.

---

THE ROLE

This is a senior individual contributor role working directly with the LATAM sales team throughout the full sales cycle — from discovery to PoC execution to technical close.

Responsibilities:
- Support the sales team throughout the entire sales cycle
- Understand customers' technical and business requirements
- Design solution architectures for enterprise clients
- Deliver technical presentations, workshops, and product demonstrations
- Execute Proof of Concept (PoC) and Proof of Value (PoV) engagements
- Install, configure, and integrate solutions in lab and customer production environments
- Produce technical documentation, architecture diagrams, and solution proposals
- Participate in RFP/RFI processes
- Train and enable customers, partners, and channel resellers
- Collaborate with Sales, Consulting, and Post-Sales teams
- Stay current on data security technologies and market trends
- Contribute to technical content and best practices

---

REQUIRED EXPERIENCE

- 5+ years in a Presales, Sales Engineer, or Solutions Engineer role in cybersecurity, data governance, regulatory compliance, or enterprise infrastructure
- Proven hands-on experience with data governance, sensitive data, data classification, DSPM, DLP, DAM, or regulatory compliance solutions
- Track record of leading end-to-end PoCs in real enterprise environments (not just lab or sandbox demos)
- Strong technical knowledge of Active Directory, File Servers, NAS, Azure, AWS and data security
- Experience with at least two categories of the integration ecosystem (file storage, databases, cloud, or SaaS)
- Experience selling to regulated-industry clients in LATAM: banking, insurance, healthcare, government, energy, or enterprise retail

---

NICE TO HAVE

Prior experience with similar solutions or data governance platforms such as:
Varonis · Netwrix · Cyera · Kriptos · Microsoft Purview


Valued certifications:
- SC-400 Microsoft Purview
- AZ-500 Azure Security Engineer
- CISSP / CISM
- CompTIA Security+
- AWS Security Specialty
- CEH

---

WHAT WE'RE LOOKING FOR

Beyond the technical profile, we care a lot about:

- Excellent communication skills in Spanish (native or professional level required). The role involves presenting to CISOs, legal teams, and executive audiences — clarity and persuasion matter.
- Highly resourceful: when you hit a technical blocker during a PoC in an unfamiliar customer environment, you find a way through it independently.
- Results-driven: you understand that a failed PoC is a lost deal, and you take ownership of making the evaluation successful for the customer.
- Organized under pressure: able to manage multiple active opportunities and PoCs in parallel.
- Strong documentation culture: architecture diagrams, RFP responses, integration guides, enablement materials.
- Technical English (reading documentation, communicating with vendors) is a plus.

---

WHAT WE OFFER

- 100% remote — open to candidates anywhere in Latin America
- Competitive compensation: base salary + performance bonus
- Direct access to founders and leadership — your feedback shapes the product roadmap
- Lean, no-bureaucracy team with real impact from day one


TO APPLY

Please include in your proposal:
- A brief description of the most complex PoC you have led (environment, integrations involved, outcome)
- Your experience with any of the data security platforms mentioned above
- Your availability and preferred engagement type (freelance / full-time)

We read every proposal carefully.

Seeking a senior AI engineer to build Phase 1 of a hierarchical multi-agent brokerage OS. The system will be messaging-first, without voice capabilities. The role involves developing a LangGraph-based AI system to manage agent interactions and decision-making. The ideal candidate will have experience in AI system design and development, particularly with LangGraph and multi-agent systems.

We are seeking a skilled developer to create and enhance applications using Microsoft Power Apps and Power Pages. The ideal candidate will have experience in designing user-friendly interfaces and integrating data sources such as dataverse, sql server etc to create efficient solutions. Responsibilities include developing new features, troubleshooting issues, and optimizing performance. Familiarity with Microsoft Power Platform is essential.

We're building an AI-powered platform for investment analysis and risk assessment and need a senior full-stack developer to architect and build the MVP.

What you'll build:
- AI Investment Analyst: Analyzes stocks, portfolios, or assets using LLMs + real-time financial data; generates reports, summaries, and investment insights
- Risk Assessment Engine: Calculates risk metrics (VaR, Sharpe ratio, beta, drawdown), flags high-risk positions, and provides risk-adjusted recommendations
- Interactive Dashboard: Visualizes portfolio performance, risk exposure, sector allocation, and AI-generated insights with charts and heatmaps
- User Authentication & Portfolios: Secure auth, user portfolios, watchlists, and saved AI reports
- AI Chat Interface: Natural language queries like "What's the risk of my tech-heavy portfolio?" or "Analyze AAPL vs MSFT"

Tech Stack (preferred):
- Frontend: Next.js 14+ (App Router), TypeScript, Tailwind CSS, shadcn/ui, Recharts/TradingView charts
- Backend: Python (FastAPI) for AI/ML services; Node.js optional for API layer
- AI/ML: OpenAI GPT-4 / Claude 3.5, LangChain for orchestration, custom Python models for risk calculations
- Financial Data: Yahoo Finance API, Alpha Vantage, Polygon.io, or IEX Cloud (real-time + historical data)
- Database: PostgreSQL (user data, portfolios), Redis (caching), optional Clickhouse/TimescaleDB for time-series
- Risk Engine: Python (pandas, numpy, scipy, pyfolio, QuantLib) for quantitative risk metrics
- Deployment: Vercel (frontend) + AWS/Railway (backend) + Docker

Core Features to Implement:
1. Portfolio Upload/Build: Manual entry or API-synced holdings
2. AI Report Generation: LLM-generated investment summaries, risk narratives, and recommendations
3. Risk Metrics Dashboard: VaR, CVaR, Sharpe, Sortino, max drawdown, correlation matrices
4. Scenario Simulation: "What-if" stress testing (market crash, rate hike, sector rotation)
5. Alert System: Risk threshold breaches, price targets, AI-detected anomalies

Requirements:
- 4+ years full-stack development with production-grade apps
- Proven experience with LLM integrations (OpenAI, Claude) and prompt engineering
- Financial/quantitative background: understanding of risk metrics, portfolio theory, or prior fintech projects
- Experience with financial data APIs (Yahoo Finance, Alpha Vantage, Polygon, etc.)
- Strong TypeScript, React, Python, and SQL skills
- Security-first mindset: OAuth, JWT, encryption, input validation
- Clean GitHub or portfolio with relevant projects

Nice to Have:
- Experience with time-series databases or financial data processing
- Background in quantitative finance, risk modeling, or CFA-level knowledge
- Familiarity with RAG for analyzing large financial documents (10-Ks, earnings calls)
- Knowledge of banking compliance (SEC, FINRA, MiFID II awareness)
- Experience with real-time data (WebSockets, streaming APIs)

We’re building a mobile-browser, real-time multiplayer arena game set in a stylized urban neighborhood. Players ride open-top auto-rickshaws, dodge city chaos, and score "strikeouts" by taking out other riders to become the Last Survivor. It's a cash-prize / real-money game, so correctness matters.
The codebase is already built and playable (server-authoritative multiplayer, deterministic game engine, durable results/payout path, local Docker stack + headless bots, ~2,800 lines of TypeScript). We're hiring an engineer to (1) integrate the incoming bespoke art, (2) review the existing implementation, and (3) complete the remaining build through to launch.

What you'll do
- Art integration (near-term): swap placeholder art for the artist's 2.5D bird's-eye sprite sheets / atlases (or Spine) in the Phaser client and wire animation states (drive / fire / hit / spin-out), per-player runtime color tinting, color-matched FX, depth/y-sorting, and hit the mobile perf budget on low-end Android (bundle splitting, atlases, WebP).

- Review the existing implementation: server authority & anti-cheat surface, netcode (30 Hz sim / 15 Hz broadcast, interpolation), the deterministic engine, and the money path (single-use join tickets, idempotent finalize, void/refund reconciliation). Flag risks, propose improvements.
Complete the build for Production and launch:
- Money loop: wallet/credit + seat lifecycle (reservation TTL, pay-but-no-join credit, refunds), payout math, per-match P&L correctness.
- Admin + leaderboards + anti-cheat detectors, and payout review workflow.
- Hardening: load/soak (20 players), graceful drain, observability, security pass.
- Third-party integration: Google OAuth, Stripe (payments + payouts), and deploy (Fly.io game server + Vercel web + Supabase Postgres/Auth + managed Redis).

Tech stack (what you'll work in)
- TypeScript everywhere, Node, pnpm monorepo, run via tsx (no build step for services).
- Colyseus (authoritative real-time rooms) · Phaser (2D/2.5D web client, PWA).
- Fastify API · Postgres (+ RLS) · Redis · Docker Compose (local) · Vitest.
- Target: Fly.io (Johannesburg), Vercel, Supabase.

Must-have
- Strong TypeScript / Node.
- Real-time multiplayer / netcode experience — server-authoritative design, WebSockets (Colyseus a big plus; Socket.IO/Nakama/Photon/custom also relevant).
- 2D web game integration with Phaser (or comparable) and sprite sheets / texture atlases / Spine; comfortable turning an artist's assets into an animated, tinted, performant client.
- Postgres/SQL + Redis; comfort with correctness-critical flows (idempotency, transactions).
- Mobile web performance instincts (low-end Android, bundle size, 30–60fps).
Nice-to-have
- Payments integration (Stripe,etc), payout/ledger correctness, KYC flows.
- Deploy experience with Fly.io / Vercel / Supabase.
- Anti-cheat / fair-play systems for competitive games.
- Familiarity with the developing countries mobile market (connectivity, devices).

How we work
- This is review + extend a working, tested codebase, not greenfield. There's a deterministic, unit-tested engine and a durable money path already in place. You'll build on solid foundations.
Milestone-based with clear acceptance criteria. We have detailed design + architecture docs and an implementation plan. A staff-level review of the current code is welcome as an early deliverable.

# Monday.com Automation & Integration Specialist

We are looking for an experienced Monday.com specialist to development, optimisation and automation of internal workflows.

This is a remote, hourly, project-based collaboration through Upwork. We are looking for someone who can support us with specific tasks and ongoing improvements as needed.

Main Responsibilities

Design, configure and optimise Monday.com boards, workspaces, dashboards, workflows, formulas, WorkForms and KPIs.
1 Improve the overall structure and architecture of our Monday.com environment.
2 Create advanced automations between boards and workspaces.
3 Configure approval flows, notifications and operational processes.
4 Manage permissions and workspace organisation.
5 Integrate Monday.com with other systems using APIs, webhooks or integration platforms.
6 Support data synchronisation between Monday.com and external platforms.
7 Help create reports and management dashboards using Looker Studio .
8 Document the solutions implemented and explain them clearly to internal users.
9 Identify opportunities to simplify and automate existing processes.

Required Experience

Strong practical experience with Monday.com.
Advanced knowledge of:

* Boards and workspaces
* Automations
* Dashboards
* Formulas
* WorkForms
* Permissions
* Cross-board workflows
Experience with Monday.com API, GraphQL, REST APIs, JSON or webhooks.
Ability to understand complex operational processes and transform them into simple and scalable workflows.
Strong problem-solving skills.
Good communication and ability to work independently.
Good level of English.

Preferred Skills

The following skills are valuable but not mandatory:

1 Experience with Make.com, Zapier or other integration platforms.
2 JavaScript, TypeScript, Python or PHP.
3 SQL and data manipulation.
4 Looker Studio.
5 ERP integrations.
6 Primavera ERP.
7 Google Workspace integrations.
8 Experience using OpenAI, Gemini or other AI APIs for process automation.
9 Portuguese language skills.

Collaboration Details

* Fully remote.
* Hourly work
* Work will be assigned by task or project.
* The number of hours may vary depending on current needs.
* Possibility of long-term collaboration for the right specialist.
* No travel or on-site presence is required.

When Applying

Please include:

1. Your experience with Monday.com.
2. Examples of advanced boards, dashboards or automations you have built.
3. Experience with the Monday.com API or external integrations.
4. Integration tools you normally use.
5. Your hourly rate.
6. Your current availability.
7. Relevant case studies, screenshots or project examples.

Senior MySQL & Full-Stack Developer (Part-Time, Long-Term)

We are seeking an experienced developer to support our internal team on an ongoing basis. Responsibilities include MySQL database schema design and optimization, SSO implementation, code reviews, troubleshooting, and general application development support.

Requirements:

Strong MySQL/database design experience
Experience implementing SSO (SAML, OAuth, OpenID Connect, etc.)
Ability to perform thorough code reviews and recommend best practices
Full-stack development experience preferred
Strong communication skills and ability to collaborate with a remote team

This is a flexible, part-time engagement.

We are looking to optimize our current existing implementation of Intercom to something that is more AI-friendly and responsive to some of our existing data.

Software/Data Engineer needs to efficiently set up virtual work environment.

To Apply:
- Share your approach
- Confirm availability for a 30-min trial session

Tags: Virtual / Hybrid work from home office

I am looking for an advanced eClinicalWorks user who currently works with the platform on a daily basis. I need someone who can screenshare with me (if possible) the different modules, specifically focusing on billing, RCM (aging schedules), and reporting.

I have already completed multiple demonstrations with eClinicalWorks and have spent significant time reviewing contracts, pricing, AI functionality, reporting, revenue cycle workflows, and implementation. The issue is demonstrations are done in a fast manner where it is difficult to assess full functionality; thus, why I would like a more personal demo from a current user.

I am not looking for another sales presentation. Instead, I am looking for someone who has extensive hands-on operational experience and can validate how the system actually works in day-to-day practice.

This is essentially a technical and operational due diligence consultation before selecting our long-term EHR.

Behavioral Health/Psychiatry experience is strongly preferred.

Ideal Background
Current or recent daily eClinicalWorks user
Practice Administrator
Billing Manager
Revenue Cycle Director
Implementation Consultant
Practice Management Consultant
Healthcare IT Consultant
eClinicalWorks Certified Trainer (preferred)
5+ years of eClinicalWorks experience
Experience with outpatient behavioral health or psychiatry is a significant plus
Consultation Topics

I would like to validate and better understand the following:

Revenue Cycle
Claims workflow
Corrected claims
Appeals
Denials
Work queues
Secondary claims
ERA posting
Payment posting
Contract fee schedules
Insurance allowables
Reporting by payer and CPT
Financial reporting
Reporting & Analytics

Help me understand:

Where the data actually resides
Standard reports
Custom reports
SQL reporting
Exporting data
Power BI integration
Executive dashboards
Revenue cycle reporting
Day-to-Day Workflow

Please walk me through the actual workflow for:

Front desk
Scheduling
Patient check-in
Medication management visit
Provider documentation
Billing
Collections
Revenue cycle follow-up

I want to understand what actually happens in practice—not just what is shown during demonstrations.

Customer Support

Based on your experience:

How responsive is customer support?
What are the biggest frustrations?
What questions typically require multiple follow-ups?
AI

Please discuss your experience with:

Sunoh
Ambient documentation
AI assistants
Time savings
Limitations
Patient Communication

I would like to understand the real-world workflow for:

Appointment reminders
Secure messaging
Two-way texting
Patient Portal
Intake forms
Telehealth
Phone Systems

Please explain:

Which phone systems integrate best with eClinicalWorks
Whether staff still spend their day switching between the EHR and the phone system
Whether there is a truly integrated communication workflow
Automation

Please identify:

Which workflows are actually automated
Which still require manual work
Which automation features meaningfully reduce staffing
Which advertised automation features provide little real-world value
Comparison with athenahealth

Experience with athenahealth is highly preferred.

If you have worked extensively with both platforms, I would appreciate an unbiased comparison of:

Daily workflow
Revenue cycle
Reporting
Customer support
Automation
AI
Patient communications
Operational efficiency
Long-term scalability
Deliverable

I am looking for a 90–120 minute Zoom consultation where I can ask detailed operational questions along with a write up

The objective is to validate my understanding of the software, challenge my assumptions, and better understand the strengths, weaknesses, and real-world workflow before making a final purchasing decision.

Please include:

Current role
Years using eClinicalWorks
Whether you currently use the software
Specialty experience
Experience with athenahealth (if applicable)
Hourly consulting rate

I am specifically looking for someone who can explain how the software actually works in practice, rather than simply repeating features shown during vendor demonstrations.

DATA ANALYTICS ENGINEER
TwoTen · Data & Engineering
ABOUT US
TwoTen Strategy is a boutique consulting firm that helps retailers, restaurants, consumer brands, and real estate owners make smarter growth and location decisions through data. We combine first-party customer data, mobile location data, GIS, and advanced analytics to answer high-impact business questions for leading national brands.
We work with highly confidential client and consumer datasets. Trust, discretion, and rigorous data stewardship are fundamental to every project.
THE ROLE
We're looking for an Analytics Engineer to own the technical infrastructure behind our client engagements. You'll connect client data sources, APIs, cloud platforms, and third-party datasets into reliable, automated data pipelines that power Tableau dashboards and client deliverables.
This is a fully-remote, hands-on role for someone who enjoys building systems, solving problems, and creating scalable solutions. Your success will be measured by the reliability, accuracy, and efficiency of the data ecosystem you build.
WHAT YOU'LL DO
Own the end-to-end data pipeline supporting client analytics—from data ingestion through Tableau delivery.
Build and maintain secure integrations with APIs, client databases, cloud storage, spreadsheets, and third-party platforms.
Develop automated Python and SQL workflows to clean, validate, transform, and load data into BigQuery.
Design and maintain scalable data models that support high-performing Tableau dashboards.
Monitor, troubleshoot, and continuously improve production data pipelines and dashboard refreshes.
Implement rigorous QA processes and data validation to ensure accurate, reliable client deliverables.
Automate recurring reporting and eliminate manual processes wherever possible.
Partner with consultants to translate complex business questions into clear, actionable analytical solutions. Communicate technical insights and data nuances to non-technical client stakeholders during project deliverables.
Handle confidential client and consumer data with the highest standards of privacy, security, and governance.
WHAT WE'RE LOOKING FOR
3–6 years of experience in analytics engineering, business intelligence, data analytics, consulting, or a related field.
Strong SQL and Python skills (pandas, APIs, automation).
Experience building and maintaining automated data pipelines.
Experience working with cloud data warehouses (BigQuery preferred).
Experience building and maintaining Tableau data sources and dashboards.
Comfortable connecting and integrating data from APIs, cloud storage, spreadsheets, databases, and external client systems.
Experience working in Google Workspace (Sheets, Drive, Docs) and collaborative notebook environments such as Google Colab or Jupyter.
Strong understanding of data quality, validation, and troubleshooting.
Experience handling confidential or sensitive data with sound data governance and security practices.
Excellent organization, attention to detail, and ability to manage multiple client engagements simultaneously.
Stable, high-speed internet - and a professional remote work setup.
NICE TO HAVE
Geospatial analytics (GeoPandas, Shapely, PostGIS, QGIS, ArcGIS, etc.)
Retail, restaurant, consumer, or commercial real estate analytics
Machine learning or predictive modeling experience
Experience working with location intelligence or mobility datasets
Git/GitHub and modern development workflows
OUR TECHNOLOGY STACK
Python · SQL & BigQuery · Tableau · REST APIs · Google Workspace · Google Colab & Jupyter · GIS & Spatial Data · Git/GitHub
WHAT SUCCESS LOOKS LIKE
Client data sources are integrated quickly and securely.
Data pipelines run reliably with minimal manual intervention.
Tableau dashboards refresh accurately and perform efficiently.
Data quality issues are identified and resolved before they impact clients.
Repetitive work is automated, allowing consultants to focus on insights and strategy.
Clients trust the accuracy, consistency, and reliability of every deliverable.

COMPENSATION
$25-35 per hour, depending on experience
Performance Based Bonus up to 20%

WHY TWOTEN?
You'll work on a wide variety of high-impact projects across retail, restaurants, real estate, and consumer brands, helping clients solve complex business problems using modern analytics. As a member of a small, entrepreneurial team, you'll have significant ownership, direct exposure to clients, and the opportunity to shape the technical foundation of a growing consulting firm.

• Describe your recent experience with similar projects
• What tools do you use for data mining and visualization?
• How do you deal with outliers or missing values in a dataset?

We are looking for an experienced Agentic AI and LLM Engineer to build an intelligent research and automation platform using publicly available filings and documents from SEC.gov.
The system will collect, process, analyze, and structure financial information from SEC filings such as 10-K, 10-Q, 8-K, registration statements, prospectuses, exhibits, and asset-backed securities reports.
The ideal candidate should have experience with LLM-powered research systems, document intelligence, financial data extraction, retrieval-augmented generation, and production-grade automation.
Project Responsibilities
Build automated pipelines to discover and download filings from SEC.gov and EDGAR.
Process SEC HTML, XML, XBRL, PDF, and text documents.
Extract financial metrics, tables, disclosures, risk factors, transaction details, and other structured information.
Develop AI agents that can research companies, securities, trusts, and financial transactions.
Build RAG pipelines for searching and answering questions across large collections of SEC filings.
Generate research reports with source references and filing-level citations.
Create workflows for comparing filings across companies, reporting periods, or securities.
Implement structured outputs using predefined schemas.
Develop validation and reconciliation checks to reduce extraction errors and hallucinations.
Integrate the solution with APIs, databases, dashboards, or internal applications.
Document the architecture, extraction logic, and deployment process.
Example Use Cases
Analyze quarterly and annual company filings.
Extract KPIs and financial disclosures from 10-K and 10-Q reports.
Track changes in risk factors and management commentary.
Analyze asset-backed securities and trust-level performance reports.
Extract payment waterfalls, triggers, delinquency metrics, losses, and credit enhancement data.
Compare SEC disclosures across reporting periods.
Generate cited investment or financial research summaries.
Required Skills
Strong Python development experience.
Hands-on experience with OpenAI, Anthropic, Gemini, or open-source LLMs.
Experience building agentic AI workflows using LangGraph, LangChain, CrewAI, AutoGen, or similar frameworks.
Strong understanding of RAG, embeddings, vector search, hybrid retrieval, and reranking.
Experience parsing SEC filings, EDGAR data, XBRL, XML, HTML, PDFs, or complex financial documents.
Experience designing structured data extraction pipelines.
Familiarity with financial statements and public-company filings.
Experience with FastAPI, PostgreSQL, Docker, and cloud deployment.
Ability to build reliable production systems rather than basic AI demonstrations.
Preferred Experience
Previous experience working with SEC.gov or EDGAR APIs.
Experience analyzing securitizations, asset-backed securities, loan portfolios, or trust reports.
Knowledge of financial metrics, accounting terminology, and regulatory disclosures.
Experience with document OCR, table extraction, and data reconciliation.
Familiarity with Pinecone, Qdrant, Weaviate, OpenSearch, Elasticsearch, or FAISS.
Experience implementing LLM evaluations, observability, guardrails, and citation verification.
Application Questions
Please include the following in your proposal:
Have you previously worked with SEC.gov, EDGAR, XBRL, or financial filings?
Share an example of an LLM-based document intelligence or research system you have built.
How would you reliably extract structured financial data from SEC filings?
How would you validate LLM-generated outputs against the original filing?
Which agentic AI, retrieval, and vector database technologies would you recommend?
Please share your GitHub, portfolio, or a relevant project demonstration.
We are looking for someone who can understand complex financial documents, design the right AI architecture, and independently deliver a reliable and scalable research intelligence platform.
This may become a long-term engagement for the right candidate.

I am an early-career data automation and reporting candidate based in India with portfolio-based experience in:

Microsoft Excel
Google Sheets
Google Apps Script
Spreadsheet workflow automation
Formula-driven reporting
Data validation and quality checks
KPI dashboards
Operations reporting
Daily, weekly and monthly review systems
Structured input logs
Python and data-analysis foundations
Data visualization and reporting documentation
User guides and non-technical handoffs

I am looking for an experienced reverse recruiter or data-career job-search specialist to manage a focused application campaign.

The campaign should emphasize data automation, spreadsheet systems, operations reporting and entry-level analytics rather than advanced data-science positions.

Target roles

Potential roles include:

Junior Data Automation Analyst
Reporting Analyst
Operations Reporting Analyst
Data Operations Analyst
Junior MIS Analyst
MIS Executive
Spreadsheet Automation Specialist
Excel Automation Specialist
Google Sheets Automation Specialist
Junior Operations Analyst
Junior Business Operations Analyst
Reporting and Dashboard Associate
Data Quality Associate
Junior Data Analyst, when requirements are appropriate

A general Data Analyst role should be pursued only when the requirements are reasonably aligned with Excel, Google Sheets, reporting, basic Python or entry-level analytics.

Do not prioritize:

Senior Data Analyst
Data Scientist
Machine Learning Engineer
Analytics Engineer
Data Engineer
Advanced BI Developer
Roles requiring advanced SQL, Power BI, Tableau, cloud data warehousing or several years of production analytics experience unless the job description treats those skills as optional
Target markets

Primary markets:

Remote opportunities that accept candidates located in India
India-based positions

Selected GCC opportunities may be included for MIS, reporting or operations-analysis roles when overseas candidates are eligible.

Responsibilities

The selected freelancer will:

Review my data-automation and spreadsheet-automation CVs.
Evaluate my portfolio and identify the strongest marketable evidence.
Recommend realistic role titles and exclusions.
Search employer career pages and suitable job platforms.
Verify location and work-authorization eligibility.
Review every job description before recommending it.
Send suitable positions for approval during the pilot.
Tailor my résumé to each approved role.
Emphasize the appropriate reporting, spreadsheet, dashboard or automation projects.
Prepare accurate screening answers and short cover notes.
Maintain a complete application tracker.
Save every résumé, cover letter and job description.
Identify recurring skill gaps in rejected opportunities.
Accuracy requirements

The freelancer must clearly distinguish portfolio projects and simulated business datasets from paid employer or client work.

The freelancer must not invent:

Commercial clients
Production deployment
Professional data-analysis employment
Revenue or cost savings
Unsupported SQL or BI expertise
Technical tools that do not appear in my verified experience
Work authorization or location eligibility
Initial paid pilot

The pilot will include:

Positioning assessment.
Recommended role-title and exclusion list.
Six approved job applications.
One tailored résumé per application.
Cover notes where useful.
Complete application tracker.
A short skill-gap and campaign recommendation report.

Expected duration: 7–10 calendar days.

A smaller pilot is intentional because this campaign has a narrower target profile.

Required experience
Reverse recruiting or job-application management.
Data, reporting, MIS or operations recruitment.
Excel and Google Sheets résumé terminology.
Understanding of junior data and reporting occupations.
Strong résumé tailoring and written English.
Experience finding remote jobs that accept India-based candidates.
Manual and quality-controlled work.

• Which roles best fit a spreadsheet automation and operations-reporting portfolio?
• Which common Data Analyst jobs would you reject for this candidate, and why?
• How do you tailor a résumé differently for MIS, reporting and spreadsheet-automation roles?
• Share an anonymized data/reporting résumé and application tracker.
• Will you personally perform the applications, and how do you verify remote-location eligibility?

Senior AI/ML Engineer | Agentic AI, RAG, FastAPI, LLM Applications
About the Role
We are looking for an experienced AI/ML Engineer to join our team and help build production-ready AI applications, intelligent AI agents, and scalable machine learning solutions.
The ideal candidate has hands-on experience with LLMs, AI agents, prompt engineering, RAG pipelines, API development, and deploying AI systems into production environments.
Project Scope
You will be responsible for:

Building AI-powered applications using Python
Developing intelligent AI agents with reasoning, memory, and tool-calling capabilities
Designing and optimizing prompt engineering workflows
Implementing RAG (Retrieval-Augmented Generation) systems
Building FastAPI-based AI services and REST APIs
Integrating OpenAI, Claude, Gemini, or other LLM providers
Developing function-calling and workflow automation pipelines
Integrating third-party APIs, enterprise platforms, and business tools
Improving AI reliability, evaluation, and performance
Deploying and maintaining production AI systems
Required Skills

Python
FastAPI
REST APIs
Prompt Engineering
AI Agents
RAG
Function Calling / Tool Use
OpenAI, Anthropic Claude, Gemini, Llama, or Mistral
PostgreSQL / SQL Databases
Docker
Git
Nice to Have

LangChain
LangGraph
LlamaIndex
MCP (Model Context Protocol)
Pinecone, Weaviate, Chroma, or pgvector
Multi-Agent Systems
Promptfoo, DeepEval, LangSmith
Kubernetes
MLOps
What We're Looking For

3+ years of software engineering experience
Experience deploying AI products into production
Strong understanding of LLM architectures and AI workflows
Ability to design scalable, maintainable systems
Excellent communication and problem-solving skills
When Applying
Please include:

Examples of AI agents or RAG systems you've built
LLMs, frameworks, and vector databases you've worked with
Experience with production deployments
Your availability and hourly rate
This is a long-term opportunity for someone passionate about building real-world AI products and intelligent automation systems.

# Senior API Integration & Automation Engineer for Housecall Pro Business Intelligence System

## About Us

We are a growing plumbing company based in Hawaii that is investing heavily in systems, automation, and business intelligence.

Our objective is not simply to automate repetitive tasks. We are building the foundation of a data-driven operating system that will allow us to better understand our business, accurately measure profitability, improve decision-making, and scale efficiently.

This project is the first phase of a long-term initiative. We are looking for someone who can become a trusted technical partner as we continue expanding the platform.

## Project Overview

Our company currently operates on Housecall Pro for scheduling, dispatching, estimating, invoicing, customer management, and technician operations.

We also maintain detailed financial and operational calculations in Microsoft Excel.

The goal of this project is to design and build a centralized business intelligence and job-costing system that automatically collects operational data from Housecall Pro, combines it with our internal costing models, and produces accurate job costing and profitability information.

Although we have initially considered using Housecall Pro, Make.com, Airtable, and Excel, we are intentionally looking for an experienced engineer who can evaluate the overall architecture and recommend improvements where appropriate.

We are not hiring someone to simply build what we specify. We are looking for someone who can help us determine the best technical solution.

## Existing Resources

We already have:

Housecall Pro

A detailed Excel workbook containing our labor burden calculations, overhead allocation, hourly cost formulas, and profitability calculations

An internal systems administrator who understands Housecall Pro and can explain our workflows and business processes

Clearly defined operational procedures

This means you will not be starting from scratch.

## Objectives

Design a scalable architecture for our business intelligence platform

Automatically synchronize operational data from Housecall Pro

Maintain historical snapshots for job costing

Calculate actual labor cost using our existing formulas

Allocate company overhead accurately

Calculate gross profit and net profit

Provide meaningful reporting and dashboards

Design the platform so future automation and reporting can be added without rebuilding the system

## We Are Looking For Someone Who Can

Study our business workflow

Understand our existing Excel calculations

Recommend the best technical architecture

Design a proper relational database

Integrate Housecall Pro using APIs

Build reliable automation workflows

Prevent duplicate or corrupted data

Document the system

Design with scalability in mind

Think like a systems architect rather than simply an API developer

## Technical Experience

Ideal candidates will have experience with several of the following:

Housecall Pro API

REST APIs

API integrations

Webhooks

Business process automation

Database design

SQL

PostgreSQL

MySQL

Make.com

n8n

Airtable

JavaScript

Python

Microsoft Excel

Google Sheets

Business intelligence

Reporting systems

Data modeling

If your preferred technology stack differs from ours, we encourage you to explain why.

## Important

We are completely open to alternative technical solutions.

If you believe another architecture would produce a better long-term result, we want to hear your recommendation.

For example, you may recommend:

Housecall Pro + PostgreSQL

Housecall Pro + Make.com + PostgreSQL

Housecall Pro + n8n

Housecall Pro + Azure

Housecall Pro + AWS

or another architecture that you believe is more appropriate.

Your reasoning is more important than using any particular software.

## Discovery Phase

The project will begin with a paid discovery phase.

During this phase we expect you to:

Review our business

Review our Excel workbook

Review our Housecall Pro workflow

Recommend the best architecture

Estimate implementation effort

Produce a development roadmap

Only after both parties agree on the proposed architecture will we begin implementation.

## Communication

Good communication is extremely important.

We expect regular updates.

We appreciate developers who explain technical decisions in plain English.

You will have direct access to our internal systems administrator for technical questions regarding Housecall Pro.

## Long-Term Opportunity

This is not intended to be a one-time project.

Future phases may include:

Inventory management

Warehouse automation

Technician dashboards

Management dashboards

KPI reporting

AI integration

Accounting integration

Purchasing automation

Scheduling automation

Customer analytics

Custom internal applications

We hope to establish a long-term relationship with the right engineer.

## To Apply

Please answer the following questions:

Describe the largest API integration project you have personally designed.

Have you built systems that preserve historical data rather than simply synchronizing current information?

How would you approach building an accurate job-costing system for a service company?

What database would you recommend for this project, and why?

If you would not use Airtable or Make.com, what would you recommend instead?

Have you worked with Housecall Pro or another field service management platform?

How do you prevent duplicate records and synchronization errors?

Do you personally perform all of the work, or do you subcontract any portion of your projects?

Provide examples of systems you have designed that continue to scale successfully today.

What questions would you ask us before recommending an architecture?

## Final Note

We are looking for a systems thinker who enjoys solving business problems through technology.

If your approach is to understand the business first, recommend the right architecture second, and write excellent software third, we would love to hear from you.

Budget $5000
Delivery time: 3 months (likely extension).

I am after a part-time freelancer who is a real Power BI Expert with at least 10 years experience in BI.

This is a part-time position for 3 months and likely to go for much longer and potentially full time after 3 months.

I only want real experts who know what they are doing and can complex very complex tasks on their own, to high quality and very quickly.

You must be responsive and reliable.

• How many years of Experience do you have with Power BI on a full-time basis?
• How many years of Experience do you have in BI a full-time basis?
• Do you have part-time availability of at least 20h a week for 3 months?
• How likely is that you will be available full-time after 3 months?
• Are you prepared to take lengthy interview process? It will start with basics, and if you pass, gradually increase until we reach your limits.

About the Role

We are seeking a highly motivated Business Systems Analyst to support business process improvement, ERP implementation, system enhancements, and digital transformation initiatives across our organization.

This role bridges business operations and technology. You will work closely with business users, project managers, developers, and leadership to analyze requirements, improve processes, support software implementations, perform testing, and help maintain enterprise systems.

The ideal candidate is analytical, technically curious, detail-oriented, and enjoys solving business problems.
Responsibilities
Business Analysis
Gather and document business requirements.
Analyze business processes and identify improvement opportunities.
Prepare functional specifications and process documentation.
Create workflow diagrams and user stories.
Facilitate meetings with business stakeholders.
Systems Support
Support ERP and business application implementations.
Assist with system configuration and maintenance.
Troubleshoot functional system issues.
Support end users during implementations and production.
Coordinate with developers and third-party vendors.
Quality Assurance
Develop test plans and test cases.
Execute functional, integration, and regression testing.
Document software defects.
Validate enhancements before deployment.
Coordinate User Acceptance Testing (UAT).
Data & Reporting
Perform data analysis and validation.
Support data migration and imports.
Create reports and dashboards.
Validate data integrity across systems.
Project Support
Track project tasks and deliverables.
Maintain project documentation.
Assist with implementation planning.
Monitor open issues and coordinate resolution.
Technical Support
Perform basic system configuration.
Assist with API and integration testing.
Support simple automation initiatives.
Create basic SQL queries or scripts when needed.
Assist developers with technical testing.

• Describe your recent experience with similar projects
• Please list any certifications related to this project
• Describe common challenges of maintaining SLAs
• How do you create a dependency map for systems operating in multi-tier architecture?
• How do you operationalize your projects?

I've applied several times for access to the Google local business management API but keep receiving the same vague 'did not pass internal quality checks' response, with no concrete explanation.
I'm looking for an experienced consultant who can help us understand what’s blocking approval and what needs to change for our next submission to be successful.
Your work will include reviewing our original access application and use-case description, and auditing our Google Cloud project and OAuth setup, as we suspect there may be a configuration problem at the project or organization level.
I also need you to interpret the repeated “internal quality checks” messages, confirm whether they are connected to account history or active-profile requirements, and identify any other likely policy or quality issues.
Based on your findings, we’d like a clear, practical re-application strategy and hands-on help refining our next request so it aligns with Google’s expectations.
You should have direct experience successfully guiding clients through this specific API access approval process, plus solid knowledge of the related review/posts functionality and Google Cloud/OAuth 2.0 setup.
Collaboration will be done primarily via Slack, so in your proposal please share your relevant approval experience and your view on what 'internal quality checks' typically signal, and how you would validate that in our situation.

I need someone to mentor me set up a Snowflake Database within a Sample Dataset and integrate this Snowflake database with Power BI. Ideally the data set needs to be commodities based, e.g. Lithium, Graphite, Manganese, Cobalt, etc. You must have commercial experience of integrating Snowflake and Power BI. Ideally you will have commercial experience of Commodities. This is a mentoring role, not a development role.

I am looking for an experienced WordPress developer to review and fix issues in the backend of my website.

At the moment, there appear to be some PHP-related problems that may be affecting the database structure, schema, or general backend stability. Before uploading a large product catalogue, I want to make sure the website is properly configured, stable, and able to handle the data without errors.

The website will have more than 700 products, so the backend needs to be optimized for smooth product management and bulk uploads.

Main responsibilities:
-Review the WordPress backend and identify any PHP errors or conflicts
-Check the database for broken tables, schema issues, or corrupted data
-Fix plugin, theme, or custom code conflicts
-Make sure WooCommerce is properly configured
-Review the product database structure and product attributes
-Ensure the website can handle bulk product imports
-Improve backend speed and stability
-Check PHP version, memory limits, execution time, and server settings
-Set up proper backups before making any changes
-Test the website after the fixes
-Make sure the admin dashboard works smoothly without errors
-The developer should also review the current hosting environment and advise if any server-level changes are required.

Requirements:
-Strong experience with WordPress and WooCommerce
-Advanced PHP and MySQL knowledge
-Experience fixing WordPress database and schema issues
-Experience handling large WooCommerce product catalogues
-Familiarity with CSV/XML product imports
-Ability to troubleshoot plugin and theme conflicts
-Good communication and clear reporting

Please explain how you would diagnose the issue before making changes. Also share examples of similar WordPress or WooCommerce backend work you have completed.

The final goal is to have a stable, secure, and smooth WordPress backend that can reliably manage more than 700 products.

We are seeking a skilled JavaScript developer to load data from CSV files, analyze it, and perform data prediction using Python. The ideal candidate will have experience in data analysis and be able to integrate Python scripts into a JavaScript application. This is a part-time role with a project scale of small, expected to last less than a month.

• Describe your recent experience with similar projects
• What tools do you use for data mining and visualization?

We are seeking an experienced Healthcare Data Analyst / AI Developer to analyze patient data and build an insights platform that turns complex healthcare datasets into actionable intelligence.

The ideal candidate will have strong experience working with EHR, EMR, claims, or clinical data and building scalable analytics workflows.

You will clean and transform healthcare data, identify meaningful trends, create dashboards, and develop predictive models to support better operational and clinical decisions.

Strong Python, SQL, data visualization, and machine learning skills are required, along with experience handling healthcare data securely and following HIPAA best practices.

Experience with FHIR/HL7, cloud healthcare platforms, healthcare SaaS products, and LLM-based analytics solutions is a plus.

Deliverables will include data exploration reports, structured datasets, analytics dashboards, predictive models where applicable, and clear documentation of findings.

This is a long-term, part-time opportunity with a budget of $5k per month depending on experience and project scope.

• What techniques would you use to clean a data set?

We are seeking a Data Engineer to design, build, and maintain scalable data pipelines that power analytics and machine learning across the organization. In this role, you will develop and optimize ETL/ELT processes, integrate data from diverse sources, and ensure the reliability, quality, and integrity of data across our systems.

You will collaborate closely with data scientists, analysts, and software engineers to deliver clean, well-structured datasets and robust data infrastructure.

The ideal candidate has strong proficiency in SQL and Python, hands-on experience with cloud platforms and modern data tools (such as  Airflow, and databricks), and a solid understanding of data warehousing and modeling concepts.

A successful Data Engineer is detail-oriented, thrives in a fast-paced environment, and is passionate about turning raw data into trusted, actionable assets.