AI Engineer – Temporary Contract

This is a fully remote position, open to applicants in Mexico.

📋 Description

• Prepare the context for each migration process, encompassing functional documentation, source schema, and the target data model.

• Design and optimize prompts for proposing queries, mappings, and transformation rules.

• Review generated SQL and mappings against data models, ensuring the validation of entities, fields, relationships, and constraints.

• Address unreliable LLM cases, including modifications to identifiers and resolving constraint conflicts.

• Create parameterized queries to identify changes on both sides since the last synchronization, which includes spreadsheets and document folders.

• Collaborate with the Senior Python Developer to establish safeguards for LLM-generated SQL and ensure controlled, approved writes to source systems.

• Classify records of failed synchronization by root cause, including instances where data has been altered on both ends.

• Transform each treatment into an approved rule.

• Automate tasks related to migration preparation, such as loading inputs, generating artifacts, and comparing versions of artifacts.

• Version approved artifacts alongside their inputs and document procedures for reuse by other teams.

⛳️ Requirements

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

• A minimum of 3 years of software development experience with Python and adherence to software engineering best practices.

• Proficient SQL skills with PostgreSQL, MySQL, and cloud data warehouses like BigQuery.

• At least 1 year of experience in developing LLM applications that are operational in production, beyond just prototypes.

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

• Knowledge in prompt engineering, prompt versioning, fallback strategies, and optimization of cost and latency.

• Experience in evaluating LLM output through test cases and established evaluation methodologies.

• Capability to comprehend and modify a partially documented codebase that you did not author.

• Proven use of AI tools in your daily workflow, with a definitive step to verify their outputs.

• Strong autonomy, meticulous attention to detail, and the ability to navigate ambiguity as requirements evolve.

• Proficiency in English at an advanced level.

• Experience in data migration or ETL projects is a plus.

• Familiarity with Vertex AI or Gemini is advantageous.

• Experience in extracting data from spreadsheets or documents is beneficial.

• Knowledge of MLOps practices, including CI/CD, observability, and reproducible pipelines is a plus.

🏝️ Benefits

• Employees have the option to work remotely.

• A 6-month contractor framework is in place, with the potential for extension.