AI Engineer (temporary contract)

Applaudo Studios; Ciudad de México; On-site; MXN 350,000 - 550,000; Part time

Job summary

Applaudo Studios is seeking an AI Developer to join a migration platform team. You will help convert LLM outputs into reliable SQL, mappings, and rules for bidirectional syncing. The role focuses on production-grade, validated AI-driven data logic, with a strong emphasis on automation and safeguards.

The position is a 6-month contractor framework with potential extension. You should have 3+ years of Python, advanced SQL, and experience building production LLM apps. Fluent English is essential.

Qualifications

• Bachelor's degree in CS or related field or equivalent experience.
• 3+ years of software development experience with Python.
• Advanced SQL skills with PostgreSQL, MySQL, and BigQuery.
• 1+ year building production LLM applications.
• Experience integrating hosted LLM APIs and validating structured output.
• Prompt engineering, versioning, fallback strategies, and cost optimization.
• Experience evaluating LLM output with tests and methodologies.
• Ability to understand and modify a partially documented codebase.
• Strong autonomy, attention to detail, and comfort with evolving requirements.
• Advanced English fluency.

Responsibilities

• Prepare context for each migration process with docs, schemas, and target data model.
• Design and tune prompts to generate queries, mappings, and rules.
• Review generated SQL and mappings against data models for validity.
• Resolve edge cases where LLM outputs are unreliable while preserving constraints.
• Build parameterized queries to detect changes across sources.
• Collaborate on safeguards for LLM-generated SQL for controlled writes.
• Automatically classify and document failed sync records and rules.
• Automate migration prep tasks like loading inputs and generating artifacts.
• Version each artifact with inputs and provide reusable procedures.

Skills

Advanced English

Education

Bachelor's Degree in CS or related field

Tools

Python

SQL

PostgreSQL

MySQL

BigQuery

LLM applications

Prompt engineering

MLOps

CI/CD

Vertex AI

Gemini

Job description

About You

You are an AI Developer who turns large language models into reliable, production-ready data logic. You will join the team building a migration platform, where an LLM proposes SQL and mappings, a person reviews and approves them, and the approved logic is reused at scale. Your focus will be the reverse direction of the sync, taking changes made in the target platform back into each source system, along with the rules that classify and resolve the records that fail to sync.

Note: This position is offered under a 6-month contractor framework, with the possibility of extension.

You Bring to Applaudo the Following Competencies:

• Bachelor's Degree in Computer Science, Engineering, Information Systems, or a related field is desired, or equivalent professional experience.


• 3+ years of software development experience with Python and software engineering best practices.


• Advanced SQL skills working with PostgreSQL, MySQL, and cloud data warehouses such as BigQuery.


• 1+ year of experience building LLM applications that run in production, beyond prototypes.


• Experience integrating hosted LLM APIs into production environments, including structured output and its validation.


• Experience with prompt engineering, prompt versioning, fallback strategies, and cost and latency optimization.


• Experience evaluating LLM output with test cases and clear evaluation methodologies.


• Demonstrated ability to understand and modify a partially documented codebase that you did not write.


• Demonstrated use of AI tools in your daily workflow, with an explicit step to verify what they produce.


• Strong autonomy, attention to detail, and comfort with ambiguity as requirements evolve.


• Advanced English fluency.

Nice to haves:

• Experience in data migration or ETL projects.


• Experience with Vertex AI or Gemini.


• Experience extracting data from spreadsheets or documents.


• Experience with MLOps practices, including CI/CD, observability, and reproducible pipelines.

You Will Be Accountable for the Following Responsibilities:

• Prepare the context for each migration process, including functional documentation, source schema, and target data model, so the LLM generates accurate mappings in both directions.


• Design and tune the prompts the LLM uses to propose queries, mappings, and transformation rules, reducing rework during human review.


• Review generated SQL and mappings against both data models, validating entities, fields, relationships, and constraints.


• Resolve cases the LLM does not handle reliably, such as identifiers that change format between systems or data that conflicts with a constraint, while keeping the constraint in place.


• Build parameterized queries that detect what changed on each side since the last sync, including sources that are not databases, such as spreadsheets and document folders.


• Work with the Senior Python Developer on safeguards for LLM-generated SQL, enabling controlled and approved writes to source systems.


• Automatically classify records that fail to sync by root cause, including conflicts where the same data changed on both sides, and turn each treatment into an approved rule.


• Automate repetitive migration preparation tasks, such as loading inputs, generating artifacts, and comparing artifact versions.


• Version every approved artifact together with the inputs that produced it, and document the preparation procedure so other teams can reuse it.

• 3+ years of experience with Python, plus advanced SQL on PostgreSQL, MySQL, and BigQuery


• Production LLM applications experience, including hosted LLM API integration, structured output, and validation


• Prompt engineering and versioning, fallback strategies, cost and latency optimization, and LLM evaluation methodologies

About Us

We Are Engineered Different.

At Applaudo, talented people design, build, and scale meaningful, AI-powered solutions that create real business impact. As an AI-native organization, we collaborate across design, development, cloud, data, and artificial intelligence to turn ideas into scalable products that transform how companies operate, make decisions, and grow.

We are building a high-performance culture grounded in five values:Empowering Excellence, Collaborative Teamwork, Unsolicited Respect, Consistent Transparency, and Efficient Communication. These define how we work, how we support one another, and how we hold ourselves accountable.

Applaudois a place for people who want to learn fast, take ownership, and work alongside strong teams they are proud to belong to. Joining us means being part of an organization that is evolving intentionally, investing in modern ways of working, and leading AI-native transformation at scale.