SQL Jobs

I want a sleek, self-refreshing Power BI dashboard that pulls customer counts from two sources—an Excel file and our Databricks environment—and visualises the 12-month trend for each line of business across Brand A, Brand B and Brand C. The core visual should be clean line charts with a rolling monthly view, allowing users to toggle brands or drill down by product line without losing the last-year perspective. You will work with my existing Databricks SQL endpoint (I’ll share the cluster URL and credentials) and a locally stored Excel workbook. I need the model set up so both sources refresh automatically through the Power BI gateway and any new month appended to either source rolls straight into the visuals. Deliverables • A .pbix file containing the data model, r...

Our in-house document management platform has been running smoothly on a C#/.NET stack, MS SQL Server, and AWS for several years, but the developer who built and nurtured it is leaving. I need someone who can step in right away, understand the codebase, and keep the application stable and performant. The immediate focus is routine maintenance—diagnosing and fixing any bugs that surface and squeezing better performance out of the code, database, and AWS resources. I don’t have a current list of issues, yet I suspect the usual mix of edge-case errors and slow queries will emerge once you start profiling the system. You’ll get full access to the Git repository, SQL scripts, and our AWS environment (EC2, RDS, S3). A thorough walkthrough with the departing developer can be a...

Power BI – Talent Acquisition Control Tower & Executive Dashboard We are looking for an experienced Power BI Developer / HR Analytics Specialist to build a comprehensive Talent Acquisition Control Tower & Executive Dashboard. This is not a basic visualization project. We need a scalable recruitment analytics solution covering the full recruitment lifecycle: Requisition → Sourcing → Screening → HM Review → Interview → Selection → Offer → Acceptance → Joining → Closure The solution must support both daily recruitment operations and executive-level reporting. 1. Recruitment Overview & Demand vs Delivery Track: * Total Requisitions * Total Openings/Vacancies * Open / Closed / Hold / Cancelled * Sourcing / Interview / Offer /...

I have a production oracle instance that has grown beyond 100 GB and it now needs to live on SQL ,Server postgres sql . The task covers everything from preparing the source, mapping the schema, transferring the data, and validating that every object—tables, views, functions, and constraints—behaves exactly the same once it lands in SQL Server. Here is what I expect to walk away with: • A fully migrated SQL Server database, ready for cut-over • A repeatable migration script or SSIS/ADF/DMS pipeline so I can re-run the process for future refreshes • A concise migration report highlighting any datatype conversions, performance tweaks, and objects that required special handling • Verification scripts or queries that prove row counts, checksums, and refe...

I’m putting together a lightweight ERP foundation and need a clean, well-structured VB.Net solution that I can grow over time. The stack is fixed—VB.Net with DevExpress WinForms controls on the front end and PostgreSQL on the back. Core scope The project centres on three building blocks: a secure login screen, a ribbon-style main menu, and one fully functional CRUD form that will serve as the model for future modules. Authentication must recognise three separate roles—Administrator, Manager, and Employee—and enforce granular permissions once the user is inside the application. Main menu expectations After a successful login the user should land on a DevExpress-based menu that exposes the Reporting Module, Settings & Preferences, and User Management. Menu...

I need an Oracle APEX application that streamlines one of our internal business processes from start to finish. The focus is a clean, permission-based workflow that automatically routes each new record through a multistep approval cycle. At a minimum the app must: • Capture data through responsive APEX forms • Trigger an approval workflow the moment a record is submitted • Update status, log every decision, and prevent users from skipping steps When an approver acts, the system should move the item to the next stage, send the correct email or in-app notification, and maintain an audit trail we can export to CSV or view in a dashboard. I will provide table definitions and sample data; you’ll translate that into APEX pages, processes, and any PL/SQL packages req...

I’m kicking off a new healthcare patient-management system and the first critical piece is a rock-solid, compliant data layer. The entire scope at this stage revolves around database management—designing, building, and documenting a schema that can safely house patient records, appointments, clinical notes, and billing details while meeting HIPAA-level security expectations. Here’s what I need from you: • Analyse typical patient-care workflows and translate them into an efficient relational model. • Deliver an ER diagram, a fully normalised schema, and an indexing strategy suitable for high-volume queries. • Implement the model in the SQL engine you recommend (PostgreSQL, MySQL, or MS-SQL are all fine if they cover encryption-at-rest, robust backup, a...

I need a purpose-built IoT inventory platform that keeps every tool in my auto shop accounted for and instantly searchable from a tablet on the workshop floor. The interface has to feel at home on an iPad or similar device—large touch targets, quick loading times, and an offline-tolerant design so my technicians can still work if Wi-Fi drops for a moment. Core workflow Technicians will scan or tap a tagged tool, confirm where it is going, and the system updates our stock level and location log. When a tool hasn’t been returned or its quantity falls below a preset threshold, the platform should flag it on the dashboard and optionally push a notification. I’m open to common tag technologies such as BLE or passive RFID; the software just needs a clean way to map tag IDs to ...

I have a collection of well-formatted CSV files and a live SQL database that I need to turn into clear, insightful visuals. The core of this engagement is data visualization—using Python to translate rows and columns into plots, dashboards, or interactive charts that quickly communicate trends and outliers to non-technical stakeholders. You will have direct access to the structured data; most of it is already clean, so the emphasis is on choosing the right libraries (Pandas, Matplotlib, Seaborn, or Plotly—whatever suits the story best), crafting reusable code, and presenting the results in a concise, easy-to-update format. If you are comfortable adding light data-cleaning steps or basic statistical summaries along the way, that flexibility is welcome, but not required. De...

I have a growing file of U-S customer email records that first need to be keyed in accurately and then grouped into meaningful customer segments. The work starts with straightforward data entry—importing every record exactly as provided into a master spreadsheet or my HubSpot CRM—before moving on to customer segmentation that relies on one critical attribute: each contact’s Medical code. Once every line is in place, I’d like you to segment the list so I can target campaigns with precision. Feel free to use Excel, Google Sheets, or an SQL-friendly tool for the entry phase; for the segmentation itself, you can stay in the same environment or switch to Python / R if that speeds things up. Consistency and zero typos are essential because these addresses feed directly...

Developer Brief Build a secure, cloud-based sports performance data platform that consolidates data from multiple technology providers into one dashboard. This is an example dashboard I have built The initial scope is to integrate Catapult Sports, VALD, and Teamworks. The platform must support both API-based data ingestion and manual or automated uploads of Excel/CSV files. API connections should retrieve approved data on a scheduled basis, while spreadsheet imports should validate, map, and standardise fields before storage. Create a central database with a consistent athlete profile and identifiers, enabling data to be matched across systems. Athlete matching should prioritise unique IDs and verified email addresses, with an administrator review process for unmatched or duplicate rec...

I want to commission a full-featured hospital management system that natively integrates with the Ayushman Bharat Digital Mission (ABDM) stack. The application must streamline day-to-day operations for Out-Patient, In-Patient and Emergency departments while guaranteeing smooth data exchange with ABDM services such as Health ID creation, HIP/HIE-CM consent flows and e-prescriptions. Core modules I need: • Patient management covering registration, OPD/IPD admissions, discharge summaries and encounter history that can be shared via ABDM. • Inventory management for pharmacy and medical supplies with real-time stock, expiry and reorder alerts. • Billing & accounting that supports cashless, insurance and government scheme workflows, generates GST-compliant invoices and ...

I’m rebuilding a web application from scratch and need a seasoned JavaScript developer who is equally comfortable on the browser and in Node.js. On the front-end I want clean, intuitive screens, a fully responsive layout, and smooth API integration. I’ll rely on you not only to code those pieces but also to show me the best way to push user-generated data up to a database. Server-side, you’ll wire everything together in Node.js and expose the endpoints the UI depends on. Part of the work involves calling Claude AI, so familiarity with its SDK, streaming responses, and prompt design will save us a lot of trial and error. I haven’t settled on a data store yet—SQL or NoSQL are both on the table—so I’d value your guidance on choosing and provisio...

Senior Data / AI Engineer - Marine Data, APIs, Web Scraping & Machine Learning We are building a new AI-powered technology platform that works with large amounts of marine, oceanographic, weather, environmental, geographic and destination data. We are looking for a strong Data / AI / Machine Learning Engineer to help build the data and intelligence infrastructure behind the platform. This is not primarily a frontend or UI development role. We need someone who is very comfortable working with large datasets, APIs, web scraping, automated data pipelines, geospatial data, historical and forecast data, oceanographic datasets, and scoring/recommendation models. Experience working with marine weather, oceanographic, coastal or environmental data is a major advantage. What you will work...

We are looking for an experienced Software / System Architect to design and review the architecture of a closed-loop financial platform. The platform includes user accounts, balances, transactions, deposits/withdrawals, trading, payments, wallet functionality, and administration. We already have a development team and an existing system. We need an architect who can review the current setup, identify gaps, design the overall system architecture and flows, and provide clear technical guidance and architecture documentation for our developers. Experience with FinTech, payment systems, trading platforms, digital assets, banking, or other transaction-heavy financial systems is highly preferred. Please share relevant architecture experience and examples of similar systems you have worked on...

I have a Sage 50 (Canadian edition) company that stores its data in MySQL-style *.frm files. After repairing corruption outside of Sage, all tables now exist only as clean exports—both *.sql dumps and matching *.csv files. My challenge is getting that data back into the working Sage50 MySQL repository so the program will recognise the company and let me complete the fiscal year-end rollover. I would like this project completed as soon as possible. Here’s the current state: • Schema files: original Sage-generated *.frm files still sitting in the data folder. • Data files: full content available in *.sql and *.csv formats. • Problem: attempts to re-import keep failing because Sage50 expects its exact table structure, indexes, triggers and constraints. Error...

I am building an end-to-end Python solution that automatically ingests, processes, and reports on financial data pulled from CSV files, SQL databases, and live APIs. Clean, well-structured, and easily maintainable code is essential because the system will be extended over time. Scope of work You will take the project from initial design through deployment. That includes setting up the data-collection pipeline, writing transformation and analysis modules, implementing robust error handling and logging, building unit / integration tests, and preparing a production-ready deployment script or container. The stack is entirely Python, so I expect idiomatic use of tools such as pandas, SQLAlchemy, asyncio, and, where it adds value, lightweight AI/ML components for anomaly detection or forecast...

Cloud Pricing Validation & Test Automation Framework Designed and developed an end-to-end Python automation framework to scrape and validate cloud pricing data from AWS and Azure platforms. Built Selenium-based UI automation using the Page Object Model (POM) and PyTest framework to validate pricing calculators, search functionality, filters, and region selection. Implemented API validation using the requests library to compare pricing data with scraped UI data. Automated data storage in SQLite and performed SQL-based validation for duplicates, missing values, and historical price comparison. Generated HTML execution reports, detailed logs, CSV/Excel summaries, and dashboards to monitor pricing changes and regression results. Integrated modular architecture with reusable utilities, con...

SAP S/4HANA Greenfield Implementation for Procure-to-Pay (P2P) Description Implemented end-to-end SAP S/4HANA solution using SAP MM for procurement and inventory processes, ensuring seamless system transition with high data accuracy. Roles &Responsibilities ? Configured end-to-end Procure-to-Pay (PR, PO, GR, LIV) in SAP S/4HANA, improving procurement efficiency by 20%. ? Designed and configured pricing procedures and account determination (OBYC), reducing invoice mismatches by 25%. ? Set up enterprise structure and master data (Material Master & Business Partner) for procurement processes. ? Executed data migration using LSMW/Migration Cockpit with 99% data accuracy. ? Implemented subcontracting and consignment processes for complex procurement scenarios. ? Ensured seamless cross-m...

CORE-103 Data & SQL Foundations. 10 topics. Almost every system these students build or support will store its data in a relational database, and almost every serious production incident involves one. From what a database is for through querying, joins and aggregation to schema design, transactions and indexing. Real time goes to reconciliation - checking that a query returned the RIGHT answer rather than a plausible one - because a wrong number delivered confidently is worse than no number at all. Note: this course shares ground with DB-101, the Databases track foundation, at a much shallower depth. You will be asked to coordinate with that trainer so the two reinforce rather than repeat each other. THE 10 TOPICS — FIXED 1. What a database is for (6 h) - persistence, con...

I have a dataset that must be loaded into our online database without errors and, at the same time, I want the source text that accompanies each record rendered in both Spanish and simplified Chinese. All source material is in English and arrives as clean text files; your job is to: • Populate every field in the database exactly as specified in the schema I will share (SQL-based back-end with a web form for input). • Translate the English content into Spanish and Chinese before the final save, keeping sentence structure natural and industry terminology consistent. I will give you step-by-step screencasts on how to access the system, a glossary of preferred terms, and a small test batch so we can confirm quality. I expect native-level accuracy in both languages, correct char...

I’m looking for onsite training in Oracle Fusion Cloud Procurement who is located in Bangalore near by electronic city. I'll be coming to your location to learn any project you have done on below mentioned modules. My immediate focus spans the following functional areas: • Supplier Management • Sourcing • Procurement Contracts • Self Service Procurement . integrations Day to day, I may ask you to review or adjust existing configurations, troubleshoot workflow or approval issues, walk me through best-practice setups, and document any changes so I can maintain them moving forward. Clear explanations, quick turnaround on questions, and the ability to share screens while we work through solutions will be essential. If you have proven experience guidi...

The project centres on my raw sales data, delivered to you in a mix of CSV files and Excel spreadsheets. I need the full analytical pipeline built and documented so that anyone in my team can reproduce it. First, consolidate every source in Excel and use Power Query to remove duplicates, fix date and currency formats, and create calculated columns that will later support trend analysis, sales-performance comparisons and customer segmentation. Keep the transformation steps clearly named and ordered so that refreshing future files is one click. Next, publish the cleaned table to Power BI and design an interactive, professional-looking dashboard. Key visuals should highlight monthly and quarterly trends, compare performance across product lines or regions, and let the user dive into custome...

Analyzed sales data using Excel, SQL and Power BI to identify sales trends, top-performing products, revenue insights and business performance. Created an interactive Power BI dashboard with KPIs and visualizations to help users understand the data and make better business decisions.

I have a two-part project that blends data science with creative rendering. First, I need to mine our operational data to uncover clear, actionable insights that will streamline internal workflows. You’ll have direct access to our raw logs and performance metrics; from there, I’m expecting clean data pipelines, exploratory analysis, and models or dashboards that highlight where we can cut cycle time, reduce error rates, and better allocate resources. Python (Pandas, scikit-learn), SQL, or a similar stack is ideal, but I’m open to the tools you find most efficient as long as the findings are reproducible and clearly documented. Second, I want a series of polished 2D and 3D character renders that visualize key personas involved in those optimized processes. Think engagin...

I have several enterprise-scale integration and data-migration initiatives kicking off right now and need an Azure Data Factory specialist who can jump in immediately for at least the next two months. The work centres on building, troubleshooting and optimising ADF pipelines that: • extract data from SQL Server and other database engines, plus a range of APIs (including Salesforce and S3 endpoints), • apply complex, rule-driven transformations, and • load cleansed results into a variety of target systems. You will own the whole lifecycle—from designing linked services and parameterised datasets, to writing highly-tuned SQL, to setting up monitoring and alerting so everything runs reliably at scale. I’ll look to you to surface and solve performance issues ...

Our company has amassed a rich set of customer data from CRM, support tickets, and usage logs, and I need a full prescriptive analysis that pinpoints actions we can take to boost retention. The work goes beyond describing what has happened; I need to understand why customers leave, simulate what-if scenarios, and receive clear, prioritized recommendations I can implement right away. You will have direct access to anonymized customer records, churn labels, engagement metrics, and marketing touchpoints. I expect you to apply statistical modeling or machine-learning techniques of your choice, validate findings rigorously, and convert them into concrete retention strategies—loyalty offers, upsell timing, personalized messaging, or workflow changes—complete with expected impact. D...

Our company has amassed a rich set of customer data from CRM, support tickets, and usage logs, and I need a full prescriptive analysis that pinpoints actions we can take to boost retention. The work goes beyond describing what has happened; I need to understand why customers leave, simulate what-if scenarios, and receive clear, prioritized recommendations I can implement right away. You will have direct access to anonymized customer records, churn labels, engagement metrics, and marketing touchpoints. I expect you to apply statistical modeling or machine-learning techniques of your choice, validate findings rigorously, and convert them into concrete retention strategies—loyalty offers, upsell timing, personalized messaging, or workflow changes—complete with expected impact. D...

My priority is to build and refine Microsoft Dynamics 365 Business Central through new AL objects, with the spotlight on custom tables and pages. These pages must support clean data entry, run their own validation, trigger custom workflows, and surface key metrics in dashboard-style reports. Beyond the UI layer, I need business logic that enforces bespoke validation rules and handles data integration processes so information moves reliably between internal modules and any external systems we connect later. Additional work will include, when required, adjusting RDLC or Word layouts for reports, extending posting and approval workflows, exposing data through APIs or web services, and tuning SQL for performance. Deliverables • AL code for tables, pages, and supporting codeunit...

I have several datasets coming in from different systems where the numeric fields are stored as plain ASCII files in some cases and UTF-8 exports in others. My goal is to run solid, reproducible data analysis on them, but first they need to be cleaned and standardised. Here is what I need from you: • Build a repeatable cleaning pipeline in Python (Pandas, NumPy) that detects the file encoding, converts everything to UTF-8 where necessary, and validates that all numeric columns are truly numeric—no stray characters, misplaced separators, or locale-specific quirks. • Where the raw files already sit in SQL Server, create T-SQL or Python-based routines that achieve the same checks and corrections in-database so I can schedule them in an Agent job. • Document each s...

My MySQL 5.5.18 instance is limping along after a corruption event—system tables open, but every InnoDB table throws errors. The server is only “partially functional,” so I have powered it down and kept all data files intact (ibdata, ib_logfile*, .frm, .ibd, relay/binlogs, ). Remote log-in isn’t possible; you will need to walk me through everything step-by-step while I work directly on the box. What I need is a complete, reliable FULL backup of every database, including the damaged InnoDB tables, so I can spin up a fresh 5.7+ server later. I am comfortable following detailed terminal commands; I just need an expert plan and real-time guidance to: • Mount the data directory in a safe environment (ideally using Percona XtraBackup, mysqlbackup, or a comparable t...

I manage our university’s Student Information System and need a technically savvy partner to keep it running at peak performance while we expand its capabilities. Day to day, the work ranges from fine-tuning system configuration, maintaining a clean permission hierarchy, and automating routine admin tasks, through to digging into database queries when the system slows down or an integration drops data. You’ll be hands-on with: • System configuration & ongoing management • User account lifecycle, roles, and permissions • Reporting, analytics, and custom queries Current pain points I want resolved quickly: • Intermittent performance slow-downs during high-traffic periods • Data integration failures between the SIS and our LMS/HR platforms ...

I have raw sales tables sitting in a SQL-based database and I need them transformed into a clean, interactive dashboard that lets me track monthly revenue growth at a glance. The core KPI is that single figure, but the design should leave room for additional views—regional performance comparisons and top-selling category trends—so the board can evolve without a rebuild. You’re free to use the platform you feel delivers the best user experience; Tableau, Power BI, or even Google Data Studio are all acceptable as long as the final product is fast, visually clear, and can connect directly to my SQL schema. I’ll provide database credentials and an ERD. You’ll handle the data pull, modeling, and visual layout, then publish or package the dashboard so I can share i...

# Data Engineer – Remote Contract We are looking for an experienced Data Engineer to join a remote technical project supporting an international client. * It is an open contract and you get paid monthly. ### Requirements • 2–4 years of professional Data Engineering experience • Strong Python and SQL skills • Hands-on experience with Apache Spark • Experience with Airflow, Dagster, or Prefect • Experience with dbt and modern data pipelines • Knowledge of Snowflake, BigQuery, Redshift, or Databricks • Experience with AWS, Azure, or GCP • Strong understanding of data modeling and Git workflows • Experience working with production data pipelines • Strong spoken and written English communication skills ### Nice to Have • K...

I have a dataset that needs a focused trend analysis and I’d like your help with the data cincse side of things. What matters most to me is uncovering clear patterns, explaining what drives them, and presenting the results in a way that makes next-step decisions obvious. Here’s what I have in mind: • Work through the raw data, clean it where necessary, and structure it for analysis. • Carry out the core trend analysis, highlighting any seasonality, upward or downward movements, and outliers that deserve attention. • Summarise the findings visually—charts, dashboards, or other intuitive visuals—so stakeholders can grasp the story at a glance. • Deliver a concise report (code notebook or slide deck) that walks through your methodology and ke...

We are seeking an experienced Full Stack Developer to support the development and enhancement of modern web applications. The ideal candidate will have strong experience building scalable front-end and back-end solutions, developing APIs, working with databases, and collaborating with engineering teams to deliver high-quality software. The role involves developing and maintaining user-facing applications using technologies such as React, Angular, Node.js, .NET, or Java. Responsibilities include building and integrating REST APIs, working with SQL and NoSQL databases, troubleshooting application issues, improving existing features, participating in code reviews, and supporting continuous improvement of development practices. Experience with Git workflows and cloud deployment environments...

Cuento con más de diez tablas en Visual FoxPro 8, cada una con menos de 1000 registros y con datos mixtos (numéricos y texto). Necesito llevarlas a PostgreSQL 18 y, sobre todo, dejar listo un mecanismo reproducible para repetir la migración en producción sobre una base vacía. Alcance solicitado 1. Crear en PostgreSQL 18 una base de datos que respete la estructura de las tablas que proporcionaré (nombres de campos, tipos de datos, índices y claves). 2. Migrar el contenido actual de todas las tablas, verificando integridad y consistencia. 3. Entregar los programas, formularios o rutinas en Visual FoxPro 8 que permitan repetir el proceso de migracion cuando la base de producción esté lista. Acepto que uses ODBC, scripts ...

En lo técnico necesito nivel sólido de React con TypeScript y buen manejo de SQL (consultas, esquemas, optimización básica). El punto clave es Claude Code: buena parte del código existente fue generado con esa herramienta, así que necesito a alguien que sepa leer y entender esas estructuras sin perderse, y que además trabaje con ella de forma eficaz — gestionando bien el contexto, iterando y revisando el output. No busco ni a quien la use a ciegas ni a quien la evite. Más allá del stack, valoro la autonomía: te doy el objetivo y lo resuelves. Entregas completas, sin dejar cosas a medias. Comunicación directa y rápida. Y criterio para decirme que algo está mal planteado antes de construirlo, no...