Freelance SQL programmer jobs, employment

Job Title: PySpark Developer – Data Engineering (Cloud)
Duration: 3 Hours
 Budget: ₹30K 
 Experience: 8+ Years
 Demo: Today
 Location: Remote

Overview:
 Looking for an experienced Data Engineer (PySpark) with strong hands-on expertise in Spark, Python, and any cloud platform (AWS/Azure/GCP). The role involves building and optimizing large-scale data pipelines, detecting and anonymizing PII data, and integrating tokenization services to ensure security and compliance.

Key Skills:
PySpark, Apache Spark, Python, SQL
Hadoop, HDFS, YARN
Airflow, DBT (Preferred)
Cloud: AWS / Azure / GCP
Tokenization, Data Security, GDPR/CCPA
CI/CD, Git, Agile

Responsibilities:
Design & optimize Spark-based data pipelines
Implement PII detection & tokenization workflows
Integrate APIs & automate data processes
Ensure scalable, secure, and compliant data solutions

We’re looking for an experienced full-stack developer who can work with NestJS and Laravel. You’ll help us build new features, improve existing functionality, and keep our application stable and scalable. This is a long-term role for someone who writes clean code, communicates well, and can work independently.

Responsibilities:
- Develop REST APIs and backend features using NestJS and Laravel
- Work with MySQL or PostgreSQL databases (migrations, queries, optimization)
- Integrate third-party APIs
- Fix bugs, improve performance, and refactor existing code when needed
- Write reusable, clean, and testable code
- Collaborate using Git (GitHub, GitLab, Bitbucket)
- Follow best practices for security and performance

Basic Requirements:
- Strong experience with NestJS (TypeScript)
- Strong experience with Laravel (PHP)
- Solid understanding of RESTful APIs
- Good knowledge of SQL databases
- Experience with authentication systems (JWT, OAuth, Sanctum, Passport)
- Ability to work with queues, schedulers, and background jobs
- Familiarity with Docker (preferred)
- Ability to understand and improve existing code
- Good communication and timely updates

I run a UK-based Health & Safety consultancy. We provide and maintain full Health & Safety Management Systems (HSMS) for over 100 clients across a range of sectors (construction, waste & recycling, office-based businesses, etc.).

At the moment, I have a complete suite of H&S policies, procedures and templates that I manually adapt for each client (branding, names, responsibilities, risk profile, etc.). This is time-consuming, repetitive, and hard to scale.

I now want to build a bureau-style, centrally managed document system, where:

I maintain one master HSMS (policies, arrangements, procedures, forms), and

Client-specific systems are generated automatically from that master, based on a structured client profile,

Legislative / wording updates can be made once centrally and then rolled out to all relevant clients.

I am looking to outsource the technical build of this system to an experienced developer / solutions architect who understands document automation and can work within the Microsoft 365 ecosystem (Word, SharePoint, possibly Power Automate/Power Apps or similar).

I will provide all H&S content (policies, procedures, templates).
Your job is to design and build the machinery around it.

Current Environment

We use Microsoft 365 (including desktop Word and SharePoint/OneDrive).

All policies and procedures are currently Word documents (.docx).

Content is already structured but not yet fully templated with fields/placeholders.

Clients currently receive static copies of documents, manually edited.

High-Level Objective

To design and implement a bureau-managed HSMS platform that allows:

Setup of a new client in minutes (not days).

Central maintenance of a single master document library.

Automatic generation of client-specific document sets using client profile data.

Controlled rollout of legislative and content updates to multiple clients.

Strong version control, audit trail, and permissions.

This is not a public SaaS platform for thousands of random users; it’s a controlled, internal bureau service for my consultancy to use across 100+ clients.

Core Concept

One Master HSMS Library

A single set of Word-based master templates (H&S Policy, Environmental Policy, Equal Opportunities, Harassment, Smoke-Free, Modern Slavery, HSMS Arrangements, forms, etc.).

All master documents use structured fields/placeholders for client-specific data (e.g. Company_Name, Managing_Director_Name, Policy_Issue_Date).

Where appropriate, content is modular (e.g. Construction module, Waste & Recycling, Office, Lone Working, etc.).

Client Master Register (Data Layer)

A central, structured client profile database (could be SharePoint list, Dataverse, SQL, or similar) that holds all client-specific fields:

Company details (name, trading name, addresses)

Contacts and roles (MD, H&S lead, competent person)

Risk profile / sector

Modules applicable (e.g. Construction: Yes/No, Waste: Yes/No)

System issue date, review frequency, etc.

This becomes the “single source of truth” for document generation.

Document Automation Layer

The system must be able to:

Take a master template (Word).

Merge it with one client’s profile data.

Output a client-specific document set into a client-facing area (e.g. separate SharePoint library/folder).

Repeated fields (Company_Name, director name, dates, etc.) must be populated once per document from the client profile data.

This should use a robust method (e.g. Word fields, content controls, or server-side templating) that supports:

Repeated use of the same value

Future automation

Easy maintenance of master templates

Client Delivery / Portal Structure

Each client should have a separate area (SharePoint library/folder/“site”) with:

Read-only policies and procedures (PDF or controlled Word).

Editable forms and pro formas (accident forms, inspection forms, etc.), where appropriate.

Access control so each client only sees their own documents.

I should have a central admin view.

Update & Version Control Workflow

When a master document is updated (e.g. due to legislation or best practice), I want to:

Update it once in the master library.

Push or regenerate updated versions for all affected clients (or a defined subset).

Maintain clear document metadata:

Document code

Version

Issue date

Owner

Status (Draft / Approved)

Maintain an audit log of:

When documents were issued/updated for each client

Which version they currently hold

Detailed Functional Requirements
1. Data Model & Configuration

Design and implement a client master data structure with (at minimum):

Client_ID

Company_Name

Trading_Name

Registered_Address

Trading_Address

Industry_Type

Employee_Count

Risk_Profile (Low/Med/High)

Managing_Director_Name

Managing_Director_Title

H&S_Lead_Name

H&S_Lead_Title

Appointed_Competent_Person

Policy_Issue_Date

Policy_Review_Date

HSMS_Version_Set

Review_Frequency

Consultant_Assigned

Applicable_Modules (Construction, Waste, Transport, Office, Lone working, etc., Yes/No flags)

This must be centralised and easy to maintain.

2. Template Management

Create (or help convert) my existing documents into master templates with fields mapped to the data model.

Ensure a repeatable approach:

Same field names across all templates.

Clear mapping between data model and document fields.

Ideally support:

Versioning on templates.

Marking templates as Draft vs Approved.

3. Document Generation

Build a process so that I can:

Select a client (or run for all applicable clients).

Generate a full HSMS pack (or selected documents) for that client.

Automatically populate all relevant fields.

Output:

Word documents and/or PDFs into the client’s library.

Follow a consistent folder structure (e.g. 01 Policy, 02 Arrangements, 03 Forms, etc.).

This process could be:

A Power Automate flow.

A custom application/portal.

Another robust automation solution you propose.

4. Module Logic

The system should toggle sections/modules based on client profile. For example:

A purely office-based client receives core policies plus low-risk office arrangements only.

A waste management client receives core plus Waste, Transport, Workplace Transport, etc.

A construction client receives core plus CDM / Work at Height / Construction-specific arrangements.

The module logic needs to be:

Configurable by me (not hard-coded)

Stored in a structured way (e.g. a module mapping table)

5. Version Control & Updates

Implement transparent version control for:

Master templates

Client-issued documents

Provide a simple interface/process so that when:

A master template changes,

I can regenerate or update affected client documents and:

log the update,

optionally notify clients.

There should be a change log per client:

Date

What changed

Which documents

Who initiated it

6. Permissions & Security

Use role-based access:

My internal team: full access to master templates and client profiles.

Clients: view (and where allowed, edit) only their own documents/forms.

Ensure compliance with:

UK GDPR requirements for processing client data.

Provide a clear structure for:

Adding/removing clients.

Deactivating clients while retaining their history.

7. Admin & Usability

I need to be able to:

Onboard a new client quickly (add profile, select modules, generate pack).

View, search and filter clients (by sector, risk profile, consultant assigned, etc.).

Quickly see which HSMS version each client holds.

Export basic reports if possible (e.g. list of clients and their HSMS issue dates and review dates).

8. Documentation & Handover

I will need:

Clear technical documentation (architecture, data structures, flows).

Simple user guides or screen-recordings explaining:

How to onboard a new client.

How to update client data.

How to trigger document generation.

How to manage template updates.

The end goal is that my team can run the system day-to-day without developer support.

Non-Functional Requirements

Technology preference:

Strong preference to leverage Microsoft 365 (SharePoint, Word, Power Automate / Power Apps) where possible.

I am open to a lightweight custom app if it integrates cleanly and works with Word templates.

Security & Reliability:

Must be robust and stable for 100+ clients.

Must respect access controls (clients cannot see each other’s data).

All core logic must be well-documented.

Maintainability:

No “black box” code that only you understand.

Logical, maintainable structure; easy to extend modules later.

What I Will Provide

All H&S content:

Current HSMS policy suite (.docx).

Arrangements and procedures.

Forms/pro formas.

High-level mapping of:

Which content applies to which type of client.

Support to clarify:

Risk profiles.

Module logic.

Expected outputs.

What I Need From You (in Your Proposal)

Please include:

Relevant Experience

Experience with document automation, especially in:

Microsoft 365 / SharePoint / Word

Power Automate / Power Apps

Any experience with:

Bureau-style services

Legal, H&S, HR or compliance document systems

Suggested Technical Approach

How you would design:

Client master data layer

Template management

Generation flow

Which tools you would use (e.g. SharePoint lists + Power Automate, custom web app, etc.)

Example of Similar Work

Links or short descriptions of similar systems you’ve built.

Outline Project Plan & Phasing

Phase 1: Discover & design (including confirmation of data model, structure, and tools)

Phase 2: Build core engine (data + template connection + generation)

Phase 3: Build client delivery structure & access

Phase 4: Testing with a small number of clients

Phase 5: Documentation & handover

Estimated Timeline & Cost Range

I appreciate this will be refined later, but an initial ballpark and breakdown would be helpful.

Ongoing Support

Indicate whether you can provide ongoing support or future enhancements (not mandatory but useful to know).

Hello!

We are a small, tight-knit product team looking for a passionate Python Developer to join us. We don't build software for the shelf – we build digital products that make people's lives easier. We are looking for a partner, not just a ticket-closer.

The Situation: You will be joining a team consisting of the Founder and a talented Junior Developer. We need an experienced developer to help us maintain the current platform, squash bugs, and – most importantly – build new key features (starting with Payment Automation).

Who we are looking for: You are a "Product Engineer". You understand that code is a tool to solve business problems. You are accurate, analytical, and proactive. You prefer a small, agile environment over corporate structures.

The Tech Stack (Must Haves):

Backend: Expert level Python & Django.

API: Strong experience with GraphQL (this is crucial).

Async/Performance: Experience with Redis and background task queues (Celery or similar).

Infrastructure: Familiarity with AWS services (especially for building automations).

Frontend: You must be comfortable working with Vue.js 2 (Legacy code maintenance & small features).

Tools: Git, Docker, SQL, basic HTML/CSS.

Nice to have:

Experience with React.js (we have some new modules in React).

Experience writing Automated Tests (pytest/Jest).

Experience with Payment Integrations (Stripe/PayPal/etc.).

Your Responsibilities:

Feature Development: Your first task will be designing and implementing a robust Payment Automation system using Django, queues, and AWS.

Maintenance: Debugging and maintaining our existing web app (Vue 2 + Django).

Collaboration: Working closely with the team, communicating in English, and mentoring our Junior dev when needed.

Logistics:

Workload: 100 - 160 hours/month (Flexible, but we value availability). We are looking for someone to start from January 2026.

Type: Independent Freelancer ONLY. No Agencies.

How to Apply: Please send your proposal starting with the word "PRODUCT". Tell us briefly about your experience with Django + GraphQL and one complex automation/queue problem you solved recently.

• Do you have commercial experience with GraphQL in a Django environment? Please describe a specific implementation.
• Our frontend is largely in Vue.js 2. Are you comfortable maintaining and debugging Vue 2 code?
• Have you worked with Redis and task queues (e.g., Celery) for background processing?
• Are you an individual freelancer? (We do not work with agencies/outsourcing houses).

I need an experienced server administrator to optimize my LiteSpeed server and WordPress site for maximum performance.

🖥️ SERVER SETUP:
- VPS: 12 vCPU, 48GB RAM, 300GB SSD
- OS: AlmaLinux 9.7
- Control Panel: Webuzo
- Web Server: LiteSpeed (active)
- Platform: WordPress (high-traffic)

🎯 GOAL:
- GREEN scores on PageSpeed Insights (90+ mobile & desktop)
- GREEN scores on GTmetrix (A grade)
- Fast loading with ALL plugins working
- Site uses Makfast image plugin (MUST stay active)

✅ REQUIRED TASKS:
1. Configure LiteSpeed Cache properly for WordPress
2. Setup Redis or Memcached for object caching
3. Optimize PHP-FPM settings for available RAM
4. MySQL/MariaDB performance tuning
5. Identify and resolve plugin conflicts (document them, don't just disable)
6. Database optimization and cleanup
7. Server-level caching configuration

🔒 IMPORTANT:
- If you find plugin conflicts, document:
* Which plugins conflict
* Error logs
* Your recommended solution
- NO removing features to fake good scores
- Makfast plugin must remain active and functional
- Backup before any changes
- Provide simple documentation of all changes made

📋 DELIVERABLES:
- Optimized server with green PageSpeed/GTmetrix scores
- List of changes made (commands, configs modified)
- Report of any plugin conflicts found
- Brief guide on maintaining the optimization

⏱️ TIMELINE: 1-2 days

💰 BUDGET: $100 fixed price

Please start your proposal with "LITESPEED-OPT" and include:
- Your experience with LiteSpeed + Webuzo
- Brief explanation of your approach
- Examples of similar projects

NO generic proposals. Show me you understand the requirements.

Paid test task (up to 5 hours).

Goal:
Verify code quality, communication, and ability to work with our stack.

Scope:
– Small isolated task based on existing codebase
– No production access
– No long-term commitment at this stage

Stack:
React / Next.js / TypeScript
Node.js / NestJS
PostgreSQL

After the test, we decide whether to continue cooperation.

We’re looking for a backend developer to build a lightweight internal web tool.
The scope is straightforward: basic data handling, simple API endpoints, authentication, and connecting a few internal services. No heavy architecture or complex systems - just clean, reliable backend work in a reasonable timeframe.

Tech stack is flexible. We’re open to whatever you’re comfortable with as long as it fits a standard modern backend workflow.

What we need:

Solid understanding of how to structure and build backend logic

Ability to create clean, maintainable REST APIs

Experience working with databases (any common SQL or NoSQL option is fine)

Clear communication and predictable delivery

Someone who’s confident in their skills, but not over-engineering tasks


To apply:
Please send examples of small backend tools or APIs you’ve built, your preferred tech stack, and availability.

We are seeking a highly skilled professional to take on a hybrid leadership role combining QA Management, Scrum Master, and Project Management responsibilities. The ideal candidate will have a strong background in quality assurance processes, agile methodologies, and end-to-end project delivery.
What We're Looking For:
QA Management Skills:
Strong experience in test planning, strategy, and execution
Expertise in manual and automated testing methodologies
Experience with test management tools (JIRA, TestRail, Zephyr, or similar)
Knowledge of API testing, performance testing, and security testing
Ability to define and track quality metrics and KPIs
Experience building and leading QA teams
Bug tracking, reporting, and defect management
Scrum Master Skills:
Certified Scrum Master (CSM) or equivalent certification preferred
Deep understanding of Agile/Scrum frameworks
Experience facilitating sprint planning, daily standups, retrospectives, and reviews
Skilled at removing blockers and enabling team productivity
Ability to coach teams on agile best practices
Experience with Kanban and other agile methodologies
Project Management Skills:
Proven experience in end-to-end project delivery
Strong skills in planning, scheduling, and resource allocation
Risk identification and mitigation strategies
Stakeholder communication and expectation management
Experience with project management tools (JIRA, Asana, Monday.com, Trello)
Budget tracking and timeline management
Technical Knowledge:
Understanding of software development lifecycle (SDLC)
Familiarity with CI/CD pipelines and DevOps practices
Experience working with development teams on web and mobile applications
Basic understanding of frontend, backend, and database technologies
Responsibilities:
As QA Manager:
Define and implement QA processes and standards
Create comprehensive test plans and test cases
Oversee testing activities and ensure quality deliverables
Report on quality metrics and testing progress
Identify areas for process improvement
As Scrum Master:
Facilitate all scrum ceremonies
Shield the team from external distractions
Track sprint velocity and team performance
Foster a culture of continuous improvement
Ensure adherence to agile principles
As Project Manager:
Plan and manage project timelines and milestones
Coordinate cross-functional teams
Communicate project status to stakeholders
Manage risks and resolve issues proactively
Ensure projects are delivered on time and within scope
Requirements:
5+ years of combined experience in QA, Scrum Master, and/or Project Management roles
Excellent leadership and team management skills
Outstanding communication skills in English (written and verbal)
Strong organizational and multitasking abilities
Self-motivated with attention to detail
Available for regular sync calls and team meetings
Comfortable working with distributed/remote teams
How to Apply
Please include in your proposal:
A brief introduction highlighting your experience in QA, Scrum, and Project Management
Examples of projects you've managed end-to-end
Tools and methodologies you're proficient in
Your availability and timezone
We look forward to connecting with you!
Job Type: Contract
Experience Level: Expert
Duration: Ongoing

Title: Senior Python Engineer (Scraping + Data Logic) – AI-Workflow Expert Needed

We are building a Real Estate SaaS that aggregates auction and market data to automate property valuations. Current State: Python structure/DB and UI are ready (Block 1 and 2 of Project Management).

Your Mission: Complete Block 3 (Scraping) and Block 4 (Valuation Engine).

Why this is for you: You are a senior Python developer who masters Scraping (Playwright/Apify) but also loves Data Logic (Pandas, SQL calculations, Basic ML). You use AI tools (Antigravity, Codex) to fly through boilerplate and focus on complex logic.

The Scope (2 Milestones)
Milestone 1: Robust Scraping & Aggregation (Block 3)
- Fix & Scale Scraping: Improve existing scripts for an auctions site and a real estate listing site, using Playwright/Apify. Must handle blocking, proxies, and huge datasets.
- Document Parsing: Extract text/values from auction PDFs (OCR/Text parsing) to get official appraisals.

Milestone 2: Valuation & Rating Engine (Block 4)
- Comparables Engine: Write logic to fetch listings within a 500m radius and calculate median market prices.
- Dynamic Rating System: Implement a SQL/Python scoring engine that ranks properties (AAA to C) based on user-weighted preferences (Yield, ROI, Risk).
- Basic ML Valuation: Implement a baseline price prediction model (using Scikit-learn or XGBoost) based on property features.

- Note: We do not expect you to be a Lead Data Scientist. We need a solid V1 implementation (Linear Regression or Random Forest) that we can refine later.

Requirements
1. AI-Assisted Workflow: You utilize AI (Antigravity, Codex) to speed up development. This is a requirement.
2. Python Data Stack: Strong experience with Pandas and NumPy. You aren't just building APIs; you are manipulating data tables.
3. Scraping Mastery: Playwright (Async), Anti-detect browsers, Proxy management.
4. Backend Logic: Complex SQL queries (Window functions, geospatial queries are a plus).

To Apply
Start your cover letter with "DATA-DRIVEN" and answer:
1. Rate your proficiency with Pandas and Scikit-learn (1-10). Can you build a simple price-prediction model?
2. Which AI coding assistant do you use most?

• Do you operate as a registered business or self-employed professional with a valid VAT number (if applicable in your country)?
• Rate your proficiency with Pandas and Scikit-learn (1-10). Can you build a simple price-prediction model?
• Which AI coding assistant do you use most?
• Describe a project where you used AI tools (Antigravity/Codex) to speed up development and used Pandas + NumPy for data manipulation. Include one specific transformation you implemented.
• Describe a scraping system you built with Playwright (async). How did you handle anti-detect browsers and proxy rotation? Also share one complex SQL query you wrote (window functions or geospatial preferred)

Contract-to-hire: We start with a paid contract period to confirm fit on both sides, then extend a full-time offer to the right person

Benefits & values (once hired):
• Unlimited PTO-style flexibility (outcomes over hours)
• Higher-than-average paid sick/vacation time
• Transparency on priorities, expectations, and feedback
• In-house only, no rotating/random client accounts
• Minimal meetings, async-first, deep-work friendly

About us: We’re a product-led team building our internal go-to-market engine, we value calm execution, high ownership, and systems that are reliable, observable, and easy to operate

Why this role: We need a builder who can take a vague or messy RevOps/GTM problem and drive it to completion, clarify requirements, design the system, implement it, document it, and keep it reliable

High autonomy expectations:
• We give outcomes and constraints, not step-by-step instructions
• You work independently, choose the right approach/tools, and do what it takes to ship
• You proactively surface tradeoffs and risks, then unblock yourself
• You deliver with minimal oversight by building, testing, documenting, and monitoring

What success looks like:
• Inbound flows are stable and measurable end-to-end (capture → enrich → dedupe → score → route → book → report)
• Data quality is enforced with clear governance (field ownership, overwrite rules, dedupe, enrichment)
• Failures are detectable and recoverable (alerts, retries, backfills, runbooks)
• Every major workflow has an up-to-date diagram and SOP

Responsibilities:
• Architect and implement lead lifecycle flows (capture → enrich → route → nurture → convert)
• Build and maintain CRM objects, fields, validation, dedupe, and governance (Salesforce primary, HubSpot secondary)
• Own marketing automation and lifecycle hygiene (Marketo/Conversion AI)
• Implement and debug integrations across corporate website, Unbounce, Chili Piper, ZoomInfo, and RingLead
• Create observability (logging, alerting, retries, failure-handling) across GTM workflows
• Produce clear documentation and system diagrams for every major workflow
• Track work in Jira with clean incremental delivery

Core tech stack:
• CRM: Salesforce (primary), HubSpot (secondary)
• Marketing automation: Marketo / Conversion AI
• Scheduling: Chili Piper
• Landing pages + A/B testing: Unbounce
• Enrichment: ZoomInfo
• Lead management/dedupe/data quality: RingLead
• Work management: Jira (RevOps)
• Analytics: Google Analytics, SQL, Metabase

Must-haves:
• Proven experience building Salesforce-first GTM/RevOps systems end-to-end
• Confident debugging across systems (sync rules, field mapping, APIs/webhooks, identifiers/UTMs, rate limits)
• Strong documentation habits (diagrams + runbooks) and clear written communication
• High autonomy and ownership with minimal hand-holding

Nice-to-haves:
• RingLead implementation depth (dedupe, normalization, routing)
• Marketo operational depth (program architecture, tokens, channels, lifecycle reporting)
• ZoomInfo enrichment governance (match logic, overwrite rules, refresh cadence)
• Salesforce Flow/validation rules/Apex familiarity

Engagement:
• Rate range: $50–$125/hr (or propose project pricing)
• 10–20 hrs/week to start, with room to scale
• Long-term, contract-to-hire path
• Async-first, minimal meetings, direct feedback, clear priorities

Hiring process (Upwork-compliant):
• Step 1: Proposal + screening question answers + links to prior work samples (no custom unpaid deliverables required)
• Step 2: Shortlist finalists based on relevance, clarity, and prior work quality
• Step 3: Paid screening task for up to 3 finalists (guaranteed paid project for those selected)
• Step 4: Select contractor, then scale scope and move toward hire based on performance

Paid screening task (for up to 3 finalists):
• 2–4 hours, paid via Upwork
• Includes a realistic troubleshooting/design prompt and one diagram deliverable
• Used to evaluate systems thinking, reliability mindset, and documentation quality

• In 6–8 sentences, what are the first checks you’d run when Chili Piper demo bookings stop creating records in Conversion/Marketo and Salesforce, and why that order.
• Name 5 likely breakpoints across Unbounce changes, Chili Piper, Conversion/Marketo, and Salesforce, and give one validation method for each (1 sentence each)
• What 5 specific things would you ask the marketing team for to confirm whether an Unbounce A/B test caused the issue (examples: URL variants, scripts/tags changed, hidden fields/UTMs, redirect behavior, test launch time)
• Share 1 link or screenshot to an existing systems diagram/SOP you’ve created for a similar inbound flow (redacted is fine); do not create anything new for this proposal.
• In 6–10 sentences, describe how you represent lead scoring in Salesforce (fit vs intent, fields, thresholds), and how sales teams should use it day-to-day.

We are seeking a Senior Backend & Infrastructure Engineer to build the robust plumbing that powers sophisticated AI agents for a major cloud technology client. Your code will run on a modern PaaS environment and will serve as the backbone for critical automation tools.
You are not just building APIs; you are building the execution environment for agents. You will handle state management (Postgres/Redis), infrastructure as code (Terraform/Blueprints), and secure sandboxing for code execution. You understand that "observability" for agents means more than just HTTP logs.

Key Responsibilities:
Design and deploy scalable backend services on modern PaaS infrastructure using Infrastructure as Code (IaC).
Build robust APIs and webhooks that allow agents to interact with internal and external tools (e.g., issue trackers, chat platforms).
Implement secure execution environments (sandboxes) for agents to run code safely.
Set up comprehensive logging and observability (traces, metrics) to debug complex agent reasoning traces.
Manage persistent state for long-running agent workflows using Postgres and Redis.

Required Skills & Experience:
PaaS & Cloud Native Expert: Deep experience deploying and scaling services on platforms like Heroku, Vercel, or similar modern cloud providers.
Strong Backend Engineering: Expert in Python (FastAPI/Django) or TypeScript (Node/Next.js).
Infrastructure as Code: Proven experience with Terraform, Pulumi, or similar IaC tools.
Database Design: Strong SQL (Postgres) and Redis skills for managing agent state/memory.
Security Mindset: Experience building secure integrations and handling sensitive data.

• We need to deploy a fleet of AI agents on a modern PaaS. Describe how you would structure the Infrastructure as Code to manage a production environment versus ephemeral preview environments for testing PRs.
• An agent needs to execute arbitrary Python code generated by an LLM to analyze data. How do you architect this safely? What technologies or patterns would you use to prevent the agent from accessing sensitive env vars or bringing down the service?
• Describe your approach to observability for an autonomous agent system. Standard HTTP logs aren't enough when an agent takes 15 steps to solve a task. How do you trace the execution so we can debug why it made a specific decision?

Job description
Job Title: Analytics Engineer Associate
Required Hours - around 30-40 hrs/week for 6 months to 1 YR

Job Summary:
We are seeking a detail-oriented and analytical, Reporting and Data Visualization Associate to join our data-driven team. This role will be responsible for translating business metrics into impactful reports and dashboards using tools like Power BI and Domo. The ideal candidate will work closely with business stakeholders to understand reporting needs and support decision-making through accurate, timely, and actionable insights. The ideal candidate will also have impeccable conversational English speaking and writing skills.

In addition to visualization, the role involves working with data infrastructure and ETL processes using Microsoft Fabric, with exposure to AWS, Snowflake, and scripting in PySpark, Python, and SQL being advantageous.

Key Responsibilities:
Design, develop, and maintain interactive dashboards and reports using Power BI and Domo based on business requirements.
Translate complex business metrics into clear visual narratives to support strategic and operational decision-making.
Work with cross-functional teams to gather requirements, define KPIs, and ensure data consistency and accuracy.
Develop and maintain data pipelines and ETL processes primarily using Microsoft Fabric.
Integrate and manipulate data from multiple sources including Snowflake, AWS, and other cloud-based platforms.
Perform data analysis and validation to ensure data integrity across reporting tools and systems.
Optimize report performance and implement best practices in visualization design and user experience.
Collaborate with data engineers, analysts, and business stakeholders to streamline reporting and analytics workflows.
Maintain documentation for data models, data sources, and reporting processes.

Selection note: The top 3 proposals will receive a guaranteed paid project for further testing

Contract-to-hire: We start with a paid contract period to confirm fit on both sides, then extend a full-time offer to the right person

Benefits & values (once hired):
• Unlimited PTO-style flexibility (outcomes over hours)
• Higher-than-average paid sick/vacation time
• Transparency on priorities, expectations, and feedback
• In-house only, no rotating/random client accounts
• Minimal meetings, async-first, deep-work friendly

About us: We’re a product-led team building our internal go-to-market engine, we value calm execution, high ownership, and systems that are reliable, observable, and easy to operate

Why this role: We need a builder who can take a vague or messy RevOps/GTM problem and drive it to completion, clarify requirements, design the system, implement it, document it, and keep it reliable

High autonomy expectations:
• We give outcomes and constraints, not step-by-step instructions
• You work independently, choose the right approach/tools, and do what it takes to ship
• You proactively surface tradeoffs and risks, then unblock yourself
• You deliver with minimal oversight by building, testing, documenting, and monitoring

Responsibilities:
• Architect and implement lead lifecycle flows (capture → enrich → route → nurture → convert)
• Build and maintain CRM objects, fields, validation, dedupe, and governance (Salesforce primary, HubSpot secondary)
• Own marketing automation and lifecycle hygiene (Marketo/Conversion AI)
• Implement integrations across Unbounce, Chili Piper, corporate website, ZoomInfo, and RingLead
• Create observability (logging, alerting, retries, failure-handling) across GTM workflows
• Produce clear documentation and system diagrams for every major workflow
• Track work in Jira with clean incremental delivery

Core tech stack:
• CRM: Salesforce (primary), HubSpot (secondary)
• Marketing automation: Marketo / Conversion AI
• Scheduling: Chili Piper
• Landing pages + A/B testing: Unbounce
• Enrichment: ZoomInfo
• Lead management/dedupe/data quality: RingLead
• Work management: Jira (RevOps)
• Analytics: Google Analytics, SQL, Metabase

Must-haves:
• Proven experience building end-to-end GTM/RevOps systems with Salesforce (HubSpot familiarity is a plus)
• Strong lifecycle, routing, scoring, and attribution fundamentals
• Confident debugging across systems (field mapping, sync rules, webhooks, API limits, cookies/identifiers, UTM capture)
• Strong documentation habits with diagrams (Lucidchart, Miro, Figma, Excalidraw, etc.)
• High autonomy and ownership with minimal hand-holding

Nice-to-haves:
• RingLead expertise (dedupe, routing, normalization, segmentation)
• ZoomInfo enrichment governance (match logic, overwrite rules, refresh cadence)
• Deep Marketo ops (program templates, tokens, channels, operational best practices)
• Salesforce Flow/validation rules/Apex familiarity

Engagement:
• 10–20 hrs/week to start, with room to scale
• Long-term, with contract-to-hire path
• Competitive hourly or project-based pricing (include your rate and preferred structure)
• Async-first, minimal meetings, direct feedback, clear priorities

Proposal requirement (mandatory written assignment + visuals, required for any consideration): Your proposal MUST include your written responses to Scenario 1 and Scenario 2 below from the beginning, plus at least one system diagram/visual artifact; proposals without the assignment responses will not be reviewed

Selection note: The top 3 proposals will receive a guaranteed paid project for further testing

SCENARIO 1: Demo bookings aren’t becoming CRM leads

A team has identified a major tracking gap: a large share of demo meetings being scheduled are not appearing as new prospects in the CRM

Context
• Demo meetings are scheduled through Chili Piper embedded on the corporate website (and/or linked from marketing pages)
• The marketing group recently launched A/B tests on demo and landing pages in Unbounce, and you can partner with them to validate what changed
• The usual path is Chili Piper → Marketo/Conversion AI → Salesforce, but new records are not showing up in Marketo/Conversion AI or Salesforce
• The business typically logs hundreds of new records per day; it has dropped to roughly a dozen

Using this information, outline how you would investigate and fix the issue, including what you would prioritize first and why; you may reference comparable systems if needed, but assume the stack below is available

SCENARIO 2:
You’ve implemented a new lead scoring framework; provide clear documentation that explains:
• How the scoring works (criteria, weights, thresholds, and what “high intent” means)
• How to administer and update the model safely over time (ownership, change control, testing, and rollback)
• How scores and related fields are represented in Salesforce (and/or equivalent CRM objects/fields), including how downstream teams should use them
• Best practices for hygiene (data completeness, enrichment, deduping, and common pitfalls)

Available tech stack (reference as needed)
• Marketo / Conversion AI: marketing automation for programs, forms, landing pages, and engagement tracking
• Salesforce: system of record for leads, contacts, accounts, opportunities, automation, and routing logic
• Chili Piper: scheduling and lead-to-meeting routing within the inbound funnel
• Unbounce: landing pages and experimentation (A/B testing) tied to conversion flows
• ZoomInfo: enrichment and list data to improve contact and account completeness
• RingLead: deduplication and data quality controls across top-of-funnel capture and CRM records
• Corporate website: primary entry point that must pass identifiers and events reliably end-to-end
• Jira (RevOps): intake, prioritization, delivery tracking, and process and playbook documentation
• Analytics (Google Analytics, SQL, Metabase): funnel monitoring, attribution checks, diagnostics, and reporting

We are seeking an experienced Data Analyst /Visualization/Database Expert/Web Analytics Engineer to design and implement a real-time web analytics dashboard in Power BI for a major event marketplace platform.

The objective is to move beyond raw Google Analytics reporting into a structured, interpretable analytics layer that enables hourly, actionable insights into user behaviour, content performance, and conversion pathways.

This URGENT project will create a continuous feedback loop that allows our team to optimise content, user journeys, and engagement in near real time, especially during high-traffic event periods.

Core Problem We Are Solving
(1) Google Analytics data, while rich, is not decision-friendly in its raw form.
(2) Event URLs, page paths, and unbranded parameters make it difficult to quickly understand what users are actually engaging with.

We therefore require:
(1) A dedicated analytics database that ingests Google Analytics interaction data
(2) A semantic layer where variables are renamed, cleaned, and enriched
(e.g., converting generic page URLs into human-readable event names)
(3) A Power BI dashboard that visualises this curated data clearly and intuitively

Proposed Analytics Architecture
The consultant will help design and implement the following flow:

(1) Google Analytics (GA4)
→ Custom Analytics Database (Open-source or lightweight relational DB)
→ Transformed & Renamed Variables (Semantic Layer)
→ Power BI Interactive Dashboard

This architecture is critical to ensure:
-Consistent naming conventions
-Long-term scalability
-Better storytelling from data
-Reduced analyst interpretation time

Key Responsibilities
The consultant will:
-Extract and ingest Google Analytics interaction data into a custom database
-Design a data model that supports hourly, daily, and trend-based analysis
-Clean, map, and rename GA variables
(e.g., page URLs → event titles, content categories, campaign names)
-Build a Power BI dashboard that visualises:
-Hourly traffic volume and spikes
-Top-performing and underperforming pages
-User navigation paths and drop-off points
-Engagement depth (time on page, scroll behaviour where available)
-Click-throughs to ticketing and exit behaviour
-Returning vs first-time visitors
-Enable near real-time refresh during peak periods
-Support interpretation and insight generation, not just charts

Analytics Focus Areas
The dashboard must support deep behavioural insight, including:
-Who is visiting the site and where they are coming from
-Which pages users linger on and which lose attention quickly
-How users move across the site
-Where and why users drop off
-What drives click-through to ticketing
-What content or campaigns trigger traffic surges
-What changes should be made within the same day or hour
-Reporting & Insight Delivery



Required Skills & Experience
-Strong experience with Google Analytics (GA4) and tags
-Experience designing analytics pipelines and semantic layers
-Advanced Power BI dashboard development
-Strong SQL and data modelling skills
-Experience working with web interaction and behavioural data
-Familiarity with open-source analytics databases

The work is to be completed this weekend in the next 48 hours.

Engagement Model
You will work with a team of 2 young data analysts to expedite the work over the weekend


How to Apply
Please include:
Relevant Power BI dashboard examples
Experience working with Google Analytics data
Brief explanation of how you would approach the Google Analytics → Adaptable Database → Power BI architecture

I’m looking for a complete, production-ready Recharge & Billing solution that includes a website, Android app, and a flexible API-driven admin panel.
A working demo (APK or live URL) is mandatory before we proceed—please do not apply without one.

The system should allow users to recharge mobile numbers, pay utility/DTH bills, and view real-time transaction history. On the backend, I need an admin interface where I can manage third-party APIs, set commissions, handle wallets, generate downloadable reports, and configure providers—all without service interruptions. Clean UI/UX, fast performance, secure authentication, and smooth payment gateway integration are essential.

Deliverables

Android app (production-ready) with full source code

Responsive web frontend mirroring the app’s features

Admin/API control panel to manage users, wallets, providers, and commissions

Deployment guide, database/schema documentation, and full API documentation

Acceptance Criteria

A recharge must work end-to-end in the demo.

Wallet balance and transaction logs must update instantly after each payment.

Admin panel must export CSV reports reliably without data loss.

Code must install successfully on my server and compile for Google Play with zero build issues.

Tech Preferences

Preferred stacks include: PHP (Laravel), Node.js, or Flutter for the app.
However, I’m flexible—as long as your demo proves stability, speed, and scalability (500 API requests/second support).

To Apply

Please share:

Your live demo link or APK

A short outline of the tech stack you will deliver

Confirmation that you can meet the demo and stability requirements

Candidate must have experience in Media and Entertainment Industry
Experience with Data analytics and engineering
Nice to have Experience in Media & Entertainment industry
Expertise in SQL, Python, ERD, GCP(All GCP services, GCP adapter, especially BigQuery, GCS, Cloud Function, Composer), DBT with active hands-on experience in the last 3~5 years
Gather data from multiple sources and prepare it for analysis.
Analyze large volumes of structured and unstructured data to identify trends and patterns.
Develop machine learning models and predictive algorithms to solve business problems.
Use statistical techniques to validate findings and ensure accuracy.
Possess the knowledge of Modern Data Technology released in the last 2~3 years
Design and optimize conceptual and logical database models
Analyze system requirements, implementing data strategies, and ensuring the efficiency and security
Improve system performance by conducting tests, troubleshooting, and integrating new elements
In-depth understanding of database structure principles
Expertise in implementing and maintaining data pipelines
Deep knowledge of data mining and segmentation techniques
Familiarity with data visualization tools
Pub-sub setup/configuration steps. Use case where pub-sub is used.

About the Project
We’re looking for an experienced Backend Developer to perform a comprehensive audit of our website’s backend with a specific focus on mobile responsiveness and performance. Our site currently operates well on desktop, but we’re seeing inconsistencies, slow loading, and layout shifts on mobile devices that appear tied to backend structure or data handling.

What We Need
We need a developer who can analyze how backend logic, APIs, and data flows may be affecting frontend responsiveness—particularly on mobile screen sizes.

Responsibilities
Conduct a full backend audit with emphasis on mobile responsiveness factors

Review server configuration, API response times, caching, asset delivery, and data models

Identify bottlenecks causing layout issues, slow load times, responsiveness delays, or rendering problems

Provide a clear report of findings, including:

What’s working

What’s causing responsiveness issues on mobile

Recommended fixes (ranked by priority and impact)

Collaborate with our designer/developer to clarify issues or propose solutions

Ability to implement the code in the backend to solve proposed issues