Jobs / Mexico / Allstate Insurance Company
Lead BI Developer
Allstate Insurance Company · 🌍 Mexico (Remote) · Remote
Sponsorship verdict
No sponsorship evidence yet
No government record and no wording either way. Not a refusal — ask the recruiter.
- No government sponsor record hereNo government sponsor record covers this employer in this country.
- The posting doesn’t mention sponsorshipSilence isn’t a refusal — ask the recruiter before investing much time.
- Can’t check pay against the visa rulesWe don’t have visa salary rules for this country yet.
- Confirmed live todayWhen a source last listed this job as open.
A verdict summarises public evidence; it is not legal advice and never a guarantee — the employer and the immigration authority decide. Sign in to factor in where you can already work.
Or apply yourself on the official page →
Why not apply?
No register record and no sponsorship wording in the posting. Worth asking the employer before investing significant time.
SponsorApply flags time-wasters so your applications go where they can land. These come from the posting's own wording — read the original listing to confirm. See better-fit alternatives →
Sponsor Radar — Allstate Insurance Company
No government sponsor record covers this employer in this country.
Past sponsorship or register membership never guarantees sponsorship for this vacancy or for you. Full Sponsor Radar for Allstate Insurance Company →
About the role
Integon is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. It’s how we’ve become industry leaders in property and casualty insurance servicing. We support our insurance company affiliates by offering property and casualty insurance products inclusive of personal auto, homeowners, RV, motorcycle, small business auto insurance and more. Job Description We are seeking a highly skilled and motivated Lead Business Intelligence Developer to join our Data & Analytics team. The ideal candidate will have strong experience designing, developing, and supporting enterprise-scale data warehouse solutions, modern cloud-based data platforms, and business intelligence environments. This role requires expertise in data warehousing, dimensional modeling, ETL/ELT development, Microsoft Fabric, Power BI, and modern data engineering practices. The successful candidate must be a self-starter who can work independently while also collaborating effectively with business stakeholders, analysts, architects, and fellow engineers. Key Responsibilities • Design, develop, and maintain scalable enterprise data warehouse solutions. • Build, optimize, and support ETL/ELT pipelines using modern data integration tools and frameworks. • Develop and maintain data ingestion, transformation, and orchestration processes in Microsoft Fabric . • Create and manage Fabric Data Engineering workloads including: • Data Pipelines • Dataflows Gen2 • Notebooks • Lakehouses • Warehouses • Design and implement robust dimensional models (Star and Snowflake Schemas) to support reporting and analytics. • Develop complex T-SQL code including stored procedures, views, functions, and performance optimization. • Build and maintain Power BI semantic models, reports, dashboards, and DAX measures. • Develop data engineering solutions using Python and PySpark for large-scale data processing. • Monitor data quality, troubleshoot issues, and implement data governance best practices. • Collaborate with business users and technical teams to gather requirements and translate them into scalable data solutions. • Participate in architecture reviews, code reviews, and technical design discussions. • Support operational activities including deployment, monitoring, performance tuning, and production support. Required Qualifications Technical Skills • 5+ years of experience in Data Engineering, Data Warehousing, or Business Intelligence. • Extensive experience with: • SQL Server • T-SQL Development • SSIS (SQL Server Integration Services) • Enterprise Data Warehousing • Dimensional Modeling • Strong experience designing: • Star Schemas • Snowflake Schemas • Fact and Dimension Tables • Slowly Changing Dimensions (SCD) • Hands-on experience with Microsoft Fabric: • Data Factory • Data Pipelines • Dataflows Gen2 • Notebooks • Lakehouses • Data Warehouses • OneLake • Strong experience using: • Python • PySpark • Spark-based Data Processing • Advanced Power BI skills: • Semantic Models • Dataset Design • DAX Development • Dashboard Development • Performance Optimization • Experience working with: • Data Integration • ETL/ELT Frameworks • Data Quality Processes • Data Governance Practices Preferred Qualifications • Microsoft Fabric Certifications. • Azure Data Engineering experience. • Experience implementing metadata-driven ingestion frameworks. • Experience building audit, logging, and monitoring solutions. • Knowledge of CI/CD processes and DevOps practices. • Experience supporting large-scale enterprise analytics platforms. • Experience with Agile/Scrum methodologies. Soft Skills • Strong analytical and problem-solving abilities. • Ability to work ind