Lead BI & Data Warehouse Engineer

Allstate Private Limited; Tijuana; Híbrido; MXN 900.000 - 1.500.000; Jornada completa

Descripción de la vacante

Integon, part of The Allstate Corporation, seeks a Lead BI Developer to join our Data & Analytics team in Mexico. You will design and deliver enterprise data warehouse solutions, build ETL/ELT pipelines, and develop Power BI semantic models and Python/PySpark data processing.

Collaborate with business and engineering teams to translate requirements into scalable data solutions while upholding data quality and governance standards.

Formación

• 5+ years of experience in Data Engineering, Data Warehousing, or BI.
• Experience with SQL Server, T-SQL, SSIS, and Enterprise DW.
• Proficient in Star/Snowflake schemas and SCDs.
• Hands-on with Microsoft Fabric components: Data Factory, Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, Data Warehouses, OneLake.
• Proficient in Python, PySpark, and Spark-based processing.
• Advanced Power BI skills: semantic models, dataset design, DAX, dashboards, performance optimization.
• Experience with data integration, ETL/ELT, data quality, and governance.

Responsabilidades

• Design, develop, and maintain scalable enterprise data warehouse solutions.
• Build and optimize ETL/ELT pipelines and data integration workflows.
• Develop data ingestion, transformation, and orchestration in Microsoft Fabric.
• Create Fabric Data Engineering workloads: pipelines, dataflows, notebooks, lakehouses, warehouses.
• Model data using Star/Snowflake schemas for reporting and analytics.
• Develop complex T-SQL code and performance tuning.
• Build Power BI semantic models, reports, dashboards, and DAX measures.
• Develop data processing with Python and PySpark for large-scale workloads.
• Monitor data quality, governance, and production support; collaborate with stakeholders.

Conocimientos

Analytical thinking

Communication

Documentation

Stakeholder management

Multi-priority management

Soft skills

Team collaboration

Herramientas

Microsoft Fabric

Power BI

SQL Server

T-SQL

SSIS

Python

PySpark

Spark

Notebooks

Lakehouses

Descripción del empleo

Integon, part of The Allstate Corporation, seeks a Lead BI Developer to join our Data & Analytics team in Mexico. You will design and deliver enterprise data warehouse solutions, build ETL/ELT pipelines, and develop Power BI semantic models and Python/PySpark data processing.

Collaborate with business and engineering teams to translate requirements into scalable data solutions while upholding data quality and governance standards.