Lead BI Developer - Data Warehousing & Power BI

Allstate; Tijuana; Presencial; MXN 600.000 - 900.000; Jornada completa

Descripción de la vacante

Allstate's Integon unit seeks a Lead Business Intelligence Developer to design and support enterprise-scale data warehouses, modern cloud platforms, and BI environments. You will work with stakeholders, analysts, and engineers to turn data into actionable insights.

You will develop star and snowflake schemas, T-SQL, PySpark, and Power BI models, and mentor teammates while ensuring data quality and governance across production environments.

Formación

• 5+ years of experience in Data Engineering, Data Warehousing, or BI.
• Extensive experience with SQL Server T-SQL, SSIS, data warehousing and dimensional modeling.
• Experience with Microsoft Fabric, Data Factory, Data Flows Gen2 Notebooks Lakehouses, and Power BI.

Responsabilidades

• Design, develop, and maintain scalable enterprise data warehouse solutions.
• Build and optimize ETL/ELT pipelines using modern data integration tools.
• Develop Fabric data ingestion, transformation, and orchestration processes.
• Create Fabric workloads including pipelines, dataflows, notebooks, lakehouses, warehouses.
• Design star and snowflake schemas to support reporting and analytics.
• Develop T-SQL code including stored procedures, views, and functions.
• Build Power BI semantic models, reports, dashboards, and DAX measures.
• Develop Python and PySpark data processing solutions.
• Monitor data quality and implement governance practices.
• Collaborate with stakeholders to translate requirements into scalable solutions.
• Participate in architecture and code reviews and in design discussions.
• Support deployments, monitoring, and production support.

Conocimientos

Data Engineering

Data Warehousing

Business Intelligence

SQL Server

SSIS

Dimensional Modeling

Power BI

Python

PySpark

DAX

Herramientas

Microsoft Fabric

Data Factory

Gen2 Notebooks

Power BI Dataflows

Lakehouses

Descripción del empleo

Allstate's Integon unit seeks a Lead Business Intelligence Developer to design and support enterprise-scale data warehouses, modern cloud platforms, and BI environments. You will work with stakeholders, analysts, and engineers to turn data into actionable insights.

You will develop star and snowflake schemas, T-SQL, PySpark, and Power BI models, and mentor teammates while ensuring data quality and governance across production environments.