Freelance Python & SQL Developer (AWS / Azure)

About the Role

We are looking for an experienced Python and SQL Developer to work on SightShark, our SaaS-based analytics and reporting platform.

The role involves developing backend services, building reporting APIs and working with cloud-based data warehouses. You will work across our existing BigQuery infrastructure and AWS and Azure environments, developing scalable data services and reporting solutions.

Engagement: Freelance / Contract

Availability: Minimum 4 hours per day

Work Arrangement: Remote

Responsibilities

• Develop backend services and REST APIs using Python.
• Write, optimise and maintain complex SQL queries.
• Work with cloud data warehouses and large datasets.
• Build APIs to serve transformed and aggregated data to React-based reporting interfaces.
• Work with BigQuery, AWS Redshift and Azure Synapse / Microsoft Fabric.
• Develop reusable data access and query execution components.
• Implement API authentication, error handling, caching and data validation.
• Optimise query performance and reduce unnecessary data processing costs.
• Work with existing ETL processes and reporting tables.
• Write clean, maintainable and well-documented code.
• Collaborate with frontend developers and the product team.

Required Skills

• Strong proficiency in Python.
• Strong SQL skills, including complex joins, CTEs, window functions and query optimisation.
• Experience building REST APIs using FastAPI or Flask.
• Experience working with cloud data warehouses.
• Practical experience with AWS services, particularly Amazon Redshift, S3 and related data services.
• Practical experience with Azure data services, particularly Synapse Analytics, Microsoft Fabric or Azure Data Factory.
• Experience with database connectivity, query execution and data modelling.
• Familiarity with Git, Docker and collaborative development workflows.
• Understanding of API security, authentication and multi-tenant application architecture.

Preferred Skills

• Experience with Google BigQuery.
• Experience designing cloud-independent data access layers.
• Experience working with Redis or other caching solutions.
• Experience with Terraform and cloud infrastructure management.

Engagement Requirements

• Minimum availability of 4 hours every day.
• Must be an individual freelancer. Agencies, companies and teams will not be considered.
• Ability to work independently and provide regular progress updates.
• Comfortable working with existing codebases and cloud infrastructure.
• Must be available for regular coordination with our team.

How to Apply

Please share:

1. Your GitHub profile or relevant Python/backend projects.
2. Your experience with AWS, Azure and cloud data warehouses.
3. Examples of APIs or data-intensive applications you have developed.
4. Your hourly rate.
5. Your daily availability and preferred working hours.
6. Your estimated start date.

Important: All communication and applications must remain within the platform where this job is posted. Anyone attempting to contact us outside this platform, including through direct email, LinkedIn, WhatsApp or other channels, will be automatically disqualified from the selection process.