Allstate Finance/FinTech

Senior BI Developer

Remote Full-time

Location: Mexico (Remote)

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.

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.

Free tool / Resume tailor

Tailor your resume for this job

Paste your resume and get 3 to 8 of your own lines rewritten in the words this posting uses, with the reason for each change. The job is already filled in, and you don't need an account.

Job description provided by Allstate.
View the original posting