Sql Projects

Flutter App Deployment — iOS App Store + Android Play Store

Required Skills (must-have) Flutter 3.x / Dart (3+ years) iOS deployment: Xcode, Apple Developer Portal, App Store Connect Android deployment: Android Studio, Google Play Console, keystore signing Firebase integration (google-services.json, APNs setup) Social auth: Google Sign-In, Apple Sign-In, Facebook Login Supabase experience (running SQL migrations, RLS, auth providers) CocoaPods (for pod install) Experience uploading to App Store + Play Store Nice to Have Experience with Agora RTC Flutter BLE / Bluetooth (for QC Band) Experience with sign_in_with_apple and google_sign_in packages "Flutter app is 100% code-complete (269 files, 75K lines). Needs environment setup, signing, social auth credential configuration (Google/Apple/Facebook), Firebase config files replaced with real ones, SQL migrations run in Supabase, and submission to App Store + Play Store. Estimated 10–12 hours of actual work. All code, migration files, and a step-by-step deployment guide are provided."

opportunity

API data reporting- Ecommerce marketplaces

Project Title Margin Reporting System – Multi-Source API Data Integration into On-Prem SQL Database Overview We want to build an automated margin reporting system that pulls commercial and operational data from multiple sources via API, standardises it, and stores it in a SQL database hosted on our on-site server. This database will then be used to report margins across products, customers, and orders. The goal is to replace manual reporting and create a reliable “single source of truth” for margin analysis. Objectives Pull data from multiple platforms via API on a schedule Store raw + cleaned data in a structured SQL database Calculate margin metrics consistently Produce reporting-ready tables/views for Power BI / Excel Data Sources (initial) - Shopware (orders, customers, products, pricing) - Exact Globe - Helm / Neuro by despatch company - Ebay / amazon and other marketplaces Key Outputs 1) SQL Database Schema Raw tables (staging layer) Cleaned tables (standardised layer) Reporting layer (margin-ready views/tables) 2) Automated Data Sync Scheduled API pulls (daily, or hourly depending on limits) Incremental updates (not full reload every time) Logging of sync success/failure 3) Margin Logic Margin calculation should support: Revenue (net of VAT) Discounts / vouchers COGS (purchase cost, supplier cost) Shipping income vs shipping cost Payment fees (optional) Returns / refunds / credit notes Deliverables Working data pipeline (API → SQL) Database schema + views Setup instructions for server deployment Documentation of API endpoints used Error handling + logs Handover session (1 hour)

Aged payable summary page in Power bi

We provide financial reports to our clients at period end and are currently looking for help with a new report page to display an Aged Payables Summary in Power BI, similar to the format available in Xero. The report needs to be dynamic and respond to the period selected within the Power BI report. The data source is Xero. We use an ETL service to extract the data from Xero and load it into a SQL database, which then serves as the data source for the Power BI report. The report currently utilises the following Xero tables: Journal Invoices Accounts Organisation Tracking Categories we are looking for someone who has already worked on Data from Xero or have created a dynamic Aged payable Summary in Power BI. We would be happy to arrange a meeting to discuss the project requirements in more detail.

Senior BI & Analytics Consultant

Our travel-focused platform runs on data, yet we are still hitting a few roadblocks: reports occasionally contradict each other, web experiments take too long to interpret, and we know there is hidden opportunity to move our conversion rate even higher. I want a senior-level mind to step in, find the story inside our numbers, and turn it into dashboards, recommendations, and winning test results. Scope and priorities • First, tighten the data foundation. Using Snowflake and Oracle you will write advanced SQL and, through dbt models scheduled in Airflow/Astronomer, ensure every metric is trustworthy. Eliminating inaccurate data reporting is the immediate win. • Second, elevate visualization. You will rebuild our Tableau estate so executives see traffic analysis, KPIs, and conversion funnels at a glance, with lightning-fast load times. • Third, unlock experimentation insights. Our Optimizely programme is active but under-analysed; you will pair the raw results with Adobe Analytics to resolve current difficulties in A/B testing analysis and surface clear next steps for site performance and personalization. Key tools in play include Tableau, Adobe Analytics, Optimizely, Snowflake, Oracle, dbt, Airflow, and Git for version control; deep knowledge of each is essential. A background in e-commerce, travel, or hospitality analytics will help you understand our audience and move quickly. Deliverables 1. Clean, documented SQL/dbt models feeding a single source of truth. 2. At least three executive-ready Tableau dashboards displaying website performance, traffic, and conversion rate optimization metrics. 3. A repeatable Optimizely analysis framework (queries, templates, slides) that shortens the time from test completion to decision. 4. A concise narrative deck highlighting insights, wins, and next steps—data storytelling that lands with non-technical stakeholders. Please attach or link to previous Tableau dashboards or BI work that demonstrate similar challenges solved. I will shortlist and invite a brief technical chat to confirm fit before kickoff.

Full stack .Net developer with broad Azure experience

We are seeking a highly proficient Full Stack .Net Developer with extensive Azure expertise to assist in the development of various web applications and address a variety of project requirements. Working directly with the MD, who will provide briefs and guidance on achieving our development objectives. This role offers an ongoing opportunity for a dedicated professional, picking all sorts of tasks and requirements either developing/patching existing developments or taking on new briefs. My hope is to partner up with an ace freelancer on an ongoing basis. Fluency in English is essential, with a preference for native speakers - please do not apply if you're in any doubt about your English! Key skills required include • Full stack .Net developer • css • Javascript • Broad Azure experience • Azure identity management • Azure devops • Git • SQL database management I can offer more details on request, regards the work we're doing, but for brevity, will only engage with those that I feel meet the above requirements (sorry). We're planning to pay by the hour for each task, with the potential for a consistent workflow as you familiarise yourself with our technology and processes.

Web3 + Supabase Developer Needed

We are building a production-ready Web3 waitlist and dashboard platform using Next.js 15 (App Router), BSC Testnet, Supabase, and Wagmi v2. The core architecture, database schema, and feature roadmap are already defined. We are looking for an experienced developer to complete, polish, and harden the project. This is not a prototype — the goal is a fully working, deployable system with clean code, security best practices, and proper Web3 UX. Required: Next.js 14/15 (App Router) TypeScript Wagmi v2 + WalletConnect EVM chains (BSC preferred) Supabase (Postgres, RLS, triggers, SQL functions) Tailwind CSS Web3 transaction handling & logging Nice to Have: Discord bot development (Node.js) OAuth 2.0 (X / Twitter) Smart contract interaction (staking contracts) Framer Motion shadcn/ui / Radix UI

Make the code work

We are seeking a skilled developer with expertise in both front-end and back-end technologies to seamlessly integrate and optimize our web and app functionalities. The ideal candidate should be proficient in PHP (Laravel) or Node.js for backend development, and React, Vue.js, or clean Blade templates for mobile-responsive frontend design. A strong understanding of MySQL is essential. Your role will involve taking provided code and SQL updates, ensuring proper implementation while maintaining a well-organized file and folder structure. Availability for at least five hours daily is required to facilitate smooth collaboration during the development process.

PL/SQL AND ORACLE APEX DEVELOPER

We are seeking a proficient PL/SQL and Oracle APEX developer to join our project team. The ideal candidate will possess extensive experience in crafting robust database solutions and developing dynamic web applications using Oracle Application Express. Responsibilities include designing and implementing efficient SQL queries, optimizing database performance, and creating user-friendly interfaces. The successful freelancer will demonstrate strong problem-solving abilities and a keen attention to detail. If you have a passion for database management and application development, we invite you to submit your proposal for this exciting opportunity.

Software Tester / QA Engineer

Job Description We are looking for a detail-oriented Software Tester (QA Engineer) to ensure the quality and reliability of our software products. You will work closely with developers and product managers to identify bugs, improve performance, and deliver high-quality applications to users. Responsibilities Analyze requirements and create test plans, test cases, and test scenarios Perform manual and/or automated testing of web and mobile applications Identify, document, and track bugs using defect tracking tools Execute functional, regression, integration, and system testing Collaborate with development teams to resolve issues Ensure software meets quality standards before release Participate in reviews and provide feedback on product usability Requirements Bachelor’s degree in Computer Science, IT, or a related field (or equivalent experience) Experience in software testing or quality assurance Knowledge of SDLC and STLC Familiarity with testing tools (e.g., Selenium, JIRA, TestRail, Postman) Basic understanding of SQL and APIs (preferred) Strong analytical and problem-solving skills Good communication and documentation skills

Senior Data Engineer

We are seeking a Senior Data Engineer to design, implement, and optimize data pipelines utilizing Scala, Spark, and Java. The ideal candidate will develop and maintain real-time data processing systems essential for business operations. Collaboration with data scientists and analysts is crucial to understand data requirements and deliver high-quality solutions. Responsibilities include ensuring data quality through robust testing, monitoring workflows, and troubleshooting pipelines. Candidates should possess a degree in Computer Science or Engineering, with proven experience in data engineering, real-time processing, and SQL proficiency. Familiarity with cloud platforms and data governance is preferred. We offer a competitive salary, benefits, and opportunities for professional growth in a collaborative environment. Key Responsibilities: - Design, implement, and optimize data pipelines using Scala, Spark, and Java. - Develop and maintain real-time data processing systems to support business-critical operations. - Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver high-quality solutions. - Ensure data quality and reliability through robust testing and validation procedures. - Monitor and troubleshoot data pipelines and workflows to ensure high availability and performance. - Stay current with emerging technologies and industry best practices to continuously improve our data infrastructure. Qualifications: -Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field. - Proven experience with Scala, Spark, and Java in a data engineering or similar role. - Strong understanding of real-time data processing and streaming technologies. - Experience with big data platforms and tools such as Hadoop, Kafka, and Flink is a plus. - Proficiency in SQL and experience with relational databases. - Excellent problem-solving skills and attention to detail. - Strong communication and collaboration skills to work effectively with cross-functional teams. Preferred Skills: - Experience with cloud platforms (AWS, Azure, Google Cloud) and their data services. - Knowledge of data warehousing solutions and ETL processes. - Familiarity with data governance and security best practices.

Senior Software Engineer - Long Term Collaboration

This is Long Term collaboration in Software Development Looking for an experienced Senior Software Engineer Collaborators who can design, build, and maintain scalable software systems based on United States. You will play a key role in technical decision-making, system architecture, and mentoring junior engineers while collaborating closely with product, design, and infrastructure teams. Key Responsibilities - Design, develop, and maintain scalable and reliable software applications. - Lead technical design discussions and contribute to system architecture decisions. - Write clean, maintainable, and well-tested code. - Review code and mentor junior and mid-level engineers. - Collaborate with cross-functional teams to deliver high-quality products. - Troubleshoot production issues and optimize system performance. - Contribute to continuous improvement of development processes and best practices. Required Qualifications - Strong software engineering experience in modern development environments - Proficiency in at least one major programming language (e.g., JavaScript, Python, Go, Java, or similar) - Strong understanding of system design, APIs, and distributed systems - Experience with cloud platforms (AWS, GCP, or Azure) - Solid understanding of databases (SQL and/or NoSQL) - Experience with CI/CD pipelines and version control systems (Git) - Strong problem-solving and communication skills Nice to Have - Experience working in high-growth startups or product-focused companies - Experience with microservices architecture - Knowledge of containerization (Docker, Kubernetes) - Exposure to blockchain or Web3 technologies (optional but a plus) What We Offer - Competitive compensation - Flexible work environment - Opportunity to work on impactful and innovative products - Career growth and leadership opportunities Location US Remote

Senior UK .NET Developer – Long-Term System Support + Dev

We are looking for an experienced UK-based senior .NET developer to take long-term ownership of a business-critical CRM & Finance platform. This is not a one-off task. We want a long-term partner who can first familiarise themselves with the system and stabilise it, then provide full ongoing support and further system development. We are actively replacing an existing slow and ineffective support arrangement and are keen to work with someone professional, proactive and reliable. Phase 1 – Initial Audit, Familiarisation & Bug Fixing The first phase will be a paid engagement to: • Set up a full offline / local development environment • Review the codebase, database and overall architecture • Identify and fix priority bugs and long-standing issues • Improve system stability and performance • Produce a short stabilisation and improvement plan This phase allows you to fully understand the platform and demonstrate ownership before moving into long-term support. Phase 2 – Full Ongoing Support & Further Development (Long-Term) After stabilisation, this becomes an ongoing hourly role providing both live system support and further development, including: • Full production support when bugs or system issues arise • Rapid diagnosis and fixing of live problems • Ongoing performance monitoring and optimisation • Enhancements and new feature development • Refactoring and gradual modernisation • Safe testing and controlled deployment into the live environment We expect regular monthly work and a long-term working relationship. Technology Stack • VB.NET and C#.NET (mixed legacy and newer code) • SQL Server Express (stored procedures, LINQ, optimisation) • jQuery, NuGet packages, PDF export module • Hosted on AWS (Windows Server 2019) • Source control in Bitbucket Two tightly integrated applications (CRM + Finance) sharing a central database. Who We’re Looking For This role is only suitable for a senior UK-based developer who: • Has strong experience with C#.NET / VB.NET and SQL Server • Has proven experience supporting live, business-critical systems • Is confident diagnosing and fixing production issues quickly • Is comfortable owning and evolving a complex legacy platform • Communicates clearly and works reliably long-term Experience with AWS / Windows hosting is a strong advantage. Budget & Engagement • Engagement via PeoplePerHour • Hourly rate: £60 – £75 per hour (depending on experience) • Phase 1 expected to be a short initial contract (audit + stabilisation) • Phase 2 is an ongoing hourly support & development role with regular monthly work How to Apply Please include: • Confirmation that you are UK-based • Relevant experience with legacy .NET systems and live production support • Your hourly rate • Availability per week / month • Brief outline of how you would approach the initial audit and stabilisation phase

WooCommerce Analytics Dashboard

create Data Dashboard in Power BI, write script, DAX, DESIGN Customer Journey Map - Data Cleaning, Custom Visuals, Customer Journey Mapping & Interactive Dashboards - Designed and developed interactive dashboards in Power BI to track costs, revenues, and customer journeys - Built custom visuals to highlight KPIs and support data-driven decision-making - Performed data cleaning and integration from diverse sources including SQL Server, WooCommerce, Google Sheets, and Google Apps Script - Enhanced reporting efficiency and provided clear insights for management and cross-functional teams

Application Support – Healthcare & Research Systems

We are looking for a Freelance Application Support Engineer (4–5 years experience) to support a medical research institute, providing technical analysis, server support, and application troubleshooting across research and healthcare systems. Time Commitment ⏱ 2–2.5 hours per day | Monday–Friday (No weekends) Key Responsibilities Support 20+ vendor-hosted and in-house clinical/research applications Troubleshoot Azure cloud & on-prem servers (Windows/Linux) Develop and support SQL/MySQL reports Handle user tickets via email, Teams, and phone Coordinate with vendors for upgrades and issue resolution Manage user access, SSL renewals, and security protocols Support applications like REDCap, OnCore, Streamlyne, DocuSign Collaborate with IT, researchers, and clinical stakeholders Must-Have Skills 4–5 years of application/technical support experience Strong SQL & MySQL skills Windows & Linux server administration Report writing and data analysis experience Familiarity with REDCap Healthcare or health-adjacent domain experience Strong communication and customer-facing skills Nice to Have Databricks, Azure/AWS/Snowflake Analytics tools: SAS, SPSS, R, Python Experience with OnCore, Streamlyne, Oracle Health (Cerner) Engagement Type

Hiring machine learning engineer

Location: Remote Job Type: Contract About the Project: We are looking for a skilled Machine Learning Consultant to join our team on a contract basis. This role is ideal for an expert who can provide strategic guidance and hands-on support for various machine learning projects. Responsibilities: - Consult on the end-to-end ML pipeline, from data preprocessing to model deployment. - Provide clear documentation and presentations on findings and recommendations. - Collaborate with stakeholders to translate business needs into technical requirements. Required Qualifications: - Bachelor's degree in Computer Science, Engineering, Statistics, or a related field. - Minimum of 5 years of experience in a machine learning engineering or consulting role. - Demonstrated expertise with Python, SQL, and major ML frameworks. - Experience with cloud platforms (e.g., AWS SageMaker, Google AI Platform, Azure ML) is a plus. - Excellent verbal and written communication skills.

Data Scientist – Measurement & Causal Inference

We are seeking a Freelance Data Scientist (3+ years experience) with strong expertise in statistical inference and causal analysis to support enterprise measurement frameworks. Time Commitment: ⏱ 2–2.5 hours/day | Monday–Friday (No weekends) Key Requirements: Strong knowledge of hypothesis testing, OLS, GLM, and causal inference Hands-on experience with A/B testing & experimental design Proficiency in Python & SQL (statsmodels, scikit-learn, DoWhy) Experience with Databricks or enterprise cloud environments Ability to work independently and collaborate via GitHub (CI/CD) Type: Freelance