1 day ago
Remote, Mexico or Mexico (city not specified)Senior
Responsibilities
- Design, develop, and maintain scalable enterprise data warehouse solutions.
- Build, optimize, and support ETL/ELT pipelines and data integration processes.
- Develop Microsoft Fabric data ingestion, transformation, and orchestration workloads, including Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, and Warehouses.
- Design and implement dimensional models using star schemas, snowflake schemas, fact and dimension tables, and slowly changing dimensions.
- Develop complex T-SQL stored procedures, views, functions, and performance optimizations.
- Build and maintain Power BI semantic models, reports, dashboards, datasets, and DAX measures.
- Develop large-scale data processing solutions using Python and PySpark.
- Monitor data quality, troubleshoot issues, and implement data governance practices.
- Gather requirements and translate business needs into scalable data solutions.
- Participate in architecture reviews, code reviews, and technical design discussions.
- Support deployment, monitoring, performance tuning, and production operations.
Requirements
- At least 5 years of experience in data engineering, data warehousing, or business intelligence.
- Extensive experience with SQL Server, T-SQL development, SSIS, enterprise data warehousing, and dimensional modeling.
- Strong experience designing star schemas, snowflake schemas, fact and dimension tables, and slowly changing dimensions.
- Hands-on experience with Microsoft Fabric, including Data Factory, Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, Data Warehouses, and OneLake.
- Strong experience with Python, PySpark, and Spark-based data processing.
- Advanced Power BI skills, including semantic models, dataset design, DAX development, dashboard development, and performance optimization.
- Experience with data integration, ETL/ELT frameworks, data quality processes, and data governance practices.
- Preferred qualifications include Microsoft Fabric certifications, Azure data engineering experience, metadata-driven ingestion, audit/logging/monitoring solutions, enterprise analytics platform support, and knowledge of DevOps practices.
- Strong analytical, problem-solving, communication, stakeholder management, documentation, organizational, collaboration, and prioritization skills.
- Ability to work independently, collaborate with technical and business teams, and mentor others.
Tech Stack
Categories
Data Engineering
About Allstate
Allstate is a major U.S. personal-lines insurer that sells auto, homeowners, renters, and life policies to consumers through agents and direct online channels. It earns premiums and service fees across insurance and protection products, including telematics-based programs and device/identity protection. Founded in 1931 and headquartered in Northbrook, Illinois, Allstate is publicly traded on the NYSE under the ticker ALL.
