Freelance SQL programmer jobs, employment

We are looking for a Senior Product Analyst to complete cross-platform analytics setup for AirAdvisor (flight compensation claims service).

We have an existing foundation: GA4, GTM, and BigQuery (data warehouse) are already in place. We need someone to finish the remaining integration and validation work across 4 milestone areas.

SCOPE (Milestone-Based):

M1:
- Troubleshoot G-Ads tracking issues - URGENT (potential conversion data pollution due to cookie consent mis-config)

M2:
— G-Ads, Microsoft Ads Tracking & BigQuery Ingestion

- Set up Microsoft Ads conversion tracking (offline + enhanced)
- Ingest Microsoft Ads data into BigQuery via Fivetran or custom pipeline
- Validate conversion data accuracy across platforms

M2 — Internal Data x GA4 Integration in BigQuery
- Design join keys between internal claim data and GA4 sessions
- Build deduplication and attribution logic
- Create unified user journey views in BigQuery

M3 — Reporting & Intelligence Layer
- Build a Looker Studio dashboard OR semantic layer for LLM-based querying
- Key metrics: acquisition cost by channel, claim conversion rates, user LTV signals
- Must connect to BigQuery as single source of truth

M4 — Metrics Testing & QA
- End-to-end validation of all tracking and data pipelines
- Cross-platform reconciliation (GA4 vs BigQuery vs Microsoft Ads vs internal)
- Document data model, known limitations, and handover notes

REQUIREMENTS:
- Strong hands-on experience with GA4, GTM, BigQuery, and SQL
- Experience with ad platform conversion tracking (Google/Microsoft Ads)
- Ability to write and optimize BigQuery SQL for analytics use cases
- Understanding of attribution logic and cross-platform data joins
- This is NOT a dashboard-only role — we need deep technical analytics skills

HOW WE WORK:
- Fixed-price, milestone-based payments only (no hourly)
- Work tracked via Hubstaff for transparency
- M1: budget TBD, time: ASAP/URGENT
- M2-M5:
- Budget: $1,500 USD provisional for all 2-5 milestones (exact TBD based on proposal)
- Timeline: ~2-3 weeks

Please include in your proposal:
1. Relevant experience with similar analytics setups
2. Your approach to M1-M5 (brief, not a novel)
3. Any questions or scope clarifications needed

We are seeking an experienced PHP developer to harden and fix our existing SMM agency script running via cPanel. A full technical audit will be provided.

Scope of Work
- Enable full dynamic support for 8 themes in `app/views/` and fix admin theme switching logic (currently only 4 active)
- Fix broken CAPTCHA validation in `signup.php`
- Secure `app/hidden/bridge.php` against LFI with token-based protection
- Harden session security in `app/init.php`
- Replace raw SQL queries with PDO prepared statements in:
- `tickets.php`
- `subscriptions.php`
- `appearance.php`
- Fix logo upload issue in `admin/controller/appearance.php` (path handling + mkdir)
- Fix UI/layout inconsistencies across themes

Requirements
- Strong PHP + PDO experience
- Knowledge of web security (SQLi, LFI, session security)
- Experience working in cPanel / legacy systems
- Clean, safe, production-ready fixes

Deliverables
- Fully fixed and secured script
- Working 8-theme system in admin panel
- Brief summary of implemented fixes

Audit report provided after selection

looking for someone who is experienced in VOIP for predictive/auto dialers built on freeswitch as we are running into long wait times, high abandon rates, and some dialing issues on our dialer and would like some help if you have done this in the past.

We are seeking a Software Product Engineer with strong Quality Assurance (QA) experience to support software development projects on a part-time, project-based basis. This role will work closely with business stakeholders and developers to validate functionality, identify defects, improve product quality, and support the software development lifecycle.

The ideal candidate has experience testing web applications, reviewing requirements, executing test cases, validating integrations, and collaborating with developers on code releases and pull requests.

Responsibilities

Review business and technical requirements to ensure completeness and testability
Create and execute test plans, test cases, and test scripts
Perform functional, regression, integration, and user acceptance testing
Identify, document, and track software defects through resolution
Validate fixes and verify software quality prior to release
Test web-based applications, APIs, and system integrations
Collaborate with developers during code reviews and pull request processes
Verify software changes before deployment to production
Assist with online testing platforms and automated testing initiatives
Provide recommendations for product improvements and quality enhancements
Maintain QA documentation and testing records

Qualifications

3+ years of experience in Software QA, Product Engineering, or Software Testing
Experience testing web applications and cloud-based software platforms
Familiarity with Git, GitHub, GitLab, or similar version control systems
Experience reviewing and validating pull requests (PRs)
Understanding of software development lifecycle (SDLC) and Agile methodologies
Strong analytical and problem-solving skills
Excellent communication and documentation abilities
Experience with automated testing tools is a plus

Preferred Skills

API testing experience (Postman or similar tools)
Experience working with CI/CD pipelines
Knowledge of SQL and database validation
Familiarity with Jira, Azure DevOps, or similar project management tools
Experience supporting business software and enterprise applications

Engagement Details

Part-time, project-based engagement
Remote work
Flexible schedule
Opportunity for ongoing projects based on performance
Hourly or fixed-price proposals accepted

When applying, please provide:

Relevant QA/Product Engineering experience
Examples of software projects you have tested
Experience with pull requests and code review processes
Availability and hourly rate
Resume and Upwork profile

We are developing a customer profile analysis solution, and to perform the necessary analyses, we need to identify and understand what customer and sales information is recorded in the NBS system, as well as the data storage structure.

- What we are looking for
We are looking for a professional with practical experience in the NBS system, who can assist us in understanding the data structure used by the platform (Database, Tables and Queries).
The ultimate goal of this work is: together, to have built the necessary queries to be applied to the real databases of our clients (dealerships), and to understand the modeling of the information so that we can maintain it in the future.

- Scope of Work
The professional should assist with the following items:
• Presentation of the NBS database structure;
• Provision of a data dictionary or relational model;
• Identification of tables related to:
o Customer registration (Individuals and Legal Entities);
o Buyers and owners;
oCommercial proposals;
o Vehicle sales;
o Billing;
o Payment methods;
o Vehicles traded;
• Financial data associated with the operation;
• Assistance in building SQL queries to extract this information;

- Desirable:
• Provision of technical documentation;
• Provision of a study environment, anonymized database, or mockup representing the system structure.

- Important

We are not interested in:
• Real customer data;
• Production databases;
• Confidential information or information protected by confidentiality agreements;
• Any material that violates security policies, LGPD (Brazilian General Data Protection Law), or commercial agreements.

Our interest lies exclusively in understanding the data structure and the relationships between the system's entities.

- Desired Profile
• Proven experience as an NBS analyst or developer;
• Knowledge of the system's database structure;
• Knowledge of SQL;

- Expected Deliverables
This is a quick project, which we plan to complete collaboratively in one to two days, to achieve the following upon completion:
1. Mapping of the tables and relationships involved in the registration, sales, and invoicing processes (at a minimum);
2. Identification of relevant fields for customer profile analysis;
3. Examples of SQL queries for extracting the necessary information;
4. Recommendations for future system integrations.

- If you have experience with NBS, please provide:
• System versions you have worked with;
• Type of role (implementation, support, development, BI, integrations, DBA, etc.);
• Availability for technical meetings.

*** SUBMIT YOUR PROPOSAL ***

We are looking for an experienced AEO / AI Search Engine Optimization specialist to help our company show up more often in AI search results, answer engines, and LLM-driven recommendations.

We want someone who understands how to optimize for platforms like ChatGPT, Perplexity, Google AI Overviews, Claude, Gemini, and other AI search experiences.

The goal is to improve our visibility when potential customers search for topics related to B2B lead generation, outbound sales, appointment setting, cold email, and SQL generation.

Responsibilities:

Audit our current website and online presence for AI search visibility
Recommend and implement AEO / GEO strategies
Optimize website content for answer engines and AI search results
Create structured, authoritative content that AI tools are likely to cite
Improve schema markup, FAQs, comparison pages, service pages, and topical authority
Help us appear for high-intent searches related to B2B lead generation and outbound sales
Identify where competitors are showing up in AI search and how we can outrank them
Provide a clear roadmap with priorities and expected impact

Ideal Candidate:

Experience with AEO, GEO, AI SEO, or LLM search optimization
Strong understanding of traditional SEO plus AI-driven search behavior
Experience optimizing B2B service businesses
Familiarity with ChatGPT, Perplexity, Google AI Overviews, Gemini, Claude, etc.
Strong content strategy skills
Ability to explain recommendations clearly and execute quickly

Nice to Have:

Experience with B2B SaaS, lead generation, sales agencies, or marketing agencies
Experience creating comparison pages, “best of” pages, FAQ content, and topical clusters
Knowledge of schema markup and technical SEO
Experience getting brands mentioned in third-party sources, directories, and review platforms

## **Job Title**

**Senior Data Engineer (Azure / Databricks) – Long-Term Engagement**


## **Job Description**

We’re looking for a **true Data Engineer** with strong, real-world experience to support ongoing data engineering and analytics work.

This is a long-term engagement for someone who is dependable, communicative, and comfortable owning data pipelines end-to-end. The right person will be hands-on, detail-oriented, and available during core U.S. business hours.

---

## **Core Responsibilities**

* Build and maintain **production-grade data pipelines**
* Work extensively with **Azure data services**
* Develop and optimize **Databricks notebooks**
* Write clean, efficient **SQL and Python**
* Support downstream analytics and reporting use cases
* Troubleshoot data quality, performance, and reliability issues
* Communicate progress clearly and consistently

---

## **Required Experience (Must-Haves)**

* Proven experience as a **Data Engineer** (not entry-level)
* Strong hands-on experience with:

* **Azure**
* **Databricks**
* **Python**
* **SQL**
* Experience working with cloud data platforms in real environments
* Ability to work independently with minimal supervision

---

## **Availability & Communication**

* **Required availability:** **8:00 AM – 3:00 PM Chicago (CST) time**
* High degree of responsiveness during working hours
* Clear written and verbal communication
* Comfortable with regular check-ins and status updates

---

## **Engagement Details**

* Long-term engagement (not a one-off project)
* Consistent workload
* Opportunity for expanded responsibility over time
* Close collaboration with technical leadership

---

## **What We Value**

* **Trust and reliability**
* Ownership mentality
* Professionalism
* Strong communication
* Long-term mindset

There is meaningful **growth potential within a private business** for someone who consistently delivers and earns trust.

Please include:

1. A brief overview of your data engineering experience
2. Your experience specifically with **Azure and Databricks**
3. Confirmation of availability between **8am–3pm CST**
4. Why you’re looking for a **long-term engagement**

OVERVIEW

I'm looking for an experienced Next.js / full-stack developer to deploy a completed web application called SignalBoard — a stakeholder engagement platform that helps organizations manage public consultations, track community feedback, and generate engagement reports.

The codebase is fully written and on GitHub. This is not a greenfield project. Your primary role is to configure the infrastructure, deploy the application, verify everything works end to end, and be available for ongoing maintenance and feature additions.

WHAT'S BUILT

SignalBoard is a production-ready Next.js 14 application with the following features:

- Dashboard: project and interaction management with role-based access
- Multi-organization support: team invitations, org switching, member management
- Interaction logging: manual entry, CSV/XLSX bulk upload, and email inbound (SendGrid)
- AI classification: automatic categorization and sentiment analysis via Claude AI
- Public submission forms: embeddable iframe widget for stakeholder-facing pages
- Review queue: triage and action item management
- Geographic map view: Leaflet-based map with Nominatim geocoding
- AI response drafting: Claude-powered draft replies to stakeholders
- Report generation: automated engagement summary reports
- Email notifications: transactional emails via SendGrid

TECH STACK

Framework: Next.js 14 (App Router, TypeScript)
Database: Supabase (PostgreSQL + Row Level Security + Auth)
Styling: Tailwind CSS
Background jobs: Inngest
Email: SendGrid (outbound notifications + inbound parse webhook)
AI: Anthropic Claude API
Hosting: Vercel (recommended)

WHAT THE JOB INVOLVES

Phase 1 - Deployment (primary scope):
- Clone from private GitHub repo (access provided)
- Create and configure Supabase project (run 11 SQL migrations, configure auth)
- Set up Vercel deployment with all required environment variables
- Configure SendGrid (transactional email + inbound parse webhook + subdomain MX record)
- Configure Inngest for background job processing
- Configure Anthropic API key
- End-to-end smoke test across all features
- Document anything that needed adjustment

Phase 2 - Ongoing (as needed):
- Bug fixes and minor feature additions
- Performance or security improvements
- Assistance deploying updates as the product evolves

REQUIREMENTS

- Strong experience with Next.js (App Router preferred) and TypeScript
- Experience with Supabase (auth, RLS policies, migrations)
- Comfortable configuring Vercel deployments and environment variables
- Familiarity with SendGrid or similar transactional email providers
- Able to read and understand an existing codebase without hand-holding
- Good written English for async communication

Nice to have:
- Experience with Inngest or similar background job tools
- Experience with the Anthropic or OpenAI APIs

WHAT I'LL PROVIDE

- Access to the private GitHub repository (110 files, fully documented)
- A detailed developer brief covering architecture, data models, API endpoints, environment variables, and deployment steps
- Prompt responses to questions

ENGAGEMENT DETAILS

Type: Contract / freelance
Phase 1 estimate: 8-16 hours depending on experience
Phase 2: Hourly, retained as needed
Communication: Async preferred, video call available if needed

HOW TO APPLY

Please include in your proposal:
1. A brief summary of your relevant experience (Next.js, Supabase, Vercel)
2. An example of a project you deployed or maintained (link if possible)
3. Your estimated hours and rate for Phase 1
4. Confirmation that you're comfortable working from an existing codebase with documentation rather than building from scratch

Looking forward to working with someone detail-oriented who can hit the ground running.

We are developing a customer profile analysis solution, and to perform the necessary analyses, we need to identify and understand what customer and sales information is recorded in the NBS system, as well as the data storage structure.

- What we are looking for
We are looking for a professional with practical experience in the NBS system who can assist us in understanding the data structure used by the platform (Database, Tables, and Queries).

The ultimate goal of this work is: together, to have built the necessary queries to be applied to the real databases of our clients (dealerships), and to understand the information modeling so that we can maintain it in the future.

- Scope of Work
The professional should assist with the following items:

• Presentation of the NBS database structure;
• Provision of a data dictionary or relational model;
• Identification of tables related to:
o Customer registration (Individuals and Legal Entities);
o Buyers and owners;
o Commercial proposals;
o Vehicle sales;
• Billing;
• Payment methods;
• Vehicles traded;
• Financial data associated with the operation;
• Assistance in building SQL queries to extract this information;

- Desirable:
• Provision of technical documentation;
• Provision of a study environment, anonymized database, or mockup representing the system structure.

- Important
We are not interested in:

• Real customer data;
• Production databases;
• Confidential information or information protected by confidentiality agreements;
• Any material that violates security policies, LGPD (Brazilian General Data Protection Law), or commercial agreements.

Our interest lies exclusively in understanding the data structure and the relationships between the system's entities.

- Desired Profile
• Proven experience as an NBS analyst or developer;
• Knowledge of the system's database structure;
• Knowledge of SQL;

- Expected Deliverables
This is a quick project, which we plan to complete collaboratively in one to two days, to achieve the following upon completion:
1. Mapping of the tables and relationships involved in the registration, sales, and invoicing processes (at a minimum);
2. Identification of relevant fields for customer profile analysis;
3. Examples of SQL queries for extracting the necessary information;
4. Recommendations for future system integrations.

If you have experience with NBS, please provide:
• System versions you have worked with;
• Type of role (implementation, support, development, BI, integrations, DBA, etc.);
• Availability for technical meetings.

*** SUBMIT YOUR PROPOSAL ***

JD Full-Stack AI Engineer (Next.js / Supabase) — Internal Tools
We're looking for a senior full-stack engineer to build and maintain internal tools, working closely with AI coding agents (Claude Code) as part of your daily workflow. This isn't "AI-assisted coding" as a buzzword — it's how we ship. You'll scope prompts, steer the agent across our codebases, and verify everything before it touches production data.
Must-haves

Fluent with AI coding agents, Claude Code specifically. You know the discipline: scope a prompt well, steer across a large codebase, verify before merging. Too slow if you hand-write everything; too risky if you let the agent merge unverified. We need someone who does neither.
Senior full-stack TypeScript — comfortable owning a feature end-to-end, from database to UI.
Next.js (App Router) — our codebases run a version with non-standard conventions. You read the docs before writing rather than assuming the framework behaves like your last project.
React + Tailwind + shadcn/ui — we build in the native Tailwind/shadcn idiom, no bespoke CSS. You can turn a rough mockup into clean, consistent components.
Postgres/SQL fluency — not just "I've used an ORM." You write and reason about real queries, design schema, write migrations. Many of our hardest problems are data problems.
Supabase, or strong Postgres fundamentals with willingness to ramp fast.
Ships clean PRs — small, reviewable, with reasoning written down. Comfortable working in isolated branches/worktrees since multiple things touch these repos in parallel.

Nice-to-haves

Vercel deployment experience.
Domain exposure to revenue/sales ops, HR/people, finance, or email/comms tooling.
Experience as the sole engineer on an internal tool with real users.
Built data importers, ETL, or reconciliation pipelines.
Comfort with the broader AI tooling stack (MCP connectors to databases, deployment, Slack, project trackers, etc.).

To apply
Please include:

A short note on a project where you used Claude Code (or similar AI coding agent) on a real codebase — what you scoped to the agent vs. did yourself, and how you verified the output before merging.
A link to a Next.js/Postgres project you've shipped (GitHub or live link).
Your availability and hourly rate.

We are seeking an experienced Senior Database Administrator with deep expertise in SQL Server Performance and Data Engineering. The ideal candidate will have a strong background in database management and administration, with a focus on optimizing SQL Server performance. Responsibilities include managing database systems, ensuring data integrity, and collaborating with cross-functional teams to implement data solutions. The role requires a proactive approach to identifying and resolving database issues, as well as contributing to the development of best practices in data engineering.

We are a boutique consulting firm specializing in financial planning and analysis (FP&A) built inside the Microsoft stack: Power BI, Microsoft Fabric, and Aimplan. We are looking for a skilled Power BI developer who also understands finance and is ready to become an expert in Aimplan, a FP&A platform that runs inside Power BI (www.aimplan.com).

This starts as project-based work, but we have a steady pipeline and are looking for someone who can become a reliable, recurring part of our delivery team over time.

A core part of this role is Aimplan. Aimplan extends Power BI into a full planning, budgeting, forecasting, and reporting tool, and it is central to how we deliver for clients. You do not need prior Aimplan experience to start, but you do need to commit to learning it quickly and building production applications in it. We will provide training and support, and we expect you to ramp into being genuinely strong with the platform. If you are not excited to go deep on a specialized tool, this is not the right role.

You will also work across multiple client accounts, not a single customer. Each engagement has its own data, its own model, and its own business questions, so you will need to learn new contexts quickly and produce clean, professional work.

What you will do:
- Build, develop, and maintain planning and forecasting applications in Aimplan across multiple client projects
Design, build, and maintain Power BI dashboards and reports for FP&A use cases (budgeting, forecasting, variance analysis, management reporting)
- Build and maintain data models using DAX, Power Query, and Power Pivot, including row-level security, drill-through, and slicers
- Drive adoption by building with user-centered design, so each app delivers a real improvement to the client's planning process
- Translate finance and business requirements into working solutions and communicate results clearly

Must-haves:
+ Strong, demonstrable Power BI development skills (please share a portfolio or sample work)
+ Solid command of DAX and Power Query
+ A genuine commitment to learning Aimplan and building production work in it. This is a requirement of the role
+ Real financial literacy. You should be comfortable working with income statements, balance sheets, and cash flow, and understand concepts like variance to budget and forecast. This is not optional. A lot of this work is financial reporting, so you need to understand what the numbers mean

Clear written English and the ability to work independently against a brief

Nice-to-have:
+ Prior experience with Aimplan or another planning / CPM tool (Anaplan, Vena, Planful, or similar)
+ Experience with Microsoft Fabric or Azure SQL
+ Prior FP&A, accounting, or finance work experience

How we work:

We are remote and run a tight, professional operation. We value initiative, accuracy, and people who flag problems early rather than hand over work that quietly does not tie out. Good work here leads to more work.

To apply, please include:

A short note on your Power BI experience and a link to sample dashboards or a portfolio

One sentence explaining the difference between a forecast and a budget, so we know you read this post and understand finance

A sentence on how you feel about learning a specialized new tool like Aimplan, since it is central to this role

Your availability and typical weekly capacity

• Aimplan is a specialized FP&A tool that runs inside Power BI and is central to this role. How do you feel about learning it and building production applications in it, and have you learned a niche tool like this before?
• How comfortable are you reading financial statements? Briefly describe a time you worked with an income statement, balance sheet, or variance analysis.
• Have you used Microsoft Fabric or Azure SQL? If so, describe how.

I run a small portfolio of digital products and internal business operations. As we've grown, we've accumulated a steady backlog of automation and integration work, data pipelines, scheduled jobs, API connections between our tools, reporting scripts, and lightweight internal dashboards.

I'm looking for one reliable Python engineer to work with me on an ongoing basis. Not a one-off hire, someone who gets familiar with our systems and becomes a long-term execution partner. I define the scope and write the specs; you implement, deploy, and keep things running.

What the work looks like:


Building and maintaining ETL pipelines that pull data from external sources, transform it, and route it to the right destination (databases, reports, downstream APIs)
Event-driven and scheduled automation, webhook triggers, cron jobs, polling loops, email-based triggers
Connecting our SaaS tools to each other via their APIs (CRM, communication tools, document workflows, cloud storage)
Data cleanup, reconciliation, and reporting scripts using Python and SQL
Small internal services and admin dashboards
Monitoring and maintaining what gets built, this isn't ship-and-forget work


Stack we work in:


Languages: Python (primary), JavaScript / Node.js where needed
Data: PostgreSQL, MS SQL Server, pandas, CSV/Excel processing
Automation & orchestration: n8n for simpler glue work, Python services for complex logic
Cloud & hosting: AWS (Lambda, API Gateway, S3), Azure, DigitalOcean, depending on the project
APIs & auth: REST, OAuth2, webhooks, third-party SaaS integrations
DevOps basics: Docker, environment-based secrets management, CI/CD pipelines


What I need from you:


Strong integration instincts you know how OAuth2 flows work, you handle errors and retries properly, you think about failure modes upfront
Clean, production-ready code secrets in env vars, structured logging, failure alerts. Code that runs reliably at 3am without babysitting
Careful with sensitive data some workflows touch business and personal records. You understand what that means: no unnecessary third-party surfaces, proper credential scoping
Clear communicator I write detailed specs. You read them, ask the right clarifying questions, then build. No disappearing mid-project
Reliable availability this is a retainer-style arrangement. Consistency matters more than raw speed


Nice to have:


Experience with n8n, Make, or Zapier — knowing when to use low-code vs. custom code is a skill
Apache Airflow or similar orchestration experience for more complex pipeline work
Familiarity with Django or Django REST Framework for any internal tool work
Experience handling PII or financial data responsibly


How we'll start:

The first engagement will be a well-scoped, paid project a real task from our actual backlog with a clear spec. How you handle the implementation, deployment, and any sensitive-data considerations will tell me whether this is a good long-term fit.

If it goes well, this becomes a standing monthly arrangement with a continuous stream of work.

I'm looking for an experienced developer to build a custom bot that can automate tasks within a website. The solution should be reliable, efficient, and scalable. If you have experience with web automation and bot development, I'd love to connect and discuss the project. Feel free to reach out or send me your portfolio.

Seeking a Quantitative Trading Systems Lead to develop an AI-assisted crypto trading bot. Responsibilities include designing trading strategies, integrating AI models, and optimizing performance. The role requires expertise in quantitative finance, data analysis, and trading systems. The candidate will lead a team to build a scalable and reliable trading platform.

Project:
I am building a crypto trading research and bot system with AI coding agents. The system studies wallet behavior, trading patterns, raw fills, PnL, timing, and signal candidates across BTC, ETH, SOL, and HYPE.

Football prediction system which relates to the current system we would be building. Required to use prior data and find edges in market inefficiency and on odds.

The goal is not generic indicators. The goal is wallet intelligence:
- find profitable wallet behavior
- map repeatable trade patterns
- separate real signal from noise
- avoid lookahead bias
- avoid pooled/clustering mistakes
- turn validated patterns into bot trigger logic

I need someone experienced enough to help drive this project to completion with AI tools, not just follow small tasks.

Required skills:
- Python
- pandas / CSV / JSON / SQL
- backtesting or replay logic
- trading PnL, fees, win rate, drawdown, sample size
- crypto market structure basics
- pattern recognition from time-series / event data
- bot/signal system thinking
- ability to review AI-generated code and reports critically

Strong bonus:
- quant trading experience
- Hyperliquid or crypto perp experience
- wallet/on-chain/off-chain trading data experience
- event-driven bot systems
- no-lookahead backtest design
- data pipeline debugging

Main work:
- review AI-generated research and code
- identify bad assumptions
- verify counts and results from files/data
- help design clean pattern-mining methods
- help convert valid patterns into bot signal specs
- keep system modular: each wallet/pattern stands on its own
- write clear task briefs for AI agents
- review output before anything becomes trusted

I need a Universal ZRA Smart Invoice Connector.

The concept is to create a middleware platform called AfriTax Connect that sits between ERP/Accounting Systems and the ZRA Smart Invoice platform. ZRA integration is achieved through the Smart Invoice API and VSDC (Virtual Sales Data Controller) framework used for ERP integrations.

Please see attached requirements for your attention

We've been growing this year and are now urgently looking to hire a Business Intelligence and Data Consultant for one of our new manufacturing clients.

Candidate must be:
- Strong in Power BI, SQL, and Python (optional).
- Have worked with inventory or manufacturing reporting
- Can show they have personally owned work from requirements through to dashboard delivery and handover.

Contract type: Independent fixed-term contractor
Duration: 3-months (with possible extension)
Location: Remote
Eligible Hiring Markets: Nigeria, Philippines, India, Pakistan or Kenya
Start: Immediately
Working Hours timezone: UTC+01:00

Please submit a proposal or message if interested, thank you!

We are seeking a Finance Analyst with strong automation skills to support planning, reporting, analysis, and process optimization.

Key Responsibilities

Quotes and maintenance related to quotes.
Automation projects (creating and maintaining tools for Invoicing, Sales Tax, Shipping Allocation, and similar).
Ad hoc analysis

Automation & Process Improvement

Automate different processes and reports.
Develop and maintain automated workflows:

Excel VBA
Power Query
Power BI
SQL
Python
Microsoft Power Automate
Google Apps Script

- Streamline data collection, reconciliation, and reporting processes.
- Reduce manual effort and improve data accuracy through automation initiatives.

Data Management & Business Intelligence

Extract, clean, and transform large datasets.
Build interactive dashboards and self-service reporting tools.
Ensure data integrity and consistency across financial systems.
Collaborate with stakeholders to define reporting requirements.

Cross-Functional Collaboration

Partner with Finance, Operations, Sales, and Leadership teams.
Translate business requirements into analytical and automation solutions.

Qualifications

Required

Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or related field.
3+ years of experience in financial analysis, FP&A, or business finance.
Advanced Excel skills including formulas, pivot tables, and data modeling.
Strong analytical and problem-solving skills.

Ideal Candidate: A finance professional who understands financial reporting and analysis while also possessing the technical skills to automate processes, build dashboards, and leverage data to improve business efficiency and decision-making.

Project Overview

We are a growing healthcare and retail business operating multiple locations across the UK. We are looking for an experienced AI-focused reporting specialist to help us transform raw operational data into meaningful daily, weekly, and monthly management reports.

The ideal candidate will have experience working with business intelligence tools, AI-powered analytics, dashboards, and operational reporting systems.

What We Need

We currently use:

* Practice Management System (PMS)
* HR Time & Attendance / Clocking-In System
* Sales and Financial Reports
* Google Sheets and Excel

We need someone who can:

* Connect and analyse data from multiple systems
* Build automated reports and dashboards
* Use AI tools to identify trends, anomalies, and opportunities
* Produce meaningful management reports rather than simply exporting data
* Create KPI scorecards for managers and senior leadership
* Highlight performance issues and recommend actions
* Reduce manual reporting through automation

Examples of Reports Required

Daily:

* Sales performance by location
* Staff attendance and lateness
* Appointments booked vs attended
* Outstanding tasks and operational issues

Weekly:

* Branch performance comparison
* Staff productivity analysis
* Revenue and profitability trends
* Compliance and operational KPI reporting

Monthly:

* Executive management reports
* Trend analysis
* Forecasting and predictive insights
* Performance league tables
* Recommendations for improvement

Skills Required

* Strong experience with AI tools and automation
* Power BI, Looker Studio, Tableau, or similar
* Advanced Excel and Google Sheets
* Data analysis and business intelligence
* Dashboard creation
* Process automation
* KPI development
* Experience integrating data from multiple systems

Bonus Skills

* Experience within healthcare, optical, pharmacy, retail, or multi-site businesses
* SQL knowledge
* API integrations
* Experience with HR systems and workforce analytics
* Experience building AI-powered reporting workflows

Deliverables

Phase 1:

* Review our current systems
* Understand available data sources
* Recommend reporting structure

Phase 2:

* Build automated dashboards and reports

Phase 3:

* Provide ongoing optimisation and reporting support

When Applying Please Include

1. Examples of dashboards or reports you have built
2. AI tools you regularly use
3. Business intelligence platforms you have worked with
4. Experience integrating multiple systems
5. Your proposed approach to this project

We are looking for someone who can turn data into actionable business intelligence and provide meaningful insights that help management make better decisions.

We're looking for a Senior .NET/C# Developer to join our remote team and help build reliable, scalable software. You should have solid experience with C#, .NET, ASP.NET Core, SQL Server, REST APIs, and Azure, and enjoy solving complex problems while working with a collaborative team. If you take pride in writing clean code and delivering high-quality solutions, we'd love to work with you.

We are seeking an experienced HubSpot specialist to manage and optimize our marketing automation processes. This role supports a B2B SaaS company in the fashion/retail technology space, focused on building scalable lead generation and nurture workflows.

Responsibilities:
Build, manage, and optimize marketing automation workflows in HubSpot (lead nurturing, scoring, MQL routing)
Set up and maintain email marketing campaigns and sequences
Configure and manage lead scoring models and MQL/SQL handoff processes
Create and manage landing pages, forms, and CTAs within HubSpot
Segment contact lists and manage list hygiene/data quality
Set up reporting dashboards to track campaign performance and funnel metrics
Integrate HubSpot with other tools (LinkedIn Ads, Google Ads, etc.)
Collaborate with our marketing team on campaign strategy execution
Troubleshoot and optimize existing automation workflows

(Part-Time Remote Contractor – Europe Timezone Preferred)
About the Role
We’re a small, established company (4 FTEs) running a specialized CRM platform with ongoing development, infrastructure, and contractor-supported work. We’re looking for a technically strong, hands-on IT Technical Project Lead to help coordinate and drive projects without the overhead of a traditional project manager role.
This is a part-time remote contractor position. The person will report directly to the owner but will work with various team members and external contractors depending on the project. Some projects will require the lead to take ownership so the owner can stay hands-off.
Key Responsibilities

Gather requirements/specs from stakeholders and clearly communicate them to contractors
Ensure contractors have the information, access, and resources they need to work effectively
Actively monitor progress, check in regularly, and step in to help when issues arise so projects keep moving
Establish and enforce proper version control practices across projects
Assist with testing and quality checks before code moves forward
Support promotions/releases to production environments
Make sure all source code and related assets are properly stored and backed up

Requirements

Strong technical background (comfortable reading and discussing code, databases, and infrastructure concepts)
Experience coordinating or leading technical work with contractors or distributed teams
Practical understanding of version control (Git or similar) and source code management
Good communication skills — able to translate technical details for contractors and business needs back to the team
Self-directed and reliable in a remote, part-time setup
Comfortable working across European time zones to align with existing contractors

Nice to Have

Familiarity with SQL Server / T-SQL
Experience with Classic ASP or older web technologies
Background in small company or startup environments where wearing multiple hats is normal
Previous experience setting up lightweight processes (version control, release procedures, etc.) in small teams

Position Details

Part-time remote contractor role (hours flexible but consistent)
Europe timezone strongly preferred for overlap with other contractors
Reports to the owner
Some projects will involve working directly with other staff; on others the lead will have more autonomy
Competitive contractor rate based on experience

We are looking for a hands-on AI Automation Architect / AI Systems Builder to help us design and build an internal AI-enabled operating layer for a growing creative, production and marketing services group.

This is not a generic chatbot project. It is not a prompt-engineering project. We are looking for someone who can connect business systems, structure company knowledge, build practical AI workflows, and create a working management-control prototype using tools such as Claude, MCP, n8n, Google Workspace, Slack, Microsoft 365 and custom API integrations.

Our objective is to create an internal AI operating system that helps senior management interrogate the business more effectively, identify issues earlier, and reduce manual coordination across finance, legal, HR, operations, project management, client delivery and new business.

The first phase will be focused on building a controlled prototype that can help us analyse and report on:

* Live project status
* Revenue and margin risk
* Cashflow and invoicing risk
* SOWs, scope and change requests
* Client status and next actions
* Operational blockers
* Weekly management reporting
* New business intelligence and client research
* Internal knowledge retrieval across documents, spreadsheets and business files

We currently use Google Workspace, Slack and Microsoft tools. We are also exploring Claude Desktop, Claude Code, MCP connectors, n8n, API-based workflows and other agentic automation tools.

We need someone who can think architecturally but also build practically. The right person will be able to recommend the technical approach, configure workflows, connect systems, test outputs, document the setup and leave us with a usable internal operating layer.

Key responsibilities

* Review our current systems, data sources and priority workflows.
* Recommend the right architecture for an internal AI operating layer.
* Define what should be handled through Claude, MCP, n8n, custom code, APIs and manual processes.
* Build a working prototype focused initially on finance, project control and management reporting.
* Connect selected Google Workspace, Slack and Microsoft 365 data sources into controlled AI workflows.
* Create workflows that can retrieve, summarise and analyse relevant documents, spreadsheets and structured data.
* Build a weekly business-control report that highlights project, margin, cash, invoicing, scope and operational issues.
* Help structure internal company knowledge so that AI outputs are grounded in the right source materials.
* Document the system clearly so it can be maintained and extended internally.
* Recommend the roadmap for further build-out after the initial prototype.

Required experience

You must have hands-on experience building real AI automation, agentic workflow or business-system integration projects. We are not looking for someone who only writes prompts or advises on AI strategy.

Required skills include:

* Claude Desktop, Claude API and ideally Claude Code
* MCP / Model Context Protocol
* AI agents and tool-using AI workflows
* n8n workflow automation
* Google Workspace APIs: Drive, Gmail, Calendar, Docs and Sheets
* Slack API, Slack apps or Slack workflow automation
* Microsoft Graph / Microsoft 365 integrations: SharePoint, OneDrive, Outlook and Teams
* REST APIs, OAuth, webhooks and API authentication
* RAG, document retrieval or internal knowledge-base design
* Data extraction from documents, spreadsheets, PDFs and structured files
* Workflow automation and business-process design
* Strong documentation and handover discipline

Programming skills required

* Python
* TypeScript / JavaScript / Node.js
* SQL
* Google Apps Script preferred
* Comfortable with JSON, YAML, Git, command line tools and API testing

Nice-to-have experience

* Vector databases such as Pinecone, Weaviate, Chroma, Supabase or similar
* LangChain or LlamaIndex
* Docker
* Retool, Airtable, Make.com or Zapier
* Finance automation, project reporting or executive reporting
* Agency, consulting, professional services or project-based business experience
* Experience building internal AI copilots, management dashboards, reporting agents or business-control workflows

What we are not looking for

* Generic AI consultants
* Prompt engineers with no systems-building experience
* Chatbot developers focused only on website support bots
* Machine-learning researchers or model trainers
* Pure DevOps engineers
* Strategy consultants who cannot build
* Developers who cannot explain architecture clearly to non-technical business leaders

The first phase

We want to start with a paid discovery and prototype phase, likely over 4–8 weeks.

The initial project should produce:

1. A recommended architecture for the internal AI operating layer.
2. A clear data-source and workflow map.
3. A working prototype focused on finance/project control.
4. AI-assisted retrieval and analysis of selected company documents and structured files.
5. A weekly management/risk report prototype.
6. Documentation of workflows, tools, credentials, assumptions and limitations.
7. A recommended roadmap for the next phase.

The first prototype should help us answer questions such as:

* What has changed in the business this week?
* Which projects have margin risk?
* Which clients have cash or invoicing risk?
* Which SOWs or scopes may be drifting?
* Which operational blockers need senior management attention?
* What decisions or actions are required?
* Which information is missing or inconsistent?
* What should be escalated?

How to apply

Please include the following in your proposal:

1. A short summary of your relevant experience.
2. 2–3 examples of similar AI automation, agentic workflow or business-systems projects you have built.
3. Your experience with Claude, Claude Code, MCP and n8n.
4. Your experience connecting Google Workspace, Slack and Microsoft 365.
5. The programming languages and frameworks you would use for this project.
6. How you would approach the first 30 days.
7. What architecture you would recommend at a high level.
8. Any implementation challenges or failure points you would expect.
9. Whether you are more comfortable as a builder, architect or strategist.
10. Your availability and preferred working model.

We are UK-based, so strong English and at least 3–4 hours of overlap with UK working hours is required.

We are looking for a practical builder who can move quickly, think commercially, communicate clearly and create something that is genuinely useful to senior management.

Overview
We are looking for an experienced Full-Stack Developer to execute a well-defined sprint consisting of system enhancements, API webhooks, database updates, and technical documentation. The workload is strictly scoped to approximately 31 hours.

Core Tech Stack & Ecosystem

Bright Data

Metabase

Vite & PM2

SQL

Make (Integromat)

Fireberry CRM

Scope of Work

1. Frontend & Backend Enhancements

User Type Management: Execute a backend DB migration, create a new endpoint, and build a frontend column featuring a select dropdown, color-coding, and real-time saving capabilities.

Filtering System: Develop a multi-select filter for the 'Type' parameter with Apply/Cancel logic, seamlessly integrating it into the existing filter architecture.

UI/DOM Optimization: Implement targeted DOM updates for automatic status changes without triggering full page re-renders.

Conditional Logic: Implement logic to hide specific UI buttons based on active statuses.

2. Integrations & Data Processing

Contact Aggregation: Refactor the aggUserContacts function to merge data seamlessly from posts and comments, updating all usage instances across the application.

WhatsApp Webhook (via Make): Segment phone numbers into blocks, add UI 'Send' buttons, build the integration with Make, implement a strict guard against double-sending, and ensure clean JSON payloads (stripping symbols).

Fireberry Webhook: Set up an integration to transmit user data automatically upon a 'Positive response' trigger.

Database Maintenance: Update group databases, configure DB file permissions, and thoroughly test related SQL queries.

3. Troubleshooting & Documentation

Calculator App Repair: Diagnose and restore the functionality of the calculator module following a recent system failure.

Metabase Setup & Guide: Investigate user access rights, resolve current 'read-only' limitations, test the solution, and write a step-by-step internal guide with screenshots.

Architecture Documentation: Analyze the PM2 + Vite architecture of the calculator app and write clear, maintainable documentation.

We would like for you to scrape through all the employees listed under the companies below (filtering where necessary). For each employee, we wish to extract the following information.

1. Basic Details:
- Name
- Linkedin URL
- Headline

2. Experiences:

a. Current Job:
i. Company Name
ii. Job Title
iii. Start Date, End Date and Duration
iv. Location

b. All Previous Roles:
i. Company Name
ii. Job Title
iii. Start Date, End Date and Duration
iv. Location

3. Education:
a. University
i. Degree
ii. Completion Date

Companies List:
• PwC Australia
• Accenture Australia
• CBRE*
• JLL*
• Argon & Co*
• TMX Transform
• ThreeSixty Supply Chain Group
• Prological
• Proxima*
• Trace Consultants
• RP Infrastructure

*For these companies, please filter for “Australia” under location.

We are looking for an experienced AI Specialist to conduct a comprehensive Technical Audit and GEO (Generative Engine Optimization) Recommendation Audit for our ongoing projects.

The selected freelancer will be responsible for reviewing our current AI workflows, analyzing data quality, evaluating recommendation accuracy, identifying technical gaps, and providing detailed, actionable recommendations to improve overall performance and effectiveness.

Key Deliverables:

* Complete technical audit of existing AI systems and processes
* GEO recommendation audit and optimization suggestions
* Analysis of performance, accuracy, and scalability
* Identification of issues, risks, and improvement opportunities
* Detailed audit report with prioritized recommendations
* Implementation roadmap and best-practice guidance

We value clear communication, attention to detail, and a professional approach. The ideal candidate should be able to explain findings clearly and provide practical recommendations backed by data and analysis.

Project Details:

* Fixed Budget: $1,000
* Duration: With in a Week
* Project Type: One-Time Project
* Experience Level: Expert

Important:

This is an urgent project, and we are looking for someone who can start immediately and deliver high-quality work within the specified timeframe.

To confirm that you have read the entire job description, please begin your proposal with the word "Attention".

Only candidates with relevant experience in AI systems and analytics who submit detailed and professional proposals will be considered.

We're a professional trader building a private, AI-driven market research engine, and we're looking for a senior Python / machine learning engineer to act as Fractional CTO across a two-phase build.
Phase 1 (this contract): a Financial Market Signal Backtesting Dashboard — a clean measurement harness for trend, momentum, and multi-signal models with walk-forward backtesting.
Scope:
• Python project + GitHub repo
• Historical market-data ingestion (ETFs via yfinance / market-data APIs, SQL storage)
• Baseline models: 200-day trend, time-series & cross-sectional momentum, equal-weight multi-signal
• Walk-forward backtesting with look-ahead-bias controls
• Evaluation metrics: hit rate, Brier score, Sharpe, Sortino, Calmar, max drawdown, turnover, calibration
• A dashboard comparing signals and model performance
Stack: Python, pandas, NumPy, SQL, Python-based dashboard.
Phase 2 (follow-on): we extend the harness into the AI layer — an OODA / weight-of-evidence engine that scores competing market hypotheses. This involves LLM-based signal processing, an AI agent workflow over financial research and macro data, model evaluation / observability (LLMOps), and potentially fine-tuning and RAG over our research library. Strength here shapes who we keep on as Fractional CTO.
You are:
• A senior Python engineer with quantitative finance / backtesting experience
• Strong in machine learning and statistical evaluation
• Comfortable owning architecture as a Fractional CTO — evaluations, regression tests, observability, clean handover
• Bonus for Phase 2: AI agents, LLMs, LLMOps (LangChain / LangGraph, fine-tuning, RAG)

I run several businesses (consulting boutique, e-commerce brands, AI services) and I'm building a single operating system that runs across all of them — one place that aggregates every data source I have, organizes it, and puts an AI layer on top.

I've already built a working first version. Now I want to make it far more powerful, robust and polished, and I'm looking for a strong, fast, AI-native developer to build it out with me long-term.

What the OS does (and where it's going)

The core idea is aggregation. Today it already:

Pulls in all my communication and activity — email, calendar, meeting transcripts, messages — into one database
Automatically attributes and classifies it (which deal, which project, which person/company)
Builds a CRM out of it — companies, people, deals, every interaction, all linked
Surfaces everything in a web cockpit (Next.js): a radar of all projects, deal rooms, the CRM, dashboards, to-dos, files
Runs an AI/agent layer on top — triage, drafting, an approvals queue with a human in the loop
Refreshes itself on a schedule and flags what's stale or needs attention
Where I want to take it: more data sources wired in, a much stronger and cleaner cockpit, deeper automation, and AI agents that actually do work instead of just surfacing it. Also better edge case handling and learning loops.

Current projects you'd work across:

The OS / data-aggregation + CRM platform (the main one)
Internal dashboards, automation tools and MVPs

What you'd be doing:

Build out the OS — new data-source integrations, the cockpit frontend, the backend pipeline, the AI/agent layer
Take messy real-world data from many sources and turn it into something clean, linked and reliable
Turn rough product ideas into working features, fast
Improve UX, onboarding, auth, payments and integrations
Ship quickly, iterate on feedback, and bring real opinions on product direction
You are:


AI-native — you already use Claude Code / Cursor and AI tools heavily every day
Strong with React / Next.js / TypeScript
Comfortable with Python, backend APIs, databases (SQL) and data pipelines
Good with integrations and third-party APIs (auth, OAuth, webhooks, external data sources)
Product-minded — you can think through UX without waiting for pixel-perfect specs
Fast, reliable and easy to communicate with (good English — we'll jump on calls)
Bonus:

LLM / AI agent app experience (RAG, classification, agent workflows)
SaaS products end-to-end
Stripe, Supabase / Postgres
CRM, analytics or workflow software
Experience cleaning and merging messy data from multiple sources
Comp:

Hourly (tell me your rate)
Starts with a small paid test project
Strong fit → ongoing, long-term work
To apply, send:

2–3 products you've built (links)
Your GitHub profile
Strongest frontend example
Strongest backend / API or data-pipeline example
Which AI coding tools you use daily (one line)
Your rate, timezone and weekly availability

Project 1: Backend Framework for OHLC Market Data Ingestion and Storage

We need a backend developer to build a Python/PostgreSQL-based framework for collecting and storing historical OHLC market data for research purposes.

The system should be able to:

Download or import OHLC data in CSV format.
Normalise the data into a consistent schema.
Store securities, tickers, exchanges, sectors and industry classifications.
Load large CSV datasets efficiently into PostgreSQL, preferably using a parallel PostgreSQL loader / COPY-based approach.
Keep raw files and normalised files separately.
Track import jobs, errors and basic data-quality issues.
Provide initial FastAPI endpoints to query securities and historical OHLC data.

Expected stack:

Python
PostgreSQL
FastAPI
SQLAlchemy / asyncpg or similar
Docker / Docker Compose preferred

Deliverables:

Database schema.
Data ingestion scripts.
CSV normalisation process.
PostgreSQL bulk-loading process.
Basic FastAPI service.
Short setup documentation.

The goal is to create a clean backend foundation that can later be used for financial research and statistical analysis.

We are seeking an experienced Data Engineer to design and build an interactive business intelligence dashboard using *AWS QuickSight, with data feeding directly from **Amazon Athena*.

Our business focuses on upskilling and training resources. To deliver the right insights to our stakeholders, we need a dashboard that accurately reflects our specific business model and data hierarchy.

Understanding Our Data Model
You will need to construct datasets and visualizations based on the following business logic:
- Training Types: All training sessions fall into one of two categories: AI-Driven or Human-Driven.
- Products: Individual training "Sessions" are clubbed together to form purchasable/assignable "Products."
- Teams: "Users" can be grouped together to form "Teams" for cohort tracking and B2B reporting.

Scope of Work
- Data Integration:* Connect AWS QuickSight to our existing Amazon Athena data warehouse.
- Data Preparation & Modeling:* Write optimized SQL queries in Athena/QuickSight to join Users, Teams, Sessions, Products, and Training Types.
- Dashboard Development:* Build a clean, intuitive dashboard that allows business users to track key metrics (e.g., engagement by training type, product popularity, and team-level vs. individual progress).
- Implementation:* Ensure row-level security or appropriate filtering is in place, and publish the final dashboard for stakeholder use.

Required Skills
- Strong proficiency in *AWS QuickSight* (building datasets, calculated fields, and interactive visuals).
- Expertise in *Amazon Athena* and writing complex, highly optimized SQL queries.
- Experience in data modeling for EdTech, SaaS, or training platforms is a major plus.
- Strong communication skills to ensure technical outputs align with product requirements.

Deliverables
- A fully functional, deployed QuickSight dashboard accurately reflecting the data model described above, along with a brief handover document explaining the data relations.

To Apply
- Please submit your fixed-price proposal, your estimated time to completion, and 1-2 examples of previous QuickSight dashboards you have developed.

We are looking for a senior PrestaShop specialist with proven experience migrating stores from PrestaShop 1.6 to modern PrestaShop versions.

Store:
https://surfwax.lt

About us:
Surfwax is an established surf, fashion and lifestyle e-commerce store serving customers across Europe.

Current setup:

PrestaShop 1.6.1.24
Several thousand products
Multiple brands and categories
Existing SEO rankings that must be preserved

Project goals:

Migrate from PrestaShop 1.6.1.24 to PrestaShop 9 (or recommend the best target version)
Improve mobile experience
Improve site performance and Core Web Vitals
Preserve SEO rankings and URL structure
Ensure smooth customer experience during migration

Scope of work:

Full store audit
Migration planning
Products migration
Categories migration
Customers migration
Orders migration
Images migration
SEO migration
301 redirects where required
Theme recommendation and implementation
Module compatibility review
Testing and launch support

IMPORTANT:

Please DO NOT apply if your primary experience is with WordPress, Shopify or general PHP development.

We are only interested in developers who have completed multiple PrestaShop migration projects.

To be considered, please provide:

Number of PrestaShop migrations completed
Examples of PrestaShop 1.6 → 8 or 9 migrations
URLs of migrated stores
Recommended migration path for our store
Estimated budget range
Estimated timeline
Your location and time zone

Preferred:

PrestaShop-focused developers
Experience with European e-commerce stores
Strong SEO migration experience
Long-term maintenance availability