Business Inteligence Engineer (Lagos de Moreno)

Job Title: Business Intelligence (BI) Engineer / BI Analyst

Experience: 4–6 years

Location: Guadalajara, Jalisco (MX-JAL), Mexico (MX) – (Specify location / Remote / Hybrid)

Employment Type: Full-time

Role Overview

We are looking for a Business Intelligence (BI) Engineer to design, develop, and optimize data solutions that enable data-driven decision‑making across the organization. This role focuses on transforming complex data into actionable insights through robust data modeling, efficient ETL/ELT pipelines, and impactful dashboards, while working closely with business stakeholders.

Key Responsibilities

• Design and develop scalable BI solutions, including dashboards, reports, and data models
• Build, maintain, and optimize ETL/ELT pipelines to support analytics and reporting needs
• Write and optimize complex SQL queries for data extraction, transformation, and performance tuning
• Develop data models (star schema, snowflake, 3NF) aligned with dimensional modeling best practices (Kimball methodology)
• Partner with business stakeholders to gather requirements and translate them into data products and insights
• Define and implement KPIs, metrics, and reporting frameworks
• Perform data analysis, profiling, and validation to ensure data accuracy and consistency
• Develop interactive dashboards using BI tools to support strategic and operational decisions
• Ensure data quality, governance, and consistency across reporting layers
• Support experimentation initiatives, including A/B testing and performance analysis

Required Skills & Qualifications

• Strong SQL expertise (complex joins, window functions, query optimization)
• Hands‑on experience with ETL/ELT tools (Informatica, SSIS, AWS Glue, dbt, Airflow)
• Solid understanding of data modeling: star schema, snowflake, and 3NF
• Experience with dimensional modeling (Kimball methodology)
• Experience building and managing data pipelines and orchestration workflows