2,452,641open jobs
150,208companies
305,427added this week
Browse all
Location
Remote (Mexico)
Seniority
Senior · 5+ years exp
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 21, 2026. First seen by Alion on Nov 20, 2026. Allstate Corporation scores B on the Alion truth index.

Overview
Company
Impact
Profile match
Headquartered in Northbrook, Illinois, The Allstate Corporation is one of the largest personal lines insurance providers in the United States. The company offers a broad portfolio of protection products, including auto, homeowners, life, and commercial insurance, as well as voluntary benefits and consumer protection plans. Operating through a vast network of local agents, direct channels, and digital platforms, it serves tens of millions of policyholders across North America.
Backed by findfunding.vc

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 Senior 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 independently with minimal supervision.
  • Excellent communication and stakeholder management skills.
  • Strong documentation and organizational skills.
  • Team-oriented mindset with a willingness to mentor and share knowledge.
  • Ability to manage multiple priorities in a fast-paced environment.

Supervisory Responsibilities

  • This job does not have supervisory duties.

Education & Experience (in lieu)

  • In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

Skills

Business Intelligence (BI) Solutions, Business Intelligence Tools, Database Reporting, Data Warehousing (DW), SQL Server BI

Joining our team isn’t just a job - it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger - a winning team making a meaningful impact.

Direct General Auto & Life, Personal Express Insurance, Century-National Insurance, ABC Insurance Agencies, NatGen Preferred, NatGen Premier, Seattle Specialty, National General Lender Services, ARS, RAC Insurance Partners, Mountain Valley Indemnity, New Jersey Skylands, Adirondack Insurance Exchange, VelaPoint, Quotit, HealthCompare, AHCP, NHIC, Healthcare Solutions Team, North Star Marketing, Euro Accident.

To help create a more personal and engaging experience, we ask that you join with your camera on if your interview is virtual. Please also have a Valid Photo Identification available at the start of your interview. If you require any accommodations or have questions ahead of your interview please reach out to your recruiter.

Note: Internal candidates are only asked to join on video; a Valid Photo Identification is not needed for the interview.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,452,641 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics
Similar stack
Same company
Mexico
$136k – $187k per year · Equity · Remote (United States) · Full-Time · 5+ years exp
AI/ML
AI Agents
Apply
Senior BI Engineer 1 day ago
Remote (United States, India, ET hours) · Full-Time · 5+ years exp · Bachelor's Degree · India
Python
SQL
Databases
PostgreSQL
Snowflake
Databricks
Oracle
Analytics
Power BI
Plotly
Management
ServiceNow
Agile
MedTech
21 CFR Part 11
CAPA
Apply
Data & AI Analyst 1 day ago
$100k – $120k per year · Remote (United States) · Full-Time · 3+ years exp · New York
Python
SQL
AI/ML
Anomaly Detection
Machine Learning
DevOps
Git
Analytics
Power BI
Management
SharePoint
Apply
Remote (LATAM)
SQL
AI/ML
dbt
AI Agents
Machine Learning
Apply
ANALISTA DE T.I Senior 12 hours ago
Remote (Brazil) · Contractor · Brazil
PHP
SQL
PHP
WordPress
DevOps
Windows
DNS
Wi-Fi
Analytics
Power BI
Management
n8n
Apply
Material Planner 10 hours ago
In office · Mexico
Apply
Mexico Country Manager 10 hours ago
Equity · Hybrid · Full-Time · 10+ years exp · PhD · Mexico
Apply
In office · 5+ years exp · Mexico
Apply
Apply
≈ $35k – $78k per year (Estimated) · In office · Full-Time · 8+ years exp · Mexico
Apply
See all jobs
This is one of many
2,452,641 more open roles from verified company boards, updated every day.