SQL Jobs

I have a complete record of recent sales and need a sharp analytical mind to turn those raw numbers into clear, actionable guidance for my social-media campaigns. The assignment revolves strictly around sales data; customer or market datasets are out of scope, so the focus can remain tight and conclusions direct. What matters most is translating quantitative findings into a revised social-media strategy that lifts conversions and revenue. I expect a structured approach—data cleaning, exploratory analysis, insightful visualisations, then concrete recommendations I can test on Instagram, Facebook, TikTok, or whichever platform the numbers point to. You are free to work with Python (pandas, NumPy, Seaborn), SQL, Excel, Power BI, or any tool you trust—as long as the final files a...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I need a .NET program for data processing, specifically for data storage and retrieval using an embedded SQLite database. Need someone based in Mumbai only. As would like the persont to be onsite all the time. Key Requirements: - Develop a .NET application - Implement data storage and retrieval functionalities - Embed SQLite database Ideal Skills and Experience: - Proficiency in .NET development - Experience with SQLite integration - Strong understanding of data processing principles

Description: I need an experienced Airtable builder to design and implement two executive dashboards in Airtable Interfaces: Sales Dashboard Marketing Dashboard These dashboards must support robust filtering, clean UI (tiles/rows), and accurate funnel math across Bookings, Closed Deals, and Capacity (Available Slots). Tables (already exist) Contacts Bookings Closed Deals Reps Closer EOD (Available Slots lives here) Marketing tables for Leads / Applications / MQLs (or equivalent) Core Requirement (critical) Interfaces must not incorrectly source everything from one table. Metrics must be accurately calculated and filterable. If Airtable limitations prevent reliable cross-table calculations inside Interfaces, you must implement a clean solution (examples: a Daily Fact table, sum...

Description: I need an experienced Airtable builder to design and implement two executive dashboards in Airtable Interfaces: Sales Dashboard Marketing Dashboard These dashboards must support robust filtering, clean UI (tiles/rows), and accurate funnel math across Bookings, Closed Deals, and Capacity (Available Slots). Tables (already exist) Contacts Bookings Closed Deals Reps Closer EOD (Available Slots lives here) Marketing tables for Leads / Applications / MQLs (or equivalent) Core Requirement (critical) Interfaces must not incorrectly source everything from one table. Metrics must be accurately calculated and filterable. If Airtable limitations prevent reliable cross-table calculations inside Interfaces, you must implement a clean solution (examples: a Daily Fact table, sum...

Tengo algunas aplicaciones ya operativas creadas en / NextLovable y alojadas en Lovable Cloud. Requiero trasladarlas íntegras a un entorno de hosting compartido que controlo personalmente, eliminando toda dependencia futura de la plataforma Lovable. Alcance • Clonar y extraer cada aplicación desde , conservando código, estructura y bases de datos. • Ajustar la configuración para que funcionen en mi proveedor de hosting compartido. • Mantener exactamente todas las funcionalidades actuales durante la transición. • Brindar soporte para lovable y cualquier ajuste necesario tras la migración. • Ejecutar pruebas funcionales y entregar reporte de validación técnica. • Documentar los pasos de desplieg...

I need an expert to provide support and maintenance for Oracle Transportation Management (OTM). The primary focus will be on bug fixes. Ideal skills and experience: - Proficiency in OTM - Strong background in troubleshooting and resolving software bugs - Experience with system maintenance and support

I need our raw financial numbers transformed into clear, interactive Power BI reports that management can rely on for day-to-day decisions. The datasets live in SQL Server plus a few recurring Excel exports; once connected, they must be modelled, cleaned, and enriched with the right DAX measures before being published to Power BI Service and shared through workspaces. What matters most to me is your experience: show me a brief overview of similar finance or accounting projects you’ve handled, the size or complexity of the data involved, and any notable outcomes you helped your client achieve. Screenshots or live demo links are welcome if you can share them. Deliverables I expect: • Robust data model with refresh schedules configured • A suite of role-based reports (P&...

I’m looking to replace the manual copy-and-paste routine we use today with an automated flow that keeps all of our resource management data—specifically human-resource information—up to date and error-free. The focus is on resource tracking: I need to see who is available, who is booked, and how utilisation is trending without having to touch a spreadsheet. Here’s the picture: • Source data lives in Excel/CSV files (and, if you can integrate it, a small HRIS API). • I want it validated, normalised, and stored in a structured repository—SQL, BigQuery, even Google Sheets if that’s the simplest. • A refreshed report or dashboard should surface the key tracking metrics for managers automatically, on a schedule we set together. You&rsquo...

Hi I will share the details with the shortlisted candidates. thanks

I already have a working large-language-model application and now I need it to do more than just generate or transform text. The next milestone is bringing true Predictive Analytics into the project so the system can forecast trends in our data and surface insights before they become problems. Concretely, I want the LLM to understand a prompt such as “Show me the expected CPU, memory and disk utilisation for the next 24 hours” and then: • craft the appropriate SQL query that pulls historic utilisation metrics (CPU, MEM, DISK) from my monitoring tables, • run or hand that query off to the existing pipeline, • feed the results into a prediction model (your choice of proven libraries like scikit-learn, TensorFlow, PyTorch, Prophet, etc.), • return a con...

We need someone to add data to tecdoc based on data from other manufacturers. We introduce approximately 500 new products per month. The request should include downloading data from another data provider (or several others) and entering it into our article.

I’m gearing up for the Databricks Data Engineer Professional certification and want a coach who can focus squarely on exam preparation. I’ve covered the course content on my own but still feel gaps when it comes to consolidating concepts, practicing timed questions, and understanding how topics are weighted on the actual test. Here’s what I’m hoping you can provide: • A structured study plan that maps every exam domain—ingestion, transformation, optimization, governance, and orchestration—to bite-size review sessions. • Live walkthroughs of tricky Spark SQL, Delta Lake, and data pipeline scenarios, highlighting the patterns that Databricks loves to test. • Fresh practice questions (or a curated question bank) with detailed explanati...

I need a seasoned database developer who can jump straight into our Microsoft stack. The work centres on three pillars: • Database design – architect new tables, relationships, and indexes that align with our current Microsoft Dynamics workflows while remaining compatible with long-standing Access front-ends and SQL Server reporting. • Data migration – extract and cleanse data sitting in several internal legacy databases, then import it cleanly into the new schemas. You’ll have direct access to the existing SQL Server instances plus a handful of Access files; SSIS or your preferred migration tool is fine as long as the result is reliable and auditable. • SQL query optimisation – review the most heavily used stored procedures and ad-hoc queries. I w...

I run a U.S. law firm and need a secure, compliant way to pull hearing-date information from the Case Access authenticated portal and push it into our existing Microsoft Azure environment. The piece I still need built is the EOIR Case Access integration itself. Everything else—Azure SQL tables, Microsoft 365 endpoints, and downstream reporting—already exists and is ready to receive data. Core needs • A fully RPA-based solution that signs into the portal through Okta MFA, built in Microsoft Power Automate Desktop. • Robust error handling so the flow can recover gracefully from timeouts, CAPTCHA, or authentication challenges. • Parsed docket data returned in JSON or CSV and posted to our Azure SQL stored procedures. • Change tracking inside the bot ...

VB.NET / MS SQL Developer Needed – Uganda EFRIS Integration I am looking for an experienced VB.NET and MS SQL Server developer to integrate Uganda’s Electronic Fiscal Receipting and Invoicing System (EFRIS) API into an existing VB.NET POS system. The ideal freelancer must have prior experience with tax or statutory compliance integrations, such as: Uganda – EFRIS, Kenya – KRA / TIMS, UAE – FTA, India – GSTN, Angola – SAF-T (or similar government e-invoicing systems) Scope of Work Integrate URA EFRIS API into a VB.NET POS Implement e-invoicing, fiscal receipts, QR code handling, and invoice validation Handle API authentication, error handling, and response reconciliation Ensure full Uganda URA EFRIS compliance Requirements Strong VB.NET & M...

I'm seeking an experienced SQL developer to optimize queries in BigQuery, focusing on complex joins and aggregations. Key requirements: - Expertise in BigQuery and SQL - Proven experience in query optimization - Strong problem-solving skills - Ability to work within budget constraints Ideal candidates should have a track record of improving query performance and can demonstrate their expertise with relevant certifications or project experience.

Buscamos Desarrollador(a) Full Stack – Node.js / React Somos una empresa dedicada al desarrollo de software para el procesamiento, visualización y análisis de datos de transporte público. Trabajamos junto a gobiernos y operadores de buses para mejorar la planificación, la gestión y la toma de decisiones a partir de grandes volúmenes de datos. Rol principal: Buscamos un(a) Desarrollador(a) Full Stack con experiencia en Node.js y React, que se integre a nuestro equipo para apoyar en: La operación y mantenimiento de sistemas de información para transporte público. Procesos de CI/CD, despliegue y monitoreo de servicios. El desarrollo de nuevos módulos y funcionalidades para nuestras plataformas. Requisitos dese...

Our civil-engineering group needs a seasoned GIS analyst to keep our spatial data organised, reliable, and ready for everyday design and reporting tasks. All work centres on spatial data management—cleansing existing layers, harmonising projections, and loading everything into a coherent geodatabase that feeds our internal mapping and analysis tools. I already have raw shapefiles, CAD exports, and a few FGDBs from previous projects. Your job is to audit what’s there, fix naming and schema issues, resolve coordinate mismatches, and package the results so ArcGIS Pro and QGIS open them without a hitch. If you prefer PostGIS or another enterprise store we can discuss it; what matters is simple versioning, clear metadata, and zero broken links. Deliverables • A master geodata...

I am almost at the finish line with an app built in Bolt, but a few technical roadblocks are preventing me from shipping to both iOS and Android stores. The most pressing issue is a persistent SQL database connection error that stops the app from reading or writing data reliably. Once that’s stable, I also need the existing two-factor authentication flow polished so users can register, receive their code, and sign in every time without hiccups. When both of those pieces are solid, the remaining work is essentially a production-ready build for iOS and Android so the app performs the same on each platform. Deliverables • Repair the SQL connection so all queries execute without timeouts or dropped sessions • Validate and fix the current 2FA login logic (code delivery,...

We had a Wordpress website that was created in 2017, but unfortunately it stopped working last week, so I need a new WordPress-based site that explain our enterprise and that has a separate web page that lets our clients log in, switch between French and English, and immediately see the debtor information we hold in an existing SQL table. The login must work with the classic username + password flow; if adding a simple 2-factor option is straightforward I’m open to that as well. I would upload the updated SQL table every week using a tool like phpMyAdmin. Once authenticated, users should land on a dashboard that pulls live data from the table and shows the following fields: • Account number • Debt amount and full payment history • Outstanding balance with due d...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I have an existing dataset already living inside Power BI and I now need a clean, interactive dashboard that turns those numbers into meaningful financial insights for my team members. The goal is to give them a single page (with drill-through detail where it makes sense) that tracks revenue, expenses, cash flow, variance against budget, and any other standard finance KPIs you normally see. You will be working entirely in Power BI—no additional SQL, Excel, or cloud connectors are involved—so expect to shape, model, and visualise the data directly within that environment. I’ll grant you access to the workspace along with a brief on our account structure and current measures. From there I’d like you to: • Design an intuitive layout that works both on desktop an...

Looking for Oracle Fusion Cloud personal supporting customer's relation and end-to-end environment configuration. This will be an ongoing on a monthly basis with 40+ hours every week. Attend all customer's meetings. Please indicate your experience with which Oracle ERP modules and for how many years ?

I’m seeking dependable help for ongoing data-entry work that centres on Microsoft Access database management. A few hours spread across the week will be enough to keep our existing Access file clean, current, and functioning smoothly. You’ll take raw spreadsheets I supply, import them, validate the new records against existing tables, and flag or fix duplicates before they cause problems. On quieter days I may ask you to tweak simple queries, update look-up lists, or generate quick summary reports, so solid familiarity with Access forms, tables, and basic SQL is essential. Accuracy matters more than speed, yet I still expect regular progress updates and a final confirmation once each batch is fully processed. If you already have a reliable routine for versioning and backu...

I’m seeking dependable help for ongoing data-entry work that centres on Microsoft Access database management. A few hours spread across the week will be enough to keep our existing Access file clean, current, and functioning smoothly. You’ll take raw spreadsheets I supply, import them, validate the new records against existing tables, and flag or fix duplicates before they cause problems. On quieter days I may ask you to tweak simple queries, update look-up lists, or generate quick summary reports, so solid familiarity with Access forms, tables, and basic SQL is essential. Accuracy matters more than speed, yet I still expect regular progress updates and a final confirmation once each batch is fully processed. If you already have a reliable routine for versioning and backu...

I work with large manufacturing datasets inside Palantir Foundry and need practical help each day to keep the data flowing smoothly. The job is entirely hands-on: you and I will sit together in Kharadi, Hadapsar, or any nearby part of Pune for roughly one to two hours (we can fine-tune the schedule once we see the workload) and tackle daily data-engineering tasks. Your core focus will be designing, building, and refining Foundry pipelines and related Python components that ingest raw plant information, transform it for downstream analytics, and push clean, trusted tables back into Foundry. This involves writing well-structured Python code, mapping source systems, troubleshooting schema issues, and performance-tuning the workflows so overnight runs stay within SLA. • Creating new cod...

I have several retrospective ICU studies underway and I need an analyst who already feels at home inside both MIMIC-III and MIMIC-IV on PhysioNet. The work centres on pulling raw tables, stitching them together through patient and hospital-stay identifiers, and transforming that sprawl into tidy, analysis-ready cohorts. Every step—from initial SQL queries to the last model diagnostic—must be reproducible and clinically defensible. Day to day you will: • Extract rows from the core Meds, diagnoses, procedures, labs, and vitals tables, then link them reliably across encounters. • Clean and preprocess the high-dimensional data, flagging implausible values and resolving unit or time-stamp issues. • Derive clinically meaningful variables (severity scores, medica...

I need a Python script that links directly to my existing SQL Server database, fetches WS-GROSS-RECEIPTS, and returns the correct WS-LIC-TAX for each record. The core rule is simple—multiply gross receipts by 0.005—yet the script must recognise when a licence falls under a “Flat Fee” category. In those cases, and whenever receipts sit below the defined threshold, the percentage is bypassed in favour of the fixed minimum (currently $200.00, held in a constants section you will expose for easy updates). Police Fund licence types keep their prevailing 0.5 % rate. Multiple licence types will flow through the same routine, so the code should evaluate the type field, decide which calculation path applies, and write the resulting tax back to the database (or return it as ...

I need a single Power Apps solution that streamlines our entire purchasing cycle—from the moment a vendor is onboarded to the point a bill is settled and reflected in the ledgers. The same app must run smoothly on both desktop and mobile so that Managers, Vendors, Accountants, and our internal Maker/Checker roles can switch devices without losing functionality or data consistency. Scope of work The build should cover vendor management, invoice processing, purchase orders, purchase returns, bills-paid and bills-payable tracking, along with dedicated ledgers for vendors, transactions, projects, and materials. Role-based security is essential so each user group only sees the data and actions relevant to them, while the Maker/Checker flow ensures approvals are formally logged. Delive...

I have several sets of structured data in spreadsheets and simple database exports that I need transformed into a clear, insight-rich summary. The work centres on cleaning the files, running descriptive statistics, creating intuitive visuals, and assembling a concise narrative that highlights the most important findings. You’ll receive the raw CSVs and a small MySQL dump. Feel free to work in Python (pandas, matplotlib, seaborn), SQL, Excel, or any comparable stack you prefer—as long as the workflow is reproducible and I can rerun it later if the data updates. Deliverables • A cleaned, well-documented dataset • A short written report (PDF or slide deck) that explains trends, aggregates, and any unexpected patterns in plain language • Visualisations and/or...

I need a tailor-made LAB module for Odoo 17 that will let my manufacturing team record every product sample and immediately see what stage it is in. All entries will be done manually for now, so the interface must be fast, error-tolerant, and easy for operators who are not barcode or RFID experts. Later on I may add scanning options, but the first milestone is a rock-solid manual entry flow. Once the data is in, I want decision-ready insight, not raw tables. The module should generate interactive reports that combine: • Real-time analytics (current queue, pending tests, turnaround times) • Historical trend views (weekly, monthly, yearly) • Side-by-side comparison charts for batches, lines, or shifts Charts need to refresh inside the Odoo dashboard, with drill-downs...

We are looking for a specialist to support our data operations Team based in Egypt (remote), specifically focused on webcrawling, API's, ELT, BI and data operations tasks. Any experience with building AI agents into the workflows or experience with N8N that is is nice to have add on. We are looking exclusively for people in Egypt. We agree weekly on 10 hour work packages and will asses the work quality and deliverables also on weekly basis prior to payout. skills & experience required: - Proven experience designing and implementing robust ETL pipelines for large-scale, heterogeneous data sources - Strong proficiency in building and maintaining custom web crawlers and data scrapers using tools like power automate desktop, Javascript or similar frameworks - Expertise in handling ...

Hi, I need some help with Kronos Configurations

I’m in a time sensitive sprint to complete Harvard’s CS50: Introduction to Computer Science and I’m looking for someone who has already completed CS50 to work closely with me and guide me through the remaining assignments step by step. The goal is to finish all remaining problem sets and the final project within the next 3 to 4 days with focused, hands on support. Course coverage includes: Week 0: Scratch Week 1: C Week 2: Arrays Week 3: Algorithms Week 4: Memory Week 5: Data Structures Week 6: Python Week 7: SQL Week 8: HTML, CSS, JavaScript Week 9: Flask Week 10: Final Project Where I’m at: I understand the concepts, but I still run into friction translating ideas into clean, efficient code that passes check50 and style50 consistently. I want help breaking down...

I’m looking for a data-savvy partner who can turn a raw set of finance-sector customer transaction data into clear, insightful storylines. My priority is descriptive analysis: I want to understand what has happened—patterns in spending, seasonal spikes, product uptake, and any anomalies that jump off the page. Here’s what I’ll hand over: • Raw customer transaction files (CSV/Excel). • A brief explaining column meanings, business context, and any compliance notes. Here’s what I’d like back: • A cleaned, well-documented dataset ready for future work. • An exploratory data analysis notebook or script (Python, R, or SQL) with comments so I can reproduce every step. • A concise slide deck or PDF report highlighting key metrics...

I need support turning several raw transactional and user-behaviour datasets into clear, decision-ready insights for an upcoming strategy review. The work is fully freelance and centers on data analysis, so skills in Python (pandas, NumPy, scikit-learn), R, SQL, or a comparable stack are essential. Expect to begin with cleaning and normalising PostgreSQL and CSV data, move on to exploratory and statistical analysis, and finish with a concise report and visualisations that non-technical stakeholders can understand. A lightweight Power BI or Tableau dashboard would be an appreciated bonus if it helps stakeholders drill deeper on their own. Deliverables • Re-run-able, well-annotated scripts or notebooks • A short methodology note explaining assumptions and modelling choic...

I’m seeking dependable help for ongoing data-entry work that centres on Microsoft Access database management. A few hours spread across the week will be enough to keep our existing Access file clean, current, and functioning smoothly. You’ll take raw spreadsheets I supply, import them, validate the new records against existing tables, and flag or fix duplicates before they cause problems. On quieter days I may ask you to tweak simple queries, update look-up lists, or generate quick summary reports, so solid familiarity with Access forms, tables, and basic SQL is essential. Accuracy matters more than speed, yet I still expect regular progress updates and a final confirmation once each batch is fully processed. If you already have a reliable routine for versioning and backu...

I’m building a solid prospecting base for my aviation-services business and need a structured dataset that lets me quickly understand both aircraft details and the repair stations that keep them airworthy. Here’s what I want to walk away with: a clean, up-to-date spreadsheet (or SQL/CSV if you prefer) that pairs aircraft information with nearby or commonly used repair stations. While I’m ultimately using the data to market my services, depth and accuracy matter more to me than sheer volume. Aircraft data • The essentials must include tail number, make/model, year, and current owner/operator. • Where easily obtainable, please add technical specs, last major maintenance events, and any publicly available maintenance tracking notes. Repair-station data ...

I’m ready to bring Oracle’s pre-built EPM EPM Digital Assistant online and need an expert who can get it configured, deployed, and fully integrated inside our DEVELOPMENT environment. The focus is on the standard Oracle EPM skill set—no heavy customisation this round—yet the assistant must still talk seamlessly to the rest of our EPM Cloud services (Planning, FCC, ARCS, and any others we enable down the road). Here’s what the engagement looks like: • Spin up and configure the standard Oracle EPM Digital Assistant in our dev tenancy, following Oracle best-practice security and naming conventions. • Connect the assistant to existing EPM modules so users can query, retrieve, and manipulate data straight from chat. • Hand over concise, step-...

I need a flow in Microsoft Power Automate that pulls KPI values from our SQL Server tables and turns them into polished, user-friendly PDF reports. The report must rely on a custom-designed template and display information with a mixture of charts, graphs, and tables so non-technical stakeholders can grasp trends at a glance. Our priority metrics revolve around operational efficiency—think throughput, cycle time, and utilisation—so the layout should spotlight those numbers first while still letting me expand to other KPIs later. The ideal solution lets me choose a date range (or other common filters) and then either schedule or trigger the report on demand. Once generated, the PDF should save to SharePoint and email key managers automatically. I am comfortable giving you read ...

Experienced DotNet developer required for Errors removal and Improvement work in thenafter Host on server. Developer should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - 1st User emailid- userany303@gmail.c Password- kaspersky 2nd User emailid- userany444@gmail.c Password- kaspersky At present, All functionalities of explained in below link- Errors removal and Improvement work which needs to be done explained in below doccument link- For better understanding, Sample of Previous developer's mentioned Tested Results explained in below link - Mention ‘TESTED RESULT' in below doccument link after hosting on ‘Test server’ after completion of 'Errors remo...

I’m almost ready to sit the Snowflake certification but still lack high-quality practice exams that truly reflect the test. I need a set of original, full-length exams—timed and weighted like the real thing—with clear answer keys and explanations so I can understand not just what’s right but why. Scope • Three complete mock exams at minimum, each covering the three focus areas I selected: data warehousing concepts, SQL queries, and security & data protection. • Balanced question distribution and difficulty that mirrors Snowflake’s blueprint. • Detailed rationales for every answer, including references to official documentation where relevant. • Delivery in a format I can take repeatedly (PDF, Google Form, or a lightweight web i...

I need an end-to-end, web-based hospital network system written in ASP.NET (C#) with a SQL Server back-end. A single login page must offer a drop-down for ADMIN, DOCTOR, RECEPTION, USER/PATIENT and LAB; once a role is selected, only the relevant dashboard, menu and permissions load. Every module also keeps its own accounting ledger that later rolls up to an admin-level view. Core scope • Clinic & Medical Store – Inventory Management, Appointment Scheduling, Billing and Payments are mandatory, with any supporting tools (prescription-to-stock sync, stock alerts, discount handling) that make day-to-day work frictionless. • Lab – Test Management, Sample Tracking and Report Generation, plus the auxiliary features a modern lab needs such as barcode labels, ...

First, I want the data layer to communicate with external accounting services through a REST-style API. The module should issue authenticated HTTP requests using only the methods I plan to expose—GET, POST and PUT—to push or pull records between the database and providers such as InFakt or Betterfly. I expect clean, asynchronous calls via HttpClient (or another modern .NET approach), clear error handling and concise helper classes that make future endpoint additions straightforward. Second, the system must generate invoice exports. When I select ‘Faktury’ in the UI, the code should collect the relevant rows and create XML files that fully respect the FA(3) KSeF structure. The output has to validate against the official XSD so that I can upload it to KSeF without ...

Project Requirement (Step-by-Step Implementation) DATASET - Requirements - (Fully clear implementation with explanation and workings) Step 1 — Business Question & Topic Framing The notebook should clearly define the business problem: Question: “In a given city, which business categories look most promising to start a new business, and what factors correlate with high customer ratings?” Expected outputs: Top 10 “high-opportunity” business categories in the selected city A short checklist of key success drivers derived from data A simple predictive model to classify businesses as High Rated vs Not Step 2 — Input: Import Data from Web Dataset Files Use the public Yelp Open Dataset Programmatically read: optionally a sampled Parse JSON...