Apply

Ready to go for it?

AI Apply speeds things up—apply directly if you prefer.

FREE ACCESS
5,000–10,000 jobs/day
Scoutfield Logo

See all jobs on Scoutfield

Search thousands of fresh jobs every day.

Discover
  • Fresh listings
  • Fast filters
  • No subscription required
Create a free account and start exploring right away.
Allstate

Lead BI Developer

Allstate

. Design, develop, and maintain scalable enterprise data warehouse solutions .

Posted 9/29/2026full-timeRemote • MexicoSeniorWebsite

Core Competencies

Role fit
Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Data Engineering and Data Warehousing, with a strong focus on Microsoft Fabric, ETL/ELT processes, and advanced Power BI capabilities. Proficient in T-SQL development, dimensional modeling, and large-scale data processing using Python and PySpark.

Highest-signal resume keywords
Data EngineeringMicrosoft FabricT-SQL DevelopmentPower BIDimensional Modeling

ATS Keywords

Tailor your resume
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills
T-SQLPythonPySparkETLData WarehousingData IntegrationData GovernanceDimensional ModelingDAXData Quality
Soft Skills
Analytical SkillsProblem-SolvingCommunicationOrganizational SkillsTeam-Oriented
Tools & Technologies
Microsoft FabricPower BISSISData FactoryData PipelinesDataflows Gen2LakehousesData WarehousesOneLakeAgile/Scrum
Certifications & Qualifications
Microsoft Fabric Certifications
Industry Keywords
Data EngineeringData WarehousingBusiness IntelligenceEnterprise AnalyticsCI/CDDevOpsSlowly Changing DimensionsAudit SolutionsLogging SolutionsMonitoring Solutions

Tech Stack

Tools & technologies
AzureETLPySparkPythonSparkSQLSSIS

About the role

Key responsibilities & impact
  • 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, and Warehouses
  • Design and implement dimensional models using Star and Snowflake Schemas
  • 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 deployment, monitoring, performance tuning, and production support activities

Requirements

What you’ll need
  • 5+ years of experience in Data Engineering, Data Warehousing, or Business Intelligence
  • Extensive experience with SQL Server, T-SQL Development, SSIS, and enterprise data warehousing
  • Strong experience with dimensional modeling, including Star Schemas, Snowflake Schemas, Fact and Dimension Tables, and Slowly Changing Dimensions (SCD)
  • Hands-on experience with Microsoft Fabric, including Data Factory, Data Pipelines, Dataflows Gen2, Notebooks, Lakehouses, Data Warehouses, and OneLake
  • Strong experience using 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
  • Ability to work independently with minimal supervision
  • Strong analytical and problem-solving abilities
  • Excellent communication and stakeholder management skills
  • Strong documentation and organizational skills
  • Team-oriented mindset and willingness to mentor and share knowledge
  • Ability to manage multiple priorities in a fast-paced environment
  • Valid photo identification required at the start of virtual interviews, except for internal candidates
  • Microsoft Fabric Certifications preferred
  • Azure Data Engineering experience preferred
  • Experience implementing metadata-driven ingestion frameworks preferred
  • Experience building audit, logging, and monitoring solutions preferred
  • Knowledge of CI/CD processes and DevOps practices preferred
  • Experience supporting large-scale enterprise analytics platforms preferred
  • Experience with Agile/Scrum methodologies preferred

Benefits

Comp & perks
  • Opportunity to develop skills and advance professionally
  • Opportunity to challenge the status quo and shape the future of protection
  • Opportunity to support causes that matter to employees
  • Camera-on virtual interview process
  • Interview accommodations available upon request