website logo

Juan David Mazuera

Python | Backend Developer

Backend engineer with experience in Python (Django, Flask), RESTful APIs, and high-volume SQL optimization. Skilled in cloud integrations (AWS, Azure), data reporting, and enhancing legacy systems. Strong collaborator, translating business needs into scalable technical solutions and supporting reliable deployments through CI/CD.

Get in Touch

Work Experience

LF Technologies

Software Engineer

Dec 2020 — Sept 2025
  • Designed and maintained Flask-based RESTful APIs in Python 2.7, providing ongoing support and ensuring reliable backend functionality.
  • Executed deployments of new features via Jenkins, leveraging continuous integration and continuous delivery (CI/CD) pipelines to ensure reliable and automated releases.
  • Collaborated with the tech lead on sprint planning, clarified technical blockers, and contributed to architectural and technical design discussions.
  • Developed new components and performed frontend refactoring in React 15 to support new features.
  • Developed and expanded automated tests for both new features and legacy code, ensuring high code quality and significantly increasing test coverage.
  • Designed and delivered data reports using Pandas, Looker, SQL, and SQLAlchemy, supporting client needs within a SaaS-based platform.
  • Enhanced and updated existing system integrations to reliably capture and process financial data from Plaid.

UseIT S.A.S.

Backend Developer

Mar 2020 — Dec 2020
  • Developed business logic and designed robust database models with Django, ensuring scalability and reliability across core system functionality.
  • Implemented and configured new software solutions on cloud platforms (AWS), integrating them as secondary services to enhance and extend the functionality of the primary application.
  • Analyzed and optimized SQL queries for high-volume datasets in PostgreSQL, significantly improving database performance and scalability.
  • Implemented OAuth2-based authentication with Microsoft Azure (Azure AD) to securely integrate the system with cloud identity services.

Opal Group S.A.S.

Backend Developer and SQL Developer

Jun 2016 — Mar 2020
  • Designed and built client-specific reporting solutions using Django, JavaScript, AngularJS, and SQL Server, ensuring accurate data delivery and seamless integration with existing systems.
  • Consolidated and processed data from heterogeneous database systems to deliver comprehensive financial reporting and analysis.
  • Optimized and fine-tuned SQL queries for high-volume workloads across PostgreSQL, SQL Server, MySQL, and Oracle, significantly improving performance and resource utilization.
  • Supported and maintained cloud-based application solutions for diverse clients, ensuring stability and reliability in production environments.
  • Collaborated directly with clients to understand their business needs, documenting and translating them into detailed technical requirements for implementation.
  • Worked closely with Product Managers and Product Owners to evaluate technical feasibility, shaping what could be built and defining the scope of viable solution offerings.

Featured Projects

About Me

I’m a backend engineer with experience building scalable and reliable systems using Python (Django, Flask), RESTful APIs, and high-volume SQL databases. I’ve worked across SaaS, enterprise, logistics, and fintech environments, enhancing legacy platforms, integrating third-party services, and delivering cloud solutions on AWS and Azure. I also build data reporting tools, support CI/CD deployments, and collaborate with product teams and clients to translate business needs into technical solutions that drive real value.

Juan David Mazuera