Analytics Engineer (BigQuery)

TL;DR

Analytics Engineer (BigQuery): Building and maintaining analytical data products and transformation processes for a leading Latin American airline with an accent on data modeling and GCP optimization. Focus on developing scalable consumption layers, migrating processes to Dataform, and implementing corporate data standards.

Location: Must be based in Mexico, Uruguay, Argentina, or Colombia

Company

hirify.global is a global software engineering company providing technology services to a wide range of clients.

What you will do

• Design and maintain scalable analytical data models in BigQuery.
• Develop and optimize advanced SQL queries for data integration workloads.
• Build and support ELT and ETL transformation processes.
• Collaborate with business and tech teams to validate transformation logic.
• Document data models, business rules, and technical definitions.
• Implement data quality, governance, security, and compliance practices.

Requirements

• 3+ years of experience for Middle, 5+ years for Senior roles.
• Advanced SQL skills and proven experience in analytical and transactional data modeling.
• Hands-on experience with BigQuery and GCP data services.
• Proficiency in Python for analysis and automation.
• Fluency in Spanish and intermediate English for international collaboration.
• Experience with Dataform, dbt, or BI tools like Looker, Power BI, or Data Studio.

Nice to have

• Experience with AI-assisted development and Generative AI solutions.
• Experience supporting enterprise-scale analytical platforms.
• Exposure to DataOps methodologies and governance frameworks.

Culture & Benefits

• Health insurance for employees and their loved ones.
• Vacation and sick pay according to local national laws.
• Time off for state holidays regardless of the client's schedule.
• Corporate parties and regular team-building events.
• Support for IT certifications and access to top-tier learning platforms.