SQL DBA - Trainee analyst/engineer

Job Description:

Summary

The Data Engineer will be responsible for designing, developing, and maintaining the data infrastructure. They must have experience with SQL and Python.

Roles & Responsibilities:

● Collaborate with product, business, and engineering stakeholders to understand key metrics, data needs, and reporting pain points.

● Design, build, and maintain clean, scalable, and reliable data models using DBT.

● Write performant SQL and Python code to transform raw data into structured marts and reporting layers.

● Create dashboards using Tableau or similar tools.

● Work closely with data platform engineers, architects, and analysts to ensure data pipelines are resilient, well-governed, and high quality.

● Define and maintain source-of-truth metrics and documentation in the analytics layer.

● Partner with product engineering teams to understand new features and ensure appropriate

instrumentation and event collection.

● Drive reporting outcomes by building dashboards or working with BI teams to ensure timely delivery of insights.

● Help scale our analytics engineering practice by contributing to internal tooling, frameworks, and best practices.

Who You Are:

Experience : 3 to 4 years of experience in analytics/data engineering, with strong hands-on expertise in DBT, SQL, Python and dashboarding tools.

● Experience working with modern data stacks (e.g., Snowflake, BigQuery, Redshift, Airflow).

● Strong data modeling skills (dimensional, star/snowflake schema, data vault, etc.).

● Excellent communication and stakeholder management skills.

● Ability to work independently and drive business outcomes through data.

● Exposure to product instrumentation and working with event-driven data is a plus.

● Prior experience in a fast-paced, product-led company is preferred.

We are looking for a Python Backend Developer to design, build, and maintain scalable backend services and APIs. The role involves working with modern Python frameworks, databases (SQL and NoSQL), and building well-tested, production-grade systems.

You will collaborate closely with frontend developers, AI/ML engineers, and system architects to deliver reliable and high-performance backend solutions.

Key Responsibilities

• Design, develop, and maintain backend services using Python
• Build and maintain RESTful APIs using FastAPI
• Design efficient data models and queries using MongoDB and SQL databases (PostgreSQL/MySQL)
• Ensure high performance, security, and scalability of backend systems
• Write unit tests, integration tests, and API tests to ensure code reliability
• Debug, troubleshoot, and resolve production issues
• Follow clean code practices, documentation, and version control workflows
• Participate in code reviews and contribute to technical discussions
• Work closely with cross-functional teams to translate requirements into technical solutions

Required Skills & Qualifications

Technical Skills

• Strong proficiency in Python
• Hands-on experience with FastAPI
• Experience with MongoDB (schema design, indexing, aggregation)
• Solid understanding of SQL databases and relational data modelling
• Experience writing and maintaining automated tests
• Unit testing (e.g., pytest)
• API testing
• Understanding of REST API design principles
• Familiarity with Git and collaborative development workflows

Good to Have

• Experience with async programming in Python (async/await)
• Knowledge of ORMs/ODMs (SQLAlchemy, Tortoise, Motor, etc.)
• Basic understanding of authentication & authorisation (JWT, OAuth)
• Exposure to Docker / containerised environments
• Experience working in Agile/Scrum teams

What We Value

• Strong problem-solving and debugging skills
• Attention to detail and commitment to quality
• Ability to write testable, maintainable, and well-documented code
• Ownership mindset and willingness to learn
• Teamwork

What We Offer

• Opportunity to work on real-world, production systems
• Technically challenging problems and ownership of components
• Collaborative engineering culture

About Us

Tradelab Technologies is a leading fintech company building high-performance trading platforms, low-latency systems, and scalable market infrastructure for the global trading and broking ecosystem. We work at the intersection of technology, trading, and innovation.

Role Overview

We are looking for an experienced Python Backend Developer with strong expertise in trading, low-latency systems, or high-frequency trading (HFT). The ideal candidate will design, develop, and optimize backend components powering real-time trading systems.

Key Responsibilities

• Develop and maintain backend microservices and real-time trading components using Python.
• Build low-latency, high-throughput systems optimized for trading workflows.
• Integrate with market data feeds, order management systems, APIs, and broker/exchange interfaces.
• Write clean, scalable, and high-performance code with a focus on reliability and fault tolerance.
• Work closely with product, QA, and DevOps teams to deliver robust and scalable platforms.
• Troubleshoot production issues and optimize system performance.
• Ensure system security, stability, and compliance with industry standards.

Required Skills & Experience

• 5–8 years of backend development experience with Python.
• Strong experience in trading/HFT/fintech/market infrastructure is mandatory.
• Deep understanding of algorithms, data structures, and system design.
• Experience working with multithreading, multiprocessing, asynchronous programming.
• Strong knowledge of API development (REST, WebSockets).
• Experience with Redis, Kafka, RabbitMQ, PostgreSQL/MySQL, or similar technologies.
• Hands-on experience building low-latency and high-availability systems.
• Familiarity with Linux systems, shell scripting, and performance profiling.
• Exposure to FIX protocol, OMS, RMS, or market data systems is a plus.

Good to Have

• Knowledge of microservices architecture and containerization (Docker, Kubernetes).
• Understanding of exchange trading mechanisms and order lifecycles.
• Prior experience in broker terminals, algo systems, or risk engines.

Why Join Tradelab Technologies?

• Work on cutting-edge trading technologies impacting millions of users.
• Fast-paced, innovation-driven engineering culture.
• Opportunity to build mission-critical systems in fintech and HFT.
• Competitive compensation and growth opportunities.

Key Responsibilities:

• Design, develop, and maintain robust and scalable backend applications using Core Java and Spring Boot.
• Build and manage microservices-based architectures and ensure smooth inter-service communication.
• Integrate and manage real-time data streaming using Apache Kafka.
• Write clean, maintainable, and efficient code following best practices.
• Collaborate with cross-functional teams including QA, DevOps, and product management.
• Participate in code reviews and provide constructive feedback.
• Troubleshoot, debug, and optimize applications for performance and scalability.

Required Skills:

• Strong knowledge of Core Java (Java 8 or above).
• Hands-on experience with Spring Boot and the Spring ecosystem (Spring MVC, Spring Data, Spring Security).
• Experience in designing and developing RESTful APIs.
• Solid understanding of Microservices architecture and related patterns.
• Practical experience with Apache Kafka for real-time data processing.
• Familiarity with SQL/NoSQL databases such as MySQL, PostgreSQL, or MongoDB.
• Good understanding of CI/CD tools and practices.
• Knowledge of containerization tools like Docker is a plus.
• Strong problem-solving skills and attention to detail.

About the Role

We are seeking a highly skilled and motivated Senior Backend Developer with strong expertise in Node.js and AWS to join our dynamic team. The ideal candidate will have solid backend development experience, with additional working knowledge of PHP and Python. Exposure to frontend frameworks like React.js and Angular will be considered a strong advantage.

Key Responsibilities

• Design, develop, and maintain scalable backend systems and APIs using Node.js.

• Deploy, manage, and optimize applications on AWS cloud infrastructure.

• Collaborate with cross-functional teams (frontend, product, QA) to deliver end-to-end solutions.

• Ensure application performance, security, and scalability.

• Write clean, maintainable, and testable code following industry best practices.

• Work with databases (SQL/NoSQL) to design efficient data models and queries.

• Integrate third-party services and APIs when required.

• Contribute to code reviews, technical discussions, and mentoring of junior developers.

• Support continuous integration and deployment pipelines.

• Troubleshoot, debug, and optimize existing applications.

Requirements

• 4+ years of backend development experience.

• Strong expertise in Node.js and hands-on experience with AWS services (EC2, S3, Lambda, etc.).

• Good working knowledge of PHP and Python.

• Strong understanding of RESTful API design, microservices architecture, and databases (MySQL, PostgreSQL, or MongoDB).

• Working knowledge of React.js and Angular is preferred.

At least 4 years' experience as a Node.js developer.

Experience in Microservices

Extensive knowledge of JavaScript, web stacks, libraries, and frameworks.

Mandatory experience in Postgres and MySql.

Knowledge of front-end technologies such as HTML5 and CSS3.

Superb interpersonal, communication, and collaboration skills.

Exceptional analytical and problem-solving aptitude.

Responsibilities : 

- Developer responsibilities include, but are not limited to the following:

- Experience as a Sun Certified Java Developer with proven hands-on Software Development experience. We use Java 8

- 4-10 years java development experience with JSE/JEE, Java-based Micro-services framework, and implementation, Spring framework, Hibernate framework, SQL, etc

- Hands-on experience on Spring boot & SPARK Microservices and OSGi specifications

- Strong knowledge of micro-service logging, monitoring, debugging, and testing

- Implementations experience of micro-service integration, packaging, building automation, and deployment

- At least two years experience in SOA & Microservices based process applications using BPM (Activiti/JBPM/Camunda)

- Object-Oriented Analysis and design using common design patterns.

- Insight of Java and JEE internals (Classloading, Memory Management, Transaction management, etc)

- Excellent knowledge of Relational Databases, SQL, and ORM technologies (JPA2, Hibernate)

- Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT, Spring MVC, Spring Boot)

Qualifications: BS/MS degree in Computer Science, Engineering or a related subject and a minimum of 8 years of professional work experience in a mid-d or large corporate Information Technology environment. Highly organized and detail-oriented, with the ability to keep multiple projects and client engagements active at once. Comfort with ambiguity and ability to navigate uncertainty.