Slow Query Optimisation (SQL)
Specialist · SQL & ETL Support · Remote · United States
- Company
- Contract research organisation in diagnostics · 201–500 employeesCL-76279 · based in Tarragona
- Where
- Remote · United States
- Format
- One-off task
- Time needed
- about 6 h in total
- Start
- Starts within 2 weeks
- Level
- Specialist · 2-5 years
- When you work
- Evenings or weekends
The company is already looking at 4 profiles for this task. It is still open: new profiles are added to the shortlist until the company decides.
8 professionals have asked about this task220 tasks of this type completed on Deftridge
About this task
This contract research organisation in diagnostics (201–500 employees) is looking for a specialist SQL & ETL Support for a single piece of work with a fixed scope and a fixed price. Rewrites queries and adds indexes or partitions.
The company has a deadline, no one free to own it, and wants a person who has done the same job before. It works in life sciences, where documents are versioned and reviewed in a fixed order.
The work is fully remote. Any location in United States works, with a few hours of overlap with the team's day. Evenings or weekends are fine, as long as the agreed weekly output is there.
What you deliver
- Speed up the ten slowest warehouse queries and report before and after run times.
- A 20-minute walkthrough call, or a recorded screen share if you prefer
- A final note stating what was checked and what was left out of scope
- The finished deliverable in the agreed file format, with sources and assumptions listed
How the work runs
- Day 1: scope confirmed in writing, files shared
- Middle of the period: draft shared for early feedback
- Last day: final version and handover note
Duration: about 10 working days. Accepted when the output matches the agreed checklist and the sample check passes; the recruiter confirms by e-mail.
Tools
Who fits
- 2-5 years of hands-on work as an SQL & ETL Support, or the equivalent mix of roles
- Comfortable working in SQL, BigQuery and Snowflake
- Your own work history stays private; the company sees a first name, your field and a rate
Nice to have
- Has worked with a distributed team across time zones
- Used to short written handovers
Not included
- Managing other contractors or employees
- Anything that needs a signature in your own name unless the brief says so
- Travel or work at a fixed location
How you get paid
- The company prepays Deftridge before your first hour, so payment does not depend on a late invoice.
- Deftridge pays you in USD after the company confirms the hours or the deliverable. The payment date is written in your task agreement.
- You work as an independent contractor: you report your own income, and your recruiter sends the statements your accountant needs.
- You never chase the company. Questions about money go to Deftridge.
What happens after you say you're interested
- Within one working dayA recruiter writes to you to confirm your hours and the rate you want.
- You agree the rateYou and the recruiter fix an exact rate inside the company's range. You decide whether to go ahead.
- With your written OKThe company sees the anonymous profile below. Most companies answer within three working days.
- StartYou sign the task agreement and the company's confidentiality terms through Deftridge, and begin on the date above.
What the company sees about you
First name, field, experience, tools and the hours you offer. Not your surname, your employer or your contact details.
- Experience
- 2-5 years in data & analytics
- Tools
- SQL, BigQuery, Snowflake
- Offers
- 6 hours in total, weekday evenings
- Rate
- $116 an hour, agreed with the recruiter
How this rate compares
The midpoint of this range, $116 an hour, is above the median specialist SQL & ETL Support rate in the United States ($110). The shaded band is the 25th to 75th percentile of the market.
All SQL & ETL Support jobs in United States · SQL & ETL Support rates in United States · Data & Analytics jobs
Questions about pay and privacy
The rules are the same for every task. Pricing explains the 15% fee, prepayment and when you are paid; How it works covers matching, what the company sees and side work next to a job.
CL-76279 is the Deftridge code for this company. Its name is shared only after you agree to an introduction, and you decide whether to go ahead.