Data Engineer

ITJ; Tijuana; On-site; MXN 600,000 - 900,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Gym bonus

Education reimbursement

30% vacation bonus

10 days paternity leave

Work at Home Bonus for office equip

Job summary

ITJ is seeking a data-engineering professional in Tijuana to design and implement ingestion and normalization processes for vendor stability reports. You will build data structures supporting studies, lots, time points, and assay attributes, while ensuring quality controls and traceability across extracted data.

You will collaborate with BI to validate metrics, support AI-assisted data entry with human review, and help establish reusable data-engineering practices for ITJ TechOps products within

Responsibilities

• Design and implement ingestion and normalization processes for vendor stability reports and related files.
• Build data structures supporting programs, studies, lots, time points, assay attributes, results, specifications, deviations, vendors, reference standards, and critical reagents.
• Support automatic generation and tracking of operational time points using study start dates and applicable scheduling rules.
• Implement data-quality controls for completeness, consistency, valid relationships, duplicate information, and reliable status tracking.
• Build the data-processing workflow for AI-assisted vendor-report extraction, including proposed values, confidence indicators, human review, and approved value retention.
• Preserve source references and traceability for extracted or transcribed vendor-derived information.
• Ensure extracted values are never saved automatically and that AI-assisted functionality remains limited to data entry support.
• Prepare operational data for portfolio views, overdue-report tracking, review status, OOS/OOT visibility, deviations, trends, and CSV exports.
• Collaborate with the BI Analyst on operational metrics, dashboard data, trend visualization, and reporting validation.
• Build pipeline monitoring, error handling, reconciliation, documentation, and support procedures.
• Partner with the Full Stack Engineer on application data models, APIs, workflow state, and data-quality behavior.
• Participate in backlog refinement, technical design, testing, release planning, production support, and knowledge transfer.
• Help establish reusable data-engineering practices for future ITJ TechOps products without expanding our internal application beyond its approved scope.

Job description

• Employer-paid medical, dental, vision, and life insurance; medical insurance for employees, Gym bonus support
• Education reimbursement (Up to MXN 54,000 per year)
• 30% vacation bonus
• 10 days paternity leave
• Work at Home Bonus for office equipment 1-time MXN 5,000

Key Responsabilities

• Design and implement ingestion and normalization processes for vendor stability reports and related files.
• Build data structures supporting programs, studies, lots, time points, assay attributes, results, specifications, deviations, vendors, reference standards, and critical reagents.
• Support automatic generation and tracking of operational time points using study start dates and applicable scheduling rules.
• Implement data-quality controls for completeness, consistency, valid relationships, duplicate information, and reliable status tracking.
• Build the data-processing workflow for AI-assisted vendor-report extraction, including proposed values, confidence indicators, human review, and approved value retention.
• Preserve source references and traceability for extracted or transcribed vendor-derived information.
• Ensure extracted values are never saved automatically and that AI-assisted functionality remains limited to data entry support.
• Prepare operational data for portfolio views, overdue-report tracking, review status, OOS/OOT visibility, deviations, trends, and CSV exports.
• Collaborate with the BI Analyst on operational metrics, dashboard data, trend visualization, and reporting validation.
• Build pipeline monitoring, error handling, reconciliation, documentation, and support procedures.
• Partner with the Full Stack Engineer on application data models, APIs, workflow state, and data-quality behavior.
• Participate in backlog refinement, technical design, testing, release planning, production support, and knowledge transfer.
• Help establish reusable data-engineering practices for future ITJ TechOps products without expanding our internal application beyond its approved scope.